ETL Architect ( Looking Only ETL Architects Not Data Architects or Data Engineers)

Position: ETL Architect Location: Windsor, CT Experience: 10–15 years Role Overview We are seeking a seasoned ETL Architect to design and lead scalable data integration solutions for our enterprise Snowflake Data Warehouse. This role requires expertise in Snowflake along with hands-on experience in working with diverse data sources and ETL/ELT technologies. The architect will ensure efficient data movement, transformation, and governance across heterogeneous systems to support analytics and business intelligence initiatives. 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, and cost optimization. • Lead and mentor ETL/ELT developers in building robust pipelines. • Optimize Snowflake performance (virtual warehouses, clustering, query tuning). • Establish data quality, governance, and 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.