Sap Bi Data Architect (Xico)

Title: Data Architect (Hands‑On Builder)

You may occasionally be required to travel for business.

Key Responsibilities

• Build and Own Core Data Pipelines (Hands‑On)

  • Architect and implement end‑to‑end ingestion and transformation pipelines from source systems into Snowflake.
  • Develop robust ELT/ETL workflows using dbt and orchestration tools (Airflow, Dagster, ADF), including incremental loads, SCD handling, backfills, and reprocessing of late‑arriving data patterns and idempotent job design.
  • CDC‑based ingestion where applicable.
  • Build integrations for key enterprise SaaS systems (Salesforce, Marketing Cloud, Netsuite, Zuora, Gainsight, CSOD) and internal app databases.

• Data Modeling & dbt Development

  • Own the data modeling layer in Snowflake with dbt: design dimensional models (star schemas), marts, and curated layers.
  • Define metric‑ready datasets (e.g., ARR/NRR, pipe...