Snowflake Data Architect

Company Description

Aezion, Inc. is a leading custom software provider based in the Dallas, Fort Worth, and DFW metroplex. We help clients solve IT challenges and achieve their business goals, providing services from architecture and design to development, hosting, deployment, maintenance, and support. Our commitment is backed by the Aezion A-Z Performance Guarantee, aiming to transform clients into lifelong partners through result-driven work.

Location : Bangalore / Coimbatore

About the Role

We are seeking a highly skilled Snowflake Data Architect 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

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