Data Engineer

Job Details

• Job Title: Data Engineer
• Department: Information Technology (IT)
• Reports to: Senior Manager – MDM
• Prepared By: Senior Manager – MDM
• Grade of Reporting Manager: FC09
• Prepared On: January 2026
• Proposed Grade: FC07
• Evaluated On: (not provided)
• Upgrade / New Role: New
• HoD: Vice President – IT

Business Unit Purpose

The purpose of the Data Platform department is to provide a trusted, scalable, and secure foundation for data that enables the business to make faster, better-informed decisions and build data‑driven products.

Job Purpose

Data Engineer with strong data modeling and pipeline development skills, along with hands‑on experience supporting Power BI reporting and analytics. The ideal candidate will design, build, and optimize scalable data solutions that enable reliable dashboards, self‑service analytics, and data‑driven decision‑making across the organization.

Job Dimensions and Scope

• Direct Reports: 0
• Indirect Reports: 0
• Impact on Revenue: 0 (Please Explain the Impact)
• Impact on Cost: 0 (Please Explain the Impact)
• Impact on Employee (count): 1

Organisation Structure

• Chief Executive Officer
  • Vice President – IT
    • Senior Manager Master Data
      • Data Engineer

(Manager and manager’s manager are highlighted in the hierarchy above.)

Key Result Areas

• Design, build, and maintain scalable data pipelines for ingesting data from multiple sources (databases, APIs, files, SaaS platforms)
• Develop and manage data warehouses / lakehouses using modern architectures (Delta Lake, star schema, medallion layers)
• Transform raw data into analytics‑ready datasets optimized for Power BI consumption
• Collaborate with analysts and business stakeholders to understand reporting requirements and translate them into reliable data models
• Create and maintain semantic models and optimized datasets for Power BI
• Ensure data quality through validation checks, monitoring, and reconciliation processes
• Implement incremental loads, CDC patterns, and data refresh strategies
• Optimize query performance for Power BI (model design, aggregations, partitions, DAX efficiency)
• Support production deployments, troubleshoot data issues, and improve pipeline reliability
• Document data models, pipelines, and best practices

Job Context

Data Engineer with strong data modeling and pipeline development skills, along with hands‑on experience supporting Power BI reporting and analytics. The ideal candidate will design, build, and optimize scalable data solutions that enable reliable dashboards, self‑service analytics, and data‑driven decision‑making across the organization.

Knowledge, Skills & Minimum Experience

Education Qualification

• Bachelor’s degree or similar through experience.

Work Experience

• At least 4+ years of proven experience in a Data Engineer or similar role
• 4+ years of experience with Azure Data Factory / Synapse / Databricks / Microsoft Fabric & Power BI

Technical Experience

• Strong experience as a Data Engineer or similar role
• Proficiency in SQL (advanced querying, performance tuning)
• Experience with Power BI:
  • Dataset and semantic model design
  • Star schema modeling for analytics
  • Incremental refresh and refresh optimization
  • Understanding of DAX performance (even if not writing complex DAX daily)
  • Advanced DAX and Power BI report optimization
• Experience building ETL/ELT pipelines using tools such as:
  • Azure Data Factory / Synapse / Databricks / Microsoft Fabric
  • Apache Spark / PySpark
  • Airflow or similar orchestration tools
• Hands‑on experience with data lakes, data warehouses, or lakehouse architectures
• Knowledge of cloud platforms (Azure, AWS, or GCP)

Skills

• Data analysis
• Database management
• Problem‑solving
• Familiarity with data structures, system tables, error messages, and system problem resolution
• Ability to communicate effectively, concisely, and logically in a timely manner and at an appropriate level, while maintaining confidentiality
• Excellent organizational skills to function effectively under time constraints and within established deadlines, with particular attention to detail
• Conflict resolution experience
• Flexible & adaptable through organizational growth

Competency

• Competency level (not specified)