Snowflake Data Warehouse Consultant
Posted Today by AE Business Solutions
Negotiable
Undetermined
Remote
Remote
Summary: The Snowflake Data Warehouse Engineer role involves working with a confidential investment-focused organization to enhance their data warehouse initiatives. The position requires extensive experience in Snowflake, SQL, and data engineering, particularly in complex analytical or financial environments. The role is remote but must be performed within the US and is expected to last for over six months with potential extensions. Candidates will be responsible for designing, implementing, and optimizing data models and pipelines within Snowflake.
Key Responsibilities:
- Design and implement Snowflake schemas and object lifecycle strategies optimized for analytics workloads.
- Build scalable dimensional and time-series data models supporting portfolio hierarchies, positions, security master integration, exposures, and risk metrics.
- Develop robust ELT pipelines using dbt and native Snowflake capabilities, including Streams, Tasks, and Snowpipe, for daily and intraday processing.
- Implement efficient change data capture and incremental processing strategies across position, pricing, risk, and reference data domains.
- Create and maintain high-performance tables, views, and materialized views aligned to performance-sensitive analytical use cases.
- Lead query performance optimization efforts, including clustering strategy, micro-partition awareness, warehouse sizing, caching behavior, and workload management.
- Establish data quality and reconciliation frameworks, including completeness checks, monitoring, and alerting for financial datasets.
- Automate Snowflake deployments and SQL transformations using GitLab CI/CD and version control best practices.
Key Skills:
- 7+ years of experience in data engineering or data warehousing roles.
- 5+ years of hands-on Snowflake experience in production environments.
- Experience creating and managing Snowflake databases, schemas, roles, and grants.
- Experience designing and implementing Streams and Tasks for CDC and scheduled processing.
- Experience building and optimizing materialized views and performance-driven data models.
- Expert-level SQL skills, including complex window functions, CTEs, analytic queries, set-based transformations, and performance tuning.
- 4+ years of experience with ELT or transformation tools, ideally dbt.
- Experience integrating Snowflake with Azure cloud storage and upstream financial systems.
- Experience implementing GitLab CI/CD for SQL-based transformations and Snowflake object deployments.
- Strong analytical data modeling experience, including star schemas, slowly changing dimensions, fact tables, aggregates, and large-scale time-series structures.
- Experience supporting high-volume, performance-sensitive financial or portfolio datasets.
Salary (Rate): undetermined
City: undetermined
Country: US
Working Arrangements: remote
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
Title: Snowflake Data Warehouse Engineer (Contract)
Location: Remote- Work MUST be done in US
Duration: 6+ months with extensions
We're partnering with a confidential, investment-focused organization to add a Snowflake Data Warehouse Engineer. If you have strong Snowflake, SQL, dbt, and performance optimization experience - especially in complex analytical or financial data environments - this is a strong opportunity to work on high-impact data warehouse initiatives.
Qualifications- Required
- 7+ years of experience in data engineering or data warehousing roles.
- 5+ years of hands-on Snowflake experience in production environments.
- Experience creating and managing Snowflake databases, schemas, roles, and grants.
- Experience designing and implementing Streams and Tasks for CDC and scheduled processing.
- Experience building and optimizing materialized views and performance-driven data models.
- Expert-level SQL skills, including complex window functions, CTEs, analytic queries, set-based transformations, and performance tuning.
- 4+ years of experience with ELT or transformation tools, ideally dbt.
- Experience integrating Snowflake with Azure cloud storage and upstream financial systems.
- Experience implementing GitLab CI/CD for SQL-based transformations and Snowflake object deployments.
- Strong analytical data modeling experience, including star schemas, slowly changing dimensions, fact tables, aggregates, and large-scale time-series structures.
- Experience supporting high-volume, performance-sensitive financial or portfolio datasets.
Responsibilities
- Design and implement Snowflake schemas and object lifecycle strategies optimized for analytics workloads.
- Build scalable dimensional and time-series data models supporting portfolio hierarchies, positions, security master integration, exposures, and risk metrics.
- Develop robust ELT pipelines using dbt and native Snowflake capabilities, including Streams, Tasks, and Snowpipe, for daily and intraday processing.
- Implement efficient change data capture and incremental processing strategies across position, pricing, risk, and reference data domains.
- Create and maintain high-performance tables, views, and materialized views aligned to performance-sensitive analytical use cases.
- Lead query performance optimization efforts, including clustering strategy, micro-partition awareness, warehouse sizing, caching behavior, and workload management.
- Establish data quality and reconciliation frameworks, including completeness checks, monitoring, and alerting for financial datasets.
- Automate Snowflake deployments and SQL transformations using GitLab CI/CD and version control best practices.