Lead Data Engineer

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).Lead Data Engineer (dbt / Databricks Migration) Location: [Fully remote] - Fixed term Contract .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. About the Role As a Lead Data Engineer, you’ll lead a collaborative engineering pod delivering a large-scale data platform modernization initiative. You will guide the migration of a legacy Python/Spark ETL framework into dbt Core models on Databricks, modernizing production reporting tables that support analytics, product, and business intelligence functions. You will provide hands-on technical leadership while partnering closely with internal client engineers. This includes reverse-engineering existing ETL logic, designing scalable dbt models and staging layers, establishing testing and validation practices, and shipping changes through a CI-gated pull request workflow. You will lead the team in a structured, documentation-first, and highly collaborative environment. Responsibilities Lead the end-to-end migration of legacy Python/Spark ETL configurations into modular, maintainable dbt Core models Provide hands-on technical leadership, mentorship, code review, and delivery guidance to data engineers Partner with internal client engineers to define migration priorities, technical standards, and implementation plans Reverse-engineer existing Python ETL logic and translate it into scalable dbt SQL models, staging layers, and reusable Jinja macros Design foundational shared macros, dimension tables, and medium-to-high-complexity domain models Implement dbt sources, incremental model patterns, and schema.yml tests, including not_null, unique, and relationships Validate output parity between newly developed dbt models and legacy production pipelines before go-live Establish and uphold engineering standards for model design, documentation, testing, and maintainability Manage delivery through a Git-based, PR-reviewed workflow with automated dbt compile and dbt test CI/CD gates Identify migration risks, resolve technical blockers, and communicate progress and tradeoffs to engineering stakeholders Support scheduled dbt orchestration and production deployment within the Databricks ecosystem Collaborate effectively across distributed teams and time zones Other duties as assigned About You Qualifications & Skills 5+ years of production experience with dbt Core; dbt Certified Developer certification preferred Hands-on experience leading data engineering teams, mentoring engineers, reviewing code, and owning technical delivery Advanced knowledge of dbt, including Jinja macros, sources.yml, schema.yml tests, reusable model patterns, and incremental models Hands-on experience with Databricks, Delta Lake, Unity Catalog, and Databricks SQL Warehouses Advanced SQL skills, including CTEs, window functions, complex transformations, and Jinja templating Experience migrating custom or legacy Python-based ETL pipelines into modular, source-agnostic dbt models Experience validating output parity between modernized models and legacy production pipelines Proficiency with Git-based pull request workflows and CI/CD gates, such as GitHub Actions running dbt compile and dbt test Strong technical leadership, stakeholder communication, problem-solving, and documentation skills Experience with third-party connectors such as Fivetran or data sourced from externally managed lakehouses is a plus Familiarity with media, e-commerce, or consumer analytics domains is a plus Experience working asynchronously across distributed time zones is a plus Exposure to Databricks Workflows for orchestrating scheduled dbt runs 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 #LI-Remote #LI-BC1About 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 t‌i‌t‌l‌es 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.