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.
