ETL Developer

US-TX-US HQ Addison
FLSA Status
Exempt
Type
Regular Full-Time

Mission

Solera’s Global Data Sciences & Services Team is seeking an exceptional ETL developer to normalize and cleanse our massive dataset of automotive service, maintenance and repair data into data analytics tools to assists players in the automotive space and to support the design and development of BI Solutions.

 

This is a unique opportunity to join a new, multidisciplinary team of creative and passionate individuals destined to change the face of the automotive industry. We are focused on the company’s agenda, and work on high-impact projects utilizing big data analytics and machine learning to improve supply chain knowledge and vehicle and parts information.

 

We’re a lean, flat and experimental team combining science and engineering to identify and inject high-value insights into automotive processes at their point of highest impact. The team works in quick iterations, using the techniques and algorithms best suited for solving the challenging problems of the automotive space.

Position 80s

What you’ll be doing:

  • Advocate, evangelize and build data-fueled products that help our customers improve their supply chain and product mix.
  • Develop complex data transformations using ELT and ETL approach for BI Data Warehouse models
  • Provide mappings from proprietary data sets to industry standard data sets to allow data to be shared in common nomenclature
  • Translate business requirements into detailed data requirements by performing source data profiling and requirement analysis
  • Become an expert on our automotive datasets working with cross-functional team members of our industry-leading software packages to identify and prioritize actionable, high-impact insights across a variety of core business areas.

Qualifications

Required Qualifications

Bachelors or equivalent degree in a business, technical, or related field

Demonstrated Strong SQL Server, Hadoop, Data Warehouse, ETL Design and Development Expertise:

  • At least 7 years of experience with Data Warehouse ETL design, development and maintenance with successful implementation of large Enterprise BI solutions
  • Experience in working with RDBMS mainly SQL Server 2008/2012 and Oracle 11g
  • Experience in Hadoop data lake (Cloudera Distribution or HortonWorks) as source for data cleansing and transformation into data warehouse environment
  • Strong technical experience in designing and implementing data-intensive Data Warehouse solutions
  • High proficiency writing SQL
  • Strong Knowledge of logical and physical data modeling (relational, dimensional data modeling)

Options

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