Greetings,
Role: Snowflake Data Engineer Location: Phoenix AZ, Dallas, TX, Raleigh, NC Duration: 12+ months Looking on W2 locals (USC and GC)
Key Responsibilities
- Design, implement, and manage enterprise-scale Snowflake data platforms across multiple accounts.
- Develop and optimize Snowflake data warehouse objects, including virtual warehouses, streams, tasks, materialized views, and external tables.
- Build scalable ELT pipelines using dbt, SQL, and Jinja.
- Implement data modeling frameworks using Data Vault 2.0 and Medallion Architecture.
- Develop and maintain Bronze, Silver, and Gold data layers for enterprise analytics.
- Optimize Snowflake query performance, warehouse utilization, and data processing efficiency.
- Implement automated data quality testing, validation, monitoring, and documentation.
- Integrate Snowflake with AWS services for data ingestion, orchestration, and monitoring.
- Manage Snowflake security, access controls, roles, and permissions.
- Collaborate with architects, business stakeholders, and engineering teams in an Agile environment.
Required Technical Skills
1. Snowflake – Must Have
- Strong hands-on Snowflake architecture and engineering experience.
- Virtual warehouses, streams, tasks, materialized views, and external tables/Iceberg.
- Snowpipe, micro-partitioning, clustering keys, and zero-copy cloning.
- Query optimization, performance tuning, and warehouse management.
- Snowflake security, RBAC, and access management.
2. dbt (Data Build Tool) – Must Have
- Strong production experience with dbt Cloud or dbt Core.
- Developing modular ELT pipelines using SQL and Jinja.
- dbt models, macros, incremental processing, and dependencies.
- Automated testing, schema validation, data freshness checks, and documentation.
- Snapshots and Slowly Changing Dimensions (SCD).
3. Data Modeling – Must Have
- Strong understanding of Data Vault 2.0 and/or Medallion Architecture.
- Data Vault concepts: Hubs, Links, Satellites, Raw Vault, Business Vault, PIT, and Bridge tables.
- Medallion layers: Bronze, Silver, and Gold.
- Dimensional modeling, star schemas, and analytical data marts.
4. Advanced SQL – Must Have
- Complex SQL queries, joins, CTEs, and window functions.
- SQL performance tuning and optimization.
- Data transformation, reconciliation, and validation.
5. AWS Cloud – Required
- Experience integrating Snowflake with AWS.
- Working knowledge of S3, IAM, Lambda, EventBridge, and CloudWatch.
- Cloud-based data ingestion and pipeline orchestration.
6. Legacy Data Warehousing / ETL – Mandatory
Candidates must have prior hands-on experience with at least one of the following: