View job here
Role Overview

The Business Intelligence Analyst is responsible for building and maintaining end-to-end reporting and analytics solutions by transforming raw data into reliable, business-ready insights. This role operates across the full BI pipeline, using Python for data preparation and loading, SQL for core transformations and modeling, and Excel Power Query, DAX, and Power BI for analytical modelling, KPI creation, and reporting.
The analyst works closely with business stakeholders to understand requirements, ensure data accuracy, and deliver scalable, well-structured analytics that support operational and strategic decision-making.

Key Responsibilities
 
Data Ingestion & Preparation
  • Use Python to clean, normalize, validate, and prepare raw data from multiple sources (files, databases).
  • Perform sorting, deduplication, enrichment, and structural transformations prior to loading.
  • Load processed datasets into the data warehouse.
Data Transformation & Modelling
  • Develop and maintain SQL views, transformations, and aggregations within the data warehouse.
  • Apply business logic, classification rules, and KPI calculations at the SQL layer.
  • Optimize SQL queries for performance, consistency, and reusability.
  • Maintain clean, well-structured fact and dimension logic to support downstream analytics.
Analytics Layer (Excel, Power Query & DAX)
  • Consume SQL-based datasets in Excel Power Query for additional shaping and model preparation.
  • Build robust Data Models with clear relationships and granularity control.
  • Create advanced DAX measures and calculated columns for KPIs, SLA metrics, time intelligence, and performance tracking.
  • Ensure correct handling of business calendars, working hours, and edge-case scenarios.
Reporting & Visualization
  • Design and maintain Power BI dashboards and reports for operational and management-level insights.
  • Create Excel-based analytical reports and pivots where required.
  • Ensure consistency of KPIs and definitions across Excel and Power BI.
  • Support ad-hoc analysis requests and deep-dive investigations.
Quality, Governance & Collaboration
  • Validate data accuracy across the entire pipeline from source to report.
  • Document logic, calculations, and transformation rules.
  • Proactively identify data issues, gaps, and improvement opportunities.
 
Technical Skills
Minimum requirement:
  • Python – data cleaning, transformation, and loading into data warehouse.
  • SQL (essential) – advanced querying, transformations, views, aggregations, and performance optimization.
  • Excel Power Query – data shaping and preparation.
  • DAX – complex measures, calculated columns, and time-based logic.
  • Strong understanding of data warehousing concepts (facts, dimensions, grain).
 
Preferred:
  • Power BI – data modelling, report development, dashboards, and visualization.
  • Analytical & Professional Skills
  • Strong analytical thinking and attention to detail.
  • Ability to work with complex, multi-source datasets.
  • Clear communication of insights to technical and non-technical audiences.
  • Ability to manage multiple analytical requests simultaneously.
 
Preferred Qualifications
  • Experience working in a centralized BI or data warehouse environment.
  • Exposure to large operational datasets (e.g., contact centre, sales, or transactional data).
  • Experience with KPI frameworks, SLA metrics, and performance reporting.
  • Familiarity with data quality controls and validation techniques.
 
What This Role Delivers
  • A reliable, scalable BI pipeline from raw data to decision-ready insights.
  • Consistent KPIs across SQL, Excel, and Power BI.