Senior Data Engineer

Job not on LinkedIn

🔥 0 minutes ago

🇲🇽 Mexico – Remote

⏰ Full Time

🟠 Senior

🚰 Data Engineer

👻 Ghost score 17%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

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

Upload Resume

Sonatafy Technology - Mexico

WebsiteLinkedInAll Job Openings

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