Description

You will build and scale cloud data products on Snowflake, owning pipelines end-to-end from ingestion through curated consumption layers for institutional trading, risk, and regulatory reporting.

This role is on-site.

Responsibilities

• Design and optimize Snowflake data models (staging, integration, semantic layers) for trade, position, reference, and market data.
• Build ingestion pipelines using Snowpipe, Streams & Tasks, Dynamic Tables, and external stages against S3.
• Develop transformation logic in SQL and dbt with version control, CI/CD, and automated testing.
• Tune performance and cost via warehouse right-sizing, clustering, query profiling, and resource monitoring.
• Implement data security including RBAC, dynamic data masking, row access policies, and secure views.

Required Skills

• 7+ years in data engineering with 4+ years hands-on Snowflake production experience.
• Expert SQL: window functions, CTEs, complex joins, execution plan analysis, and query optimization.
• dbt (Core or Cloud): models, macros, snapshots, tests, and exposures.
• Orchestration with Airflow, Control-M, or Autosys.
• AWS services: S3, IAM, Glue, Lambda, Secrets Manager.
• CI/CD and IaC: Git, Jenkins/GitHub Actions, Terraform.
• Dimensional and Data Vault modeling, including slowly changing dimensions and late-arriving data.
• Experience migrating legacy Oracle/Teradata/Hadoop workloads to Snowflake with reconciliation.

Preferred Skills

• SnowPro Core or Advanced Data Engineer certification.
• Experience in a tier-1 investment bank or large financial services firm.

Key Skills

Education

Any Graduate