Snowflake Data Engineer

As a Snowflake Data Engineer 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. Key Responsibilities: - Develop and maintain ETL/ELT pipelines using Airbyte and Airflow. - Extract data from multiple sources such as APIs, direct database connections, and flat files. - Ensure data quality, consistency, and reliability throughout 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: - 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.,