Data Engineer

About the Role

****** is seeking a Data Engineer to join their team in Riyadh, Saudi Arabia. This is a full-time position requiring 0-1 years of experience. The Data Engineer will be responsible for building and maintaining data pipelines that transfer data from client operational systems into the data warehouse, along with the associated data models. This includes data ingestion, processing, modeling, and documentation, as well as performing analyst work to ensure data accuracy.

Key Responsibilities

• Profile new data sources, including databases, APIs, files, open data, structured, and unstructured formats, before pipeline construction.
• Build, schedule, and monitor data ingestion and processing pipelines using existing client tools, extending them as needed.
• Design and build data warehouse models, such as star schemas and conformed dimensions, to support dashboards and machine learning applications.
• Implement data quality checks and lineage capture within every pipeline.
• Maintain current conceptual, logical, and physical data model documentation.
• Collaborate with business owners to reconcile figures, define Key Performance Indicators (KPIs), and assist in preparing monthly progress reports.

Required Qualifications and Skills

• Strong proficiency in Python and SQL, with experience using them in production environments.
• Experience with Spark (Databricks or Hadoop) and BigQuery.
• Comfortable with both data lake and data warehouse patterns.
• Hands-on experience with at least two of the following tools: Talend, Informatica, NiFi, and Denodo.
• Experience extracting and capturing changes from MS SQL Server, Oracle, MySQL, and PostgreSQL.
• Experience ingesting data from APIs, files (SFTP, Excel, CSV), and open data, in both batch and streaming modes.
• Expertise in dimensional modeling, including star schemas, conformed dimensions, and slowly changing dimensions.
• Ability to document data models at conceptual, logical, and physical levels.
• Proficiency in orchestration, monitoring, retries, data quality checks, and lineage.
• Experience with profiling, reconciliation, and defining KPIs in collaboration with business users.

Preferred Skills

• Experience with dbt, Airflow, Dataflow, and Iceberg.
• Google Professional Data Engineer or Databricks certification.

Work Environment

This is a full-time position based in Riyadh, Riyadh, Saudi Arabia. The role involves working within a team focused on data engineering initiatives for *******