Senior Data Engineer

This is a fully remote position, open to applicants in Mexico.

📋 Description

• Develop and manage dbt staging, intermediate, core, and mart models from inception to deployment.

• Convert business rules into well-documented and testable logic for survivorship, location attribution, consent history, membership lifecycle, and mart metrics.

• Collaborate with subject matter experts from marketing, operations, and finance to validate definitions and secure approval prior to model promotion.

• Create tests and model contracts for each model.

• Implement source freshness and soft-delete handling for CDC-landed tables.

• Establish and oversee dbt Cloud Production and CI environments.

• Ensure the main branch remains compilable and deployable.

• Evaluate pull requests from fellow engineers and accept reviews from the lead architect.

• Reconcile model outputs with source systems, documenting any discrepancies and their causes.

• Document every created attribute and contribute to handoff runbooks and wiki pages.

• Collaborate closely with the lead data architect and take ownership of a specific set of models throughout the entire process.

⛳️ Requirements

• Over 5 years of experience in data or analytics engineering.

• A minimum of 3 years developing production dbt projects on Snowflake.

• Proficient in dbt, including layered modeling, incremental models, snapshots and SCD Type 2, macros and Jinja, dbt_utils, model contracts, exposures, and documentation.

• Comprehensive knowledge of dbt testing, encompassing generic and singular tests, source freshness, severity and failure handling, and CI using isolated per-PR schemas.

• Expertise in Snowflake beyond basic querying, including roles and grants, warehouses and cost management, UDFs, Secure Views, masking policies, and tags.

• Experience in customer identity resolution or entity matching, including deterministic match tiers, survivorship rules, and stable customer keys across source systems.

• Advanced SQL skills, including window functions and semi-structured data.

• Familiarity with managing PII and consent data through an append-only, auditable design.

• Proficient in Git-based workflows, including pull requests, code reviews, and protected branches.

• Strong written English skills with a commitment to documenting decisions.

• Experience with dbt Cloud administration, CDC tools, CRM, analytics, appointment or POS systems, franchise reporting, Power BI marts, consent and deletion workflows, Terraform, or Snowflake schema modifications is a plus.

🏝️ Benefits

• A rapidly growing firm recognized by the Inc. 5000.

• Support for account-based marketing initiatives.

• Access to executive events.

• Participation in the Software Leaders Uncensored podcast.