Power BI Engineer

Job Description – Power BI Engineer

Role Summary

We are seeking an experienced Power BI Engineer to design, develop, and maintain enterprise reporting and analytics solutions. The ideal candidate will have strong expertise in Power BI, data modelling, SQL, ETL processes, dashboard development, and cloud-based analytics platforms.

The candidate will work closely with business stakeholders, data engineers, architects, and leadership teams to deliver interactive dashboards, business insights, KPI reporting, and self-service analytics solutions. The role aligns with your current CL-BFSI hiring demand for Power BI Engineers.

Key Responsibilities

Dashboard & Report Development

• Design and develop interactive Power BI dashboards and reports.
• Build executive-level KPI dashboards and operational reports.
• Create drill-through, drill-down, and self-service reporting solutions.
• Develop reusable reporting frameworks and templates.

Data Modelling

• Design dimensional data models.
• Develop star and snowflake schemas.
• Create relationships and optimise data structures.
• Implement row-level security (RLS).

DAX Development

• Create advanced DAX calculations and measures.
• Develop custom KPIs and business metrics.
• Optimise report performance through efficient DAX coding.

Data Integration

• Connect Power BI to multiple data sources.
• Integrate SQL databases, APIs, SharePoint, Excel, and cloud sources.
• Support ETL and data transformation activities using Power Query.

Performance Optimisation

• Improve report performance.
• Optimise data refresh cycles.
• Implement incremental refresh strategies.
• Monitor dataset performance and usage.

Stakeholder Engagement

• Gather reporting requirements from business users.
• Conduct report demonstrations and walkthroughs.
• Provide analytical insights and recommendations.
• Support business decision-making with data-driven reporting.

Mandatory Technical Skills

Power BI

• Power BI Desktop
• Power BI Service
• Dataflows
• Workspaces
• Power BI Gateway
• Report Publishing
• Dashboard Development
• Deployment Pipelines

DAX

• Measures
• Calculated Columns
• Time Intelligence
• Advanced DAX Functions
• Performance Optimisation

Power Query

• M Language
• Data Transformation
• Data Cleansing
• Data Integration

SQL

• SQL Server
• Stored Procedures
• Views
• Query Optimisation
• Data Analysis

Data & Analytics Skills

Data Modelling

• Star Schema
• Snowflake Schema
• Fact & Dimension Modelling
• Data Warehousing Concepts

ETL & Data Integration

• Data Extraction
• Data Transformation
• Data Validation
• Data Quality Checks

Cloud & Microsoft Ecosystem

Azure (Preferred)

• Azure SQL
• Azure Data Factory
• Azure Synapse Analytics
• Azure Data Lake Storage
• Azure Analysis Services

Microsoft Stack

• Excel
• SharePoint
• Microsoft Fabric (Good to Have)
• Microsoft Teams Integration
• Power Platform

Reporting & Visualisation

• KPI Dashboards
• Executive Reporting
• Financial Reporting
• Operational Reporting
• Trend Analysis
• Forecasting Dashboards
• Data Storytelling

Good to Have

• Microsoft Fabric
• Databricks
• Python
• R
• Tableau
• SSRS
• SSIS
• Machine Learning Integration
• AI-powered Insights

BFSI Domain Experience (Preferred)

Experience in:

• Retail Banking
• Corporate Banking
• Payments
• Insurance
• Wealth Management
• Risk Management
• Compliance Reporting
• Regulatory Reporting

Given your BFSI hiring focus, candidates with experience in banking dashboards, operational reporting, financial analytics, and executive reporting would be advantageous.