Data Engineer - Marketing Science and Offerings

About Ovative Group:

Ovative Group is an independent, full-funnel media, measurement, and creative firm. Leveraging our deep industry expertise, we help brands like Best Buy, Domino's, American Eagle, The Home Depot, Post, Disney, Tumi, Michael Kors, Boost Mobile, and UnitedHealth Group transform their media and measurement programs. The result? Profitable growth that speaks for itself.

At Ovative, we don't just track data, we redefine success. How do we do it? Our proprietary MarTech platform, EMRge helps businesses transform marketing into a driver of sustainable growth. Powered by Enterprise Marketing Return (EMR), our differentiated approach to holistic media buying, planning, and measurement, EMRge is the first MarTech platform to measure businesses holistically. We're all about raising the bar every day, and it shows. Our work has been recognized by organizations like Digiday, Google, Inc. 5000, USA Today, and Search Engine Land.

About the Role: 

The Data Engineer role on the Marketing Science and Offerings (MSO) Team is an opportunity to take your next career step at a fast-growing company with the highest standards for talent, fun, and client success. The MSO team supports direct consultative work for clients and acts as the internal proving ground for pre-product ideas. 

This role blends hands-on data engineering and lightweight applied data science to enable high-quality data foundations and advanced analytics.  

In this role, you will focus on: 

•  Enabling external data source access at scale (e.g., building and hardening API integrations with external partners like Google and Amazon) to power analytics, modeling, and reporting. 

• Expanding learning and usage of partner clean rooms (e.g., Amazon Marketing Cloud and Meta clean rooms) in order to enable experimentation and measurement. 

• Contributing to Joint Technical Plans (JTPs) with partners and clients, aligning on technical approaches, deliverables, and milestones that advance Ovative’s measurement and optimization capabilities. 

You will work within a cross-functional team responsible for creating, optimizing, and maintaining generalizable, repeatable, and scalable data solutions. You will collaborate closely with business stakeholders and a seasoned team of reporting analysts, data scientists and engineers throughout the data lifecycle—from ingestion through data modeling and feature engineering—in order to build analytics-ready data sets. The team navigates ambiguity, asks lots of questions, learns, and executes quickly in a supportive, collaborative environment. 

Responsibilities of a Data Engineer - Marketing Science and Offerings:

• Serve as a technical contributor on a high-performance data engineering, science, and advanced analytics team, owning scoped workstreams and delivering executional excellence. 

• Design, build, test, and deploy reliable data pipelines integrating external sources, with emphasis on APIs (e.g., authentication, pagination, rate-limit handling, backfills, schema evolution, and monitoring/alerting). 

• Expand Ovative’s use of partner clean rooms (e.g. Amazon Marketing Cloud, Meta clean rooms): activate, author and optimize SQL queries, design experiments and measurement analyses, and operationalize repeatable templates. 

• Lead or assist in the discovery of advertising data, mapping sources/structures to enable measurement-related reporting, analytics, and modeling. 

• Identify automation opportunities across ingestion, transformations (e.g., dbt), QA, and delivery to improve reliability, speed, and cost efficiency. 

• Contribute to Joint Technical Plans (JTPs) with partners and clients: define technical approaches, sequence milestones, document assumptions/risks, and build PoCs that unlock new Ovative offerings. 

• Provide technical assistance to teammates and help raise the collective expertise in APIs, clean rooms, and analytical data engineering. 

• Follow software, security, and product engineering best practices: version control, CI/CD, code reviews, reproducibility, documentation, and testing. 

• Explore new technologies and tools—aligned with security, enterprise architecture, and data platform guidance—to enhance marketing data solutions. 

Requirements: 

• 3+ years of relevant data engineering development experience, ideally in analytics- or modeling-heavy environments. 

• Proficiency with ETL/ELT for large data sets and building resilient API integrations. 

• Strong SQL and Python skills; comfort with command line and working in modern data stack workflows. 

Preferred: 

• Experience with cloud-based platforms (e.g., GCP, AWS, or Azure); data warehouses and big data tools (e.g., BigQuery, Databricks); and pipeline/orchestration tools (e.g., dbt, Dagster, or Airflow).  

• Hands-on experience with advertising data platforms (e.g., Amazon Ads/AMC data exports, Google Ads API, Google Analytics Data API) and/or tools for connector management. 

• Practical experience using partner clean rooms—especially Amazon Marketing Cloud and Meta clean rooms—including SQL development, privacy-safe joins, experiment design, audience/overlap analysis, and templating/automation. 

• Experience contributing to Joint Technical Plans (JTPs) or similar partner/client technical roadmaps, with an ability to scope PoCs and scale pilots into production solutions. 

• Experience creating data/table architectures for analytics and modeling (dimensional designs, feature stores, slowly changing dimensions, partitioning/clustering). 

• Experience implementing QA processes and automation (e.g., dbt tests, Great Expectations, anomaly detection/monitoring). 

• Familiarity integrating data models within software products and measurement platforms; understanding of marketing, analytics, and customer data domains. 

• Familiarity with agile tooling and collaboration (JIRA, Confluence) and with code versioning (GitHub). 

Benefits of Working at Ovative Group: 

We provide strong, competitive, holistic benefits that understand the importance of your life inside and out of work.  

Culture:  

Culture matters and we’ve been recognized as a Top Workplace for ten years running because of it. We demand trust and transparency from each other. We believe in doing the hard and complicated work others put off. We’re open in communication and floor plan. We’re flat – our interns sit next to VPs, our analysts work closely with senior leaders, and our CEO interacts with every single person daily. Put together, these elements help foster an environment where smart people can support each other in performing to their highest potential.  

Ovative is committed to fostering an inclusive environment where everyone can participate and thrive. We do not tolerate discrimination of any kind, including on the basis of race, sexual orientation, gender identity, or gender expression. Our policies reflect this commitment—for example, our medical leave benefits are inclusive of same-sex partners, ensuring equitable care and support for all families. 

Compensation and Insurance:  

We strive to hire and retain the best talent. Paying fair, competitive compensation, with a large bonus incentive, and phenomenal health insurance is an important part of this mix.  

We’re rewarded fairly and when the company performs well, we all benefit.  

Tangible amenities we enjoy:  

• Access to all office spaces in MSP, NYC, and CHI  

• Frequent, paid travel to our Minneapolis headquarters for company events, team events, and in-person collaboration with teams

• Flexible paid vacation policy  

• 401k match program  

• Top-notch health insurance options, inclusive of same sex partners 

• Family formation benefits including reimbursement options for fertility, pregnancy, and parenting needs 

• Monthly stipend for your mobile phone and data plan  

• Sabbatical program  

• Charitable giving via our time and a financial match program  

• Shenanigan’s Day  

Working at Ovative won’t be easy, but if you like getting your hands dirty, driving results, and being surrounded by the best talent, it’ll be the most rewarding job you’ll ever have. If you think you can make us better, we want to hear from you!