Experienced Snowflake and dbt Developer

hace 1 semana

Guadalajara, Jalisco, México FlexTal Staffing LLC A tiempo completo

We are seeking a highly skilled Senior Snowflake and dbt Developer to join our dynamic data engineering team at FlexTal Staffing LLC. 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.

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.

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.

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.

  • Senior Snowflake and dbt Developer

    hace 1 semana

    Guadalajara, Jalisco, México Aitopics A tiempo completo

    At Meztal, we are driven to harness the power of data for informed decision-making and innovative solutions. We are seeking a highly skilled Senior Snowflake and dbt Developer to join our dynamic data engineering team.Key Responsibilities: Data Architecture and Modeling: Design and implement data models within Snowflake using dbt to support analytics,...

  • Senior Snowflake AWS Backend Developer

    hace 4 semanas

    Guadalajara, Jalisco, México Sequoia Connect A tiempo completo

    Job Title: Senior Snowflake AWS Backend DeveloperAbout the Role:We are seeking a highly skilled Senior Snowflake AWS Backend Developer to join our team at Sequoia Connect in Guadalajara, Jalisco. As a key member of our team, you will be responsible for designing and implementing scalable and efficient backend systems using Snowflake and AWS technologies.Key...

  • Snowflake Data Engineer

    hace 1 semana

    Guadalajara, Jalisco, México Msns Hr Technology Llc A tiempo completo

    **Snowflake Developer Role**At Msns Hr Technology Llc, we are seeking a talented Snowflake Developer to join our team. As a key member of our data engineering team, you will be responsible for designing, implementing, and maintaining large-scale data pipelines using Snowflake.Key Responsibilities:Design and develop data pipelines using Snowflake, ensuring...

  • Snowflake Data Engineer

    hace 2 semanas

    Guadalajara, Jalisco, México Ibm A tiempo completo

    IntroductionIn IBM Consulting, we're committed to delivering cutting-edge technical expertise to our clients worldwide. As a Snowflake Data Engineer, you'll be part of our team in one of our Client Innovation Centers, where we drive innovation and adoption of new technology.A career in IBM Consulting is built on long-term relationships and close...

  • Data Architect

    hace 3 semanas

    Guadalajara, Jalisco, México Ust Global A tiempo completo

    **Job Title:** Data Architect/Senior Data Engineer**Job Summary:**We are seeking a highly skilled Data Architect/Senior Data Engineer to join our team at UST Global. As a key member of our data engineering team, you will be responsible for designing and delivering enterprise data products using DBT and Snowflake. Your expertise in Big Data/AI platforms,...

  • Senior AWS Python Snowflake Developer

    hace 3 semanas

    Guadalajara, Jalisco, México Sonataone A tiempo completo

    **Sonata Software Overview**Sonata is a global technology company that specializes in digital transformation, helping businesses become connected, open, intelligent, and scalable. Our Platformation methodology combines industry expertise, platform technology excellence, design innovation, and strategic engagement models to deliver sustained value to...

  • Senior Java Developer

    hace 3 semanas

    Guadalajara, Jalisco, México Capgemini Engineering A tiempo completo

    Senior Java Developer PositionAt Capgemini Engineering, we are seeking a skilled Java Developer with a background in ServiceNow or Snowflake. The ideal candidate will have strong experience in Java and Spring Boot, with additional expertise in ServiceNow and Snowflake being a plus. Your RoleWe are looking for a talented Java Developer to develop and maintain...

  • SQL Developer

    hace 6 días

    Guadalajara, Jalisco, México NTT DATA A tiempo completo

    Job OverviewNTT DATA is seeking a highly skilled SQL Developer to join our team in Guadalajara, Mexico. As a SQL Developer, you will design and implement tailored data solutions to meet customer needs and use cases.Key Responsibilities:Design and implement data solutions to meet customer needs and use cases.Provide thought leadership and recommend...

  • Data Engineer

    hace 3 semanas

    Guadalajara, Jalisco, México Ust Global A tiempo completo

    Job Title: Data EngineerUST is seeking a highly skilled Data Engineer to join our team. As a Data Engineer, you will be responsible for collecting and analyzing data to drive business decisions.Key Responsibilities:Design and implement data models using DBT and SnowflakeDevelop and maintain data pipelines to deliver data products to business...

  • Sla-24-25-50 AWS Python Snowflake Developer

    hace 3 semanas

    Guadalajara, Jalisco, México Sonataone A tiempo completo

    **Digital Transformation Expertise**Sonata Software is a global technology company that specializes in platform-based digital transformation. We help businesses become connected, open, intelligent, and scalable by leveraging our Platformation methodology. This approach combines industry expertise, platform technology excellence, design innovation, and...

  • Data Engineer

    hace 3 semanas

    Guadalajara, Jalisco, México Ust Global A tiempo completo

    Job Title: Data EngineerWe are seeking a highly skilled Data Engineer to join our team at UST Global. As a Data Engineer, you will be responsible for collecting and analyzing data to drive business decisions.Key Responsibilities:Design and implement data models using DBT and Snowflake to deliver data products according to business needs.Enhance and...

  • Senior Data Architect

    hace 3 semanas

    Guadalajara, Jalisco, México Ust Global A tiempo completo

    Job Title: Senior Data ArchitectWe are seeking a highly skilled Senior Data Architect to join our team at UST Global. As a key member of our data architecture team, you will be responsible for designing and implementing enterprise data products using Big Data/AI platforms.Key Responsibilities:Design and delivery of enterprise data productsCreation of data...

  • Data Architect

    hace 3 semanas

    Guadalajara, Jalisco, México FlexTal Staffing LLC A tiempo completo

    Job Title: Sr Data ArchitectWe are seeking a highly skilled Sr Data Architect to join our team. As a key member of our data engineering strategy, you will contribute to and lead the development of our Enterprise Data and Analytics Platforms.The successful candidate will have a deep understanding of data management best practices and patterns, as well as...

  • Backend Developer

    hace 1 mes

    Guadalajara, Jalisco, México Sonata Software A tiempo completo

    Sonata Software OverviewSonata Software is a global technology company that specializes in digital transformation, helping businesses become connected, open, intelligent, and scalable. Our Platformation methodology brings together industry expertise, platform technology excellence, design innovation, and strategic engagement models to deliver sustained value...

  • Senior Backend Developer

    hace 3 semanas

    Guadalajara, Jalisco, México Sonata Software A tiempo completo

    Sonata Software OverviewSonata Software is a global technology company that specializes in digital transformation, helping businesses become connected, open, intelligent, and scalable. Our Platformation methodology brings together industry expertise, platform technology excellence, design innovation, and strategic engagement models to deliver sustained value...

  • Senior Java Developer

    hace 3 semanas

    Guadalajara, Jalisco, México Capgemini Engineering A tiempo completo

    About the RoleWe are seeking a skilled Java Developer with a background in ServiceNow or Snowflake to join our team at Capgemini Engineering. As a key member of our team, you will be responsible for developing and maintaining applications using Java and Spring Boot, leveraging ServiceNow development experience in a Java environment, and collaborating with...

  • Senior Java Developer

    hace 3 semanas

    Guadalajara, Jalisco, México Capgemini Engineering A tiempo completo

    **Senior Java Developer Position**At Capgemini Engineering, we're looking for a skilled Java developer to join our team. As a Senior Java Developer, you'll be responsible for leveraging ServiceNow development experience in a Java environment, collaborating with cross-functional teams to integrate Snowflake where applicable, and ensuring high-quality code...

  • Senior Backend Developer

    hace 3 semanas

    Guadalajara, Jalisco, México Sonata Software A tiempo completo

    Sonata Software OverviewSonata Software is a global technology company that specializes in digital transformation. Our Platformation approach brings together industry expertise, platform technology excellence, design innovation, and strategic engagement models to deliver sustained value to customers.Role: Senior Backend DeveloperWe are seeking a skilled...

  • Analytical Report Developer

    hace 2 semanas

    Guadalajara, Jalisco, México Skilled Wound Care A tiempo completo

    **Data Analysis Expertise**We are seeking a skilled professional to contribute to our team's analytical reporting efforts. As a Software/Database Developer, you will be responsible for designing, developing, and maintaining backend systems and data pipelines to support the generation and delivery of analytical reports.Key Responsibilities:Collaborate with...

  • Data Warehouse Architect

    hace 4 semanas

    Guadalajara, Jalisco, México Mollica It A tiempo completo

    Job Title: Tech Lead Big DataAbout the Role:We are seeking a highly skilled Tech Lead Big Data to join our team at Mollica It. As a Tech Lead, you will be responsible for leading the development and implementation of our Big Data solutions using Snowflake Data Warehouse.Key Responsibilities:Design and implement a fully operational solution on Snowflake Data...