Overview

Senior Data Engineer – BI Analytics & Data Warehousing

Responsibilities

• Design, build and maintain efficient ETL and ELT pipelines using Azure Data Factory, Databricks or similar orchestration frameworks.
• Ensure reliable ingestion of data from multiple sources into centralised data warehouses and data lakes.
• Design relational and dimensional data models aligned with business and analytical requirements.
• Develop and maintain data models optimised for analytics and reporting.
• Work with modern data platforms such as Snowflake, Redshift and PostgreSQL.
• Develop efficient SQL queries and stored procedures for data transformation, cleansing and aggregation.
• Work with complex joins and analytical workloads while supporting data and query performance.
• Support reporting and dashboard development using Power BI, Tableau or similar visualisation platforms.
• Collaborate with analysts and business users to understand reporting requirements and enable self-service analytics.
• Monitor and troubleshoot data pipelines and warehouse processes.
• Implement appropriate data-quality checks and validations to ensure accurate and timely data availability.
• 5–10 years of experience in Data Engineering
• Bachelor's degree in Computer Science, Information Systems, Data Engineering or a related field
• Hands-on experience in ETL/ELT development and data modelling
• Strong SQL skills

Qualifications

• Exposure to cloud and data engineering technologies such as:
• AWS S3
• Azure Data Factory
• Databricks
• Lambda functions
• Familiarity with Python for scripting and data manipulation
• Basic understanding of JSON, Parquet and CSV
• Exposure to Power BI or Tableau will be an advantage