Analytics Data Engineer

Adelphi Group•Minneapolis, MN

2d•$85,000 - $95,000•Hybrid

About The Position

The Analytics Data Engineer works across a dynamic client roster to design and build data solutions connecting media, site, and marketing performance data to actionable insights. The role partners with analytics, strategy, media, and client teams to architect scalable solutions that answer business questions and support marketing decisions. It calls for a hands-on, solution-oriented engineer with deep technical expertise and a strong understanding of media and digital analytics, who proactively identifies opportunities, solves complex data challenges, and helps shape how data is used across the agency and its clients. The engineer develops media data architecture and models that integrate media, site, sales, and conversion data; builds integrations and scalable measurement frameworks; and automates, monitors, and maintains pipelines. The role also supports GCP infrastructure, particularly BigQuery and GCP integrations, and applies DataOps practices to quality, security, governance, and reliability. It requires ownership of data quality, proactive problem solving, effective communication with technical and nontechnical stakeholders, and the ability to translate business requirements into scalable technical solutions. The role requires 2–4 years of experience in data engineering, marketing analytics, media analytics, or a related discipline. A bachelor’s degree or equivalent related work experience is preferred. The salary range is $85,000–$95,000 annually. Omnicom policy requires employees to work in the office at least three days per week, subject to applicable local law and possible additional in-office days directed by the agency or manager.

Requirements

2–4 years of experience in data engineering, marketing analytics, media analytics, or related disciplines.
Expert-level SQL and Python skills, including experience developing scalable, production-grade data pipelines.
Deep experience with digital media data, including campaign delivery, audience, conversion, and attribution datasets.
Proven experience designing and implementing data solutions for media planning, optimization, measurement, and reporting.
Strong understanding of digital marketing ecosystems, including platforms such as Google Ads, CM360, DV360, The Trade Desk, Meta, LinkedIn, Adobe Analytics, and Google Analytics 4.
Experience integrating multiple data sources, including media, site analytics, offline conversion, and first-party customer data.
Deep experience with BigQuery, GCP, or similar cloud-based data warehouse environments.
Experience evaluating client business requirements and translating them into scalable technical solutions.
Experience building data products, automated reporting frameworks, and measurement solutions for internal and external stakeholders.
Ability to understand the technical and business implications of data solutions.
Ability to recommend approaches rather than simply execute requirements.
Ability to build credibility with clients and internal stakeholders through expertise and thoughtful problem solving.
Demonstrated ownership, initiative, and accountability from project inception through delivery.
Comfort influencing decisions and challenging assumptions when a better solution exists.

Nice To Haves

Bachelor’s degree in a related field such as Computer Science, Data Science, Mathematics/Statistics, or Marketing Analytics, or equivalent work experience.
Agency experience is strongly preferred.
Drive to become, or existing expertise as, a media data expert.

Responsibilities

Partner with analytics and media teams to understand business objectives and translate them into scalable data solutions.
Design data models integrating media, site, sales, and media conversion data to provide a complete view of marketing performance.
Recommend and implement measurement approaches that support agency and client objectives.
Serve as a subject matter expert on media and marketing data architecture.
Build and maintain integrations across advertising, analytics, and marketing technology platforms.
Develop scalable frameworks for campaign performance measurement, attribution, audience analysis, and optimization.
Evaluate emerging platforms, APIs, and data sources to improve agency capabilities and client outcomes.
Automate data pipelines with speed, accuracy, and scalability in mind.
Own day-to-day pipeline health, including scheduling, monitoring, alerting, and failure recovery.
Apply DataOps best practices and maintain high standards of quality and security throughout development.
Write and optimize SQL views, Python/R scripts, and API connectors as needed.
Continuously optimize data cleaning and anomaly detection processes.
Help manage and advance GCP infrastructure, particularly BigQuery and GCP integrations.
Maintain rigorous quality assurance practices to ensure clean, reliable, and consistent data.
Identify opportunities to improve processes and infrastructure.
Proactively investigate issues, identify root causes, and implement solutions beyond surface-level fixes.
Work with analysts to anticipate needs and ensure data is easy to find and use.
Communicate effectively with less technical stakeholders, address challenges, and keep them updated on progress.