Sr Data Engineer
Sonatafy Technology | Nearshore Software Development
Senior Analytics Engineer
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 View email address on click.appcast.io.
$116k - $209k
...other. Ready to join a mission that matters? The future of cybersecurity starts with you. About the Role: As a Sr. Data Infrastructure Engineer, you will be a key member of the Data Platform Operations team, responsible for building out the AWS GovCloud environment...SeniorPermanent employmentWork experience placementWork at officeLocal areaRemote work$60 - $65 per hour
...USC or GC ONLY HYBRID WORK SETUP Job Summary: · Lead end-to-end design and delivery of scalable data engineering solutions using Snowflake, dbt and Python, ensuring high-performance data pipelines and robust data warehousing practices. · Drive data modeling...SeniorContract work- ...Job Description: Sr. Data Engineer – Data Ingestion Framework Python, DBT, and orchestration technologies such as Dagster or Control-M. The solution will utilize AWS S3 as the data Lakehouse storage layer and Snowflake as the target data platform. Experience:...SeniorContract workLocal areaRemote work
- ...Position Overview We are seeking a Data Engineer to provide data engineering, advanced analytics, and visualization support to senior DoD stakeholders. This individual will work with complex datasets, develop analytical solutions and dashboards, and translate technical...Senior
$136k - $245k
...a mission that matters? The future of cybersecurity starts with you. About the Role: We're seeking an experienced Sr. Platform Data Engineer to architect, deploy, and operate the core data infrastructure and platform services underpinning CrowdStrike's analytics...SeniorPermanent employmentWork experience placementWork at officeLocal areaRemote work- ...Role: Sr. Data Engineer Location: Seattle, WA (Remote is okay, but as per the client's policy, a monthly office visit is mandatory) Type: Contract to Hire Key Skills: AWS, MDM, Python, SQL, Reltio (not mandatory but it should be good to have) Responsibilities...SeniorContract workWork experience placementWork at officeRemote work
- ...Glue, EMR (PySpark), and Lambda functions Implement real-time data streaming solutions using Confluent Kafka with source and sink... ...Qualifications Bachelor's degree in Computer Science, Data Engineering, Information Technology, or related field Strong understanding...SeniorContract workRemote workShift work
- Job Title As an Engineer on the full stack team, you will be dedicated to help design, implement, and maintain a modern, robust, and scalable platform which will enable the Operational Risk team to meet the increasing demands from the various trading desks.Senior
- ...Strong understanding of system design principle and data storage structures, ideally in a cloud-based environment (Azure, SnowPro... ...certifications in: Microsoft Certified: (or equivalent cloud) Azure Data Engineer Microsoft Certified: Azure Fundamentals Snowflake...Senior
- ...We are looking for a skilled Data Engineer to design, build, and maintain our enterprise Data Warehouse (DWH) and analytics ecosystem — with a growing focus on enabling AI-driven insights, automation, and enterprise-grade AI usage. In this role, you will architect scalable...Senior
- ...Job Title: Senior Data Engineer (Databricks) Primary Location: Chicago, IL (Hybrid – 3 days onsite / 2 days remote) Position Type: Full-Time, Direct Hire Must Be Citizen or Green Card OVERVIEW A Senior Data Engineer. This is a full-time, direct hire...SeniorFull timeRemote work3 days per week
- ...Contract positions for a major investment firm. Hybrid work environment in Newark, NJ. Data Engineer (AWS) Job Summary: We are seeking a talented AWS Data Engineer to join our dynamic Data Engineering team. The ideal candidate will be responsible for designing...SeniorContract work
- ...POsition : Data Engineer Location : Minnetonka, MN AND Raleigh, NC Duration : 6 Months to hire Experience and Required qualifications: To be considered for this position, applicants need to meet the qualifications listed in this posting....Senior
$110k - $150k
...Sr. Data Engineer Onsite: Hampton Roads, VA Blu Omega is seeking a Sr. Data Engineer to support the Navy enterprise data initiatives. This role is responsible for designing, developing, and maintaining scalable data solutions within complex enterprise environments...Senior- ...Senior Data Engineer Experience developing, debugging, and maintaining code in Spark, Databricks, Python Deep knowledge in SQL Server databases, Azure data technologies Proficiency in NoSQL (Cosmos DB) is preferred Experience in cloud services (Azure) is preferred...SeniorTemporary workWork experience placementRelocation
- ...Sr. Data Engineer Location: Remote Project Duration: Long Term Contract Job Description: Minimum 8+ years of experience with a bachelor's degree in computer science or equivalent. Skills: Databricks, Azure Data Factory, Databricks workflows, PySpark...SeniorLong term contractRemote work
- ...Job Title Data Solution Consultant Responsibilities Data Solution Consulting & Delivery Participate in the agile planning process by understanding data consumers’ needs and technical aspects (not just an order taker, must be proactive and think critically...SeniorContract work
- ...Job Title: Sr. Data Engineer Location: Chicago, IL (Onsite) Must-Have Qualifications: ~8+ years proven experience building and maintaining ETL pipelines in production environments. ~ Proficiency in Python and SQL for data transformation and scripting....Senior
$141.8k - $173.3k
...time off + donation match IMPACT YOU'LL MAKE Senior Data Engineer is responsible for writing data workflows according to design specifications... ...data engineers, business analysts, and systems analysts, the Sr Data Engineer builds and supports enterprise-class data...SeniorWork experience placementRemote work- ...Sr. Data Engineer Location: Plano, TX OR Atlanta, GA (Onsite from Day 1 & F2F Required) Type: Long Term Job Description: ~5+ years of software/data engineering experience using Java, Scala, and/or Python, with at least 3 years’ experience in a data and BI...Senior
- ...Job DescriptionJob DescriptionSr. Data Analytics Engineer Full Time Westchester County, NY - Hybrid This role is a highly technical, business-facing... ...analyses, dashboards, and data-driven recommendations. The Sr. Data Analytics Engineer operates with a high degree of...SeniorFull time
$104.61k - $161.9k
...hiring and supporting active-duty and veteran employees. Responsibilities Position Summary We are seeking a Senior Data Engineer to implement and operate reliable, secure, and scalable data solutions supporting GSA applications, integrations, migration, and...SeniorFull timeFor contractors- ...Sr. Data Engineer An established organization is seeking a skilled professional to design and implement high-performance, production-grade data pipelines. This role supports a newly formed engineering team tasked with building scalable architectures to integrate key...Senior
- ...The Data Engineer is responsible for building, and operating scalable, secure, and high-performance data platforms that enable analytics, reporting... ...and business teams in Agile environments. Title: Sr. Data Engineer Location: Woburn, MA - ONSITE 5 days a...SeniorContract work
$120k - $160k
...fulfill the position’s purpose. If possible, please include the percentage of time spent on each key responsibility. Advanced Data Engineering and Solution Design (80%) Architect and implement scalable data pipelines to process and integrate structured and...SeniorContract work- ...Hi Professionals, Hope you are doing good, Please find the below JD and let me know your thoughts, Job Title : Sr. Data Engineer (SSIS & Power BI) Location : Remote till march 2022 Duration : 6 Months C2H W2 ONLY Day to Day Responsibilities...SeniorRemote work
- ...Sr. Data Engineer (Minimum 8 years of experience) Client: Ford Bill Rate: $75/hr on C2C Pay Rate : $65/Hour on C2C & 58/Hour on W2 Remote, US Job Description: Data Engineer Function: Data & Analytics | GCP...SeniorContract workRemote work
- ...available if requested for a F2F interview Duration: 12+ month contract Rate: $70 an hour C2C Title: Sr. Data Engineer Requirements: Snowflake, SQL, IICS/PowerCenter, ETL Position Description EOHHS is seeking to hire an...SeniorContract workLive in
- ...team that sets the standard rather than follows it, Oteemo is where you belong. Job Description We're looking for a Senior Data Engineer to design and implement AI features end to end - from data pipelines through GenAI and agentic workflows to production...SeniorRemote work
- ...Sr Data Engineer Client is in- Charlotte, NC This is now a hybrid role, onsite 3 days/week in Charlotte, long term contract Must have good communication skills Snowflake, dbt, Fivetran (must-have), Python, Advanced SQL, Azure Data Factory, Azure Synapse...SeniorLong term contract3 days per week
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Sr Data Engineer. Be the first to apply!
- junior data engineer remote United States
- bi data engineer United States
- data platform engineer United States
- principal data engineer United States
- data engineer analytics United States
- data science developer United States
- data integration engineer United States
- data engineer manager United States
- big data developer United States
- data engineer freelance United States





