Overview
On Site
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
Skills
ETL/ELT architecture withSnowflake
RDBMS
APIs
SaaS apps
flat files
streaming platforms
clou
data quality
governance
and lineage
Job Details
Role: ETL Architect
Location: CONNECTICUT,WINDSOR - Onsite
Roles & 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) 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.
- 15+ 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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.