caferemote
Sonatafy Technology

Sr Data Engineer

Remote Anguilla, Antigua and Barbuda, Argentina, Aruba, Bahamas, Barbados, Belize, Bermuda, Bolivia, Bonaire, Sint Eustatius and Saba, Brazil, Cayman Islands, Chile, Colombia, Costa Rica, Cuba, Dominica, Dominican Republic, Ecuador, El Salvador, Falkland Is Full-time Senior Posted yesterday
Apply now
Work from
Anguilla, Antigua and Barbuda, Argentina, Aruba, Bahamas, Barbados, Belize, Bermuda, Bolivia, Bonaire, Sint Eustatius and Saba, Brazil, Cayman Islands, Chile, Colombia, Costa Rica, Cuba, Dominica, Dominican Republic, Ecuador, El Salvador, Falkland Is
Contract
Full-time
Experience
Senior
Posted
19 November 2026
Apply by
24 December 2026

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.

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

About the role

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.

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.

About Sonatafy Technology

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.

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

Discussion

No comments yet. Ask a question or share a tip about this role.

Apply now

More jobs from Sonatafy Technology

View company →

Sr Machine Learning Engineer

Sonatafy Technology
Remote Anguilla, Antigua and Barbuda, Argentina, Aruba, Bahamas, Barbados, Belize, Bermuda, Bolivia, Bonaire, Sint Eustatius and Saba, Brazil, Cayman Islands, Chile, Colombia, Costa Rica, Cuba, Dominica, Dominican Republic, Ecuador, El Salvador, Falkland Is Full-time

THIS OPENING IS AVAILABLE FOR CANDIDATES IN LATIN AMERICA, NOT LIMITED TO ONLY COLOMBIA. Sonatafy Technology , headquartered in Scottsdale, Arizona, is an…

yesterday Data

Similar remote jobs

Browse all →

Risk Prevention Analyst - Remote

Velera
Remote United States Full-time $60K – $93K / year

Join the People Helping People Velera is the nation’s premier payments credit union service organization (CUSO) and an integrated fintech solutions provider. The company serves more than…

3h ago Data

Summer 2027 Analytic Enablement Graduate Intern

Highmark Health
Remote United States Internship

Company : Highmark Health Job Description : Applicants must be authorized to work in the U.S. independently. At this time, we do not offer visa sponsorship for this role. The Summer 2027…

4h ago Data

Kinyarwanda Language Specialist - AI Trainer

Invisible Technologies
Remote Worldwide Contract $6 – $65 / hour

Are you a Kinyarwanda language expert eager to shape the future of AI? Large-scale language models are evolving from simple chatbots into powerful engines of communication and…

5h ago Data

Data Support

Saisystems Health
Remote United States Temporary

Purpose Support Marketing in cleaning and enriching our customer and prospect records in our CRM, so reporting, lead tracking, and lifecycle stages are accurate. Responsibilities Update a…

5h ago Data

AI Architect

Vcheck
Remote United States Full-time

About Vcheck Vcheck was founded in 2012 on the belief that the investigative rigor of a boutique firm could be brought to scale through technology. Today, we run more than 25,000…

5h ago Data

Senior AI Automation Engineer

Helpware
Remote Argentina, Brazil, Mexico, Poland, Ukraine Full-time

Our client is a US-based company specializing in advanced solutions for health plans. Their platform helps both new and established Medicare and Medicaid programs scale efficiently by…

5h ago Data

Get remote jobs the moment they are posted

Choose your categories and skills. We push matching jobs to your device. No email, ever.