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.