Data Engineer - Snowflake & dbt, Hybrid + Growth

GP Fund Solutions, LLC.; New York (NY); Híbrido; USD 120.000 - 180.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Medical, Dental & Vision Insurance

Company-Paid Life Insurance

401(k)

Generous PTO, Sick Time & Holidays

Descripción de la vacante

GP Fund Solutions helps turn numbers into insights that drive client success. We’re a fund administrator serving clients across the US, UK, and EU, with a people-first culture, strong growth, and substantial benefits.

You will join a hybrid team building and maintaining data warehouses and lakehouse transitions, optimizing Snowflake workloads, and developing robust data pipelines. As a data engineer, you’ll develop dbt models, write efficient SQL, participate in CI/CD for data, and contribute to

Formación

• 3+ years of experience in data engineering, analytics engineering, or a closely related technical field.
• Hands-on Snowflake experience with performant SQL and secure access controls.
• Familiarity with dbt modeling and layered project structures.

Responsabilidades

• Assist with development and maintenance of core data warehouse structures and help with the transition to a lakehouse.
• Help evaluate Snowflake workloads and identify candidates for migration, optimization, or hybrid operation.
• Identify performance issues and assist with solution plans.
• Assist with development and maintenance of dbt models across staging, intermediate, mart, and semantic layers, following established project structure, testing, and documentation standards.
• Help build and maintain data pipelines that ingest data from source systems into Snowflake, collaborating with platform and analytics teams on requirements and priorities.
• Write and optimize SQL transformations for performance, readability, and maintainability within Snowflake.
• Contribute to data quality and reliability efforts, including schema validation, source freshness checks, row-level testing, and pipeline monitoring.
• Participate in CI/CD processes for data, including automated testing, code review, and deployment practices using Git-based workflows.
• Contribute to Snowflake and cloud infrastructure configuration, including warehouse sizing, access patterns, and integration with surrounding services, under the guidance of senior engineers.
• Support orchestration workflows and data pipeline scheduling, helping ensure pipelines run reliably and recover gracefully from failures.
• Participate in design reviews, offering input on implementation approaches and learning from senior engineers’ architectural decisions.
• Troubleshoot and resolve pipeline and data quality issues, conduct root cause analysis and implement fixes.
• Document work clearly, including data models, pipelines, and operational runbooks, so the broader team can understand and maintain what you build.

Conocimientos

Data engineering

SQL

dbt

Snowflake

Git workflows

CI/CD for data

Dimensional modeling

Data quality controls

Herramientas

Snowflake

dbt

Git

Descripción del empleo

GP Fund Solutions helps turn numbers into insights that drive client success. We’re a fund administrator serving clients across the US, UK, and EU, with a people-first culture, strong growth, and substantial benefits.

You will join a hybrid team building and maintaining data warehouses and lakehouse transitions, optimizing Snowflake workloads, and developing robust data pipelines. As a data engineer, you’ll develop dbt models, write efficient SQL, participate in CI/CD for data, and contribute to