Data Analyst

**Group Description**

The Mechatronics, Mirrors and Lighting group specializes in automotive technologies that are driving the future of mobility. Combining a deep systems knowledge to develop unique vehicle access experiences, intelligent visions systems and advanced automotive lighting technologies, MML's expertise light the path to innovation, safety and styling.

**Overview**:
**TECHFORM MECHATRONICS IS #HIRING A DATA ANALYST**

Are you ready to accelerate your career? Are you prepared for a challenge?** Join the Techform team in Penetanguishene**

At Techform Mechatronics, we are Developing Passionate People That Deliver Innovative Access Experiences. The Mechatronics, Mirrors and Lighting group specializes in automotive technologies that are driving the future of mobility. Combining a deep systems knowledge to develop unique vehicle access experiences, intelligent visions systems and advanced automotive lighting technologies, MML's expertise light the path to innovation, safety and styling.

**What's in it for you?**

**Role Summary**:
The Data Analyst will be tasked with managing and organizing data into a format that can be easily analyzed.

**Key Responsibilities**:

- Collaborate closely with stakeholders and other analysts 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 Power BI/Power Automate 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

**Key Qualifications/Requirements**:

- Education Preferred: Bachelor’s/Master’s Degree in Business, Engineering, Statistics, Computer Science, Mathematics, Supply Chain or equivalent combination of education and experience
- Years of Experience Required: Minimum three (3) years of related experience required

**Other Skills/Experience Required**:

- Experience with different types of data sources (relational and non-relational databases, data lakes, data warehouses, etc.)
- Expert in SQL, Microsoft Excel, PowerBI, Microsoft Flow
- Excellent analytical thinking for translating data into informative visuals and reports
- 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

**Other Skills/Experience Preferred**:

- Demonstrate the ability to document steps in a process and make technology recommendations to improve the process
- Knowledgeable of statistical methods such as regression, probability analysis, risk analysis, statistical process control, and clustering is desired
- Data and business analysis background
- Familiarity with BI technologies (ex., Microsoft Power BI, AWS Quicksight, Qlikview)
- Familiarity with one or more programming languages (ex: Python, R, JavaScript, C#, Java, etc.)
- Additional Information

**General Points**:

- Ensure that all environmental requirements are identified and addressed when performing duties.
- Ensure that all safety requirements are being carried out when performing duties.
- Comply with defined Business Management and Environmental Management Systems requirements.
- Provide support for the continuous improvement initiatives within Techform.
- Provide support in the attainment of Techform's operating system goals as outlined by the key graphs.
- Carry out all duties focusing on the goal of internal and external customer satisfaction.
- Other duties as may be assigned by the supervisor or designate.

**Additional Information**:
Accommodations for disabilities in relation to the job selection process are available upon request.

**Awareness. Unity. Empowerment.**: