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.

About the Role:

TheData 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 andlightweightapplied data science to enable high-quality data foundations and advanced analytics.

Inthisrole, you will focus on:

•  Enabling external datasourceaccessat scale (e.g.,buildingandhardeningAPIintegrations with external partners likeGoogle 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)inorder toenableexperimentationandmeasurement.

• Contributing to Joint Technical Plans (JTPs) with partners and clients,aligningontechnicalapproaches, deliverables, and milestones that advanceOvative’smeasurement and optimization capabilities.

You will work within a cross-functional team responsible for creating,optimizing, andmaintaininggeneralizable, repeatable, and scalable data solutions. Youwill collaborate closely with business stakeholders and a seasoned team ofreporting analysts,datascientistsand engineers throughout the data lifecycle—from ingestion throughdata modeling andfeature engineering—in order tobuildanalytics-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 contributorona high-performance data engineering, science, and advanced analytics team, owning scoped workstreamsanddeliveringexecutional 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).

• ExpandOvative’suse of partner clean rooms (e.g.Amazon Marketing Cloud, Meta clean rooms):activate,authorandoptimizeSQL queries,designexperimentsand measurement analyses, and operationalizerepeatabletemplates.

• Lead orassistinthe discoveryof advertising data, mapping sources/structures to enable measurement-related reporting, analytics,andmodeling.

• Identifyautomation 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 buildPoCsthatunlock newOvativeofferings.

• Provide technicalassistanceto teammates and help raise the collectiveexpertisein APIs, clean rooms, andanalyticaldata engineering.

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

• Explorenew technologiesand 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.

• Proficiencywith 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 withadvertisingdataplatforms(e.g., Amazon Ads/AMC data exports, Google Ads API, Google Analytics Data API)and/or toolsforconnector 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 scopePoCsand 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.,dbttests, 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 withcode 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 Ovativewon’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!