Data Engineer, Smart Factory Solutions

US Diversity Job Search; Troy (MI); On-site; USD 86,000 - 105,000; Full time

Job summary

Magna is seeking a Data Engineer to support data initiatives including AI/ML readiness. You will design data models, build pipelines, and develop KPI dashboards in a dynamic, automotive technology context.

Ideal candidates have a strong background in SQL, OLAP/ETL, and data warehousing, with collaboration across stakeholders and engineering teams. Magna offers growth, global exposure, and opportunities to innovate in mobility technologies.

Qualifications

• Bachelor's degree or equivalent in a relevant field.
• 3+ years of related experience required.
• OLAP and ETL concepts understanding is essential.
• Strong relational database skills (SQL).
• Experience with data warehousing and data modeling.

Responsibilities

• Collaborate with stakeholders and engineers to develop data-driven solutions on Big Data platforms.
• Connect and build pipelines between various data sources.
• Perform ad-hoc statistical analyses to support business decisions.
• Lead BI software development, deployment, and maintenance.
• Document data warehouse contents and metadata storage.
• Create technical documentation for BI tools.
• Develop KPI dashboards and metrics.
• Perform additional duties as assigned.

Skills

Data modeling

Big data

BI dashboards

KPI development

Education

Bachelor's degree in relevant field

Tools

SQL Server

MySQL

Oracle

NoSQL

Data Factory

Job description

Job descriptions may display in multiple languages based on your language selection.

What we offer:

At Magna, you can expect an engaging and dynamic environment where you can help to develop industry-leading automotive technologies. We invest in our employees, providing them with the support and resources they need to succeed. As a member of our global team, you can expect exciting, varied responsibilities as well as a wide range of development prospects. Because we believe that your career path should be as unique as you are.

Group Summary:

Magna is more than one of the world's largest suppliers in the automotive space. We are a mobility technology company built to innovate, with a global, entrepreneurial-minded team. With 65+ years of expertise, our ecosystem of interconnected products combined with our complete vehicle expertise uniquely positions us to advance mobility in an expanded transportation landscape.

Job Responsibilities:

Salary: Starting at $95,000 USD per year Immediate, open position Magna is looking for Data Engineer to support their data initiatives which will modernize their environment and set them up for future opportunities in the data space (AI, ML, etc). We are looking for a passionate individual who is self learner, has good communication skills and inclination for new technologies.

Your Responsibilities

• Collaborate closely with stakeholders and other engineers to develop new and unique data-driven solutions using Big Data platforms, creative analytical methods, and data visualization techniques (Data Modeling etc.)
• Connect and build pipelines between various data sources
• Support operational improvement and business decision making through ad-hoc statistical analysis of curated enterprise data and self-constructed data sets
• Leading BI software development, deployment, and maintenance
• Documenting contents in a data warehouse and meta-data storage
• Creating technical documentation for BI tools
• Data modeling
• Develop KPI dashboards
• Perform additional duties as assigned
• Act with honesty and integrity and make ethical business choices in accordance with Magna's Compliance Policies and Procedures

Who we are looking for

• Bachelor's Degree in Business, Engineering, Statistics, Computer Science, Mathematics, Supply Chain or equivalent combination of education and experience
• Minimum three (3) years of related experience required
• Expertise in using advance level calculations on the data sets
• In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
• Strong experience with relational databases like SQL Server, MySQL, and Oracle. NoSQL databases experience is a plus
• Experience with user-defined workflows

Your preferred qualifications

• Working knowledge of data management software like Data factory, or other ETL tools a plus.
• Knowledgeable of statistical methods such as regression, probability analysis, risk analysis, statistical process control, and clustering is desired
• Able to implement row level security on data and understand application security layer models
• Data and business analysis background
• Proficient with Microsoft Office applications, specifically Excel, Word, and PowerPoint
• Ability to explain Production / technical concepts and analysis implications clearly to a wide audience and be able to translate business objectives into actionable analyses

What we offer At Magna, you can expect an engaging and dynamic environment where you can help to develop industry-leading automotive technologies. We invest in our employees, providing them with the support and resources they need to succeed. As a member of our global team, you can expect exciting, varied responsibilities as well as a wide range of development prospects. Because we believe that your career path should be as unique as you are.

In addition, we offer you the following site benefits:

• An overview of our benefits will be discussed during the recruitment process.
• Awareness. Unity. Empowerment.

At Magna, we believe that a diverse workforce is critical to our success. That's why we are proud to be an equal opportunity employer. We hire based on experience and qualifications, and in consideration of job requirements, regardless of, in particular, color, ancestry, religion, gender, origin, sexual orientation, age, citizenship, marital status, disability, or gender identity.

Magna takes the privacy of your personal information seriously. We discourage you from sending applications via email to comply with GDPR requirements and your local Data Privacy Law.

At Magna, we believe that a diverse workforce is critical to our success. That's why we are proud to be an equal opportunity employer. We hire on the basis of experience and qualifications, and in consideration of job requirements, regardless of, in particular, color, ancestry, religion, origin, sexual orientation, age, citizenship, marital status, disability or gender identity.

Magna takes the privacy of your personal information seriously. We discourage you from sending applications via email or traditional mail to comply with GDPR requirements and your local Data Privacy Law.

AI-Assisted Screening Disclosure

As part of our commitment to a fair, consistent, and efficient recruitment process, we may use artificial intelligence (AI) tools to assist in the initial screening of applications submitted through our Workday system. These tools help identify qualifications and experience that align with the role requirements. Please note that AI is used solely to support our recruiters. Final decisions are always made by the hiring manager and the hiring team. Importantly, no applicant data is shared externally through these AI tools. All information remains securely within our systems and is handled in accordance with our privacy and data protection policies. Under conditions defined by applicable law, you may have the right to request an explanation of how AI is used to support decision-making. If you have any questions or concerns about this process, feel free to contact our Talent Attraction team.

Worker Type:Regular / Permanent

Group:Magna Corporate