Senior Data Engineer - BI

We are looking for an experienced BI Developer with strong hands-on expertise in Power BI, Power BI Report Server (PBIRS), SSRS, SQL Server, and DAX to design, develop, and optimize business intelligence solutions within an on-premise Microsoft BI environment.

The role will collaborate closely with business stakeholders, data engineers, and data architects to deliver governed dashboards, paginated reports, semantic models, and data-driven insights.

Responsibilities

Design, develop, and maintain interactive dashboards and paginated reports using Power BI Report Server (PBIRS) and SSRS. Collaborate with business stakeholders to understand reporting requirements, define KPIs, and translate business needs into scalable BI and ETL solutions.

Build and maintain governed measures, calculations, KPI definitions, and semantic models. Perform source-to-target and source-to-report reconciliation to validate data and reporting accuracy.

Implement and manage Row-Level Security (RLS), access controls, versioning, and change management across reports, dashboards, and ETL artifacts. Develop complex SQL queries, stored procedures, views, and data extraction processes.

Optimize reports, DAX calculations, SQL queries, semantic models, and ETL processes for improved performance. Apply dimensional modelling concepts including star schema, fact and dimension tables, slowly changing dimensions, conformed dimensions, fact table grain, and surrogate keys.

Perform ad-hoc data analysis to identify trends, anomalies, risks, and business opportunities. Collaborate with data engineering and architecture teams to ensure BI solutions follow enterprise data standards and governance practices. Train and support business users in self-service analytics within governed boundaries.

Participate in peer reviews and ensure adherence to BI, reporting, ETL, and development standards. Troubleshoot data, reporting, performance, and access-related issues and coordinate with relevant teams for resolution.

Requirements

Bachelor's degree in Computer Science, Information Systems, Data Analytics, Statistics, or a related field. 6–8 years of experience in Business Intelligence, Data Integration, Data Analytics, or related roles. Strong hands-on experience with Power BI and publishing reports to Power BI Report Server (PBIRS).

Strong experience developing SSRS and paginated reports. Proficiency in DAX, including measures, calculated columns, and KPI expressions. Strong SQL Server skills, including complex joins, stored procedures, CTEs, views, and query tuning. Strong understanding of dimensional modelling and data warehousing concepts.

Hands-on experience implementing Row-Level Security (RLS) in Power BI. Experience with ETL and data integration concepts and processes. Strong analytical, problem-solving, and stakeholder management skills. Excellent communication and presentation skills.

Experience in financial services, investment banking, banking, or fintech will be preferred. Experience with Power BI Report Server administration, including scheduling, subscriptions, folder security, and access management, will be an advantage.

Experience working in regulated environments involving data classification, sensitivity labelling, and access governance will be preferred. Experience with Talend or other enterprise ETL/data integration platforms will be an advantage.

Relevant certifications in Power BI, Microsoft BI, Data Analytics, or related technologies will be preferred.