Expert, Business Intelligence and Data Analyst

Magna International; Aurora; On-site; CAD 90,000 - 120,000; Full time

Job summary

Magna Powertrain in Canada seeks an experienced SAP/BI Finance Data Specialist to bridge finance and IT. You will translate business needs into data solutions, safeguard data integrity, and ensure reporting reflects financial reality.

Lead SAP FI/CO/PS data, BW-IP planning, BW reporting tools (Analysis for Office, BEx) and assist with Databricks integration while supporting modern data platforms and governance. Collaborate with cross-functional teams to drive data quality.

Qualifications

• 6+ years of expertise in financial and consolidation processes – automotive industry preferred.
• Bachelor’s degree in commerce or business management.
• Strong functional knowledge of SAP FI/CO and financial reporting structures.
• Experience with SAP BW-IP planning and BW reporting tools (Analysis for Office, BEx).
• Proven ability to troubleshoot and resolve complex data and process issues.
• Strong analytical mindset with attention to data accuracy.
• Basic knowledge of SD, PP and MM modules.
• Understanding of SAP BW/4HANA and data modeling concepts.
• Exposure to modern data platforms (e.g., Databricks, data lakes, cloud integration tools).

Responsibilities

• Act as the functional expert for SAP Finance data, including G/L, AP/AR, cost centers, internal orders and profitability analysis (CO-PA).
• Provide planning and reporting support using SAP BW-IP and enable reporting via Power BI, Analysis for Office and BEx.
• Act as escalation point for complex issues and advise on long-term, sustainable fixes.
• Collaborate with technical teams to support SAP BW data models and architecture and optimize performance.
• Support transition from traditional SAP BW to modern data environments, including cloud platforms and data governance.

Skills

SAP FI/CO/PS

G/L AP/AR

CO-PA profitability analysis

SAP BW-IP planning

BEx Query Designer

Analysis for Office

Databricks integration

SAP BW/4HANA data modeling

Data governance

Education

Bachelor’s degree in commerce or business management

Tools

SAP BW-IP

BEx Query Designer

Analysis for Office

Databricks

Job description

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

Transforming mobility. Making automotive technology that is smarter, cleaner, safer and lighter. That’s what we’re passionate about at Magna Powertrain, and we do it by creating world-class powertrain systems. We are a premier supplier for the global automotive industry with full capabilities in design, development, testing and manufacturing of complex powertrain systems. Our name stands for quality, environmental consciousness, and safety. Innovation is what drives us and we drive innovation. Dream big and create the future of mobility at Magna Powertrain.

Job Responsibilities

Salary: Starting at $105,000 CAD per year with annual discretionary bonus. Immediate, open position.

Position Overview

Serve as an internal expert for the existing financial data landscape, ensuring business needs are accurately translated into effective system solutions. This role bridges finance and IT stakeholders together by applying strong functional domain knowledge to align technical support with business reality, safeguard data integrity and quality and ensure the system reflects the underlying purpose and meaning of financial information.

Key Responsibilities

• Functional Expertise & Data Integrity: Act as the functional expert for SAP Finance data (mostly SAP FI/CO/PS), including G/L, AP/AR, cost centers, internal orders, and profitability analysis (SAP CO-PA). Validate financial data flows to ensure alignment with P&L and Balance Sheet structures. Lead root cause analysis when discrepancies arise, identifying gaps between business logic and technical processing.
• Planning & Reporting Support: Support and maintain planning processes using SAP BW-IP, including design and troubleshooting of planning sequences. Enable reporting through Power BI, Analysis for Office and BEx Query Designer. Work closely with business users to ensure reporting outputs meet financial requirements.
• 3rd Level Support & Continuous Improvement: Act as the escalation point for complex issues (e.g., failed process chains, planning errors). Provide consultative troubleshooting with a focus on long-term, sustainable fixes. Review and assess change requests to ensure business value without compromising system stability. Proactively identify and implement improvements to reporting and analytic processes and data quality.
• Technical & Data Landscape Support: Collaborate with technical teams to support SAP BW data models and architecture (e.g., aDSOs, CompositeProviders). Contribute to performance optimization using tools such as FOX formulas or AMDP (where applicable). Support integration between SAP and external data platforms (Databricks, OneStream..) as needed.
• Strategic Data Enablement: Support the transition from traditional SAP BW to modern data environments, including cloud and lakehouse platforms. Contribute to data governance practices, including data lineage and metadata management. Help bridge SAP data with external platforms (e.g., Databricks, SAP Datasphere, OData interfaces).

Customers and Business Interfaces

• Financial Key user, Directors and local End-users in different countries globally.

Requirements and Qualifications

• 6+ Years of expertise in financial and consolidation processes – automotive industry preferred.
• Bachelor’s degree in commerce or business management.
• Strong functional knowledge of SAP FI/CO and financial reporting structures.
• Experience with SAP BW-IP planning and BW reporting tools (Analysis for Office, BEx).
• Proven ability to troubleshoot and resolve complex data and process issues.
• Strong analytical mindset with attention to data accuracy.
• Basic knowledge of SD, PP and MM modules.
• Understanding of SAP BW/4HANA and data modeling concepts.
• Exposure to modern data platforms (e.g., Databricks, data lakes, cloud integration tools).

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 in 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 Powertrain

We see a future where everyone can live and move without limitations. That’s why we are developing technologies, systems and concepts that make vehicles safer and cleaner, while serving our communities, the planet and, above all, people. In the right environment, your ideas can turn into industry-changing automotive technologies and improve the lives of people around the world. Let’s create the future of mobility, together. Learn more about us: Sustainability Innovation Interview-Tips