Data Engineer (Snowflake & dbt)

As a Data Engineer (Snowflake dbt), you will be responsible for designing, developing, and optimizing modern cloud-based data solutions that enable scalable analytics, reporting, and business intelligence capabilities. You will leverage your expertise in Snowflake, dbt, SQL, Python, and Azure DevOps to build high-performance data pipelines, develop robust data models, and support enterprise data platforms. The ideal candidate combines strong data engineering fundamentals with hands-on experience in Snowflake architecture, data transformation, CI/CD automation, and modern data warehousing best practices.

• Design, develop, and maintain scalable ETL/ELT pipelines and data integration solutions using Snowflake, dbt, SQL, and Python.
• Build and optimize complex data transformation workflows, ensuring high-performance data processing, data quality, and reliability across the data platform.
• Develop and maintain Snowflake data models, including OLTP, OLAP, and Data Vault 2.0 methodologies to support enterprise analytics and reporting requirements.
• Create, manage, and optimize dbt models, macros, tests, and transformation frameworks to support governed and reusable data assets.
• Design, implement, and maintain CI/CD pipelines using Azure DevOps, Git, and deployment automation tools to support efficient release management and code promotion processes.
• Collaborate with data architects, analysts, and business stakeholders to design scalable data solutions and support evolving business requirements.
• Perform performance tuning, query optimization, and troubleshooting to improve Snowflake workload efficiency, scalability, and data processing performance.
• Document data models, transformation logic, workflows, and operational procedures while supporting governance, compliance, and knowledge-sharing initiatives.

• 5+ years of experience in Data Engineering, including hands-on experience building enterprise data pipelines, ETL/ELT frameworks, and cloud-based data solutions.
• Strong expertise in Snowflake, SQL, and Python, including advanced query development, data transformation, performance tuning, and large-scale data processing.
• Proven experience with dbt (Data Build Tool), including developing and maintaining dbt models, macros, testing frameworks, and transformation workflows.
• Experience implementing CI/CD pipelines and version control practices, using Azure DevOps, Git repositories, deployment automation, and release management processes.
• Strong understanding of data modeling and warehousing concepts, including OLTP, OLAP, Data Vault 2.0, dimensional modeling, and enterprise data architecture.
• Preferred: Experience with Azure, AWS, data governance, data security, compliance requirements, and mentoring junior developers or supporting technical leadership activities.