What are the responsibilities and job description for the Data Engineer I position at Cox Automotive?
Job Description
Cox Automotive Inc.is seeking a Data Engineer I on a dynamic Financial Analytics team. The ideal candidate for this role is an enthusiastic data minded individual with a drive to learn and grow our team's analytics capabilities. The ideal candidate will also have a desire to work on all aspects of the analytics platform including ETL, Database, Report Development, and Performance.
Data Engineer I will be responsible for designing, developing, and maintaining data warehousing solutions. They will work closely with cross-functional teams including Product Owners and Architects. Business Stakeholders, and Software Engineers to gather requirements, create Technical Designs, as well as implement scalable, optimized data pipelines.
Data Engineer I will also be responsible for data extraction, transformation, and loading (ETL) processes, data validation, performance optimization as well as report and dashboard development.
Responsibilities:
Design and develop data warehousing solutions: Create and maintain data models, schemas, and database designs for data warehouse systems that meet business requirements and optimize performance.
Develop ETL processes: Design, implement, and optimize ETL processes to extract, transform, and load data from various sources into data warehouse systems. Ensure data quality, integrity, and accuracy throughout the ETL process.
Develop Analytics/Reports/Dashboards: Develop data driven solutions in support of Financial Analytics insights.
Performance optimization: Optimize data warehouse systems for query performance, data loading, and data retrieval. Identify and resolve performance bottlenecks to ensure efficient and effective data processing.
Data validation: Develop and implement data validation processes to ensure data accuracy, consistency, and integrity. Perform data profiling and data quality analysis to identify data anomalies and discrepancies.
Collaborate with cross-functional teams: Work closely with data scientists, business analysts, and software engineers to understand data requirements, provide data engineering expertise, and support the development of financial analytics solutions.
Data integration: Integrate data from various sources, including external APIs, databases, and third-party data providers, into the data warehouse systems. Develop data pipelines and workflows to automate data ingestion processes.
Documentation: Create and maintain technical documentation including data models, data flow diagrams, ETL process documentation, and data dictionaries. Learn new applications, techniques, and technologies in Data Analytics to help drive the team and the company into the future. Collaborate within an Agile Software Development process to achieve shared team goals. Participate in the identification and implementation of continuous process improvement. Support Problem solving related to tickets submitted by Business Users. Participate in system monitoring as part of a rotating schedule.
Qualifications:
To be employed in this role, you'll need to clear a pre-employment background check and drug test. Cox Automotive does not currently consider a pre-employment drug test for marijuana for this position. However, we are a drug-free workplace, so the possession, use or being under the influence of drugs illegal under federal or state law during work hours, on company property and/or in company vehicles is prohibited.
#LI-017
About Cox Automotive
At Cox Automotive, people of every background are driven by their passion for mobility, innovation and community. We transform the way the world buys, sells, owns and uses cars, accelerating the industry with global powerhouse brands like Autotrader, Kelley Blue Book, Manheim and more. What's more, we do it all with an emphasis on employee growth and happiness. Drive your future forward and join Cox Automotive today!
About Cox
Cox empowers employees to build a better future and has been doing so for over 120 years. With exciting investments and innovations across transportation, communications, cleantech and healthcare, our family of businesses - which includes Cox Automotive and Cox Communications - is forging a better future for us all. Ready to make your mark? Join us today!
Benefits of working at Cox may include health care insurance (medical, dental, vision), retirement planning (401(k)), and paid days off (sick leave, parental leave, flexible vacation/wellness days, and/or PTO). For more details on what benefits you may be offered, visit our benefits page .
Cox is an Equal Employment Opportunity employer - All qualified applicants/employees will receive consideration for employment without regard to that individual's age, race, color, religion or creed, national origin or ancestry, sex (including pregnancy), sexual orientation, gender, gender identity, physical or mental disability, veteran status, genetic information, ethnicity, citizenship, or any other characteristic protected by law. Cox provides reasonable accommodations when requested by a qualified applicant or employee with disability, unless such accommodations would cause an undue hardship.
Statement to ALL Third-Party Agencies and Similar Organizations: Cox accepts resumes only from agencies with which we formally engage their services. Please do not forward resumes to our applicant tracking system, Cox employees, Cox hiring manager, or send to any Cox facility. Cox is not responsible for any fees or charges associated with unsolicited resumes.
Data Engineer I will be responsible for designing, developing, and maintaining data warehousing solutions. They will work closely with cross-functional teams including Product Owners and Architects. Business Stakeholders, and Software Engineers to gather requirements, create Technical Designs, as well as implement scalable, optimized data pipelines.
Data Engineer I will also be responsible for data extraction, transformation, and loading (ETL) processes, data validation, performance optimization as well as report and dashboard development.
Responsibilities:
Design and develop data warehousing solutions: Create and maintain data models, schemas, and database designs for data warehouse systems that meet business requirements and optimize performance.
Develop ETL processes: Design, implement, and optimize ETL processes to extract, transform, and load data from various sources into data warehouse systems. Ensure data quality, integrity, and accuracy throughout the ETL process.
Develop Analytics/Reports/Dashboards: Develop data driven solutions in support of Financial Analytics insights.
Performance optimization: Optimize data warehouse systems for query performance, data loading, and data retrieval. Identify and resolve performance bottlenecks to ensure efficient and effective data processing.
Data validation: Develop and implement data validation processes to ensure data accuracy, consistency, and integrity. Perform data profiling and data quality analysis to identify data anomalies and discrepancies.
Collaborate with cross-functional teams: Work closely with data scientists, business analysts, and software engineers to understand data requirements, provide data engineering expertise, and support the development of financial analytics solutions.
Data integration: Integrate data from various sources, including external APIs, databases, and third-party data providers, into the data warehouse systems. Develop data pipelines and workflows to automate data ingestion processes.
Documentation: Create and maintain technical documentation including data models, data flow diagrams, ETL process documentation, and data dictionaries. Learn new applications, techniques, and technologies in Data Analytics to help drive the team and the company into the future. Collaborate within an Agile Software Development process to achieve shared team goals. Participate in the identification and implementation of continuous process improvement. Support Problem solving related to tickets submitted by Business Users. Participate in system monitoring as part of a rotating schedule.
Qualifications:
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- 1 years of experience in data engineering, data warehousing, or a related field.
- Knowledgeable in SQL and database concepts and design.
- Experience with ETL tools and frameworks such Python, ODI, Informatica, or other similar applications.
- Experience with Report and Dashboard development
- Knowledge of data warehousing technologies such as Oracle D, Oracle Business Intelligence (OBIEE), Oracle Data Integrator (ODI), Snowflake, etc.
- Familiarity with financial analytics concepts, financial data models, and financial reporting.
- Experience with data integration and data pipeline development using Python, Java, or other programming languages.
- Strong analytical, problem-solving, and communication skills.
- Ability to work independently and collaboratively in a fast-paced environment.
- Experience in Agile Software Development methodology is a plus.
To be employed in this role, you'll need to clear a pre-employment background check and drug test. Cox Automotive does not currently consider a pre-employment drug test for marijuana for this position. However, we are a drug-free workplace, so the possession, use or being under the influence of drugs illegal under federal or state law during work hours, on company property and/or in company vehicles is prohibited.
#LI-017
About Cox Automotive
At Cox Automotive, people of every background are driven by their passion for mobility, innovation and community. We transform the way the world buys, sells, owns and uses cars, accelerating the industry with global powerhouse brands like Autotrader, Kelley Blue Book, Manheim and more. What's more, we do it all with an emphasis on employee growth and happiness. Drive your future forward and join Cox Automotive today!
About Cox
Cox empowers employees to build a better future and has been doing so for over 120 years. With exciting investments and innovations across transportation, communications, cleantech and healthcare, our family of businesses - which includes Cox Automotive and Cox Communications - is forging a better future for us all. Ready to make your mark? Join us today!
Benefits of working at Cox may include health care insurance (medical, dental, vision), retirement planning (401(k)), and paid days off (sick leave, parental leave, flexible vacation/wellness days, and/or PTO). For more details on what benefits you may be offered, visit our benefits page .
Cox is an Equal Employment Opportunity employer - All qualified applicants/employees will receive consideration for employment without regard to that individual's age, race, color, religion or creed, national origin or ancestry, sex (including pregnancy), sexual orientation, gender, gender identity, physical or mental disability, veteran status, genetic information, ethnicity, citizenship, or any other characteristic protected by law. Cox provides reasonable accommodations when requested by a qualified applicant or employee with disability, unless such accommodations would cause an undue hardship.
Statement to ALL Third-Party Agencies and Similar Organizations: Cox accepts resumes only from agencies with which we formally engage their services. Please do not forward resumes to our applicant tracking system, Cox employees, Cox hiring manager, or send to any Cox facility. Cox is not responsible for any fees or charges associated with unsolicited resumes.
Data Integration Engineer
Pantheon Data -
Matthews, NC
Data Engineer - DS11
Pantheon Data -
Charlotte, NC
Data Integration Engineer - DATA05
Pantheon Data -
Charlotte, NC
