BI Analyst

Rockwell Automation; New Delhi; On-site; INR 1,200,000 - 1,800,000; Full time

Benefits offered by this job

Mindfulness program

Volunteer time off

Donation matching

Employee assistance program

OnTrack wellbeing program

Online course library

Job summary

Rockwell Automation in New Delhi is seeking a Power BI‑focused BI Analyst to join an agile team responsible for scalable analytics solutions. You will design, develop, and support Power BI dashboards, data models, and reporting to enable data‑driven decisions across global stakeholders.

The role requires end‑to‑end BI solution development, strengths in Power BI, DAX, Power Query, SQL‑based data sources, and a data‑first mindset.

Qualifications

• Bachelor's degree in Computer Science or related field.
• 5+ years of Power BI development experience.
• Strong SQL, relational databases, and dimensional modeling (star schema).
• Experience with enterprise data sources (Azure SQL, SharePoint, Dataverse).
• Ability to translate business requirements into analytical insights.

Responsibilities

• Gather and translate business requirements into scalable BI solutions.
• Design, develop, and maintain Power BI dashboards, reports, and semantic data models.
• Apply dimensional modeling and semantic model design best practices.
• Build and optimize data models using Power Query, DAX, and relational models.
• Ensure data accuracy and consistency across reports.
• Optimize dataset performance and refresh efficiency.
• Align outputs with KPI definitions and business frameworks.
• Develop reusable governed datasets and data models.
• Identify and resolve data quality issues with data owners.

Skills

Power BI development

SQL

DAX

Power Query

Data modeling

Education

Bachelor's degree in Computer Science, Engineering, or equivalent

Tools

Azure SQL

SharePoint

Dataverse

SQL Server

Job description

Rockwell Automation is a global technology leader focused on helping the world’s manufacturers be more productive, sustainable, and agile. With more than 28,000 employees who make the world better every day, we know we have something special. Behind our customers – amazing companies that help feed the world, provide life‑saving medicine on a global scale, and focus on clean water and green mobility –our people are energized problem solvers that take pride in how the work we do changes the world for the better.

We welcome all makers, forward thinkers, and problem solvers who are looking for a place to do their best work. And if that’s you we would love to have you join us!

Rockwell is seeking a Power BI-focused BI Analyst to join an agile team responsible for delivering scalable, enterprise-grade analytics solutions. This role will primarily focus on designing, developing, and supporting Power BI dashboards, data models, and reporting solutions to enable data‑driven decision‑making across global stakeholders.

You will be reporting to TEAM LEAD - BI & DATA ANALYTICS.

Position Summary:

The BI Analyst will be responsible for end‑to‑end Power BI solution development, including data modelling, report design, performance optimization, and governance. The ideal candidate should have strong expertise in Power BI, data analytics, and SQL‑based data sources, along with the ability to translate business requirements into actionable insights.

This role requires a data‑first mindset, strong analytical skills, and hands‑on experience in building scalable BI solutions leveraging Power BI, Power Query, and enterprise data platforms (Azure SQL / SharePoint / Dataverse).

Your Responsibilities:

• Gather and translate business requirements into scalable and impactful BI solutions
• Design, develop, and maintain Power BI dashboards, reports, and semantic data models for enterprise use
• Apply best practices in dimensional modeling (star schema) and semantic model design
• Build and optimize data models using Power Query, DAX, and relational data principles
• Ensure data accuracy, consistency, and validation across all reports and datasets
• Optimize dataset performance (model size, refresh efficiency, query performance)
• Align reporting outputs with standardized KPI definitions and business frameworks
• Develop and maintain reusable datasets and governed data models
• Identify and resolve data quality issues in collaboration with data owners

The Essentials – You Will Have:

• Bachelor's degree in Computer Science, Engineering, or equivalent.
• 5+ years Strong experience in Power BI development, including DAX, Power Query, and data modeling
• Solid understanding of SQL, relational databases, and dimensional modeling (star schema)
• Experience working with enterprise data sources (Azure SQL, SQL Server, SharePoint, etc.)
• Strong understanding of business KPIs (operations, finance, performance metrics)
• Translate business requirements into analytical solutions and actionable insights
• Experience working in data governance‑aligned environments

Preferred Qualifications:

• Hands‑on expertise in Power BI (DAX, Power Query, data modeling, visualization best practices)
• Experience in optimizing large‑scale or enterprise Power BI datasets and reports;
• Knowledge of data warehousing concepts, ETL processes, and data pipeline design
• Familiarity with data governance, data lineage, and reporting standards
• Exposure to advanced analytics (trend analysis, forecasting, AI‑ready datasets)
• Experience integrating Power BI with APIs, cloud platforms, or multiple enterprise systems
• Familiarity with Power Platform (Power Apps, Power Automate) – secondary skill
• Experience with Dataverse or cloud‑based data platforms
• Microsoft Certification: Power BI Data Analyst (PL-300) or equivalent

What We Offer:

Our benefits package includes …

• Comprehensive mindfulness programs with a premium membership to Calm
• Volunteer Paid Time off available after 6 months of employment for eligible employees.
• Company volunteer and donation matching program – Your volunteer hours or personal cash donations to an eligible charity can be matched with a charitable donation.
• Employee Assistance Program
• Personalized wellbeing programs through our OnTrack program
• On‑Demand digital course library for professional development

… and other local benefits!

At Rockwell Automation we are dedicated to building a diverse, inclusive and authentic workplace, so if you're excited about this role but your experience doesn't align perfectly with every qualification in the job description, we encourage you to apply anyway. You may be just the right person for this or other roles.

#LI-Hybrid

#LI-KV1

Rockwell Automation’s hybrid policy aligns that employees are expected to work at a Rockwell location at least Mondays, Tuesdays, and Thursdays unless they have a business obligation out of the office.