Data Engineer

 

Title: Data Engineer

Location: Hybrid/Southfield, MI, US

Job Type: Full-time with Benefits  

 

Who We Are

For more than 25 years, MSX International has been a dedicated partner to leading automotive brands around the world. We support them in transforming their businesses and in managing their operations across the areas of Customer Experience, Repair Optimization, Learning and Insights. We focus on helping our clients generate more value for their customers. With over 5,000 employees based in more than 80 countries worldwide, our teams provide industry-leading expertise. We have combined our deep industry expertise with cutting-edge technology solutions to help our automotive clients increase revenue and reduce costs, while enhancing operational efficiency and improving customer satisfaction.  Our goal is to help our customers reach their full potential and to excel as their global partner of choice.

 

Summary

This position is responsible for designing, developing and maintaining business data platforms that allow for insights into customer data. The Data Engineer will use SQL skills to execute high quality projects and assignments with a high degree of accuracy in a timely manner. 

  

What Your Day-to- Day Responsibilities Include: 

• Design, code, test, correct and document programs and scripts using agreed standards and tools to achieve a well-engineered result 

• Ensures data quality and implements tools and frameworks for automating the identification of data quality issues 

• Profile data sources and develop ETL processes with knowledge of data modeling fundamentals, using both SQL and supporting ETL/ELT tools 

• Assists management in creating estimates and proposals for clients  

• Plan effective data storage, security, sharing and publishing within the organization 

• Create and update documentation of process flows and business rules  

• Maintain current workflows up to date and process large amounts of data as needed  

 

What you bring: 

• Bachelor’s Degree in computer science, statistics, mathematics or relevant discipline  

• 2+ years of data engineering and/or data warehousing experience 

• 1-3 years’ automotive operations experience, or similar business (quick-paced environment) 

• Experience in designing and developing ETL data pipelines (SSIS, KNIME, Alteryx). Should be proficient in writing Advanced SQLs, Expertise in performance tuning of SQLs 

• Experience with complex data analysis 

• Performing data manipulation and statistical analysis 

• Strong analytical skills with ability to understand and communicate the meaning of the data being presented  

• Excellent Mathematical/Statistical and Logic skills  

• Excellent Reasoning skills 

• Enthusiastic, highly motivated and ability to learn quick 

• Experience building Azure cloud data solutions and migrating from on-prem to cloud 

• Previous external client facing experience  

• Proficiency in T-SQL 

• Familiarity with administering MS SQL Server 

• Strong communication skills and a working knowledge of agile development, including DevOps concepts 

• Experience with data visualization tools (Tableau, PowerBI, etc.) 

• Knowledge Retention - In order to provide the highest quality of work, analysts must be able to learn and memorize a large amount of information 

• Detail Oriented – Analysts must be able to focus on the details in order to identify and isolate issues 

• Organizational Skills – Analysts must be organized and able to keep track of multiple projects at once  

• Flexibility - Analysts must be able to handle multiple tasks at once and follow changes in priority level 

• Speed - Must be able to work quickly and efficiently without sacrificing the quality of their work 

• Solutions Oriented - Must be able to find workable solutions for any problems they might face 

• Full Professional Proficiency in English is required 

• Able to complete advanced statistical analysis is required 

• Job requires analyzing information and using logic to address work-related issues and problems 

• While performing the duties of this job, the employee is regularly required to: 

• Call, video, email, message and communicate with dealers and co-workers 

• Must be legally authorized to work in the United States without the need for employer sponsorship, now or at any time in the f