Senior Data Engineer - Snowflake

As a Snowflake Data Engineer, 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 expertise in DBT, Airbyte, and Airflow, along with experience in Kimball dimensional modeling, will be crucial for this position. Key Responsibilities: - Develop and maintain ETL/ELT pipelines using Airbyte and Airflow. - Extract data from multiple sources like APIs, direct database connections, and flat files while ensuring data quality, consistency, and reliability. - Design and implement Kimball-style dimensional models in Snowflake, optimizing fact and dimension tables for analytical workloads. - Use DBT to create modular, testable, and version-controlled transformations, implementing data quality checks and documentation within DBT workflows. - Collaborate with business teams to define and maintain the BUS Matrix for subject areas. - Work closely with business stakeholders to translate requirements into technical solutions, ensuring 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. Additional Company Details: Experience with cloud platforms (AWS, Azure, or GCP), familiarity with BI tools (e.g., Tableau, Power BI), and knowledge of data governance and security best practices are preferred qualifications for this role.,