Developer BI & ETL

Ali Abdulwahab Al Mutawa Commercial Co.; Gouvernement Hawalli; On-site; KWD 20,000 - 33,000; Full time

Job summary

Ali Abdulwahab Al Mutawa Commercial Co. invites a Data Warehouse Engineer to design and develop analytical data models and robust data pipelines. The role focuses on enterprise reporting, data quality, and governance within a modern data warehouse environment.

The ideal candidate has 3–6 years in ETL/ELT and data warehousing, strong SQL, and hands-on experience with ERP data integration. Join a team delivering trusted data for strategic decisions.

Qualifications

• Bachelor’s degree in CS, IS, Data Engineering, or equivalent.
• 3–6 years hands-on ETL/ELT and data warehousing experience.
• Strong SQL with performance tuning.
• Experience designing and implementing DWH data models.
• ERP data integration experience is highly desirable.
• Knowledge of data quality frameworks and reconciliation methods.
• Strong documentation skills.

Responsibilities

• Design and develop dimensional and/or normalized data models to support enterprise reporting and analytics.
• Implement and maintain DWH layers (staging, integration/core, and presentation/marts).
• Establish and maintain data standards (naming conventions, keys, reference/master data alignment).
• Build and maintain ETL/ELT pipelines to ingest data from multiple sources (ERP, operational systems, flat files, APIs).
• Develop reusable transformations using SQL and ETL tools to standardize business logic and KPIs.
• Schedule, monitor, and optimize jobs for reliability and performance (incremental loads, CDC where applicable).
• Implement automated data quality checks (completeness, validity, duplicates, reconciliations).
• Perform root cause analysis for data issues and work with business/IT stakeholders to resolve upstream causes.
• Document data lineage, mapping specifications, and transformations to support auditability and trust.
• Support data governance practices (certified datasets, definitions, and KPI alignment).

Skills

SQL (advanced)

DWH data modeling

ETL/ELT development

Data quality & governance

Documentation skills

Education

Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or equivalent practical experience

Tools

SSIS

Job description

Key Responsibilities

Data Warehouse Design & Development

• Design and develop dimensional and/or normalized data models (e.g., star/snowflake) to support enterprise reporting and analytics.
• Implement and maintain DWH layers (staging, integration/core, and presentation/marts).
• Establish and maintain data standards (naming conventions, keys, reference/master data alignment).

ETL/ELT Development (Data Pipelines)

• Build and maintain ETL/ELT pipelines to ingest data from multiple sources (ERP, operational systems, flat files, APIs).
• Develop reusable transformations using SQL and ETL tools to standardize business logic and KPIs.
• Schedule, monitor, and optimize jobs for reliability and performance (incremental loads, CDC where applicable).

Data Quality, Controls, and Governance Support

• Implement automated data quality checks (completeness, validity, duplicates, reconciliations).
• Perform root cause analysis for data issues and work with business/IT stakeholders to resolve upstream causes.
• Document data lineage, mapping specifications, and transformations to support auditability and trust.
• Support data governance practices (certified datasets, definitions, and KPI alignment).

Required Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or equivalent practical experience.
• 3–6 years of hands‑on experience in ETL/ELT and data warehousing.
• Strong SQL (advanced queries, performance tuning).
• Proven experience designing and implementing DWH data models.
• Experience integrating ERP/data (e.g., Oracle JDE or similar ERP) is highly desirable.
• Working knowledge of data quality frameworks and reconciliation methods.
• Strong documentation skills.

Technical Skills

• SQL (advanced): performance tuning, indexing concepts, query optimization
• Data warehousing concepts: staging → core → marts, dimensional modeling
• ETL/ELT tooling : SSIS.
• RDBMS experience (any of): SQL Server, DB2, Snowflake, etc.