Logo for Monks

Senior Data Engineer

Role overview

Qualifications

  • 2+ years of hands-on production experience with dbt Core
  • Proven hands-on experience with Delta Lake, Unity Catalog, and Databricks SQL Warehouses
  • Exceptional skills with CTEs, window functions, and converting custom/legacy Python-based ETL frameworks into dbt SQL models
  • Demonstrated experience in PR-reviewed environments with automated CI/CD testing gates

Responsibilities

  • Reverse-engineer existing Python/Spark ETL logic and author corresponding dbt SQL models
  • Write comprehensive schema.yml tests and lead output-parity validations
  • Ship changes through a Git-based, PR-reviewed workflow utilizing automated CI/CD gates
  • Work natively within Databricks using Delta Lake and Unity Catalog in collaboration with internal client engineers

Key facts

Other skills

  • Problem Solving
  • Collaboration
  • Detail Oriented
  • Adaptability

About the company

Monks logo

Monks

Marketing & Advertising

Monks combines an extraordinary range of global marketing and technology services to accelerate business possibilities and redefine how brands and businesses interact with the world. It delivers unfettered content production, scaled experiences, enterprise-grade technology and data science fueled by AI to help the world’s trailblazing companies outmaneuver and outpace their competition.

Company details

Company typeXLarge
IndustryMarketing & Advertising
Company size5001 - 10000

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

Please note that we will never request payment or bank account information at any stage of the recruitment process. As we continue to grow our teams, we urge you to be cautious of fraudulent job postings or recruitment activities that misuse our company name and information. Please protect your personal information during any recruitment process. While Monks may contact potential candidates via LinkedIn, all applications must be submitted through our official website (monks.com/careers).

Senior Data Engineer (dbt / Databricks Migration)

.Monks Technology Services, part of Media.Monks and S4 Capital, is a global consulting firm mastering AI-powered transformations for the Fortune 100. We combine long-term strategic thinking, deep enterprise experience, and a human-centered approach to help clients transform business processes and dominate their industries.

As part of our commitment to inclusion and in compliance with Law 2466 of 2025 from Colombia, we have available spaces for people with disabilities. 

Fixed-term contract 

 

About the Role 

Monks is seeking a Senior Data Engineer to join a collaborative engineering pod delivering a data platform modernization project, migrating a legacy Python/Spark ETL framework into dbt Core models on Databricks (Delta Lake, Unity Catalog). You will help modernize a large set of production reporting tables that power analytics, product, and BI functions.

In this role, you will work alongside a Lead Data Engineer and an internal client engineer to handle the end-to-end migration of assigned legacy ETL configurations. You will move beyond maintenance to reverse-engineer legacy logic, author maintainable dbt SQL models, enforce strict testing protocols, and validate data output parity in a structured, documentation-first, PR-reviewed environment.

Key Responsibilities

  • ETL Migration & Modeling: Reverse-engineer existing Python/Spark ETL logic and author corresponding dbt SQL models, staging layers, and foundational shared macros for dimension and domain models.

  • Quality Assurance & Testing: Write comprehensive schema.yml tests (not_nulluniquerelationships) and lead output-parity validations to guarantee newly built models produce output consistent with legacy production pipelines before go-live.

  • CI/CD & Delivery: Ship changes through a Git-based, PR-reviewed workflow utilizing automated CI/CD gates (dbt compile + dbt test on every PR).

  • Platform Collaboration: Work natively within Databricks using Delta Lake, Unity Catalog, and Databricks SQL Warehouses in close alignment with internal client engineers.

  • Cross-Functional Partnership: Operate as an embedded partner within a collaborative engineering pod, ensuring seamless integration, knowledge sharing, and adherence to modern data engineering best practices.

About You

Competencies

  • Ownership & Attention to Detail: Rigorous about output parity and data quality, taking full responsibility for models from legacy conversion through production release.

  • Collaborative Mindset: Thrives in an embedded, partnership-driven engagement alongside client engineers rather than traditional handoff setups.

  • Engineering Discipline: Strong commitment to software engineering best practices, documentation-first development, and automated testing workflows.

  • Problem-Solving & Adaptability: Skillful at untangling fragile, hardcoded SQL/Python logic and refactoring it into modular, maintainable architectures.

Qualifications & Skills

  • dbt Core Expertise: 2+ years of hands-on production experience. Comfortable with Jinja macros, sources.ymlschema.yml tests, and incremental model patterns (dbt Certified Developer preferred).

  • Databricks Ecosystem: Proven hands-on experience with Delta Lake, Unity Catalog, and Databricks SQL Warehouses. Exposure to Databricks Workflows for scheduled runs is a plus.

  • Advanced SQL & Legacy Migration: Exceptional skills with CTEs, window functions, and converting custom/legacy Python-based ETL frameworks into modular, source-agnostic dbt SQL models.

  • Git & CI/CD Workflows: Demonstrated experience working in PR-reviewed environments with automated CI/CD testing gates (e.g., GitHub Actions).

  • Validation & Domain Experience (Nice to Have): Experience validating output parity against production data. Familiarity with third-party connectors (e.g., Fivetran), media/e-commerce analytics, or async-first remote delivery is a plus.

.Monks Technology Services does not discriminate on the basis of race, sex, color, religion, age, national origin, marital status, disability, veteran status, genetic information, sexual orientation, gender identity or any other reason prohibited by law in provision of employment.

 

#LI-Remote 

#LI-ES1

About Monks 

Monks is the global, digital-first, data-driven, unitary operating brand of S4 Capital plc. With a legacy of innovation and specialized expertise, Monks combines an extraordinary range of global Marketing and Technology Services to redefine how brands interact with the world. Through Monks.Flow, its flagship AI ecosystem for marketing orchestration, Monks transforms marketing into a growth engine, collapsing timelines and connecting brands to culture in real time. By deploying bespoke intelligent agents across disciplines and delivering culturally relevant, high-impact creative and digital solutions, Monks solves key critical business challenges across the entire brand enterprise to help brands sustain long-term impact.

 

Monks was named a Contender in The Forrester Wave™: Global Marketing Services, ranks among Cannes Lions' Top 10 Creative Companies (2022-25) and remains the only partner featured in AdExchanger’s Programmatic Power Players list every year (2020-24). Named Adweek’s first AI Agency of the Year (2023) and The One Show’s inaugural AI Pioneer Organization, Monks was also awarded Business Intelligence Group’s 2025 Excellence in Artificial Intelligence Award in both the Organizational and AI Product categories. As a trusted partner to cutting-edge innovators in tech, Monks earned titles such as Optimizely Experimentation Partner of the Year (2025), runner-up for the Adobe Firefly Partner Award (2024), and Workato’s AI Visionary Customer Impact Award (2024). Additionally, Monks achieved a record-breaking number of FWAs and continues to hold the most of any partner.

 

We are an equal-opportunity employer committed to building a respectful and empowering work environment for all people to freely express themselves amongst colleagues who embrace diversity in all respects. Including fresh voices and unique points of view in all aspects of our business not only creates an environment where we can all grow and thrive but also increases our potential to produce work that better represents—and resonates with—the world around us. 

Apply once. Then go straight to the hiring manager.

After you apply, unlock the direct contact details of the people who actually make the call. A quick follow-up makes you 5x more likely to land an interview.

MR

Marcus Rivera

Chief Revenue Officer

m.rivera@company.com
linkedin.com/in/marcusrivera
Unlocked after you apply
·

Data Engineer Related jobs

Other jobs at Monks

Premium

Reach out to the hiring manager directly.

Gain access to the contact details of the hiring managers who actually decide, and reach out to network with them directly. That, plus more when you upgrade:

  • Full match report with fit score and gaps
  • Career diagnostics on how recruiters read you
  • Curated company matches and warm intros
  • 48h early access to new roles

Cancel anytime.