Analytics Reporting Specialist

Marcel Digital•Chicago, IL

23h•$75,000 - $90,000•Hybrid

About The Position

Marcel Digital, an award-winning digital marketing and web development agency established in 2003, is seeking an Analytics Reporting Specialist. This role focuses on owning and optimizing the client reporting process end-to-end, transforming it into a repeatable production process. The specialist will build standard report shells, populate them with core data, and ensure timely delivery for channel SMEs to add insights. This position is ideal for someone who excels at building systems, is deadline-driven, prioritizes data accuracy, and is eager to leverage AI and automation to enhance efficiency. The role complements the Senior Martech / Technical Implementation Lead (who handles tracking and audits) and the Measurement & Strategy Lead (who manages measurement plans and client strategy).

Requirements

3–5 years of experience in digital or marketing analytics reporting
Advanced Looker Studio (or similar BI tool) skills, including data blending and calculated fields
Strong working knowledge of GA4 and ad platform reporting (Google Ads, Meta, LinkedIn, Microsoft Ads)
Experience building repeatable reporting templates across many clients
Process-minded: experience documenting and improving a recurring workflow
Hands-on use of AI tools (Claude, ChatGPT, Gemini, or similar) to speed up work
Strong attention to detail and commitment to data accuracy
Ability to manage 15+ client reporting schedules at once
Clear communication with non-technical stakeholders

Nice To Haves

Agency experience
Experience with data connectors such as Supermetrics, Fivetran, or Funnel
Experience with automation tools such as Make or Zapier
Basic SQL or BigQuery
Building AI workflows or agents for reporting
Python or Apps Script
AEO / AI search tracking tools (Peec, Profound)
Additional BI tools (Power BI, Tableau)

Responsibilities

Own the reporting process across all clients: schedule, standards, templates, QA, and delivery against strict deadlines.
Document the process so reports are produced the same way every cycle, regardless of who touches them.
Track reporting turnaround and hours, and set targets to reduce both.
Work with PMs to build reporting into ClickUp sprints and recurring task schedules.
Create and maintain a standard report shell for every client in Looker Studio (and similar tools).
Define the core data points each report includes, by client type and channel mix.
Build each new client’s report shell during onboarding.
Keep templates current as platforms, metrics, and client goals change.
Populate every report with its core data points each reporting cycle.
Connect and maintain data sources (GA4, ad platforms, Search Console, CRMs, Supermetrics or similar).
QA data for accuracy and flag anomalies or tracking issues to the Implementation Lead.
Maintain AEO / AI search reporting using tools such as Peec, Profound, SEMRush.
Deliver reports to SMEs and AMs with core data complete and space reserved for insights.
Gather feedback from SMEs and clients to keep improving report usefulness.
Field reporting requests from Paid Media, SEO, and AMs within agreed turnaround times.
Find and test ways to use AI to speed up and improve report production, such as automated data pulls, first-pass observations, and anomaly detection.
Build automations that remove manual steps from the monthly refresh.
Share what works with the wider team and help set standards for AI-assisted reporting.