Sr Data Engineer

Sonatafy Technology

United States

Remote

USD 120,000 - 170,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Sonatafy Technology, headquartered in Scottsdale, Arizona, seeks a senior analytics engineer with deep dbt and Snowflake experience to join a Managed Delivery POD building a governed data platform for a multi-location franchise brand.

You will own the dbt transformation layer, including staging models, identity resolution, Customer 360 core models, seven production marts, tests, contracts, and documentation to enable handoff to the client's team after delivery; collaborate with the lead data

Qualifications

  • 5+ years of experience in data or analytics engineering.
  • At least 3 years building production dbt projects on Snowflake.
  • Strong SQL and data modeling skills.
  • Experience with Git-based workflows and code reviews.
  • Excellent written English communication.

Responsibilities

  • Build and own dbt staging, intermediate, core, and mart models from ticket to production.
  • Translate business rules into documented, testable logic (survivorship, location attribution, consent history, membership lifecycle, mart metrics).
  • Collaborate with marketing, operations, and finance SMEs to confirm definitions and obtain sign-off before promotion.
  • Write tests and model contracts for every model.
  • Maintain CDC source freshness and soft-delete handling; set up and manage dbt Cloud Production and CI environments.
  • Review PRs and align with lead architect; reconcile model output against sources and document gaps.
  • Document every attribute and contribute to runbooks and handoff wiki pages.

Skills

5+ years data/analytics engineering
3+ years production dbt on Snowflake
SQL expert
Git and PR workflow
Clear written English

Tools

dbt Cloud
Snowflake
CI/CD tooling

Job description

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!

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Sr Data Engineer
Sr Data Engineer

Sonatafy Technology, Inc. • Scottsdale (AZ)

Remote
MXN 2,242,000 - 2,989,000
Senior Analytics Engineer - dbt/Snowflake Lead (LatAm)
Senior Analytics Engineer - dbt/Snowflake Lead (LatAm)

Sonatafy Technology, Inc. • Scottsdale (AZ)

Remote
MXN 2,242,000 - 2,989,000
Senior Analytics Engineer | dbt + Snowflake Lead
Senior Analytics Engineer | dbt + Snowflake Lead

Sonatafy Technology • United States

Remote
USD 120,000 - 170,000
Senior Data Architect (Snowflake)- Market Research
Senior Data Architect (Snowflake)- Market Research

Truelogic • United States

Remote
USD 140,000 - 210,000
100% Remote Work
Highly Competitive USD Pay
Paid Time Off
+2
Data Modeler
Data Modeler

Veridic Solutions • Spring (TX)

On-site
USD 96,000 - 193,000
Senior Data Engineer
Senior Data Engineer

MISUMI Americas • Schaumburg (IL)

On-site
USD 167,000 - 202,000
Comprehensive medical and dental
401(k) plan
Generous PTO and leave programs
Senior Snowflake Developer | NY, NJ | Contract (C2H) / FTE
Senior Snowflake Developer | NY, NJ | Contract (C2H) / FTE

Healthcare Triangle, Inc. • New York (NY)

On-site
USD 140,000 - 190,000
Senior DBT/Snowflake Developer
Senior DBT/Snowflake Developer

Go Fractional • New York (NY)

Remote
USD 96,000 - 152,000
Sr Data Engineer
Sr Data Engineer

Cox Automotive • Atlanta (GA)

On-site
USD 140,000 - 190,000
Senior Data Architect (Snowflake)- Market Research - LATAM
Senior Data Architect (Snowflake)- Market Research - LATAM

Truelogic • United States

Remote
USD 150,000 - 230,000
Remote work
Competitive USD pay
Paid time off
+2