Business Intelligence – Job Description

Job Title

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.

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.

Key Responsibilities

• Gather, analyse, and translate business and reporting requirements into effective BI solutions.
• Design and develop executive dashboards, KPI scorecards, operational dashboards, and management reports.
• Develop KPI and Data Quality reporting solutions to support performance monitoring and decision-making.
• Define and implement approved 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.
• Develop and maintain semantic, logical, and analytical data models for BI reporting.
• 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.
• Write and optimize SQL queries to extract, transform, validate, and analyse data.
• 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.
• 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).
• 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.

Required Skills & Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Business Analytics, Engineering, Business Administration, or a related field.
• 4–8 years of experience in Business Intelligence, BI Development, Data Analytics, Reporting, or a related role.
• Strong hands-on experience in Power BI, Tableau, SAP BusinessObjects, or equivalent BI platforms.
• Strong understanding of KPI development, dashboard design, reporting, data analysis, and business intelligence concepts.
• Strong SQL skills and experience working with relational databases.
• Experience with data modelling, including logical, physical, dimensional, or semantic models.
• Experience translating business requirements into reports, dashboards, KPIs, and analytical solutions.
• Experience working with multiple data sources and integrating data for BI reporting.
• Strong understanding of data quality, data validation, and data reconciliation.
• Strong analytical and problem-solving skills.
• Excellent communication and stakeholder management skills.

Preferred Skills

• Advanced Power BI experience, including DAX, Power Query, data modelling, and dashboard development.
• Experience with Tableau, SAP BusinessObjects, SAP Analytics Cloud, QlikView, MicroStrategy, or similar BI platforms.
• Strong SQL and experience with SQL Server, Oracle, MySQL, SAP HANA, or similar databases.
• Experience with ETL/data integration technologies such as SSIS, Informatica, Talend, Azure Data Factory, or equivalent.
• Knowledge of cloud and modern data platforms such as Microsoft Fabric, Azure Synapse, Databricks, Snowflake, or equivalent technologies.
• Understanding of Data Governance, Metadata Management, Data Quality, and Data Management.
• Experience developing executive scorecards and C-level reporting.
• Knowledge of advanced analytics, forecasting, trend analysis, cohort analysis, and what-if analysis.
• Experience with Agile/Scrum methodologies and tools such as Jira or Azure DevOps.

Key Deliverables

• Executive KPI dashboards
• KPI and Data Quality dashboards
• Operational and management reports
• Executive scorecards
• BI analytical solutions
• Interactive dashboards and visualizations
• KPI definitions and calculation logic
• Analytical and semantic data models
• SQL queries and data extraction solutions
• Data validation and reconciliation results
• BI solution documentation
• UAT-ready and production-ready reports and dashboards
• Ad-hoc business analysis and reporting

Core Competencies

Business Intelligence | BI Development | Data Analytics | Power BI | Tableau | SAP BusinessObjects | KPI Development | Executive Dashboards | Data Visualization | Data Modelling | SQL | DAX | Power Query | Data Quality | Data Validation | Reporting & Analytics | ETL | Data Integration | Data Governance | Metadata Management | Executive Reporting | UAT | Stakeholder Management