Data Engineer, Smart Factory Solutions

Magna International is a mobility technology company that develops automotive technologies and solutions. The Data Engineer will support data initiatives that modernize the company’s data environment, develop data-driven solutions, build data pipelines, and lead business intelligence development and maintenance.

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

Preferred

NoSQL databases experience is a plus

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

NoSQL Databases

Data Management Software

Azure Data Factory

ETL Tools

Statistical Methods

Regression Analysis

Probability Analysis

Risk Analysis

Statistical Process Control

Clustering

Row-Level Security

Application Security Models

Data Analysis

Business Analysis

Microsoft Office

Microsoft Excel

Microsoft Word

Microsoft PowerPoint

Clear Communication

Audience-Adapted Communication

Business-to-Analysis Translation

Benefits

An engaging and dynamic environment where you can help to develop industry-leading automotive technologies.

Support and resources to succeed.

Exciting, varied responsibilities.

A wide range of development prospects.

Company

Automotive supplier developing vehicle systems for automakers

Aurora, Ontario, CAN

http://www.magna.com/

Founded in 1957

10001+ employees

Qualifications

passionate individual who is self learner, has good communication skills and inclination for new technologies

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

Experience with user-defined workflows

Passionate individual who is self learner, has good communication skills and inclination for new technologies

NoSQL databases experience is a plus

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

Required skills

Database Management Systems, OLAP, ETL, SQL Server, MySQL, Oracle, User-Defined Workflows, Data Factory, Statistical Analysis, Row-Level Security, Application Security, Data and Business Analysis

Preferred skills

NoSQL databases experience is a plus, Data and business analysis background

Experience

3+ years