Base Career helps you apply smarter for this job.
Key skills for this role
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.
5+ years of experience in data engineering, analytics engineering, or a closely related technical field.
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
Latham, USA
Accounting Intern – GP Fund Solutions At GPFS, what you do makes an impact—driving client success, supporting investors, and deepening relationships. Even as an intern – we want you to feel like a full part of the team!
Latham, USA
Senior Operations Accountant – GP Fund Solutions As a Senior Operations Accountant at GPFS, you’ll be part of a collaborative team where client success, investor confidence, and your professional growth go hand in hand.
Latham, USA
Latham, USA
Latham, USA
Minneapolis, USA
Minneapolis, USA
Minneapolis, USA
Latham, USA
Latham, USA
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.
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.
Provides back-office fund administration services for private investment managers.
Visit company websiteUSD 115000-140000 yearly / year
Full-time
Senior · 5+ years experience
Hybrid
Apply faster on company sites with our extension.