Sr Snowflake and dbt Developer

Guadalajara, Jalisco, Mexico - Remote

Apply now Apply later

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.

Key Responsibilities:

Data Architecture and Modeling:

  • 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.

ETL/ELT Development and Management:

  • 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.

Data Quality and Governance:

  • 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.

Performance Tuning and Optimization:

  • 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.

Collaboration and Cross-functional Support:

  • 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.

Documentation and Best Practices:

  • 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.

Troubleshooting and Support:

  • 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

Required Skills and Experience:

  • 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

Awesome Benefits for Our Team!

  • 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.

Apply now Apply later

* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰

Job stats:  2  0  0
Category: Engineering Jobs

Tags: Airflow Architecture AWS Azure CI/CD Clustering Data governance Data quality Data visualization dbt ELT Engineering ETL GCP Git Looker Machine Learning ML models Pipelines Power BI Python Security Snowflake SQL Tableau Testing

Perks/benefits: Career development Health care Insurance Salary bonus Team events Transparency

Regions: Remote/Anywhere North America
Country: Mexico

More jobs like this

Explore more career opportunities

Find even more open roles below ordered by popularity of job title or skills/products/technologies used.