Time since we first saw it
Day 13
Similar jobs usually come down between day 6 and day 47.
From 1,405 similar postings that came down. Coming down is not always a hire.
Senior Data Engineer
Reads like an Analytics Engineer role: dbt models and clean tables.
Location not stated
Actively hiring, first seen by us 13 days ago- Pay
- Pay not listed
- Work setting
- Not stated
- Employment
Full-time — employment source
Employment type in the employer’s posting: Full-Time
From the employer’s posting
What you’ll work on
Full postingWe'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.
You will work alongside the lead data architect and own a defined set of models end to end.
Build and own dbt staging, intermediate, core, and mart models from ticket to production, following the project's naming, routing, and test conventions.
Work directly with marketing, operations, and finance subject matter experts to confirm definitions, then get sign-off before a model is promoted.
From the employer’s posting
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.
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
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.
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.
What you’ll bring
All qualificationsCore experience
- 5+ years in data or analytics engineering, with at least 3 years building production dbt projects on Snowflake.
- 5000-recognized firm with 60+ completed client engagements.
- Experience handling PII and consent data with an append-only, auditable design.
Qualification wording
5+ years in data or analytics engineering, with at least 3 years building production dbt projects on Snowflake.
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.
Experience handling PII and consent data with an append-only, auditable design.
Posting record
Report an errorActively hiringFirst seen by us 13 days ago, still listed, and not a repost of an earlier posting.
- Status in our records
- Live
- First seen by us
- Oct 22, 202613 days ago
- Recorded sightings
- 17
- Last seen by us
- Nov 4, 2026
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
How this job compares
Sonatafy Technology is hiring
2 open jobs
Open jobs by the week we first saw them, last 12 weeks.
Hiring recordSee how this role fits your experience
Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
- SQL
- AWS
- dbt
- Power BI
- Snowflake
- Terraform
Where the posting names them
- 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.
- 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.
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.
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.
- 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.
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.
- 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.
- 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.
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.
- 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.
- 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.
- Consent and data deletion workflows across marketing and CRM tools. - Terraform or schema changes for Snowflake objects. Why Work with Sonatafy?
Your next step
Complete your application on sonatafytechnology.bamboohr.com. The employer’s form will show what is required.
Applying through BambooHR
- No account needed. The form takes images too, but an image of a resume has no text for anyone to search: upload a PDF or Word file.
Already applied? Track this application
Has Sonatafy Technology posted this job before?
Yes. We’ve followed one other Senior Data Engineer job there since June 2026. It came down after 15 days.
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!
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 careers@sonatafy.com.
Source details
Source notes
Source excerptsSelected passages from the saved posting. Check the full description for conditions and exceptions.
- Pay
No pay amount identified in the saved description.
- Location & working pattern
Location not supplied.
Working pattern and location restrictions need checking in the full posting.
- Work authorization
No clear work-authorization passage found. Eligibility is unconfirmed.