Cloud Data Engineer – ETL/EDW & AWS (Python)

Hearts & Science; New York (NY); On-site; USD 50,000 - 95,000; Full time

Job summary

Hearts & Science in New York is seeking an experienced Data Engineer to build, optimize, and maintain ETL workflows and data warehouse solutions on AWS. You will work with Analytics, Data Science, IT, and Investment teams to deliver batch and real-time data solutions.

The role requires hands-on experience with Python, SQL, and cloud data services, plus the ability to navigate legacy code and complex transformations. This is a hands-on position in a collaborative environment.

Qualifications

• Bachelor’s in Computer Science or related STEM field.
• 3+ years building data pipelines with ETL tech stack and big data technologies.
• 3+ years of Python programming in a Linux environment.
• Experience deploying production cloud services in AWS (EC2, S3, Redshift).
• Ability to translate high level business requirements into data solutions.
• Ability to work in a cross‑functional team with multiple business units/partners.
• Experience with advertising/media data and knowledge of media metrics is a plus.
• Experience with Google Cloud products, Jira, and Tableau is a plus.

Responsibilities

• Contribute to the growth of the enterprise data warehouse by collaborating with stakeholders to deliver accurate data for reporting and decision making.
• Assist in developing long-term data warehouse strategies and capacity planning.
• Meet with end-users and data SMEs to clarify requirements for ETL/ELT processes.
• Collaborate with Data Engineers to support CI/CD pipelines and Git workflows.
• Mentor junior Data Analysts and review planned workflows before deployment.
• Investigate and correct data discrepancies between EDW and sources.
• Build relationships with internal/external data delivery points to ensure data needs are met.
• Document ETL processes and contribute to the team knowledge base.

Skills

SQL

Python

ETL design

AWS

Big Data

Data Warehousing

Communication skills

Education

Bachelor's degree in Computer Science or related STEM field

Tools

AWS

Redshift

Tableau

Jira

Google Analytics datasets

Job description

Hearts & Science in New York is seeking an experienced Data Engineer to build, optimize, and maintain ETL workflows and data warehouse solutions on AWS. You will work with Analytics, Data Science, IT, and Investment teams to deliver batch and real-time data solutions.

The role requires hands-on experience with Python, SQL, and cloud data services, plus the ability to navigate legacy code and complex transformations. This is a hands-on position in a collaborative environment.