> Markdown version of [/jobs/ext/938587-snowflake-data-warehouse-engineer](https://www.wearedevelopers.com/jobs/ext/938587-snowflake-data-warehouse-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Snowflake Data Warehouse Engineer

- **Company:** AE Business Solutions
- **Location:** United States (Remote available)
- **Experience:** Experienced
- **Contract:** Permanent contract
- **Skills:** Query Performance, Data Analysis, Microsoft Azure, Databases, Information Engineering, Data Warehousing, Performance Tuning, Reference Data, Standard Sql, SQL Databases, Systems Integration, Snowflake, Change Data Capture, Gitlab-ci, Star Schema, Software Version Control, Data Pipelines
- **Published:** June 22, 2026
- **Apply:** https://www.dice.com/job-detail/58c3504a-052f-4e2f-a6ca-f1b225161c90

## About the Role

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., * 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.

## Description

* 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.


## Related Videos

- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases)
- [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team)
- [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one)
- [Hacking AI at the Edge of the Indian Ocean](https://www.wearedevelopers.com/videos/100177-hacking-ai-at-the-edge-of-the-indian-ocean)
- [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs)