Data Engineer

Green Key Resources; Greenwich (CT); Hybrid; USD 120,000 - 160,000; Full time

Job summary

Green Key Resources is seeking a Data Engineer to own a cloud data platform, building ELT pipelines and data models for financial data. You will work with Snowflake, SQL, and Python as a Snowflake SME, partnering with business and technology teams to ensure accurate, scalable data.

You will design scalable pipelines, contribute to reporting layers, and collaborate across stakeholders in a hybrid environment balancing onsite and remote work.

Qualifications

• Bachelor's degree in a relevant field.
• Minimum 3 years of data engineering experience, with 2 years on Snowflake.
• Advanced SQL, Python, and Snowflake (Streams/Tasks/Data sharing).
• Experience with data modeling and orchestration tools like Airflow or Prefect.
• Familiar with AWS/Azure and Terraform or similar IaC tools.
• Strong analytical skills and data accuracy.
• Preferred SnowPro Core/Advanced certs and BI tool experience.

Responsibilities

• Design and maintain scalable ELT pipelines across diverse data sources.
• Develop dimensional/semantic models for portfolio reporting.
• Implement automated data validation with detailed reporting.
• Collaborate with stakeholders to gather requirements and write specs.
• Act as Snowflake SME and advise on patterns and costs.
• Support analysts with well-documented, performant reporting layers.
• Integrate Snowflake with operational systems with platform engineers.
• Participate in design reviews, providing feasibility and cost input.

Skills

SQL

Python

Snowflake

Airflow

Prefect

Terraform

BI tools

Data modeling

Data validation

Stakeholder collaboration

Education

Bachelor's degree in Computer Science, Engineering, Information Systems, or related field

Tools

Snowflake Streams/Tasks/Data sharing

Airflow

Prefect

Terraform

Job description

This is a Data Engineer role focused on building and owning a cloud data platform, including ELT pipelines, data models, integrations, and reporting layers for financial data. The engineer will work heavily with Snowflake, SQL, and Python, while serving as a Snowflake SME and partnering with business and technology teams to ensure data is accurate, scalable, and reliable.

Key Responsibilities & Duties

• Design and maintain scalable ELT pipelines for diverse data sources, ensuring data integrity and accessibility.
• Develop dimensional and semantic models to support portfolio reporting and analytics.
• Implement automated data validation and reconciliation tests with detailed exception reporting.
• Collaborate with stakeholders to gather requirements and write technical specifications for data solutions.
• Act as a subject-matter expert on Snowflake capabilities, advising on patterns and cost implications.
• Support analysts by exposing well-documented, performant reporting layers for downstream applications.
• Integrate Snowflake with operational systems through collaboration with platform engineers.
• Participate in design reviews, providing technical feasibility and cost input on new initiatives.

Job Requirements

• Bachelor’s degree in Computer Science, Engineering, Information Systems, or related field.
• Minimum 3 years of data engineering experience, with 2 years focused on Snowflake.
• Proficiency in advanced SQL, Python, and Snowflake features like Streams, Tasks, and secure data sharing.
• Experience with data modeling methodologies and orchestration tools such as Airflow or Prefect.
• Familiarity with cloud infrastructure (AWS or Azure) and infrastructure-as-code tools like Terraform.
• Strong analytical and problem-solving skills with attention to detail and data accuracy.
• Preferred SnowPro Core or Advanced certification and experience with BI tools.
• Ability to work in a hybrid environment, balancing onsite and remote collaboration.