Snowflake + dbt Data Architect

Title: Snowflake + dbt Data Architect
Location: Kochi
Experience: 7+ years in data engineering/architecture; 3+ years hands-on with Snowflake & dbt

Role summary
You’ll own the technical design and delivery of a HIPAA-sensitive Snowflake + dbt data platform for a healthcare enterprise. You’ll translate business needs into a secure, cost-efficient, maintainable data architecture and lead two developers to implement it.

Key responsibilities
Lead end-to-end design of the Snowflake data platform: schema design, warehouses, resource monitors, roles, and sharing strategies.
Define and enforce dbt architecture & conventions (models, macros, seeds, tests, CI/CD).
Design secure ingestion patterns (Snowpipe, staged files, Fivetran/Matillion connectors) and policies for PHI handling (masking, encryption, RBAC).
Set up governance: data cataloging strategy, lineage, auditing, and cost monitoring.
Define performance & cost optimization plan (clustering keys, partitioning strategy, scaling policies).
Create CI/CD pipelines for dbt + Snowflake deployments (Git, GitHub Actions / Azure DevOps / Bitbucket pipelines).
Review code, mentor devs, perform design/code reviews, and lead situps with stakeholders (security, compliance, analytics).
Produce runbooks, operational docs, and incident procedures.

Required skills & experience
7+ years data engineering/architecture experience.
3+ years production experience with Snowflake (warehouses, Snowpipe, Tasks, Streams, Time Travel, cloning).
2+ years building production data transformations with dbt (models, tests, snapshots, macros).
Strong SQL mastery; ability to write complex analytic queries and optimize them for Snowflake.
Experience with healthcare data standards (HL7/FHIR/claims) and HIPAA compliance controls.
Experience with cloud provider where Snowflake runs (AWS/Azure/GCP).
Familiar with ETL/ELT tools (Fivetran/Matillion/Airbyte) and orchestration (Airflow, Prefect).
Experience implementing RBAC, data masking, and access auditing.

Nice to have
Experience with data catalog tools (Collibra, Alation) or open source alternatives.
Familiarity with dbt Cloud and/or advanced dbt packages.
Experience with cost governance tools or usage-based optimization (Snowflake Resource Monitors).
Prior role in healthcare or regulated enterprise.

Job Types: Full-time, Permanent

Pay: ₹1,300,000.00 - ₹1,500,000.00 per year

Experience:

• snowflake: 6 years (Required)
• Data Build tool: 4 years (Required)
• SQL: 6 years (Required)
• ETL: 6 years (Preferred)
• HIPAA: 5 years (Preferred)
• cloud: 4 years (Required)

Work Location: In person