Expert, Business Intelligence and Data Analyst

Job descriptions may display in multiple languages based on your language selection.

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.

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.

Salary : Starting at $105,000 CAD per year with annual discretionary bonus

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.

• 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.

• Support project-based planning by working with Project Systems (WBS elements, budgeting).

• 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.

• 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.

• 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.

• 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).

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

• 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).

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.

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.