ETL Architect

Centraprise; Houston (TX); On-site; USD 90,000 - 120,000; Full time

Job summary

A leading data solutions company is seeking a candidate skilled in Snowflake data modeling and pipeline development to join their Houston team. The ideal candidate will have solid experience in ETL/ELT processes, data governance, and cloud platforms (Azure, AWS, or GCP). Excellent communication skills are required for engaging with clients and leading design sessions. This role offers an exciting opportunity to work with advanced data platforms and tools such as Power BI and DBT.

Qualifications

• Hands-on experience in Snowflake data model design and DBT.
• Ability to design and update data pipelines.
• Experience in pipeline development and optimization.

Responsibilities

• Design and optimize Snowflake data models.
• Performance tuning and security setup in Snowflake environment.
• Build semantic layers using BI tools.

Skills

Snowflake data modeling

DBT

Data pipelines design

Performance tuning

Security setup

Power BI

SQL proficiency

Data governance

Cloud platforms (Azure/AWS/GCP)

Data pipeline orchestration (Airflow, Azure Data Factory)

Client communication

Job description

Hands-on experience in Snowflake data model design, experience with DBT, ability to design and update data pipelines, experience in pipeline development and optimization

Strong experience in data modeling (conceptual, logical, physical) within the Snowflake environment.

Strong expertise in data warehousing concepts and ETL/ELT processes.

Hands-on experience with Snowflake performance tuning, clustering, and security setup.

Working knowledge of Power BI or similar BI tools, with experience building semantic layers.

Proficiency in SQL and understanding of data governance and security principles.

Experience with cloud data platforms (Azure, AWS, or GCP).

Familiarity with data pipeline orchestration tools (e.g., Airflow, Azure Data Factory, DBT).

Very good client communication skills, ability to run design sessions with the client team, experienced in global delivery model