Analytics Reporting Specialist

(Data & Measurement | Hybrid | Chicagoland candidates only | Reports to VP of Client Solutions | $75,000-$90,000 base) Marcel Digital is an award-winning digital marketing and web development agency established in 2003 and based in Chicago. We partner with mid-market B2B organizations to drive measurable business outcomes through SEO, paid media, web development, and analytics. We’ve built a culture of high performers who value authenticity, integrity, accountability, and curiosity. We invest heavily in learning, collaboration, and craftsmanship, supporting our team with conference attendance, internal training, and daily knowledge sharing. Position Summary As an Analytics Reporting Specialist, you will own Marcel’s client reporting process end to end and turn it into a repeatable production process. This role focuses on reporting production: building a standard report shell for every client, populating it with core data points each cycle, and leaving clear space for channel SMEs to layer on insights and recommendations. You will work closely with Paid Media, SEO, Account Management, Project Management, and the Senior Martech / Technical Implementation Lead and the Measurement & Strategy Lead to ensure that: Every client receives a consistent, accurate report on scheduleCore data is in place before SMEs add their insightsManual reporting effort keeps going down over time, replaced with automated time saving solutions This role is ideal for someone who loves building systems, motivated to meet deadlines, cares deeply about data accuracy, and is excited to use AI and automation to do in hours what used to take days. What We Mean by Reporting Production Report Shells – A standard reporting framework for every client, adapted for lead gen, ecommerce, and channel mixCore Data Population – Pulling and validating the core metrics each reporting cycleSME-Ready Handoff – Reports built with clear space for SEO, Paid Media, and AMs to add insightsAI & Automation – Using AI tools and connectors to speed up production and improve quality This role complements the Senior Martech / Technical Implementation Lead, who owns tracking, implementation, and audits so the data feeding every report is accurate, and the Measurement & Strategy Lead, who owns measurement plans, forecasting, and client strategy. Functions And Responsibilities Reporting Process Ownership Own the reporting process across all clients: schedule, standards, templates, QA, and delivery against strict deadlinesDocument the process so reports are produced the same way every cycle, regardless of who touches themTrack reporting turnaround and hours, and set targets to reduce bothWork with PMs to build reporting into ClickUp sprints and recurring task schedules Report Shells & Templates 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 mixBuild each new client’s report shell during onboardingKeep templates current as platforms, metrics, and client goals change Data Population & QA Populate every report with its core data points each reporting cycleConnect 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 LeadMaintain AEO / AI search reporting using tools such as Peec, Profound, SEMRush SME Handoff & Collaboration Deliver reports to SMEs and AMs with core data complete and space reserved for insightsGather feedback from SMEs and clients to keep improving report usefulnessField reporting requests from Paid Media, SEO, and AMs within agreed turnaround times AI & Automation Find and test ways to use AI to speed up and improve report production, such as automated data pulls, first-pass observations, and anomaly detectionBuild automations that remove manual steps from the monthly refreshShare what works with the wider team and help set standards for AI-assisted reporting Required Skills, Traits, & Abilities 3–5 years of experience in digital or marketing analytics reportingAdvanced Looker Studio (or similar BI tool) skills, including data blending and calculated fieldsStrong working knowledge of GA4 and ad platform reporting (Google Ads, Meta, LinkedIn, Microsoft Ads)Experience building repeatable reporting templates across many clientsProcess-minded: experience documenting and improving a recurring workflowHands-on use of AI tools (Claude, ChatGPT, Gemini, or similar) to speed up workStrong attention to detail and commitment to data accuracyAbility to manage 15+ client reporting schedules at onceClear communication with non-technical stakeholders Strongly Preferred Agency experienceExperience with data connectors such as Supermetrics, Fivetran, or FunnelExperience with automation tools such as Make or ZapierBasic SQL or BigQuery Bonus Skills & Experience Building AI workflows or agents for reportingPython or Apps ScriptAEO / AI search tracking tools (Peec, Profound)Additional BI tools (Power BI, Tableau) Benefits Marcel offers a competitive salary, comprehensive benefits, and a flexible, collaborative work environment. You’ll have meaningful autonomy, influence how analytics is delivered to clients, and help shape the future of Marcel’s analytics practice. Powered by JazzHR EBQUlqCxkd