Data Engineer
$95,000–$115,000 year
HybridLatham, New York, United States
Job Summary
Develop and maintain the core data warehouse structure and dbt models across staging, intermediate, and mart layers while assisting with the transition to a lakehouse. Evaluate Snowflake workloads for migration or optimization, write performant SQL transformations, and build pipelines ingesting data from source systems. Troubleshoot pipeline failures, conduct root cause analysis, and contribute to CI/CD processes including automated testing and Git-based deployments. Support orchestration workflows, ensure data quality through schema validation and freshness checks, and document operational runbooks. Participate in design reviews and collaborate with platform and analytics teams on requirements.
Required Qualifications
- 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
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.