Technical Lead - Cloud Data Engineering - Snowflake / Dbt - Merck

OverviewYou will lead the end-to-end lifecycle of cloud data products, applying Snowflake and DBT expertise to deliver scalable analytics solutions.As a hands-on technical lead, you’ll design data flows, implement Data Vault 2.0 models, and write optimized SQL with Python for data processing.You will build and maintain data pipelines, automate processes, and ensure data quality while mentoring junior developers.Collaborating with cross-functional teams, you’ll shape the data strategy and enable reporting, analytics, and AI initiatives.This role offers impact through scaling data solutions and driving best practices.ResponsabilidadesLead end-to-end lifecycle of cloud data productsDesign and implement data flows aligned with best practicesAct as SME for Snowflake and DBT to guide technical designCreate and optimize Data Vault 2.0 data models for interoperabilityWrite optimized SQL and use Python for data processingDevelop and maintain robust data pipelines and automate processesEnsure data quality across the data lifecycleCollaborate with cross-functional teams to support reporting, analytics, and AI initiativesMentor junior developers and promote knowledge sharingRequisitos principales8+ years as a Snowflake Developer10+ years in data modeling (OLAP, OLTP, Data Vault 2.0) and data warehousingHands-on experience with complex SQL and advanced PythonStrong understanding of data warehousing concepts and methodologiesExperience building data pipelines using DBTFamiliarity with Snowflake performance tuning and query optimizationKnowledge of CI/CD pipelines (Azure DevOps)IaC tools like Terraform or CloudFormation is a plusExcellent problem-solving, analytical, and communication skillsteam leadershipmentoringcommunicationSnowflakeDBTData Vault 2.0

Requisitos principales8+ years as a Snowflake Developer 10+ years in data modeling (OLAP, OLTP, Data Vault 2.0) and data warehousing Hands-on experience with complex SQL and advanced Python Strong understanding of data warehousing concepts and methodologies Experience building data pipelines using DBT Familiarity with Snowflake performance tuning and query optimization Knowledge of CI/CD pipelines (Azure DevOps) IaC tools like Terraform or CloudFormation is a plus Excellent problem-solving, analytical, and communication skills team leadership mentoring communication