Sonatafy Technology - Mexico
Sonatafy Technology - Mexico
Sonatafy Technology - Mexico este o firmă de dezvoltare software nearshore, care ajută startupurile și companiile să își formeze și să își extindă echipele de inginerie. Serviciile sale includ suplimentarea echipelor cu personal, gestionarea proiectelor software, prototiparea rapidă și asistență CTO cu fracțiune de normă. Compania pune la dispoziție ingineri full-stack și specialiști în front-end, back-end, aplicații mobile, DevOps, asigurarea calității, baze de date și UI/UX. Aceasta deservește clienți din sănătate, servicii financiare și fintech, SaaS și IT, precum și producție. Modelul nearshore asigură alinierea fusurilor orare și echipe cu competențe de limba engleză pentru dezvoltarea de produse.

Senior Data Engineer, dbt and Snowflake

Build governed dbt and Snowflake data platforms for Sonatafy’s nearshore software clients. Own production models, testing, documentation, and Customer 360 marts.

Descriere

  • Build dbt models across staging, intermediate, core, and mart layers from assigned tickets through production.
  • Turn business rules for survivorship, location attribution, consent history, membership lifecycle, and mart metrics into documented, testable logic.
  • Confirm definitions with marketing, operations, and finance experts and secure sign-off before promoting models.
  • Create tests and model contracts for every model.
  • Configure source freshness checks and soft-delete handling for CDC-loaded tables.
  • Set up and maintain dbt Cloud production and CI environments.
  • Keep the main branch compiling and ready to deploy.
  • Review other engineers’ pull requests and receive reviews from the lead architect.
  • Compare model outputs with source systems and document discrepancies and their causes.
  • Document each implemented attribute and contribute to handoff runbooks and wiki pages.
  • Partner with the lead data architect and take end-to-end ownership of a defined set of models.

Cerințe

  • Bring at least five years of experience in data or analytics engineering.
  • Have three or more years building production dbt projects on Snowflake.
  • Demonstrate strong dbt skills across layered and incremental models, snapshots and SCD Type 2, macros and Jinja, dbt_utils, model contracts, exposures, and documentation.
  • Know dbt testing in depth, including generic and singular tests, source freshness, severity and failure handling, and CI with isolated schemas for each pull request.
  • Bring advanced Snowflake experience beyond querying, including roles and grants, warehouses and cost controls, UDFs, Secure Views, masking policies, and tags.
  • Have experience with customer identity resolution or entity matching, including deterministic match tiers, survivorship rules, and stable customer keys across source systems.
  • Write expert-level SQL, including window functions and work with semi-structured data.
  • Have experience managing PII and consent data with append-only, auditable designs.
  • Be experienced with Git-based workflows, including pull requests, code review, and protected branches.
  • Communicate clearly in written English and document decisions consistently.
  • Additional helpful experience includes dbt Cloud administration, CDC tools, CRM, analytics, appointment or POS systems, franchise reporting, Power BI marts, consent and deletion workflows, Terraform, or Snowflake schema changes.

Beneficii

  • Join a fast-growing firm recognized on the Inc. 5000.
  • Receive account-based marketing support.
  • Attend executive events.
  • Be featured on the Software Leaders Uncensored podcast.

Locuri de muncă similare