Specialist – Power BI

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:

Job title:

Specialist – Power BI

Job Introduction:

We are seeking a highly skilled and experienced PowerBI Specialist to join our team. The ideal candidate will have a strong background in data analysis, visualization, and reporting using the PowerBI platform. As a PowerBI Specialist, you will work closely with various departments to gather requirements, design, and develop data models, and create visually compelling and interactive reports and dashboards. You will play a key role in driving data insights, decision-making, and overall business performance.  

Major Responsibilities:

• Collaborate with stakeholders to gather requirements and understand business objectives for reporting and analytics.

• Design and develop efficient and scalable data models to support reporting needs.

• Utilize Power BI and Microsoft Fabric to transform raw data into meaningful insights, visually engaging reports, and interactive dashboards.

• Clean, validate, and integrate data from multiple sources to ensure data accuracy and consistency.

• Optimize data models, DAX measures, and reports for performance and usability.

• Collaborate with IT and data teams to ensure proper data governance, security, and data quality standards.

• Experience with Microsoft Fabric for building and managing analytics solutions.

• Develop and maintain Microsoft Fabric components such as Lakehouse, Data Warehouse, Dataflows Gen2, and Semantic Models.

• Support the migration of Power BI solutions to the Microsoft Fabric platform.

• Work with deployment pipelines, Git integration, and CI/CD processes for Power BI and Microsoft Fabric.

• Collaborate with data engineering teams to integrate data from Azure Databricks and Microsoft Fabric.

• Publish, deploy, and maintain Power BI reports and semantic models across Development, Test, and Production environments.

• Train and support end users to effectively utilize Power BI tools and features.

• Stay up to date with the latest Power BI, Microsoft Fabric, and industry best practices.

• Provide technical expertise and troubleshoot Power BI and Microsoft Fabric-related issues.

• Evaluate and recommend new tools and technologies to enhance data analysis and reporting capabilities.

• Implement and maintain Row-Level Security (RLS) and ensure secure access to reports and datasets.

• Monitor Power BI Service performance, refresh history, and resolve refresh failures and service-related issues.

• Troubleshoot Power BI Service issues related to report performance, dataset refreshes, gateways, and user access.

• Support and continuously improve existing Power Apps and Power Automate solutions.

• Write and optimize SQL queries to support reporting and analytics requirements.

• Maintain a high degree of user focus, service orientation, and collaboration with cross-functional teams.

Knowledge and Education:

• Bachelor’s degree in computer science, Information Technology, Engineering, or a related field.

• Knowledge of Business Intelligence concepts and data visualization best practices.

• Understanding of SQL, relational databases, and data warehousing concepts.

• Knowledge of Power BI Service, Power Query, and DAX.

• Familiarity with Microsoft Fabric, Power Automate, and Power Apps is an added advantage.

Work Experience:

5+ years of experience in Power BI development, designing and delivering interactive dashboards, reports, and business intelligence solutions.

Skills and Competencies:

• Strong expertise in Power BI Desktop and Power BI Service.

• Advanced DAX and Power Query (M Language).

• SQL querying and database concepts.

• Data modeling (Star Schema/Snowflake Schema).

• ETL and data transformation.

• Dashboard design and visualization best practices.

• Report performance optimization.

• Analytical and problem-solving skills.

• Excellent communication and stakeholder management.

• Ability to work independently and collaboratively in a team.

• Knowledge of Microsoft Fabric, Power Automate, and Power Apps is an added advantage.

Health, Safety & Environment (HSE):

Maintains safe work practices, complies with Magna H&S requirements, and participates in training and hazard reporting.

Work Environment:

Regular overnight travel 10-25% of the time

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