LCS BI Analyst

Rockwell Automation; Pune District; Hybride; INR 1 200 000 - 2 000 000; Plein temps

Avantages offerts par ce poste

Mindfulness program

Volunteer time off

Charitable donation matching

Employee assistance program

OnTrack wellbeing

Online course library

Résumé du poste

Rockwell Automation in Noida/Pune, India, seeks a BI Analyst to design end-to-end Power BI solutions for global stakeholders. You will model data, optimize performance, and govern BI assets across enterprise datasets.

The ideal candidate has strong ETL/data analytics skills, expertise in Power BI suite, SQL and enterprise data platforms, and a data-first mindset to deliver insights that drive decisions.

Qualifications

• Experience in Power BI enterprise environments.
• Strong expertise in Power BI desktop, Power BI Service, Power BI Report Server and Power Query.
• Advanced knowledge of DAX; calculated measures and tables.
• Experience building star and snowflake schemas, tabular models, and semantic data layers.
• Advanced SQL querying, stored procedures, and performance optimization on relational databases.
• Experience connecting to diverse data sources, ETL and automated incremental data refreshes.
• Row-Level Security implementation, workspace management, app publishing, deployment pipelines & licensing.

Responsabilités

• 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 modelling best practices.
• Build and optimize data models using Power Query, DAX, and relational principles.
• Ensure data accuracy and validation across all reports and datasets.
• Optimize dataset performance and refresh efficiency.
• Align outputs with standardized KPI definitions and governance.
• Develop and maintain reusable datasets and governed data models.
• Identify and resolve data quality issues with data owners.

Connaissances

Power BI enterprise environments

Power BI Desktop

Power BI Service

Power BI Report Server

Power Query

DAX

Star schema

Snowflake schema

Tabular models

SQL querying

Stored procedures

Performance optimization

RLS and deployments

Formation

Engineering graduate (B.Tech/BE - CS/IT/E&C)

Outils

SQL Server

Azure SQL

Databricks

SharePoint/Dataverse

Power BI Report Server

Description du poste

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!

Job Description

LCS BI Analyst

Noida/Pune - India

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 possess strong expertise in ETL, Power BI, data analytics, and SQL based data sources, with the ability to translate business requirements into actionable insights and compelling data-driven stories.

This role requires a data-first mindset and strong analytical skills. Additionally, it demands hands‑on experience in building scalable BI solutions, leveraging Power BI, Power Query, and enterprise data platforms (Azure SQL/SharePoint/Dataverse/Databricks). Knowledge of SAP and Salesforce.

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.

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) & semantic model design.
• Build & 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

• Engineering graduate [B. Tech/BE - CS/IT/E&C]
• Experience in Power BI enterprise environments
• Deep expertise in PBI desktop, PBI Service, PBI Report Server and Power Query
• Advanced knowledge of DAX (write, tune and optimize) queries, calculated measures and tables.
• Strong experience building star and snowflake schema architectures, tabular models, and semantic data layers
• Advanced SQL querying, stored procedures, and performance optimization on relational databases (SQL Server, Azure SQL, Databricks)
• Experience connecting to diverse data sources, ETL and designing automated incremental data refreshes
• Row-Level Security (RLS) implementation, workspace management, app publishing, deployment pipelines & licensing structures.

The Preferred – You Might Also Have

• 5+ Years of experience.
• Microsoft Certified: Power BI Data Analyst Associate (PL-300)
• Experience supporting services, manufacturing, industrial automation, engineering, or technology organizations.
• Familiarity with ERP, CRM, service management, and financial systems.
• Experience with AI, advanced analytics, or automation platforms.
• Knowledge of Agile delivery methodologies and product-based delivery models.

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.

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.