Senior Data Engineer
About The Position
GP Fund Solutions (GPFS), a people-first fund administrator serving clients across the US, UK, and EU, is hiring a Senior Data Engineer for its GP Fund Solutions team. The role develops and maintains the core data warehouse while contributing to the transition to a lakehouse. The engineer works with Snowflake, dbt, SQL, data pipelines, data quality controls, CI/CD workflows, and orchestration, collaborating with platform and analytics teams and learning from senior engineers on architectural decisions. The position also involves troubleshooting, documentation, and contributing to cloud and Snowflake infrastructure configuration.
Requirements
- At least 5 years of experience in data engineering, analytics engineering, or a closely related technical field.
- Strong hands-on Snowflake experience, including performant SQL, warehouse behavior, and Snowflake access and security models.
- Understanding of dimensional modeling, data marts, data quality controls, and enterprise reporting needs.
- Strong hands-on dbt experience, 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, and familiarity with common tools and practices used for these tasks.
- 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 data CI/CD practices, cloud infrastructure, and orchestration tooling.
Responsibilities
- Develop and maintain the core data warehouse structure and help transition it to a lakehouse.
- Evaluate Snowflake workloads and identify candidates for migration, optimization, or hybrid operation.
- Develop and maintain dbt models across staging, intermediate, mart, and semantic layers in accordance with project structure, testing, and documentation standards.
- Build and maintain pipelines that ingest data from source systems into Snowflake, collaborating with platform and analytics teams on requirements and priorities.
- Write and optimize SQL transformations in Snowflake for performance, readability, and maintainability.
- Contribute to data quality and reliability, including schema validation, source freshness checks, row-level testing, and pipeline monitoring.
- Participate in data CI/CD processes, including automated testing, code review, and deployment through Git-based workflows.
- Contribute to Snowflake and cloud infrastructure configuration, including warehouse sizing, access patterns, and integration with surrounding services, under senior engineers’ guidance.
- Support orchestration workflows and pipeline scheduling, helping ensure reliable runs and graceful recovery from failures.
- Participate in design reviews, providing implementation input and learning from senior engineers’ architectural decisions.
- Troubleshoot pipeline and data quality issues, conduct root cause analysis, and implement fixes.
- Document data models, pipelines, and operational runbooks so the broader team can understand and maintain the work.
Benefits
- Strong training plans and materials provided.
- Competitive medical, dental, and vision insurance.
- Company-paid life insurance.
- 401(k).
- Generous PTO, sick time, and paid holidays.
- Hybrid scheduling after the probation period.
- Inclusive, team-oriented culture where people come first.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
