What are the responsibilities and job description for the ETL Architect position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Steck Systems, is seeking the following. Apply via Dice today!
Rate: $80/hour
Location: 4 days Onsite Windsor, CT.
Roles & Responsibilities
Rate: $80/hour
Location: 4 days Onsite Windsor, CT.
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 lineageframeworks.
- 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 SQLand performance optimization skills.
Salary : $80