Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

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.

Vacancy posted 2 days ago
Similar jobs that could be interesting for youBased on the Sr Data Engineer in United States vacancy
  • $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... 
    Senior
    Permanent employment
    Work experience placement
    Work at office
    Local area
    Remote work
    Remote
    13 days ago
  • $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... 
    Senior
    Contract work

    Long Finch Technologies

    Denver, CO
    a month ago
  •  ...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:... 
    Senior
    Contract work
    Local area
    Remote work

    Long Finch Technologies

    Boston, MA
    3 days ago
  •  ...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

    Centurion

    Alexandria, VA
    15 days ago
  • $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... 
    Senior
    Permanent employment
    Work experience placement
    Work at office
    Local area
    Remote work
    Remote
    a month ago
  •  ...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... 
    Senior
    Contract work
    Work experience placement
    Work at office
    Remote work

    Canvendor

    Seattle, WA
    8 days ago
  •  ...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... 
    Senior
    Contract work
    Remote work
    Shift work

    US Tech Solutions

    Charlotte, NC
    15 days ago
  • 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

    Samprasoft

    Charlotte, NC
    2 days ago
  •  ...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

    Saxon Global

    Hopkins, MN
    1 day ago
  •  ...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

    Tenth Revolution Group

    Commack, NY
    4 days ago
  •  ...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... 
    Senior
    Full time
    Remote work
    3 days per week

    BinaryBees Business Solutions LLC

    Chicago, IL
    22 hours ago
  •  ...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... 
    Senior
    Contract work

    JSR Tech Consulting

    Newark, NJ
    7 days ago
  •  ...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

    3B Staffing LLC

    Hopkins, MN
    4 days ago
  • $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

    Blu Omega

    Suffolk, VA
    1 day ago
  •  ...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... 
    Senior
    Temporary work
    Work experience placement
    Relocation

    Software Technology Inc

    Kansas City, MO
    1 day ago
  •  ...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... 
    Senior
    Long term contract
    Remote work

    Highbrow Technology Inc

    United States
    2 days ago
  •  ...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... 
    Senior
    Contract work

    Software Technology Inc

    Richmond, VA
    1 day ago
  •  ...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

    Jobs via Dice

    Chicago, IL
    2 days ago
  • $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... 
    Senior
    Work experience placement
    Remote work

    Boeing Employees Credit Union

    Virginia, IL
    22 hours ago
  •  ...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

    Yochana

    Atlanta, GA
    3 days ago
  •  ...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... 
    Senior
    Full time

    PRI Technology

    Rye, NY
    22 hours ago
  • $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... 
    Senior
    Full time
    For contractors

    Empower AI Inc.

    Remote
    1 day ago
  •  ...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

    Apex Systems

    Chicago, IL
    4 days ago
  •  ...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... 
    Senior
    Contract work

    3B Staffing LLC

    Boston, MA
    1 day ago
  • $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... 
    Senior
    Contract work

    ProArch

    Remote
    7 days ago
  •  ...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... 
    Senior
    Remote work

    Navtech

    Lake County, FL
    1 day ago
  •  ...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... 
    Senior
    Contract work
    Remote work

    Futran Tech Solutions Pvt. Ltd.

    United States
    22 hours ago
  •  ...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... 
    Senior
    Contract work
    Live in

    3B Staffing LLC

    Boston, MA
    1 day ago
  •  ...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... 
    Senior
    Remote work

    Oteemo Inc

    United States
    1 day ago
  •  ...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... 
    Senior
    Long term contract
    3 days per week

    3B Staffing LLC

    Charlotte, NC
    4 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Sr Data Engineer. Be the first to apply!