Senior Data Engineer

🕒 October 22

🇲🇽 Mexico – Remote

⏰ Full Time

🟡 Mid-level

🟠 Senior

🚰 Data Engineer

Where this job comes from

Posted on Sonatafy Technology - Mexico's careers page ↗Sonatafy Technology - Mexico's careers page, not through a job board

First seen by Remote Rocketship October 22

Still open on Sonatafy Technology - Mexico's site. Checked 2 hours ago.

Apply Now
Logo of Sonatafy Technology - Mexico

Sonatafy Technology - Mexico

51 - 200 employees

💼 Consulting

🏥 Healthcare

🏭 Manufacturing

Consulting • Healthcare • Manufacturing

Sonatafy Technology - Mexico is a nearshore software development firm that provides staff augmentation, fully managed software projects, rapid prototyping, and fractional CTO services. The company supplies pre-vetted full‑stack engineers and specialists in front-end, back-end, mobile, DevOps, QA, database management and UI/UX to help businesses accelerate product development, scale teams quickly, and reduce costs while maintaining time-zone alignment and strong English proficiency. Sonatafy serves startups and enterprise clients across industries such as healthcare, financial services/fintech, SaaS/IT and manufacturing.

📋 Description

• Build and own dbt staging, intermediate, core, and mart models from ticket to production • Translate business rules into documented and testable logic for survivorship, location attribution, consent history, membership lifecycle, and mart metrics • Work with marketing, operations, and finance subject matter experts to confirm definitions and obtain sign-off before model promotion • Write tests and model contracts for every model • Add source freshness and soft-delete handling for CDC-landed tables • Set up and maintain dbt Cloud Production and CI environments • Keep the main branch compiling and deployable • Review pull requests from other engineers and receive review from the lead architect • Reconcile model output against source systems and document gaps and causes • Document every built attribute and contribute to handoff runbooks and wiki pages • Work alongside the lead data architect and own a defined set of models end to end

🎯 Requirements

• 5+ years in data or analytics engineering • At least 3 years building production dbt projects on Snowflake • Strong dbt skills, including layered modeling, incremental models, snapshots and SCD Type 2, macros and Jinja, dbt_utils, model contracts, exposures, and documentation • In-depth dbt testing knowledge, including generic and singular tests, source freshness, severity and failure handling, and CI using isolated per-PR schemas • Snowflake expertise beyond querying, including roles and grants, warehouses and cost controls, UDFs, Secure Views, masking policies, and tags • Customer identity resolution or entity matching experience, including deterministic match tiers, survivorship rules, and stable customer keys 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 experience with pull requests, code review, and protected branches • Clear written English and a habit of 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 changes is nice to have

🏖️ Benefits

• Fast-growing, Inc. 5000-recognized firm • Account-based marketing support • Executive events • Software Leaders Uncensored podcast

Apply Now

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Similar Jobs

🕒 October 22

YouGov

1001 - 5000

💼 Consulting

📣 Marketing

📦 Logistics

Data Engineer building scalable pipelines and warehouses for YouGov’s global opinion research platform. Using Python, Airflow, Snowflake, and AWS to deliver trusted datasets.

🇲🇽 Mexico – Remote

💰 $293.4M Post IPO debt on 2023-11

⏰ Full Time

🟡 Mid-level

🟠 Senior

🚰 Data Engineer

🕒 October 21

DaCodes.

201 - 500

🚘 Automotive

🏥 Healthcare

💼 Consulting

Senior Data Engineer construyendo pipelines, modelos y controles en Snowflake y dbt para DaCodes. Integrando datos empresariales y habilitando reportes y consultas con IA.

🗣️🇪🇸 Spanish Required

🕒 October 18

Farmers Insurance

10,000+ employees

🚘 Automotive

💼 Consulting

🏥 Healthcare

Data Engineer building analytics solutions, data pipelines, and enterprise integrations for Farmers Insurance. Improving data quality, reporting platforms, dashboards, and regulatory-aligned business outcomes.

🇲🇽 Mexico – Remote

💰 $300M Debt Financing - Farmers Insurance on 2024-10

⏰ Full Time

🟡 Mid-level

🚰 Data Engineer

🕒 October 14

Capgemini

10,000+ employees

💼 Consulting

🏥 Healthcare

📦 Logistics

Global data-platform operations lead coordinating automotive ingest infrastructure, Quick Trays, and site operations. Supporting Capgemini Engineering’s technology and engineering services for innovative companies.

🕒 October 12

CRH Talento en IT

11 - 50

💼 Consulting

📣 Marketing

🎯 Recruiter

Senior AWS Data Platform Engineer diseñando plataformas de datos escalables y seguras en AWS. CRH Talento de IT selecciona consultores tecnológicos para sus clientes.

🗣️🇪🇸 Spanish Required

Built by Lior Neu-ner. I'd love to hear your feedback — Get in touch via DM or support@remoterocketship.com
Follow Remote Rocketship on LinkedInFollow Remote Rocketship on InstagramFollow Remote Rocketship on FacebookFollow Remote Rocketship on TikTok