Magna

Expert, Business Intelligence and Data Analyst

Magna$105K *
Finance & Insurance
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 6+ years in financial and consolidation processes (automotive industry preferred)
  • Bachelor's degree in commerce or business management
  • Strong knowledge of SAP FI/CO and financial reporting
  • Experience with SAP BW-IP planning and BW reporting tools
  • Proven troubleshooting skills for complex data issues
  • Strong analytical mindset with focus on data accuracy
  • Basic knowledge of SD, PP and MM modules.

Responsibilities

  • Act as functional expert for SAP Finance data (FI/CO/PS)
  • Validate financial data flows for P&L and Balance Sheet alignment
  • Lead root cause analysis for discrepancies
  • Support project-based planning with WBS elements and budgeting
  • Maintain planning processes using SAP BW-IP
  • Enable reporting using Power BI and relevant tools
  • Act as escalation point for complex issues and provide consultative troubleshooting

Benefits

  • Annual discretionary bonus
  • Regular, permanent position
  • Collaborative work environment
  • Opportunities for professional development
  • Engagement with global financial key users and directors
Full Job Description
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.
  • 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).

Worker Type:

Regular / Permanent

Group:

Magna Powertrain

About Magna

Magna Careers

Join Magna’s dynamic team of professionals and be part of a company that’s leading the way in automotive innovation. At Magna, we offer unparalleled job opportunities in an environment that values diversity, leadership, and growth. Work You’ll Do At Magna, we are committed to fostering an inclusive culture where every team member is empowered to contribute, innovate, and excel. We believe that diverse perspectives lead to groundbreaking ideas and better decisions. Joining our team means you’ll work alongside some of the industry’s most talented professionals, using state-of-the-art technology to create revolutionary automotive solutions. Lead in a Unique Market Position Magna stands at the forefront of the automotive industry, combining advanced technology, deep industry expertise, and a commitment to innovation that drives us forward. As a leader in our field, we offer careers that are not just jobs, but pathways to personal and professional growth. Explore Magna’s Job Opportunities Whether you’re looking for a position in engineering, design, production, or management, Magna has a place for you. Our global presence offers a wealth of opportunities for career advancement, professional development, and networking. From internships that provide real-world experience to leadership roles that challenge your skills, Magna is dedicated to helping you reach your full potential. Innovative Work Environment Magna is committed to innovation and excellence. Our team is constantly pushing the boundaries of what’s possible in the automotive world, making it an exciting place to grow your career. We encourage creativity and initiative, and we reward our employees with the benefits and support they need to succeed both professionally and personally. Be Part of a Great Team At Magna, you’ll find a collaborative environment that values teamwork and open communication. Our employees share a common goal: to lead the industry through innovation, efficiency, and sustainability. With diversity training and a focus on inclusive employment practices, Magna is a place where everyone can thrive. Future-Proof Your Career With Magna, you’re not just finding a job; you’re building a career. We offer extensive training and development programs to help you continue learning and evolving as a professional. With opportunities for advancement and a culture that promotes from within, Magna empowers you to design a career path that meets your ambitions. Stay Connected Join Our Team Search for open positions that match your skills and interests. We are always on the lookout for passionate, curious, and innovative team players. Explore the possibilities that Magna offers. SEARCH MAGNA JOBS Keep Up to Date Stay informed with career tips, insider perspectives, and industry-leading insights you can use today—all from the people who work here. READ CAREERS BLOG Job Alert Emails Customize your subscription to receive job alerts, the latest news, and insider tips tailored to your preferences. Discover the exciting and rewarding career opportunities that await at Magna.
Learn more about Magna
Size
161,000 employees
Market Cap
$15.9 billion
Industry
5 Year Trend
-0.1%
NASDAQ

Similar Jobs

More Jobs at Magna

More Finance & Insurance Jobs

Find similar Expert, Business Intelligence and Data Analyst jobs: