Job Summary

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 solid 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/EC]

- 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.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.

Role: Analytics Consultant,

Industry Type: Management Consulting,

Department: Data Science & Analytics,

Employment Type: Full Time, Permanent

Role Category: Business Intelligence & Analytics

Education

UG: Any Graduate

PG: Any Postgraduate read more

Key Skills advanced analyticsazure sqldata analyticsbusiness requirementsdata platformsaidatabricksanalytical skillsagile deliverydata analystanalyticsdata modelsdata qualityadvanced sqlautomationdaxagileazurecrmdataverse

📌 LCS BI Analyst (Pune)
🏢 Rockwell Automation
📍 Pune