Dieses Stellenangebot ist nicht mehr verfügbar
Über
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. 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. 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. 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. QUALIFICATIONS: 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
Sprachkenntnisse
- English
Hinweis für Nutzer
Dieses Stellenangebot wurde von einem unserer Partner veröffentlicht. Sie können das Originalangebot einsehen hier.