Data Engineer: dbt & Snowflake Pipelines (Remote)

AgileEngine, LLC.; Región Centro; Sur place; MXN 480 000 - 640 000; Plein temps

Avantages offerts par ce poste

Professional growth

Competitive compensation (USD)

Exciting projects

Flextime

Résumé du poste

AgileEngine, LLC. in Guadalajara, Mexico is seeking a Mid-level Data Engineer to build and maintain dbt pipelines and Snowflake data marts powering customer reporting, spend analytics, and AI features.

You will own production pipelines, ensure data quality, and collaborate with product and engineering teams across the data platform.

The role requires 3+ years in analytics/data engineering, strong SQL and Python, dbt experience, and a pragmatic approach to scalable data models.

Qualifications

• 3+ years in analytics engineering, data engineering, or a closely related role with production data pipelines.
• Solid dbt experience: modeling, tests, macros, and incremental models.
• Strong SQL and working Python.
• Data modeling fundamentals: dimensional modeling, data marts, grain and conformance.
• Experience with a modern cloud warehouse (Snowflake preferred).
• Experience with ingestion tooling and orchestration (Airbyte, Prefect, or equivalents).
• Familiarity with agentic coding tools and guardrails around their output.
• Deep curiosity about the business and how data is used by customers.
• Software engineering discipline for analytics code: Git, code review, CI/CD.
• Ability to take multi-sprint work from spec to production with oversight and explain tradeoffs.

Responsabilités

• Build and maintain the dbt pipelines, data marts, and warehouse models powering in-app reporting, spend analytics, AI features, and internal analytics.
• Translate procurement business logic into maintainable, well-tested pipeline code and identify wrong models.
• Build models within the data mart architecture, following grain and conformance conventions.
• Contribute to and help build the semantic layer queried by MCP servers and AI agents.
• Maintain the boundary between PII and agent/reporting-safe data.
• Build and maintain FastAPI services exposing reporting marts to customers.
• Build and maintain ingestion pipelines (Airbyte, OneSchema, S3) into the warehouse and support Forward Deployed Engineering.
• Implement data quality checks: freshness, schema tests, reconciliation, and alerting.
• Define metric definitions faithfully and flag ambiguities for review.
• Keep documentation and lineage current for humans and AI.
• Tune Snowflake performance and cost within the models.
• Use agentic coding tools with guardrails and share learnings through code reviews.
• Communicate data meaning clearly with engineering, product, and customer-facing teams.

Connaissances

SQL

Python

Data modeling

Analytical thinking

Cloud data warehousing

Outils

dbt

Snowflake

Airbyte

Prefect

FastAPI

Description du poste

AgileEngine, LLC. in Guadalajara, Mexico is seeking a Mid-level Data Engineer to build and maintain dbt pipelines and Snowflake data marts powering customer reporting, spend analytics, and AI features.

You will own production pipelines, ensure data quality, and collaborate with product and engineering teams across the data platform.

The role requires 3+ years in analytics/data engineering, strong SQL and Python, dbt experience, and a pragmatic approach to scalable data models.