Snowflake + dbt Data Architect

Title: Snowflake + dbt Data Architect
Location: KochiExperience: 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