Snowflake Data Warehouse Engineer

Fusion Solutions Inc.; United States; Remote; USD 117,000 - 138,000; Part time

Job summary

Talantir is seeking a Senior Snowflake Data Warehouse Engineer to design and deliver a scalable data platform for investment risk analytics and portfolio reporting. The role focuses on Snowflake optimization and robust data pipelines for high-volume financial datasets.

Collaborate with data architects, BI engineers, and data scientists to deliver reliable data solutions, implement ELT pipelines with dbt, and ensure data quality, governance, and performance across Snowflake workloads.

Qualifications

• 7+ years of data engineering or data warehousing experience.
• 5+ years of hands-on Snowflake experience in production environments.
• Strong expertise with Snowflake Streams, Tasks, and Snowpipe.
• Expert-level SQL skills, including window functions, CTEs, and performance tuning.
• Experience with ELT frameworks such as dbt.
• Experience building analytical data models (star schemas, fact tables, SCDs).
• Experience implementing CDC and incremental data pipelines.
• Experience with Git-based CI/CD pipelines (GitLab preferred).

Responsibilities

• Design and implement Snowflake data warehouse schemas and object lifecycle strategies.
• Develop dimensional and time-series data models supporting portfolio analytics and financial reporting.
• Build scalable ELT pipelines using dbt and Snowflake native features (Streams, Tasks, Snowpipe).
• Implement change data capture (CDC) and incremental processing frameworks.
• Optimize Snowflake performance through clustering strategies, micro-partitioning, and workload management.
• Develop and maintain high-performance tables, views, and materialized views.
• Establish data quality monitoring and reconciliation frameworks.
• Automate deployments and SQL transformations using GitLab CI/CD pipelines.
• Document data models, lineage, governance controls, and operational procedures.
• Troubleshoot and resolve production data pipeline issues

Skills

Snowflake experience

SQL proficiency

dbt ELT

Dimensional models

CDC pipelines

GitLab CI/CD

Performance tuning

Tools

dbt

GitLab

Job description

*Senior Snowflake Data Warehouse Engineer* Location: *Remote (U.S.)* Type: *6-Month Contract (Extension Possible)* Compensation: *$85–$100/hr W2* Employment: *W2 Only – No Sponsorship Available*

We are seeking a *Senior Snowflake Data Warehouse Engineer* to help design and deliver a scalable data platform supporting investment risk analytics and portfolio reporting workloads. This role will focus on building and optimizing enterprise data warehouse solutions within Snowflake and developing robust data pipelines to support high-volume financial datasets.

The engineer will collaborate closely with data architects, business intelligence engineers, and data scientists to deliver reliable and performant data solutions supporting risk metrics, portfolio analytics, and financial reporting.

Responsibilities

• Design and implement *Snowflake data warehouse schemas and object lifecycle strategies*
• Develop *dimensional and time-series data models* supporting portfolio analytics and financial reporting
• Build scalable *ELT pipelines using dbt and Snowflake native features (Streams, Tasks, Snowpipe)*
• Implement *change data capture (CDC) and incremental processing frameworks*
• Optimize Snowflake performance through *clustering strategies, micro-partitioning, and workload management*
• Develop and maintain *high-performance tables, views, and materialized views*
• Establish *data quality monitoring and reconciliation frameworks*
• Automate deployments and SQL transformations using *GitLab CI/CD pipelines*
• Document data models, lineage, governance controls, and operational procedures
• Troubleshoot and resolve production data pipeline issues

Required Skills

• 7+ years of data engineering or data warehousing experience
• 5+ years of hands-on Snowflake experience in production environments
• Strong expertise with *Snowflake Streams, Tasks, and Snowpipe*
• Expert-level SQL skills, including window functions, CTEs, and performance tuning
• Experience with *ELT frameworks such as dbt*
• Experience building *analytical data models (star schemas, fact tables, SCDs)*
• Experience implementing *CDC and incremental data pipelines*
• Experience with *Git-based CI/CD pipelines (GitLab preferred)*

Preferred Skills

• Experience integrating *Snowflake with Azure cloud storage*
• Experience working with *financial data platforms or portfolio analytics*
• Familiarity with concepts such as *risk analytics, factor exposure, stress testing, or performance attribution*

Additional Information

• Remote role (U.S. candidates only)
• W2 only – no sponsorship available
• Initial 6-month contract with extension potential

Pay: $85.00 - $100.00 per hour

Work Location: Remote