The Category Data Analyst supports sourcing activities, supplier relationships, and cost optimization through data analysis, market intelligence, and reporting, enabling strategic category management.
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:
The Magna Exteriors portfolio of products includes access systems such as liftgates, exterior trim, modular systems, front-end modules including fascia, active aerodynamic systems and other lightweight structural components for automotive, commercial truck and other industrial markets.
Recognized globally as an innovator in all aspects of vehicle exteriors, Magna provides everything needed, from materials development and design through manufacturing and assembly, to help automakers create sleek, state-of-the-art vehicles across the world.
Job Responsibilities:
Job Responsibilities:
The Category & ESG Data Analyst supports Strategic Category Leads by delivering advanced analytics, market intelligence, and ESG compliance oversight across the global supply base. This role transforms raw procurement and ESG data into forward-facing, executive-level insights that drive fact-based decision-making, cost optimization, risk mitigation, and sustainability performance.
This position requires strong technical capability, including extracting data from SQL databases and DataBricks environments and developing interactive Power BI dashboards for global stakeholders.
ESSENTIAL DUTIES & RESPONSIBILITIES:
Advanced Data Analytics & Business Intelligence
- Extract, transform, and analyze procurement and ESG data from SQL databases, SAP/ERP systems, and DataBricks environments.
- Develop and maintain forward-facing Power BI dashboards and executive reporting tools to support global category strategies.
- Design scalable data models to enable real-time visibility into spend, supplier performance, cost drivers, and ESG metrics.
- Identify data integrity issues (missing fields, incorrect commodity codes, inaccurate spend categorization) and partner with divisions to correct and standardize data.
- Ensure accurate commodity code utilization and data governance so consolidated group spend is correctly reflected.
- Perform cost modeling, scenario analysis, and trend forecasting to support negotiations and sourcing initiatives.
- Automate recurring reporting processes and drive continuous improvement in procurement analytics.
Market & Supplier Intelligence
- Monitor resin and plastics markets, including raw material pricing trends, supply/demand dynamics, and global trade impacts.
- Benchmark suppliers and track KPIs related to cost, quality, delivery, and sustainability.
- Provide strategic insights to support long-term category planning.
Category & Sourcing Support
- Support the development and execution of global sourcing strategies for resins and plastics.
- Provide analytical support for supplier negotiations, including cost breakdown analysis and volume modeling.
- Maintain supplier performance scorecards and KPI dashboards.
- Partner with Category Leads to identify cost reduction, consolidation, and risk mitigation opportunities.
Supply Chain ESG Monitoring & Governance
- Support rollout and ongoing management of Supply Chain ESG monitoring systems across Magna Exteriors' supplier base.
- Serve as point of contact for ESG-related topics for suppliers.
- Facilitate discussions with critical suppliers to ensure compliance with ESG nomination criteria.
- Lead follow-up actions including corrective action plans and supplier escalations for underperforming ESG suppliers.
- Support due diligence obligations related to supply chain compliance (legal, CSR, regulatory requirements).
- Partner with Sustainability and Global SCM teams to develop measurable ESG strategies and targets.
- Actively participate in Magna/Group/Division-level ESG governance meetings.
Supply Chain ESG Liaison
- Point of contact for ESG-related topics for suppliers
- Support due diligence obligations (legal, CSRs,...) related to the Supply Chain
- Support Group and Division purchasing in communicating with OEMs & suppliers on ESG-relevant topics
- Support the Sustainability team & Magna International SCM organization in interacting with suppliers to promote sustainability goals
- Support the Sustainability team & Magna International SCM organization in developing feasible strategies and targets for Groups and Divisions
- Actively participate in the company's ESG meetings at Magna/Group/Division level.
Supply Chain ESG Support
- Point of contact for ESG-related topics for suppliers
- Support due diligence obligations (legal, CSRs,...) related to the Supply Chain
- Support Group and Division purchasing in communicating with OEMs & suppliers on ESG-relevant topics
- Support the Sustainability team & Magna International SCM organization in interacting with suppliers to promote sustainability goals
- Support the Sustainability team & Magna International SCM organization in developing feasible strategies and targets for Groups and Divisions
- Actively participate in the company's ESG meetings at Magna/Group/Division level
QUALIFICATIONS:
To perform this job successfully, an individual must be able to perform each essential duty and responsibility satisfactorily. The requirements listed below are representative of the knowledge, skill, ability and/or physical demands required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Education/Special Knowledge
Bachelor's degree in Supply Chain Management, Business, Finance, Engineering, or related field.
Experience
- 3+ years of experience in purchasing, supply chain, finance, data analytics, or manufacturing environment (automotive preferred; internships/co-ops considered).
- Experience building enterprise-level BI dashboards from raw data sources.
- Experience with ESG programs or sustainability compliance initiatives preferred.
- Project management or systems implementation experience preferred.
- Demonstrated ability to influence cross-functional teams in a global matrix organization.
Site Benefits
- Comprehensive Medical, dental, and vision plans
- 401 (k) plan with employer matching
- Profit sharing program
- Exciting internal development opportunities
- Cafe
- Parking for electric vehicles
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 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 Exteriors
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:
The Magna Exteriors portfolio of products includes access systems such as liftgates, exterior trim, modular systems, front-end modules including fascia, active aerodynamic systems and other lightweight structural components for automotive, commercial truck and other industrial markets.
Recognized globally as an innovator in all aspects of vehicle exteriors, Magna provides everything needed, from materials development and design through manufacturing and assembly, to help automakers create sleek, state-of-the-art vehicles across the world.
Job Responsibilities:
Job Responsibilities:
The Category & ESG Data Analyst supports Strategic Category Leads by delivering advanced analytics, market intelligence, and ESG compliance oversight across the global supply base. This role transforms raw procurement and ESG data into forward-facing, executive-level insights that drive fact-based decision-making, cost optimization, risk mitigation, and sustainability performance.
This position requires strong technical capability, including extracting data from SQL databases and DataBricks environments and developing interactive Power BI dashboards for global stakeholders.
ESSENTIAL DUTIES & RESPONSIBILITIES:
Advanced Data Analytics & Business Intelligence
- Extract, transform, and analyze procurement and ESG data from SQL databases, SAP/ERP systems, and DataBricks environments.
- Develop and maintain forward-facing Power BI dashboards and executive reporting tools to support global category strategies.
- Design scalable data models to enable real-time visibility into spend, supplier performance, cost drivers, and ESG metrics.
- Identify data integrity issues (missing fields, incorrect commodity codes, inaccurate spend categorization) and partner with divisions to correct and standardize data.
- Ensure accurate commodity code utilization and data governance so consolidated group spend is correctly reflected.
- Perform cost modeling, scenario analysis, and trend forecasting to support negotiations and sourcing initiatives.
- Automate recurring reporting processes and drive continuous improvement in procurement analytics.
Market & Supplier Intelligence
- Monitor resin and plastics markets, including raw material pricing trends, supply/demand dynamics, and global trade impacts.
- Benchmark suppliers and track KPIs related to cost, quality, delivery, and sustainability.
- Provide strategic insights to support long-term category planning.
Category & Sourcing Support
- Support the development and execution of global sourcing strategies for resins and plastics.
- Provide analytical support for supplier negotiations, including cost breakdown analysis and volume modeling.
- Maintain supplier performance scorecards and KPI dashboards.
- Partner with Category Leads to identify cost reduction, consolidation, and risk mitigation opportunities.
Supply Chain ESG Monitoring & Governance
- Support rollout and ongoing management of Supply Chain ESG monitoring systems across Magna Exteriors' supplier base.
- Serve as point of contact for ESG-related topics for suppliers.
- Facilitate discussions with critical suppliers to ensure compliance with ESG nomination criteria.
- Lead follow-up actions including corrective action plans and supplier escalations for underperforming ESG suppliers.
- Support due diligence obligations related to supply chain compliance (legal, CSR, regulatory requirements).
- Partner with Sustainability and Global SCM teams to develop measurable ESG strategies and targets.
- Actively participate in Magna/Group/Division-level ESG governance meetings.
Supply Chain ESG Liaison
- Point of contact for ESG-related topics for suppliers
- Support due diligence obligations (legal, CSRs,...) related to the Supply Chain
- Support Group and Division purchasing in communicating with OEMs & suppliers on ESG-relevant topics
- Support the Sustainability team & Magna International SCM organization in interacting with suppliers to promote sustainability goals
- Support the Sustainability team & Magna International SCM organization in developing feasible strategies and targets for Groups and Divisions
- Actively participate in the company's ESG meetings at Magna/Group/Division level.
Supply Chain ESG Support
- Point of contact for ESG-related topics for suppliers
- Support due diligence obligations (legal, CSRs,...) related to the Supply Chain
- Support Group and Division purchasing in communicating with OEMs & suppliers on ESG-relevant topics
- Support the Sustainability team & Magna International SCM organization in interacting with suppliers to promote sustainability goals
- Support the Sustainability team & Magna International SCM organization in developing feasible strategies and targets for Groups and Divisions
- Actively participate in the company's ESG meetings at Magna/Group/Division level
QUALIFICATIONS:
To perform this job successfully, an individual must be able to perform each essential duty and responsibility satisfactorily. The requirements listed below are representative of the knowledge, skill, ability and/or physical demands required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
- Advanced proficiency in Power BI dashboard development, including data modeling and DAX.
- Ability to extract and manipulate data using SQL queries.
- Experience working within DataBricks environments to access and transform large datasets.
- Advanced Microsoft Excel skills.
- Strong understanding of ERP systems (SAP, Oracle, QAD, etc.).
- Strong analytical, quantitative, and financial acumen.
- Ability to translate complex datasets into executive-ready insights.
- Strong communication and presentation skills supporting global stakeholders.
- Ability to manage multiple priorities in a fast-paced, matrixed organization.
- Continuous improvement mindset.
Education/Special Knowledge
Bachelor's degree in Supply Chain Management, Business, Finance, Engineering, or related field.
Experience
- 3+ years of experience in purchasing, supply chain, finance, data analytics, or manufacturing environment (automotive preferred; internships/co-ops considered).
- Experience building enterprise-level BI dashboards from raw data sources.
- Experience with ESG programs or sustainability compliance initiatives preferred.
- Project management or systems implementation experience preferred.
- Demonstrated ability to influence cross-functional teams in a global matrix organization.
Site Benefits
- Comprehensive Medical, dental, and vision plans
- 401 (k) plan with employer matching
- Profit sharing program
- Exciting internal development opportunities
- Cafe
- Parking for electric vehicles
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 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 Exteriors
Top Skills
Erp
Excel
Power BI
SAP
Tableau
Similar Jobs at Magna International
Automotive • Hardware • Robotics • Software • Transportation • Manufacturing
The Program Manager ensures customer requirements are met through multi-department collaboration, managing project deliverables, timelines, and resources during product launches.
Top Skills:
ExcelMicrosoft PowerpointMicrosoft ProjectMicrosoft Word
Automotive • Hardware • Robotics • Software • Transportation • Manufacturing
This role involves managing secondary equipment, improving processes, implementing error proofing systems, and training personnel.
Top Skills:
Assembly ProcessesAutomation TechnologyError Proofing Systems
Automotive • Hardware • Robotics • Software • Transportation • Manufacturing
Responsible for setting up and installing die line-ups, programming changes for die transfers and changes, and other designated tasks.
What you need to know about the Colorado Tech Scene
With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
