Snowflake Data Architect — ETL & BI Pipelines

Aezion, Inc; Frisco (TX); On-site; USD 100,000 - 120,000; Full time

Job summary

A leading IT consulting firm is looking for a skilled Snowflake Data Engineer to design scalable data pipelines and implement robust data warehouses. The ideal candidate will be well-versed in DBT, Airbyte, and Airflow, with a solid understanding of Kimball dimensional modeling. Responsibilities include data integration, modeling, and transformation while ensuring data quality. This full-time position offers an opportunity to work in a collaborative agile environment and engage with multiple stakeholders.

Qualifications

• Proficiency in Snowflake for data engineering.
• Experience with ETL/ELT pipelines using Airbyte and Airflow.
• Strong SQL skills and Python for scripting.

Responsibilities

• Develop and maintain ETL/ELT pipelines for data integration.
• Design and implement Kimball-style dimensional models.
• Collaborate with teams to define requirements and solutions.

Skills

Snowflake architecture

DBT

Airbyte

Airflow

Data warehousing (Kimball methodology)

SQL

Python

Communication

Agile project management

Tools

AWS

Azure

GCP

Tableau

Power BI

Job description

A leading IT consulting firm is looking for a skilled Snowflake Data Engineer to design scalable data pipelines and implement robust data warehouses. The ideal candidate will be well-versed in DBT, Airbyte, and Airflow, with a solid understanding of Kimball dimensional modeling. Responsibilities include data integration, modeling, and transformation while ensuring data quality. This full-time position offers an opportunity to work in a collaborative agile environment and engage with multiple stakeholders.