Senior Data Engineer

GP Fund Solutions, LLC.; Latham (NY); Hybrid; USD 150,000 - 190,000; Full time

Benefits offered by this job

Medical, Dental & Vision Insurance

Company-Paid Life Insurance

401(k) matching

Generous PTO & Paid Holidays

Hybrid Scheduling

Job summary

GP Fund Solutions (GPFS) is seeking a Senior Data Engineer to help build and optimize our data warehouse and lakehouse transition. You’ll work with Snowflake, dbt, and Git-based CI/CD to deliver reliable data pipelines and analytics solutions for clients across the US, UK, and EU.

You’ll join a collaborative, growth-oriented team with strong training plans and a hybrid work schedule after probation. Ideal candidates have 5+ years in data engineering and strong SQL/data modeling skills.

Qualifications

• 5+ years of data engineering or analytics engineering experience.
• Strong SQL skills and data modeling knowledge.
• Hands-on Snowflake experience and security model understanding.
• Experience with dbt and building/test models.
• Familiarity with Git-based workflows and CI/CD for data.

Responsibilities

• Develop and maintain data warehouse and transition to a lakehouse.
• Evaluate Snowflake workloads for migration/optimization.
• Build and maintain dbt models across layers with tests/documentation.
• Create data pipelines ingesting data into Snowflake with teams.
• Write and optimize SQL transformations for performance and maintainability.
• Contribute to data quality, schema validation, and pipeline monitoring.
• Participate in CI/CD for data with automated tests and reviews.
• Assist Snowflake/cloud infra configuration and access patterns.
• Support orchestration workflows and pipeline scheduling.
• Participate in design reviews and learn from senior architects.
• Troubleshoot pipeline/data quality issues and document runbooks.

Skills

SQL

Data Modeling

Analytics

Problem Solving

Tools

Snowflake

dbt

Git

CI/CD

Job description

Senior Data Engineer - GP Fund Solutions

Where Data Meets Decision-Making. We turn numbers into insights that drive client success.

Join GP Fund Solutions (GPFS) - a people-first fund administrator serving clients across the US, UK, and EU. We offer a collaborative culture, real career growth, and benefits that invest in your future.

What You’ll Do:

• Develop and maintain core data warehouse structure and help with the transition to a lakehouse.
• Evaluate existing Snowflake workloads and identify candidates for migration, optimization, or hybrid operation.
• Develop and maintain dbt models across staging, intermediate, mart, and semantic layers, following established project structure, testing, and documentation standards.
• 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.

What We’re Looking For:

• 5+ years of experience in data engineering, analytics engineering, or a closely related technical field.
• Strong hands-on experience with Snowflake, including writing performant SQL, understanding warehouse behavior, and working with Snowflake’s access and security model.
• Understanding of dimensional modeling, data marts, data quality controls, and enterprise reporting needs.
• Strong hands-on experience with dbt, including building and testing models, using macros, and following layered project structures.
• Solid understanding of data modeling concepts, including dimensional modeling and common transformation patterns.
• Proficiency in SQL for analytical and transformation workloads, including debugging and performance along with familiarity with common tools and practices used to do so.
• Experience with Git-based version control and collaborative development workflows.
• Familiarity with building or supporting data pipelines for analytics and/or AI/ML use cases.
• Exposure to CI/CD practices for data, cloud infrastructure, and orchestration tooling.

Why GPFS?

• Strong training plans and materials provided.
• Competitive Medical, Dental & Vision Insurance.
• Company-Paid Life Insurance & 401(k).
• Generous PTO, Sick Time & Paid Holidays.
• Hybrid Scheduling after probation period.
• Inclusive, team-oriented culture where people come first.

At GPFS, every voice matters and every win is shared. We’re raising the bar in our industry - come grow with us!

#LI-GP1