Job description
Job Title
Business Intelligence (BI) Developer / Consultant
Business Intelligence (BI) Developer / Consultant
Role Overview
We are looking for a Business Intelligence professional responsible for designing, developing, and implementing BI solutions that support executive decision-making, operational monitoring, performance management, and data-driven business insights.
Business Intelligence professional
The role will involve translating business and reporting requirements into KPI frameworks, dashboards, reports, analytical models, and data visualization solutions. The BI professional will work closely with business stakeholders, Business Analysts, Data Engineers, Data Architects, and Data Governance teams to ensure that BI solutions deliver accurate, meaningful, and actionable insights.
KPI frameworks, dashboards, reports, analytical models, and data visualization solutions
Key Responsibilities
Gather, analyse, and translate business and reporting requirements into effective BI solutions.
BI solutions
Design and develop executive dashboards, KPI scorecards, operational dashboards, and management reports.
executive dashboards, KPI scorecards, operational dashboards, and management reports
Develop KPI and Data Quality reporting solutions to support performance monitoring and decision-making.
KPI and Data Quality reporting solutions
Define and implement approved KPIs, measures, calculations, business rules, dimensions, and reporting logic.
KPIs, measures, calculations, business rules, dimensions, and reporting logic
Develop interactive dashboards with appropriate filters, drill-downs, navigation, and analytical views.
Perform data analysis to identify trends, patterns, anomalies, performance gaps, and business insights.
trends, patterns, anomalies, performance gaps, and business insights
Develop and maintain semantic, logical, and analytical data models for BI reporting.
semantic, logical, and analytical data models
Work with data engineering teams to ensure the availability, quality, and suitability of data required for BI solutions.
Develop reports and dashboards using enterprise BI and visualization platforms such as Power BI, Tableau, SAP BusinessObjects, or equivalent tools.
Power BI, Tableau, SAP BusinessObjects, or equivalent tools
Write and optimize SQL queries to extract, transform, validate, and analyse data.
SQL queries
Develop calculated measures, KPIs, and analytical logic using appropriate BI technologies.
Validate dashboard and report results against source data and approved business requirements.
Perform data profiling and data quality checks to ensure accuracy and consistency of BI outputs.
Optimize dashboard and report performance through efficient data modelling, query optimization, calculations, and data refresh strategies.
data modelling, query optimization, calculations, and data refresh strategies
Support integration of BI solutions with enterprise data warehouses, databases, cloud platforms, and other data sources.
Work with stakeholders to review dashboards, reports, KPIs, and analytical outputs and incorporate approved feedback.
Conduct dashboard and report testing and support User Acceptance Testing (UAT).
User Acceptance Testing (UAT)
Deploy and publish BI reports and dashboards to appropriate environments.
Maintain BI solution documentation, including data sources, mappings, KPIs, calculations, business rules, and reporting specifications.
Support BI governance through appropriate access controls, security, metadata management, and reporting standards.
Provide ad-hoc analysis and reporting to support management and business decision-making.
Continuously improve BI solutions based on changing business requirements and analytical needs.