ETL Architet

Cloud Hybrid Technologies, LLC; Houston (TX); On-site; USD 120,000 - 150,000; Full time

Job summary

A technology company in Houston, Texas, seeks an experienced ETL/ELT Architect to lead the design and implementation of data integration solutions using Snowflake. The ideal candidate will have over 15 years of experience and strong expertise in various ETL tools. Responsibilities include optimizing performance, mentoring a team, and establishing data governance frameworks. This role offers the opportunity to integrate diverse data sources into a robust architecture.

Qualifications

• 15+ years of experience in ETL/ELT architecture and development.
• Strong expertise in Snowflake (warehouses, streams, tasks).
• Proficiency in multiple ETL/ELT tools, including Informatica, Talend, and AWS Glue.

Responsibilities

• Design and implement ETL/ELT architecture with Snowflake.
• Integrate data from various sources into Snowflake.
• Lead and mentor ETL/ELT developers to build robust pipelines.
• Optimize Snowflake performance.
• Establish data quality and governance frameworks.

Skills

ETL/ELT architecture design

Snowflake optimization

SQL performance optimization

Mentoring ETL/ELT developers

Tools

Informatica

Talend

AWS Glue

DBT

Job description

• 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.

Cloud Hybrid is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. Cloud Hybrid will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will Cloud Hybrid require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract