Business Systems ETL Developer

  • CDK
  • US - IL - Hoffman Estates
  • 2 weeks ago

Company Name: CDK

Location: Hoffman Estates, IL, US - 60169

Job Duration: 2021-09-12 to 2021-10-12

Overview

About CDK Global, Inc

CDK Global (NASDAQ:CDK) is a leading provider of integrated data and technology solutions to the automotive, heavy truck, recreation and heavy equipment industries. Focused on enabling end-to-end, omnichannel retail commerce through open, agnostic technology, CDK Global provides solutions to dealers and original equipment manufacturers, serving nearly 15,000 retail locations in North America. CDK solutions connect people with technology by automating and integrating all parts of the dealership and buying process, including the acquisition, sales, financing, insuring, parts supply, repair and maintenance of vehicles. Visit cdkglobal.com.

Position Summary

 

As part of the Customer Enablement – Analytics and Reporting team, we are centralizing and standardizing the customer experience organization’s data to enable data driven decisions at CDK. Driving revenue growth, optimizing organizational effectiveness, and enabling customer first mindset will be the outcomes driven by the CX data-mart.

 

We are looking to hire a highly-skilled ETL Developer to setup periodic data loads into our new data-mart. You will design and develop the whole ETL architecture while gathering data from various internal and external sources. You will get exposure to various source systems, business processes, tools and technologies. You will get the opportunity to own the end-to-end ETL design and development process.

 

We are a group of dedicated team players who are always ready to help and share knowledge. This is a great opportunity for you to showcase your ETL skills, while getting the opportunity to further learn and grow.

 

 

Position Responsibilities & Essential functions

 

  • Understand existing data source systems in Oracle, SQL Server, and Salesforce.
  • Design, develop, and document efficient ETL workflows to setup initial and periodic incremental loads.
  • Setup a robust and scalable ETL infrastructure to ensure high throughput on various data deliverables.
  • Follow ETL best practices to ensure optimal solution design and data quality.
  • Work with team to implement data strategies, build data flows and develop conceptual data models.
  • Develop standard naming conventions and coding practices to ensure consistency of data models.
  • Perform reverse engineering of physical data models from databases and SQL scripts.
  • Evaluate data models and physical databases for variances and discrepancies.
  • Validate business data objects for accuracy and completeness.
  • Analyze data-related system integration challenges and propose appropriate solutions.
  • Work with a dedicated team of Business Intelligence Developers, Data Analysts, and Data scientists.
  • Interact with various globally located cross functional teams.
  • Troubleshoot any data issues that may arise.
  • Provide maintenance and support.

 

 

Qualifications & Requirements

 

  • 10 years of experience working as an ETL developer using tools like Talend, SSIS, Datastage, Alteryx.
  • Expert at coding SQL, Stored Procedures, and complex ETL logic.
  • Understanding of various data warehouse architectures and data modeling techniques.
  • Ability to analyze company’s big-picture data needs, and develop optimal solutions.
  • Bachelor’s degree in Computer Science, Information Technology, or related field.
  • Ability to troubleshoot and solve complex technical problems.
  • Good to have on premise to AWS cloud data migration experience.
  • Good to have NoSQL, Big Data, and Python programming experience.
  • Ability to quickly learn new ETL tools and technologies.
  • Excellent time management and prioritization skills.
  • Excellent verbal and written communication skills.

 

 

CDK Global knows you have passions outside of work.  You have family, friends, sporting events, and lots of things going on.   That’s why we offer a comprehensive benefits package to not only take care of you but your family as well.   All of our benefits are effective the first day of employment including 401K matching, paid time off to re-energize, donate your time to volunteer in your community, and tuition reimbursement to name a few.

At CDK, we pride ourselves on having a diverse workforce. We value and celebrate the uniqueness of individuals and the different perspectives they provide. We offer equal opportunity employment regardless of race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability status, age, marital status, or protected veteran status.