Power BI Engineer

Job description

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. <p normal"="

Qualifications

BACHELOR OF ENGINEERING