ETL Architect; Snowflake & AWS - On-Site; Windsor CT

ETL Architect (Snowflake & AWS)

Key Responsibilities:

• Design and implement ETL/ELT architecture with Snowflake as the enterprise data warehouse.
• Integrate data from diverse sources (RDBMS, APIs, SaaS apps, flat files, streaming platforms & cloud services) into Snowflake.
• Define data integration best practices, including reusability, scalability & cost optimization.
• Lead and mentor ETL/ELT developers in building robust pipelines.
• Optimize Snowflake performance (virtual warehouses, clustering & query tuning).
• Establish data quality, governance & lineage frameworks.
• Collaborate with data architects, BI developers, and business stakeholders for end-to-end data delivery.
• Evaluate and implement ETL/ELT tools and automation frameworks suited for multiple source systems.
• Troubleshoot integration issues and define long-term solutions.
• Keep up to date with Snowflake features and emerging data integration technologies.

Required Skills &

Qualifications:

• 10+ years in ETL/ELT architecture and development.
• Strong expertise in Snowflake (warehouses, streams, tasks, snowpipe, data sharing).
• Proficiency in multiple ETL/ELT tools:
  Informatica, Talend, Matillion, SSIS, AWS Glue, DBT, Fivetran.
• Strong SQL and performance optimization skills.