Position: ETL Architect
Location: Stamford 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.