Data Engineer

About the role

Arabic.AI is hiring a Data Engineer in Riyadh. You will build and maintain the pipelines that move data from the client's operational systems into the warehouse, and the data models that downstream work depends on. This covers ingestion, processing and modelling, plus the documentation, and the analyst work that keeps the numbers honest.

Key responsibilities

• Profile new sources before building them: databases, APIs, files, open data, structured and unstructured.
• Build, schedule and monitor ingestion and processing pipelines in the tools the client already uses, and extend them where it makes sense.
• Design and build warehouse models (star schemas, conformed dimensions) that dashboards and machine-learning use cases sit on.
• Add data-quality checks and lineage capture to every pipeline, and keep conceptual, logical and physical model documentation current.
• Work with business owners to reconcile figures and define KPIs, and help write the monthly progress report.

Required profile

• Strong Python and SQL, used in production.
• Experience extracting and capturing changes from MS SQL Server, Oracle, MySQL and PostgreSQL.
• Ingesting from APIs, files (SFTP, Excel, CSV) and open data, in batch and streaming.
• Dimensional modelling: star schemas, conformed dimensions, slowly changing dimensions, and documenting models at conceptual, logical and physical level.
• Orchestration, monitoring, retries, data-quality checks and lineage.

Required skills

• Spark (Databricks or Hadoop) and BigQuery, with comfort with both data-lake and warehouse patterns.
• At least two of Talend, Informatica, NiFi and Denodo.
• Nice to have: dbt, Airflow, Dataflow, Iceberg, Google Professional Data Engineer or Databricks certification.