Builds and runs the pipelines that land, master and model data in Snowflake on Azure,

from ingestion through to the Gold layer that reporting runs on.

What you'll do:

 Build ingestion into Snowflake Bronze: Five Tran for Dynamics 365 CE and SQL sources, and Azure Data Factory for flat files and APIs through ADLS stages, COPY

INTO and Snow pipe.

 Develop dbt models across Silver and Gold: staging, incremental models, snapshots and SCD Type 2 history.

 Model effective-dated advisor, firm and territory hierarchies so late-arriving transactions credit the right firm and territory.

 Integrate Snowflake with the Profisee MDM hub: publish curated records for mastering, then land golden records and cross-reference tables back in Snowflake for downstream use.

 Build data quality checks and reconciliation between layers using dbt tests and

Snowflake data metric functions.

 Use streams, tasks and dynamic tables where they fit, and keep every load idempotent and secure to re-run.

 Manage warehouse sizing and compute cost for ingestion and transformation workloads.

 Maintain dbt CI/CD and code review, and document models and lineage.

Must have





 5+ years in data engineering, with at least 2 years hands-on in Snowflake.

 dbt in production: incremental models, snapshots, tests and CI.

 Expert SQL and working Python.

 Azure data services: Data Factory, ADLS Gen2 and Key Vault.

 A managed ELT tool such as Five Tran, including handling of cost and schema changes.

 Dimensional modelling, including slowly changing dimensions.

Nice to have

 Integration with an MDM hub (Profisee, Informatica MDM, Reltio, EBX or similar),

including golden-record and cross-reference handling.

 Dynamics 365 or Dataverse data.

 Financial services or asset management data: advisors, accounts, transactions,

holdings.

 Terraform or other infrastructure as code.

 SnowPro certification.

Pay: ₹509,000.00 - ₹1,000,000.00 per year

Benefits

- Health insurance

Application Question(s):
- We can offer a maximum of 30% hike on your current salary. Would that be okay with you?

Experience:
- Data Engineer: 5 years (Preferred)

Work Location: In person

📌 Senior Data Engineer (Coimbatore)
🏢 Jobbycart technologies private
📍 Coimbatore