Sr Snowflake and dbt Developer
Guadalajara, Jalisco, Mexico - Remote
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.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
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
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.