Expert, Business Intelligence and Data Analyst

Posted 4 Hours Ago
Be an Early Applicant
Aurora, ON, CAN
Hybrid
105K-105K Annually
Senior level
Automotive • Hardware • Robotics • Software • Transportation • Manufacturing
Dream big. With Us. Let's create the future of mobility, together.
The Role
Serve as the functional expert for SAP financial data, ensuring data integrity and alignment with P&L/Balance Sheet. Support SAP BW-IP planning, Power BI and BW reporting, troubleshoot complex issues, optimize BW data models, and enable integrations with modern data platforms like Databricks and OneStream.
Summary Generated by Built In

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 bonusImmediate, open positionPosition 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.
  • Support project-based planning by working with Project Systems (WBS elements, budgeting).
     
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 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 Powertrain

Skills Required

  • 6+ years expertise in financial and consolidation processes
  • Bachelor's degree in commerce or business management
  • Strong functional knowledge of SAP FI/CO and financial reporting structures (G/L, AP/AR, cost centers, internal orders)
  • Experience with SAP PS and CO-PA profitability analysis
  • Experience with SAP BW-IP planning and BW reporting tools (Analysis for Office, BEx Query Designer)
  • Understanding of SAP BW/4HANA and data modeling concepts (aDSOs, CompositeProviders)
  • Exposure to modern data platforms and integrations (Databricks, data lakes, OneStream, SAP Datasphere, OData)
  • 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
  • Automotive industry experience

What the Team is Saying

Doug
Dave
Sreeni
Sam
Jim
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Aurora, Ontario
171,000 Employees
Year Founded: 1957

What We Do

We are a mobility company that innovates like a start-up and thinks like a technology company. This helps us anticipate change in one of the most complex industries in the world and respond quickly. We depend on a team of 171,000 dynamic, entrepreneurial-minded employees in an environment where great ideas flourish. Our presence spans 343 manufacturing operations and 88 product development, engineering and sales centers in 29 countries. We understand that you need a career as unique as you are. Whether you want to advance your existing expertise or try something completely different, we are committed to your growth.

Why Work With Us

At Magna, our engineering team is advancing mobility for everyone and everything. Joining this team means being a part of the design, development, and manufacturing of the world’s most advanced mobility technology. Innovations that move families, shape communities, and improve lives. You can follow your passions and shape your own career path.

Gallery

Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery

Magna International Teams

Team
Innovation
Team
Magna International’s Pipeline for Emerging Tech Talent
About our Teams

Magna International Offices

Hybrid Workspace

Employees engage in a combination of remote and on-site work.

Majority of roles are hybrid with flexibility. Please speak with our recruiting team for specific details on hybrid work.

Typical time on-site: Not Specified
HQGlobal Headquarters - Aurora, Ontario, Canada
Bangalore, Karnataka, India
Graz, Austria
Lowell, Massachusetts
Monterrey, Mexico
Munich, Germany
Pune, Maharashtra, India
Sailauf, Germany
Saltillo, Mexico
US Headquarters - Troy, Michigan
Learn more

Similar Jobs

Magna International Logo Magna International

Manufacturing Engineering Coordinator

Automotive • Hardware • Robotics • Software • Transportation • Manufacturing
Hybrid
St. Thomas, ON, CAN
171000 Employees
83K-100K Annually

Magna International Logo Magna International

Quality Administrator / IATF Lead

Automotive • Hardware • Robotics • Software • Transportation • Manufacturing
Hybrid
Vaughan, ON, CAN
171000 Employees
80K-90K Annually

Magna International Logo Magna International

Information Technology Manager

Automotive • Hardware • Robotics • Software • Transportation • Manufacturing
Hybrid
3 Locations
171000 Employees

Magna International Logo Magna International

Manufacturing Engineering (Co-op Student)

Automotive • Hardware • Robotics • Software • Transportation • Manufacturing
Hybrid
Milton, ON, CAN
171000 Employees
23-23 Hourly

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account