Data Engineer, Smart Factory Solutions
Magna International Inc.9 months ago
Troy, MI, USAMid Level
Base Salary
$95k - $95k/yr
Responsibilities
- Collaborate with stakeholders and engineers to develop data-driven solutions using Big Data platforms, analytical methods, data modeling, and data visualization.
- Connect data sources and build data pipelines to support enterprise data initiatives.
- Perform ad-hoc statistical analysis to support operational improvement and business decision-making.
- Lead the development, deployment, and maintenance of BI software.
- Document data warehouse contents, metadata storage, BI tools, and technical processes.
- Develop data models and KPI dashboards.
- Implement row-level security and understand application security-layer models.
- Translate business objectives into actionable analyses and explain technical concepts and analytical implications to broad audiences.
- Perform additional assigned duties while following Magna’s compliance policies and ethical standards.
Requirements
- Bachelor’s degree in Business, Engineering, Statistics, Computer Science, Mathematics, Supply Chain, or an equivalent combination of education and experience.
- At least three years of related experience.
- Advanced-level calculation skills for data sets.
- In-depth understanding of database management systems, OLAP, and ETL frameworks.
- Strong experience with relational databases including SQL Server, MySQL, and Oracle; NoSQL experience is a plus.
- Experience with user-defined workflows.
- Preferred knowledge of Data Factory or other ETL and data management tools.
- Preferred knowledge of regression, probability analysis, risk analysis, statistical process control, and clustering.
- Ability to implement row-level security and understand application security-layer models.
- Background in data and business analysis.
- Proficiency with Microsoft Office applications, especially Excel, Word, and PowerPoint.
- Ability to communicate production and technical concepts clearly and translate business objectives into actionable analyses.
Benefits
- Regular, permanent employment.
- Benefits overview provided during the recruitment process.
- Professional development prospects and support resources.
- Equal opportunity workplace with a focus on diversity and inclusion.
Tech Stack
Microsoft SQL ServerMySQL
Categories
Data Engineering
About Magna International Inc.
Magna International is a public Canadian automotive supplier that designs and manufactures vehicle systems, modules, and electronics for global automakers, and also builds complete vehicles through Magna Steyr. Founded in 1957 and headquartered in Aurora, Ontario, it operates worldwide as a Tier-1 supplier across body, seating, powertrain, ADAS, and electrification. Its common shares trade on the TSX (MG) and NYSE (MGA).