Analytics Data Engineer
Adelphi Graduate Careers
Summary
As a data engineer, you'll work across a dynamic client roster designing and building data solutions that connect media, site, and marketing performance data into actionable insights. You will partner closely with analytics, strategy, media, and client teams to architect scalable data solutions that answer business questions and support marketing decision-making.
Job description
What You'll Do
- Design data models that integrate media, site, sales and media conversion data to provide a complete view of marketing performance.
- Recommend and implement measurement approaches that support both agency and client objectives.
- Serve as a subject matter expert on media and marketing data architecture.
- Build and maintain integrations across major 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 health of data pipelines: scheduling, monitoring, alerting and failure recovery.
- Apply DataOps best practices maintaining high standards of quality and security across each stage of development.
- Write and optimize SQL views, Python/R scripts, and API connectors as needed.
- Continually optimize data cleaning and anomaly detection processes.
- Help manage and advance our GCP infrastructure, particularly with BigQuery and GCP integrations.
- Maintain rigorous QA practices to ensure clean, reliable, and consistent data.
- Proactively catch and investigate issues, finding root causes and going beyond surface solutions.
- Work with analysts to anticipate needs and ensure data is easy to find and use.
- Communicate effectively with less technical stakeholders to address challenges and keep them updated on progress.
You could be a good fit if
- You take ownership of data quality and availability like it's mission critical.
- You already are, or have the drive to become, an expert in media data.
- You're a problem solver who doesn't stop at "it's broken."
- You balance speed and accuracy, knowing both matter in a client-driven environment.
- You're adaptable, resourceful, and curious.
- You're able to figure things out with limited direction.
Requirements
- Bachelor's degree preferred or equivalent work experience in Computer Science, Data Science, Mathematics/Statistics, Marketing Analytics, or related field
- 2-4 years of experience in data engineering, marketing analytics, media analytics, or related disciplines
- Agency experience strongly preferred
- Expert-level SQL and Python skills
- Experience developing scalable production-grade data pipelines
- Deep experience working with digital media data, including campaign delivery, audience, conversion, and attribution datasets
- Proven experience designing and implementing data solutions that support media planning, optimization, measurement, and reporting
- Strong understanding of digital marketing ecosystems including 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
Benefits
- Salary Range: $85,000 - $95,000 annually
- Minimum 3 days per week in office
Company overview
Adelphi Graduate Careers is the graduate recruitment division of Adelphi Group, a leading global pharmaceutical consultancy and healthcare services organization. Founded in 1986 and part of the Omnicom Corporation since 1998, Adelphi Group provides comprehensive strategic support services across the entire pharmaceutical lifecycle. The company specializes in strategic product development consultancy, health economics and outcomes research, real-world disease understanding, market research, medical communications, and post-marketing brand support services. With a global network of offices across the US, Europe, and Asia employing over 1,000 staff worldwide, Adelphi supports the world's leading pharmaceutical and healthcare organizations to improve patients' lives. The graduate program recruits talented individuals across various disciplines including life sciences, psychology, business studies, and health economics, offering roles in research, health economics, client services, and medical writing. Adelphi has been recognized as the 'Top Pharmaceutical Consultancy in Europe 2025' for its innovation and unique contributions to the life sciences sector.