Snowflake Architect

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

We are seeking a highly skilled Snowflake Data Engineer with expertise in DBT, Airbyte, and Airflow, combined with strong experience in Kimball dimensional modeling. The ideal candidate will design and implement scalable data pipelines, integrate diverse data sources, and build a robust data warehouse that supports business intelligence and analytics initiatives.

Key Responsibilities

Data Integration & Extraction

• Develop and maintain ETL/ELT pipelines using Airbyte and Airflow.
• Extract data from multiple sources including APIs, direct database connections, and flat files.
• Ensure data quality, consistency, and reliability across all ingestion processes.

Data Modeling & Warehousing

• Design and implement Kimball-style dimensional models in Snowflake.
• Build and optimize fact tables and dimension tables to support analytical workloads.
• Collaborate with business teams to define and maintain the BUS Matrix for subject areas.

Transformation & Orchestration

• Use DBT to develop modular, testable, and version-controlled transformations.
• Implement data quality checks and documentation within DBT workflows.
• Work closely with business stakeholders to understand requirements and translate them into technical solutions.
• Ensure compliance with data governance, security, and privacy standards.

Required Skills & Qualifications

Technical Expertise

• Strong proficiency in Snowflake architecture and performance tuning.
• Hands‑on experience with DBT, Airbyte, and Airflow.
• Solid understanding of Kimball methodology for data warehousing.
• Advanced SQL skills and familiarity with Python for ETL scripting.
• Experience integrating data from APIs and relational databases.
• Excellent communication and collaboration skills.
• Ability to work in an agile environment and manage multiple priorities.

Preferred Qualifications

• Experience with cloud platforms (AWS, Azure, or GCP).
• Familiarity with BI tools (e.g., Tableau, Power BI).
• Knowledge of data governance and security best practices.

Seniority Level

Mid‑Senior level

Employment Type

Full‑time

Job Function and Industries

Design, Art/Creative, and Information Technology; IT Services and IT Consulting

Referrals increase your chances of interviewing at Aezion, Inc by 2x.