Developer, BI CoE

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:
Magna is more than one of the world's largest suppliers in the automotive space. We are a mobility technology company built to innovate, with a global, entrepreneurial-minded team. With 65+ years of expertise, our ecosystem of interconnected products combined with our complete vehicle expertise uniquely positions us to advance mobility in an expanded transportation landscape.
Job Responsibilities:
We are seeking a Power BI Developer who can design and deliver complex analytical solutions using Microsoft Power BI and Fabric. Beyond report development, this role will also be responsible for the maintenance, administration, and optimization of the Power BI Tenant and Capacities, ensuring smooth platform operations for enterprise BI users. Working knowledge of Azure Databricks, Delta Lake, and Lakehouse concepts will be highly desirable as the organization continues to modernize its analytics landscape.
Key Responsibilities:
1. Power BI Development

• Develop complex, enterprise-grade Power BI reports and dashboards with strong focus on UI/UX, performance, and usability.
• Build reusable semantic models following best practices in star schema, dimensional modeling, and OneLake/Fabric integration.
• Implement advanced DAX, calculated tables, and optimized measures.
• Use incremental refresh, composite models, Direct Lake (Fabric), and performance optimization techniques.

2. Power BI Tenant & Platform Administration

• Administer the Power BI Tenant including:
  • Workspace provisioning and lifecycle management
  • Access and permissions aligned with governance standards
  • Gateway configuration (if applicable)
  • Dataflow and pipeline oversight
• Support enterprise users by providing guidance, resolving issues, and ensuring adoption of best practices.
• Monitor dataset refreshes, audit logs, lineage, and tenant-wide compliance settings.
• Ensure security implementation across RLS, OLS,ABAC, data sensitivity labels.

3. Databricks Integration (Desirable)

• Integrate Power BI with Databricks SQL Warehouse, Unity Catalog, and Lakehouse tables.
• Understand medallion architecture (Bronze → Silver → Gold) and how Power BI semantic models interface with curated layers.
• Write and optimize SQL queries on Databricks; familiarity with Delta Lake and notebook workflows is a plus.

4. Collaboration & Governance

• Work with business users, data engineers, and analysts to translate needs into scalable BI solutions.
• Document semantic models, dataflows, metrics logic, and governance artifacts.
• Support enterprise BI governance frameworks, including naming conventions, certification processes etc
• Participate in CoE activities such as office hours, community support, demos, and platform enablement.

Required Skills & Qualifications

• 3-6 years of experience developing Power BI reports and semantic models.
• Strong hands-on experience with DAX, Power Query (M), Fabric/Power BI Service, and workspace management.
• Deep understanding of data modeling, star schema, and performance engineering.
• Proficiency with SQL and ability to work with enterprise-scale data sources.
• Experience in capacity monitoring, dataset refresh troubleshooting, and platform administration.

Desirable Skills

• Data Engineering experience with Exposure to Azure Databricks, Delta Lake, Unity Catalog, and medallion architecture.
• Familiarity with Microsoft Fabric components (Lakehouse, Pipelines, Warehouse, Direct Lake).
• Understanding of CI/CD for Power BI reports and datasets.

Soft Skills

• Strong analytical and problem-solving mindset.
• Excellent communication and ability to work with cross-functional teams.
• Ability to manage priorities in a fast-paced, evolving environment.
• Strong documentation and stakeholder engagement skills.

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 Corporate