Analytics Engineer (Data Analytics Engineer)

eDesign SA; Jeddah; On-site; SAR 80,000 - 100,000; Full time

Job summary

A digital solutions company in Jeddah is seeking an experienced data analyst to build and maintain transformation pipelines and define metric logic. The role requires proven experience in analytics modeling within data warehouses or lakehouses, proficiency with dbt and familiarity with various BI tools. Strong stakeholder management and documentation skills are essential for success in this collaborative position aimed at improving data trust and governance.

Qualifications

• Proven analytics modeling experience in warehouse/lakehouse environments.
• Familiarity with dbt or equivalent frameworks.
• Understanding of BI tools' semantic behaviors.

Responsibilities

• Build and maintain transformation pipelines from raw to curated data marts.
• Define and govern metric logic in a semantic layer.
• Partner with BI developers to ensure dashboard accuracy.

Skills

Analytics modeling

DBT

BI tools (Power BI, Tableau)

Data documentation

ETL/ELT pipelines

Stakeholder management

Tools

Snowflake

BigQuery

Redshift

Synapse

Databricks

Job description

• Build and maintain transformation pipelines (ELT/ETL) from raw → curated marts.
• Define and govern metric logic in a semantic layer (dbt Semantic Layer / LookML / SSAS tabular equivalent).
• Partner with BI Devs to ensure dashboards map to certified metrics (no “shadow KPIs”).
• Own analytics data documentation (catalog descriptions, lineage notes, usage guidance).

Key interfaces

• Data Engineering: upstream contracts, schema changes, CDC semantics.
• Governance: definitions, stewardship, certification process.
• Leading: % models with tests, docs completeness, build time, review cycle time.
• Lagging: metric discrepancy incidents, dashboard trust score, adoption of certified models.
• Systems thinking: understands upstream/downstream ripple effects.
• Semantic rigor: defines grain, metric logic, edge cases explicitly.
• Pragmatic standards: enforces consistency without blocking delivery.
• Stakeholder translation: converts business questions into data contracts and models.
• AY behaviors: Trust at Scale, Clarity Over Complexity, Ownership.
• Proven analytics modeling in a warehouse/lakehouse (Snowflake/BigQuery/Redshift/Synapse/Databricks).
• Experience with dbt or equivalent transformation framework.
• Familiarity with BI tools’ semantic behaviors (Power BI DAX, Tableau LODs, Looker).

Work sample (recommended)

• Given 4 raw tables + messy requirements, produce:
  • 1 fact, 3 dims, 5 KPIs,
  • tests + documentation,
  • and explain grain + edge cases.

The company was started by Ahmed H. Taibah and Yousef H. AlDabbagh, two friends who studied at King Fahd University of Petroleum and Minerals (KFUPM). They set up eDesign immediately after graduating, starting with just one desk, one PC and one service – web design.

From those beginnings, the company has grown and prospered. In 2008 they moved into new offices, where they are still located. Today the company consists of 38 people. The services eDesign offers range from the latest in website design (including advanced e-commerce websites) to mobile apps, videos, graphic design and all aspects of digital marketing, as well as complementary services such as copywriting and printing.