Senior ETL Architect: Snowflake & AWS Data Platform Lead

Robotics Technologies LLC; Windsor (CT); On-site; USD 120,000 - 150,000; Full time

Job summary

A technology company located in Windsor, Connecticut, is seeking an experienced ETL Architect to design and optimize data integration solutions. Ideal candidates will have over 10 years of experience with expertise in Snowflake and the AWS Cloud ecosystem. Responsibilities include architecting scalable ETL pipelines and leading the migration of data platforms to AWS. This is an excellent opportunity to engage in advanced data initiatives and work collaboratively with business stakeholders to ensure data reliability and governance.

Qualifications

• 10+ years of experience in data engineering, ETL development, or data architecture.
• Proven expertise with Snowflake including data modeling and query performance tuning.
• Strong knowledge of AWS services such as S3 and Redshift.
• Hands‑on experience with ETL tools like Informatica or AWS Glue.

Responsibilities

• Design and implement ETL architecture and frameworks for data projects.
• Architect Snowflake-based data warehouse solutions.
• Lead migration of data platforms to AWS cloud-native solutions.
• Develop data pipelines using ETL/ELT tools.

Skills

ETL Development

Snowflake expertise

AWS services knowledge

SQL programming

Python scripting

Data Engineering

Data Warehousing

Problem-solving

Tools

Informatica

Talend

AWS Glue

Airflow

Job description

A technology company located in Windsor, Connecticut, is seeking an experienced ETL Architect to design and optimize data integration solutions. Ideal candidates will have over 10 years of experience with expertise in Snowflake and the AWS Cloud ecosystem. Responsibilities include architecting scalable ETL pipelines and leading the migration of data platforms to AWS. This is an excellent opportunity to engage in advanced data initiatives and work collaboratively with business stakeholders to ensure data reliability and governance.