Dealer-FX Group

ETL Developer

Job Locations CA-ON-Markham
Posted Date 4 weeks ago(1/22/2018 12:25 PM)
ID
2018-1269
# of Openings
1
Category
Operations

Overview

We are looking for an extremely talented Business Intelligence (BI) ETL Developer to join our quickly growing team.  If you have a passion for building data warehouse and data integration solutions in a fast-paced environment, and love to work with like minded people to raise the quality bar, keep reading! 

 

The automotive space is revving its engines and you can be part of the Dealer-FX development crew that drives our best-in-class solutions. We work fast, and are driven by the impact our software has on dealers and vehicle owners everywhere! That’s because our products are awesome and our development team is the foundation of our success in the marketplace. But it's not all work and no play; we have fun and enjoy seeing our hard work come to fruition.

 

Dealer-FX, the most trusted name in automotive customer experience and relationship management, is focused on helping dealer and OEM clients to Drive the Customer Experience by enhancing customer retention, mobile and data strategies. The 1 Solution suite of service tools provides integrated software that delivers a sales to service transition, online scheduling, appointment ledger, route sheet, vehicle status board, seamless DMS integration, advisor and technician dashboards in addition to supporting vehicle telematics and diagnostic data integration.

 

Dealer-FX has been recognized 4 consecutive times as a Deloitte Technology Fast 50TM company and is also the recipient of the TU Automotive Industry Newcomer award. Dealer-FX also recently announced plans for North American and global expansion, since having finalized an agreement with Private Equity Partner, HGGC based out of Palo Alto, California.

Responsibilities

  • Participate in Business Intelligence (BI) solution and data architecture design discussions
  • Translate data requirements into ETL design, identifying any gaps
  • Develop clean, maintainable and tested ETL processes for the extraction and transformation of data from various OLTP applications for loading into a data warehouse.
  • Develop and maintain a data dictionary/library to support the data warehouse
  • Contribute to data management and data improvement processes
  • Participate in troubleshooting and performance optimization with the BI solution team
  • Participate in review and planning sessions in an Agile environment, working closely with our reporting analysts and stakeholders, making sure we’re always building the best user experience possible!
  • Pro-actively put forward ideas that speak to project objectives (e.g. development, testing solutions, tools)

Qualifications

  • Extensive experience in complete life cycle of data warehouse and system integrations
  • Knowledge of cloud environment for development
  • Knowledgeable in both Relational and Dimensional data models
  • Excellent data analysis and problem-solving skills, with a superior attention to detail
  • Advanced experience (5+ years) in developing and tuning ETL processes using a variety of technologies (i.e. SSIS, Informatica)
  • Understanding of best practices around data integration, from acquisition to loading to transformation using Informatica and SSIS
  • Experience in REST API development and use in a ETL environment
  • Strong SQL programming knowledge in Microsoft SQL and MySQL
  • Experience with production implementation change management processes
  • Highly flexible and able to quickly adapt to changing priorities
  • Highly organized, self-motivated, customer oriented and able to work independently as well as within a team
  • Excellent verbal & written communication, presentation and facilitation skills
  • Ability to develop and present new ideas and conceptualize new approaches and solutions

No unsolicited agency referrals

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed