Senior Snowflake and dbt Developer

2 days ago

Apply Now

Receive Emails with Similar Jobs

MezTal

WebsiteLinkedInAll Job Openings

1 - 10

Description

• At Meztal, we are dedicated to harnessing the power of data to drive informed decision-making and innovative solutions. • We are seeking a highly skilled Senior Snowflake and dbt Developer to join our dynamic data engineering team. • This role requires a strong command of English, as you will collaborate with diverse stakeholders across our international operations. • Design and implement data models within Snowflake using dbt to support analytics, reporting, and machine learning use cases. • Develop and maintain scalable, optimized data architectures, including star and snowflake schemas, ensuring data lineage for accuracy and transparency. • Build, schedule, and manage ETL/ELT pipelines in dbt to extract, transform, and load data into Snowflake. • Optimize data ingestion, transformation, and aggregation processes to ensure low latency and high data availability. • Implement data validation and testing frameworks within dbt to ensure data accuracy and quality, utilizing dbt tests, documentation, and snapshots. • Collaborate with the data governance team to ensure compliance, security, and adherence to company-wide data standards. • Enhance performance within Snowflake through advanced techniques, including clustering, partitioning, caching, and query optimization. • Regularly monitor dbt model performance and make necessary adjustments for efficiency and cost optimization. • Partner with data analysts, data scientists, and business units to understand data requirements and deliver accessible, usable data assets. • Act as the subject matter expert in Snowflake and dbt, guiding best practices and ensuring solutions align with strategic goals. • Create and maintain comprehensive documentation for dbt models, Snowflake architecture, and data transformation processes. • Establish best practices for development, deployment, and version control within dbt and Snowflake, supporting code reviews and continuous improvement. • Provide support for data pipeline issues, Snowflake performance, and dbt run-time errors. • Collaborate with the data engineering team to resolve data quality issues, troubleshoot data discrepancies, and implement fixes.

Requirements

• Snowflake Expertise: Advanced knowledge of Snowflake features (SQL, views, data sharing, time travel, zero-copy cloning) and hands-on experience with managing large Snowflake environments. • dbt Proficiency: Extensive experience with dbt, including model development, testing, documentation, macros, and configurations, with a solid understanding of dbt best practices. • SQL Mastery: Expert-level SQL skills for writing efficient queries, data transformations, and Snowflake stored procedures. • Data Pipeline and Orchestration: Experience with data pipeline tools such as Apache Airflow, Prefect, or similar, and familiarity with scheduling and orchestrating dbt models. • Data Modeling: Strong knowledge of data modeling concepts (star, snowflake schemas) and the ability to design models for high performance and scalability. • Cloud Platforms: Familiarity with cloud data ecosystems (e.g., Azure, AWS, or GCP) and integration of cloud storage solutions (like S3 or Azure Blob) with Snowflake. • Version Control and CI/CD: Experience with version control (e.g., Git) and CI/CD practices for deploying and managing dbt projects. • Soft Skills: Excellent communication and collaboration skills, particularly in professional English, to work effectively with technical and non-technical stakeholders. Strong problem-solving abilities and the capacity to work independently with minimal supervision. • Preferred Qualifications: Experience with BI tools (e.g., Looker, Power BI, Tableau) for data visualization. • Knowledge of Python or other scripting languages for automation tasks within data workflows. • Familiarity with data governance and compliance frameworks.

Benefits

• Christmas Bonus: 30 days, to be paid in December. • Major Medical Expense Insurance: Coverage up to $20,000,000.00 MXN. • Minor Medical Insurance: VRIM membership with special discounts on doctor’s appointments and accident reimbursements. • Dental Insurance: Always smile with confidence! • Life Insurance: (Death and MXN Disability) • Vacation Days: 12 vacation days in accordance with Federal Labor Law, with prior approval from your manager. + Floating Holidays: 3 floating holidays in addition to the 7 official holidays in Mexico. • Cell Phone Reimbursement & Transportation Subsidy. • Hybrid Scheme: Enjoy the best of both worlds, remote and in-office work. Multicultural Exposure: Work with operations within Mexico and United Satates. • MezTal Internal Events: Strike a healthy balance between your professional and personal goals. • Exclusive Discounts: Benefits with different companies for being part of MezTal. • Academic Agreements: Access to national universities and language schools.