Snowflake Data Architect

As a Snowflake Data Architect at Aezion, Inc., your role will involve designing and implementing scalable data pipelines, integrating diverse data sources, and building a robust data warehouse to support business intelligence and analytics initiatives. Your key responsibilities will include: - Developing and maintaining ETL/ELT pipelines using Airbyte and Airflow. - Extracting data from multiple sources such as APIs, direct database connections, and flat files. - Ensuring data quality, consistency, and reliability across all ingestion processes. - Designing and implementing Kimball-style dimensional models in Snowflake. - Building and optimizing fact tables and dimension tables to support analytical workloads. - Collaborating with business teams to define and maintain the BUS Matrix for subject areas. - Using DBT to develop modular, testable, and version-controlled transformations. - Implementing data quality checks and documentation within DBT workflows. - Working closely with business stakeholders to understand requirements and translate them into technical solutions. - Ensuring compliance with data governance, security, and privacy standards. To be successful in this role, you will need the following skills and qualifications: - 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. Join Aezion, Inc. as a Snowflake Data Architect and be part of a leading custom software provider committed to transforming clients into lifelong partners through result-driven work.,