Analytics Data Engineer
Minneapolis, MN - USA
Job Summary
Agency:
Carmichael LynchJob Function:
Data and AnalyticsJob Subfunction:
Data EngineeringJob Description:
Role:
As a data engineer youll 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.
This role requires a hands-on solution-oriented engineer who combines deep technical expertise with a strong understanding of media and digital analytics. The ideal candidate proactively identifies opportunities solves complex data challenges and helps shape how data is leveraged across the agency and our clients.
What Youll Do
Design data solutions that solve client business needs
o Partner with analytics and media teams to understand business objectives and translate them into scalable data solutions.
o Design data models that integrate media site sales and media conversion data to provide a complete view of marketing performance.
o Recommend and implement measurement approaches that support both agency and client objectives.
o Serve as a subject matter expert on media and marketing data architecture.
Lead media data engineering initiatives
o Build and maintain integrations across major advertising analytics and marketing technology platforms.
o Develop scalable frameworks for campaign performance measurement attribution audience analysis and optimization.
o Evaluate emerging platforms APIs and data sources to improve agency capabilities and client outcomes.
Build and maintain data pipelines
oAutomate data pipelines with speed accuracy and scalability in mind.
oOwn day-to-day health of data pipelines: scheduling monitoring alerting and failure recovery
oApply DataOps best practices maintaining high stands of quality and security across each stage of development
oWrite and optimize SQL views Python/R scripts and API connectors as needed.
oContinually optimize data cleaning and anomaly detection processes.
oHelp manage and advance our GCP infrastructure particularly with BigQuery and GCP integrations.
Own data quality and governance
oMaintain rigorous QA practices to ensure clean reliable and consistent data.
oContinuously seek opportunities to improve processes and infrastructure.
Problem solves relentlessly
oProactively catch and investigate issues finding root causes and going beyond surface solutions.
oWork with analysts to anticipate needs and ensure data is easy to find and use.
oDemonstrate situational awareness knowing when to escalate push or pull back or execute.
oCommunicate 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 its mission critical.
- You already are or have the drive to become an expert in media data.
- Youre a problem solver who doesnt stop at its broken. You figure out why and how to fix it.
- You balance speed and accuracy knowing both matter in a client-driven environment.
- Youre adaptable resourceful and curious. Youre able to figure things out with limited direction. Learning new things and finding creative solutions are some of your favorite parts of your job.
Requirements
Education:
- A bachelors degree preferred or equivalent work experience in related field such as Computer Science Data Science Mathematics/Statistics Marketing Analytics etc.
Skills and Experience:
- 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 with 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 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.
Competencies (characteristics and work style)
- Understands both the technical and business implications of data solutions.
- Able to recommend approaches rather than simply execute requirements.
- Builds credibility with clients and internal stakeholders through expertise and thoughtful problem solving.
- Demonstrates ownership initiative and accountability from project inception through delivery.
- Comfortable influencing decisions and challenging assumptions when a better solution exists.
The salary range for this position is listed below. Where an employee or prospective employee is paid within this range will depend on a variety of factors including but not limited to budget relevant experience qualifications and tenure in similar roles. Consideration may also be given to internal salary data for current or former employees in the same or similar positions.
Salary Range: $85000 - 95000 annually
To the extent permissible by local law Omnicoms policy requires employees to work in the office for a minimum of three days a week unless additional in-office days are directed by their agency or manager.
Omnicom is committed to hiring and developing exceptional talent. We agree that talent is uniquely distributed and were focused on developing inclusive teams that can bring the best solutions to everything we do. We strongly believe that celebrating what makes us different makes us better together. Join uswe look forward to getting to know you. We will process your personal data in accordance with our Recruitment Privacy Notice.
Link to Recruitment Privacy Notice: US Job Seekers:
It is the policy of Omnicom and any of its affiliates to provide equal employment opportunities to all employees and applicants for employment without regard to race religion color ethnic origin gender gender identity age marital status veteran status sexual orientation disability or any other basis prohibited by applicable federal state or local law. EOE/AA/M/D/V/F.
Required Experience:
IC
About Company
At Carmichael Lynch we come together with the best people from every discipline to make the very best brand-building, culture-bending, business-altering work with our partners.