Data Analyst
Job Number: 43753
Group: Cosma International
Division: Vehma International of America
Job Type: Permanent/Regular
Location: TROY
Group Description
Cosma provides a comprehensive range of body, chassis and engineering solutions to global customers. Through our robust product engineering, outstanding tooling capabilities and diverse process expertise, we continue to bring lightweight and innovative products to market.
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 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
Key Qualifications/Requirements
Education Required: Bachelor's Degree in Business, Engineering, Statistics, Computer Science, Mathematics, Supply Chain or equivalent combination of education and experience
Education Preferred: Master's Degree 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
- 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
- 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
- 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
- This position is signing bonus eligible
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 on the basis of 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.
Nearest Major Market: Troy
Nearest Secondary Market: Detroit