Cortex Consultants LLC
ETL Architect ( Looking only ETL Architects not Data Architects or Data Engineer
Cortex Consultants LLC, Windsor, Connecticut, us, 06006
ETL Architect
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.
Seniority level
Mid‑Senior level
Employment type
Contract
Job function
Information Technology
IT Services and IT Consulting
#J-18808-Ljbffr
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.
Seniority level
Mid‑Senior level
Employment type
Contract
Job function
Information Technology
IT Services and IT Consulting
#J-18808-Ljbffr