Senior Cloud Data Engineer

Overture Partners; Boston (MA); On-site; USD 130,000 - 170,000; Full time

Benefits offered by this job

Medical plans

401(k) starting day one

Life and disability insurance

Sick time as required by law

Job summary

Overture Partners is seeking an experienced Cloud Data Engineer to design, develop, and optimize enterprise cloud data solutions. You will work with AWS, Snowflake, Informatica IICS, SQL, Python, Airflow, and CI/CD practices to build end‑to‑end data pipelines.

You will lead data architecture discussions, implement scalable data layers, and ensure governance and security. This is a hands‑on role requiring strong engineering leadership and collaboration with stakeholders.

Qualifications

• 5+ years designing and developing data pipelines, data warehouses, data models, ETL solutions, and enterprise data architectures.
• 5+ years of hands‑on experience developing cloud‑based data solutions, preferably within AWS environments.
• 5+ years working with cloud database platforms, including strong Snowflake expertise.
• Experience designing end‑to‑end data pipelines for large enterprise environments.
• Strong hands‑on experience with Informatica IICS, SQL, and Python for complex data integration.

Responsibilities

• Design and develop cloud‑based data management and engineering solutions.
• Architect and implement scalable data pipelines across centralized and decentralized data environments.
• Develop and maintain data integration solutions using Informatica IICS, Snowflake, SQL, Python.
• Lead the design and development of data layers and ETL requirements.
• Collaborate with cross‑functional teams to build highly available, scalable cloud data platforms.
• Facilitate technical design sessions and guide architecture decisions.
• Monitor cloud data platform performance and improve efficiency and security.

Skills

Data pipelines

Cloud data platforms

Snowflake

Informatica IICS

SQL

Python

Airflow

Data governance

Security/compliance

Tools

Snowflake

Informatica IICS

Airflow

GitHub CI/CD

AWS

Job description

Job Overview

We are seeking an experienced Cloud Data Engineer for an urgent engagement supporting the design, development, and optimization of enterprise cloud data solutions. This role is ideal for a hands‑on data engineering professional with strong experience in AWS, Snowflake, Informatica IICS, SQL, Python, Airflow, and modern data architecture. Candidates most likely to secure an interview will have deep experience building end-to-end data pipelines, working with large-scale cloud data platforms, and applying strong data governance and security practices.

Must Haves

• 5+ years of experience designing and developing data pipelines, data warehouses, data models, ETL solutions, and enterprise data architectures.
• 35 years of hands‑on experience developing cloud‑based data solutions, preferably within AWS environments.
• 5+ years of experience working with cloud database platforms, including strong Snowflake expertise.
• Proven experience designing and implementing end‑to‑end data pipelines for large‑scale enterprise environments.
• Strong hands‑on experience with Informatica IICS, SQL, and Python for complex data integration and engineering use cases.
• Experience with decentralized data architecture concepts, including Data Mesh, as well as traditional centralized data environments.
• Experience with Airflow for workflow orchestration and GitHub or similar tools supporting CI/CD practices.
• Experience working with sensitive or regulated data and applying privacy, security, and governance controls.

What the Client Needs You to Do

The successful candidate will play a key role in designing scalable, secure, and high‑performing cloud data solutions that support enterprise data management and analytics needs. You will work closely with technical teams, architects, vendors, and business stakeholders to define requirements, establish effective data architectures, and deliver reliable solutions.

This individual will also provide technical leadership during solution design, guide decisions related to data layers and ETL requirements, and identify opportunities to improve performance, scalability, governance, and operational efficiency. Success in this role requires strong hands‑on engineering capabilities combined with the ability to communicate complex technical solutions clearly.

Key Responsibilities

• Design and develop cloud‑based data management and engineering solutions that support enterprise business and technical requirements.
• Architect and implement scalable data pipelines across centralized and decentralized data environments.
• Develop and maintain data integration solutions using Informatica IICS, Snowflake, SQL, Python, and related technologies.
• Lead the design and development of data layers, including reviewing ETL requirements, data models, and integration approaches.
• Collaborate with cross‑functional teams to build highly available, scalable, secure, and high‑performing cloud data platforms.
• Facilitate technical design sessions and guide teams toward effective architecture and implementation decisions.
• Evaluate emerging cloud services and technologies for data ingestion, curation, storage, processing, and analytics.
• Monitor cloud data platform performance and develop strategies to improve efficiency, reliability, scalability, and cost effectiveness.
• Establish recurring system performance assessment processes and develop action plans to address identified issues.
• Implement and maintain data governance, data management, security, and privacy practices across cloud‑based solutions.
• Ensure data solutions align with established security standards, governance policies, and applicable regulatory requirements.
• Analyze and document cloud data engineering strategies, architecture decisions, technical designs, and operational processes.
• Support CI/CD practices and automated deployment processes using GitHub and related engineering tools.
• Work with orchestration technologies such as Airflow to manage, schedule, monitor, and maintain complex data workflows.
• Contribute to the timely delivery of technical solutions while ensuring alignment with requirements, quality expectations, and project priorities.

Additional Information

Preferred Qualifications:

• AWS certification or a recognized Cloud Data Engineer certification.
• Snowflake certification or demonstrated advanced Snowflake expertise.
• Additional experience with Informatica IICS and Airflow orchestration.
• Experience creating reports or supporting analytics initiatives using Tableau and/or Power BI.
• Experience supporting large, multi-terabyte enterprise data platforms in cloud environments.

Technical Environment: AWS, Snowflake, Informatica IICS, SQL, Python, Airflow, GitHub, CI/CD, Unix, Linux, and shell scripting.

Additional Knowledge Areas: Candidates should have a solid understanding of system administration, database administration, storage architecture, backup and recovery, networking, enterprise data warehousing, and information system architecture.

Data Privacy and Security: Experience working with highly sensitive information in regulated environments is strongly preferred. Familiarity with HIPAA and other data privacy and security controls is highly desirable.

W2 employees of Overture Partners who work 30 or more hours per week are eligible for the following benefits:

• medical (choice of 3 plans)
• 401(k) starting on day one
• a variety of voluntary benefits including life and disability insurance
• sick time if required by law in the worked‑in state/locality