Specialist – Power BI

Magna International; Bengaluru; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Magna Powertrain is seeking a skilled Power BI Specialist to join our data and analytics team in Bengaluru. You will design and develop interactive dashboards, reports and data models, collaborating with multiple departments to translate business needs into actionable insights.

The role focuses on Power BI, Microsoft Fabric, and data governance across development, test and production environments. A strong background in analytics, SQL, and visualization is essential for success.

Qualifications

• Bachelor's degree in computer science, information technology, engineering or related field.
• Knowledge of BI 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 a plus.

Responsibilities

• Collaborate with stakeholders to gather requirements and define reporting objectives.
• Design and develop scalable data models to support reporting needs.
• Transform raw data into meaningful insights using Power BI and Microsoft Fabric.
• Clean, validate and integrate data from multiple sources for accuracy.
• Optimize data models, DAX measures and reports for performance and usability.
• Implement and maintain Row-Level Security and governance for data access.
• Publish, deploy and maintain Power BI reports and semantic models across environments.
• Train end users to effectively use Power BI tools and features.

Skills

Power BI

SQL

DAX

Data Modeling

ETL

Dashboard Design

Azure Databricks

Security & Governance

Team Collaboration

Education

Bachelor's degree in CS/IT/Engineering

Tools

Microsoft Fabric

Power Apps

Power Automate

Job description

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. Under conditions defined by applicable law, you may have the right to request an explanation of how AI is used to support decision‑making.

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.

Worker Type

Regular / Permanent

Group

Magna Powertrain