Job Description: Senior Cloud Data Architect (Data Engineering Focus)

Experience Level: 10+ Years

Engagement: Contract / Fractional Lead (1620 Hours/Week)

Primary Tech Stack: Snowflake DLH, dbt, SQL, Python, Pimcore 11 (Integration), Docker/Containerization, CI/CD DevOps, Data Observability & Monitoring

Role Summary

We are seeking a Senior Cloud Data Architect with a robust Data Engineering background to drive the cloud architecture, pipeline engineering, and upstream data quality for our enterprise Data Lakehouse (Snowflake) and its integration with our Master Data Management platform (Pimcore 11).

In this role, you will bridge technical execution with business architecturebuilding scalable Snowflake pipelines, defining robust Data Quality (DQ) framework rules, and partnering closely with our MDM Lead and cross-functional teams to ensure seamless data flows and operational efficiency.

Core Responsibilities

1. Data Lakehouse Architecture & Pipeline Engineering
- Architect, build, and optimize end-to-end data pipelines connecting Snowflake Data Lakehouse layers (RAW,



PROCESSED, CURATED) with external applications and MDM systems.
- Oversee data transformation logic, dbt models/snapshots, SCD Type 2 historical tracking, and surrogate key hashing mechanisms.
- Define resilient ingestion patterns for Change Data Capture (CDC), transaction log parsing for hard deletes, and cross-system entity reconciliation.

2. Integration & Upstream Data Modeling
- Partner directly with the MDM Lead to align Snowflake curated layer schemas with Pimcore 11 data classes and target object models.
- Establish clear source-to-target mapping specifications, data contracts, and survivorship/golden record staging logic upstream of MDM ingestion.
- Evaluate structural options (flattened vs. relational header/split models) to optimize query performance and API payload delivery.

3. Data Governance, Quality, Observability & Exception Handling
- Design and implement automated Data Quality

📌 Senior Cloud Data Architect Data Engineering Focus (Bengaluru)
🏢 Baseel Partners
📍 Bengaluru