Data Engineer

GP Fund Solutions

Latham (NY)

Hybrid

USD 120,000 - 150,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Medical, Dental & Vision Insurance
Company-Paid Life Insurance & 401(k)
Generous PTO, Sick Time & Holidays
Hybrid Scheduling after probation

Job summary

GP Fund Solutions is seeking a Data Engineer to help design and maintain the core data warehouse, migrate toward a lakehouse, and optimize Snowflake workloads. You will develop dbt models, build data pipelines, and ensure data quality with CI/CD practices.

The role requires 3+ years in data engineering, strong SQL and Snowflake skills, and experience with data modeling and analytics pipelines. Hybrid work arrangement after probation, with a focus on reliable, scalable data infrastructure.

Qualifications

  • 3+ years of experience in data engineering, analytics engineering, or closely related field.
  • Hands-on Snowflake experience with SQL, warehouse behavior, and Snowflake security model.
  • Understanding of dimensional modeling, data marts, and enterprise reporting needs.
  • Hands-on dbt experience: building/testing models, macros, layered structures.
  • Proficiency in SQL for analytics/transformations; debugging and performance.
  • Experience with Git-based version control and collaborative workflows.
  • Familiarity with building/supporting data pipelines for analytics/AI/ML use cases.

Responsibilities

  • Assist with development and maintenance of core data warehouse and transition to lakehouse.
  • Evaluate Snowflake workloads and identify migration/optimization candidates.
  • Identify performance issues and help with solution plans.
  • Develop and maintain dbt models across staging to semantic layers with standards.
  • Build and maintain data pipelines ingesting data from source systems into Snowflake.
  • Write and optimize SQL transformations for performance and readability.
  • Contribute to data quality, including schema validation and pipeline monitoring.
  • Participate in CI/CD processes for data with automated testing and code reviews.
  • Contribute to Snowflake/cloud infra configuration (warehouse sizing, access patterns).
  • Support orchestration workflows and data pipeline scheduling for reliability.

Skills

Snowflake SQL
dbt
SQL
Git-based workflows
CI/CD for data
Data pipelines
Dimensional modeling
Data quality

Tools

Snowflake
dbt

Job description

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:
  • Assist with the development and maintenance of the core data warehouse structure and help with the transition to a lakehouse.
  • Help evaluate existing Snowflake workloads and identify candidates for migration, optimization, or hybrid operation.
  • Identify performance issues and assist with solution plans.
  • Assist with the 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.
What We’re Looking For:
  • 3+ years of experience in data engineering, analytics engineering, or a closely related technical field.
  • 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.
  • 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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer
Senior Data Engineer

GP Fund Solutions • Latham (NY)

Hybrid
USD 150,000 - 190,000
Medical, Dental & Vision Insurance
Company-Paid Life Insurance
401(k) matching
+2
Senior Data Engineer — Snowflake, Lakehouse & Hybrid Pipelines
Senior Data Engineer — Snowflake, Lakehouse & Hybrid Pipelines

GP Fund Solutions • Latham (NY)

Hybrid
USD 150,000 - 190,000
Medical, Dental & Vision Insurance
Company-Paid Life Insurance
401(k) matching
+2
Data Engineer — Snowflake, Lakehouse & CI/CD (Hybrid)
Data Engineer — Snowflake, Lakehouse & CI/CD (Hybrid)

GP Fund Solutions • Latham (NY)

Hybrid
USD 120,000 - 150,000
Medical, Dental & Vision Insurance
Company-Paid Life Insurance & 401(k)
Generous PTO, Sick Time & Holidays
+1
Data Engineer
Data Engineer

Collectivus Holdings • United States

Remote
USD 100,000 - 150,000
Data Engineer
Data Engineer

Spectrum Staffing Services • New Jersey

On-site
USD 140,000 - 180,000
Modern cloud data technologies
Snowflake architecture focus
Full development lifecycle
+2
Senior Data Engineer
Senior Data Engineer

MISUMI Americas • Schaumburg (IL)

On-site
USD 167,000 - 202,000
Comprehensive medical and dental
401(k) plan
Generous PTO and leave programs
Senior Data Engineer
Senior Data Engineer

TSG Resources, Inc. • Louisiana

On-site
USD 87,000 - 128,000
Medical insurance
Dental insurance
Vision insurance
+1
Senior Data Engineer - Snowflake Expert
Senior Data Engineer - Snowflake Expert

The Timberline Group • St. Louis (MO)

On-site
USD 130,000 - 170,000
Medical, Dental & Vision insurance
401(k) with company match
PTO
+5
Data Engineer, Financial Services
Data Engineer, Financial Services

Huxley • Boston (MA)

On-site
USD 149,000 - 182,000
Annual performance-based bonus
Medical, dental, vision coverage
Retirement and financial wellness
Senior Data Engineer
Senior Data Engineer

RxSense • Boston (MA)

On-site
USD 150,000 - 190,000