Sr Data Engineer

Posted Yesterday
Be an Early Applicant
Hiring Remotely in México
Remote
Senior level
Artificial Intelligence • Software • Consulting • App development
The Role
Build and own governed dbt transformation models in Snowflake, including staging, core, Customer 360, and production marts. Translate business rules into tested, documented logic; manage contracts, freshness checks, CDC soft deletes, CI environments, and deployment workflows. Collaborate with marketing, operations, finance, and architecture stakeholders, reconcile outputs with source systems, review code, and document platform decisions for client handoff.
Summary Generated by Built In

THIS OPENING IS AVAILABLE FOR CANDIDATES IN LATIN AMERICA, NOT LIMITED TO ONLY MEXICO.

Sonatafy Technology, headquartered in Scottsdale, Arizona, is an award-winning nearshore software development company with a strong reputation. They have a dedicated in-house team of engineers, offering end-to-end software solutions and supporting client development staff augmentation. Catering to companies of all sizes and industries, including some of the world's largest brands, Sonatafy Technology is a trusted provider of nearshore enterprise-level cloud and mobile application software development services.


About the Role

We're looking for a senior analytics engineer with deep experience in dbt and Snowflake to join a Managed Delivery POD building a governed data platform for a multi-location franchise brand.


The platform is a layered Snowflake Enterprise instance (RAW, STAGING, CORE, MARTS, SANDBOX) fed by CDC, with functional RBAC and a dbt Cloud project. The role centers on the dbt transformation layer: staging models, identity resolution, Customer 360 core models, seven production marts, and the tests, contracts, and documentation that let the client's team own the platform after handoff.


You will work alongside the lead data architect and own a defined set of models end to end.


Key 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.

Requirements

  • 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.

Nice to Have

  • dbt Cloud administration: environments, jobs, service users with key pair auth, and network policies.
  • Modeling data landed by CDC tools such as Snowflake OpenFlow or AWS DMS, including soft-delete flags.
  • Source familiarity with Zoho CRM, Customer.io, GA4 exports, or appointment and POS systems.
  • Multi-location or franchise reporting, including row-level security by franchise, market, or region.
  • Building marts for Power BI and matching metrics to existing report logic.
  • Consent and data deletion workflows across marketing and CRM tools.
  • Terraform or schema changes for Snowflake objects.

Why Work with Sonatafy?

At Sonatafy, you’ll join a fast-growing, Inc. 5000-recognized firm with 60+ completed client engagements. You’ll be backed by account-based marketing, executive events, and our Software Leaders Uncensored podcast. We provide the platform and support. You bring the hustle, relationships, and follow-through.


If you have reached this point and feel you are our ideal candidate, it’s time for you to apply!


Recruitment Scam Notice:

Sonatafy recruitment communications will only come from @sonatafy.com email addresses. We do not request fees, sensitive financial information, or conduct hiring solely through online forms without interviews. If you receive a suspicious message, contact us at [email protected].

Skills Required

  • 5+ years of experience in data or analytics engineering
  • At least 3 years building production dbt projects on Snowflake
  • Strong dbt experience with layered modeling, incremental models, snapshots, SCD Type 2, macros, Jinja, packages, model contracts, exposures, and documentation
  • In-depth dbt testing experience, including generic and singular tests, source freshness, severity and failure handling, and isolated per-PR CI schemas
  • Advanced Snowflake experience with roles, grants, warehouses, cost controls, UDFs, secure views, masking policies, and tags
  • Experience with customer identity resolution or entity matching, including deterministic match tiers, survivorship rules, and stable customer keys
  • Expert SQL skills, including window functions and semi-structured data
  • Experience handling PII and consent data using append-only, auditable designs
  • Experience with Git-based workflows, pull requests, code review, and protected branches
  • Clear written English and strong documentation habits
  • dbt Cloud administration, including environments, jobs, service users with key-pair authentication, and network policies
  • Experience modeling CDC data from tools such as Snowflake OpenFlow or AWS DMS, including soft-delete flags
  • Familiarity with Zoho CRM, Customer.io, GA4 exports, appointment systems, or POS systems
  • Experience with multi-location or franchise reporting and row-level security
  • Experience building Power BI marts and reconciling metrics with existing report logic
  • Experience with consent and data deletion workflows across marketing and CRM tools
  • Terraform or Snowflake schema changes experience
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
180 Employees
Year Founded: 2020

What We Do

Sonatafy Technology helps organizations diagnose and fix software-delivery problems through consulting, managed delivery teams, and senior engineering capacity. Its work includes fractional technology leadership, cross-functional software engineering, custom product and platform development, cloud modernization, data warehousing, analytics, AI solutions, and workflow automation. The company emphasizes accountable delivery and measurable outcomes, serving businesses in SaaS, healthcare, fintech, manufacturing, enterprise software, and private-equity-backed technology.

Similar Jobs

Moderna Logo Moderna

Senior Analytics Engineer

Healthtech • Biotech
In-Office or Remote
3 Locations
6848 Employees

Nagarro Logo Nagarro

Senior Engineer

Artificial Intelligence • Information Technology • Machine Learning • Software • Virtual Reality • Analytics
Remote
MX
19994 Employees

Nexaminds Logo Nexaminds

Sr. Data Platform Engineer

Artificial Intelligence • Cloud • Information Technology • Machine Learning • Natural Language Processing • Consulting
Remote
México
80 Employees

Nexaminds Logo Nexaminds

Senior Data Engineer

Artificial Intelligence • Cloud • Information Technology • Machine Learning • Natural Language Processing • Consulting
Remote
México
80 Employees

Similar Companies Hiring

Blee Thumbnail
Artificial Intelligence • Marketing Tech • Software
New York, New York
33 Employees
Vega Thumbnail
Artificial Intelligence • Automotive • Insurance • Transportation
US
65 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account