BI Developer

ExlService Holdings, Inc.; Gurugram District; On-site; INR 900,000 - 1,300,000; Full time

Job summary

EXL Talent Acquisition Team in Gurugram seeks an experienced BI developer to design interactive Power BI reports and dashboards, implement DAX measures, and manage data refresh with gateways.

You will connect to SQL Server, Excel, and APIs, craft SQL queries and ETL via SSIS, and support MDX/SSAS as needed; strong communication is essential for stakeholder collaboration.

Qualifications

• Experience designing interactive Power BI reports and dashboards.
• Proficient in writing complex DAX expressions.
• Experience with data refresh, gateways, and row-level security.
• Experience publishing to Power BI Service.
• Strong SQL development: queries, stored procedures, and views.
• Experience with SSIS/ETL for data preparation.
• MDX/SSAS basics for multidimensional data.
• Excellent communication skills.

Responsibilities

• Design and develop Power BI reports/dashboards.
• Create and optimize DAX measures.
• Configure data refresh and gateways with RLS.
• Publish and share content in Power BI Service.
• Connect to data sources (SQL Server, Excel, APIs).
• Extract data from relational databases.
• Develop SQL queries, stored procedures, and views.
• Develop SQL/SSIS ETL for Power BI reports.
• Support MDX/SSAS cubes for select use cases.
• Automate report refresh with T-SQL/SQL.
• Communicate effectively with stakeholders.

Skills

DAX expressions

SQL

Data extraction

Communication

Tools

Power BI

SSRS

Report Builder

SSIS

MDX

SSAS

T-SQL

SQL Server

Power BI Service

Job description

• Designing interactive reports and dashboards using PowerBI or leverage SSRS or Report Builder
• Writing complex DAX expressions for custom measures and calculations
• Configuring scheduled data refresh and Power BI Gateways, Implementing Row Level Security
• Publishing and sharing content through Power BI Service
• Connecting to various data sources (SQL Server, Excel, APIs, etc.)
• Data extraction from relational databases and external sources
• Create, modify and test various SQL queries, stored procedures and views for obtaining data from diverse source systems and platforms
• Design and develop new SQL/SSIS code as part of an ETL process to support report development on PowerBI
• Support multi-dimensional cube development using MDX in SSAS for select use cases or run existing assets
• Develop stored procedures functions using T-SQL/SQL to automate report refresh or data views
• Excellent verbal and written communication skills including demonstrated ability to effectively and professionally communicate with others, including situations where you may disagree with people