Senior Analytics Engineer - dbt/Snowflake Lead (LatAm)

Sonatafy Technology, Inc.; Scottsdale (AZ); Remote; MXN 2,242,000 - 2,989,000; Full time

Job summary

Sonatafy Technology, Inc. is seeking a senior analytics engineer to own the dbt transformation layer on a Snowflake-based data platform for a multi-location franchise. You will build staging to mart models, implement robust data rules, and ensure quality through tests and contracts.

You will collaborate with marketing, operations, and finance SMEs, validate definitions, and promote models to production with sign-off. Strong SQL, dbt, Snowflake, and Git workflows are essential.

Qualifications

• 5+ years in data or analytics engineering, with at least 3 years building production dbt projects on Snowflake.
• Strong dbt: layered modeling, incremental models, snapshots and SCD Type 2, macros and Jinja, packages such as dbt_utils, model contracts, exposures, and docs.
• dbt testing in depth: generic and singular tests, source freshness, severity and failure handling, and CI that builds into isolated per-PR schemas.
• Snowflake beyond querying: roles and grants, warehouses and cost controls, UDFs, Secure Views, masking policies, and tags.
• Customer identity resolution or entity matching: deterministic match tiers, survivorship rules, and a stable customer key across source systems.
• Expert SQL, including window functions and semi-structured data.
• Experience handling PII and consent data with an append-only, auditable design.
• Git-based workflow with pull requests, code review, and protected branches.
• Clear written English and the habit of documenting decisions so others can pick up the work.

Responsibilities

• Build and own dbt staging, intermediate, core, and mart models from ticket to production, following the project's naming, routing, and test conventions.
• Turn business rules into documented, testable logic: survivorship, location attribution, consent history, membership lifecycle, and mart metrics.
• Work directly with marketing, operations, and finance subject matter experts to confirm definitions, then get sign-off before a model is promoted.
• Write tests and model contracts with every model. Add source freshness and soft-delete handling for CDC-landed tables.
• Set up and maintain dbt Cloud Production and CI environments, and keep the main branch compiling and deployable.
• Review pull requests from other engineers and take review from the lead architect.
• Reconcile model output against source systems and write up any gap with its cause.
• Document every attribute you build, and contribute to the runbooks and wiki pages used at handoff.

Skills

dbt

Snowflake

SQL

Git-based workflow

Model testing

Tools

dbt Cloud

CI pipelines

Job description

Sonatafy Technology, Inc. is seeking a senior analytics engineer to own the dbt transformation layer on a Snowflake-based data platform for a multi-location franchise. You will build staging to mart models, implement robust data rules, and ensure quality through tests and contracts.

You will collaborate with marketing, operations, and finance SMEs, validate definitions, and promote models to production with sign-off. Strong SQL, dbt, Snowflake, and Git workflows are essential.