FREELANCE Digital Marketing Analytics Coordinator

Freelance Digital Marketing Analytics Coordinator

VISION

Schaefer Advertising Co. is seeking a data-driven Marketing Analytics Coordinator to join our team.  As part of the Digital team, this person will work under the Digital Marketing Associate Director and in collaboration with the full digital team to bring client reports to life across Schaefer’s three key verticals— Healthcare, Real Estate, and Attractions, Tourism & The Arts.

The Digital Marketing Analytics Coordinator is responsible for managing key aspects of Schaefer’s analytics process, including monthly reporting calendar management, data aggregation, dashboard development, and report visualization. This role requires close collaboration with the media and CRM teams to ensure all campaign data is accurately collected and reported within the designated timeframe. The ideal candidate must be highly detail-oriented and possess a strong sense of urgency to meet reporting deadlines consistently.

This role requires a strong working knowledge of Google Analytics 4 (GA4) and Looker Studio (Google Data Studio) to independently build, customize, and manage reports that provide insights into marketing campaign performance. The Digital Analytics Coordinator will consolidate and analyze data from paid search, social, publication media, email, and CRM sources to uncover trends and deliver actionable recommendations.

A foundational understanding of Google Tag Manager (GTM) is also required to assess tracking needs and make informed recommendations. While the coordinator will collaborate with the Web Development/Tracking team for implementation, they will have opportunities to further develop their expertise in GTM.

Additionally, this position provides hands-on exposure to paid media platforms, ensuring the coordinator understands how different marketing channels contribute to overall campaign success. As a key player in campaign performance reporting, cross-team collaboration, and data-driven decision-making, the Digital Analytics Coordinator supports the agency’s long-term growth in analytics, paid media management, and CRM.

KEY RESPONSIBILITIES

• Monthly Reporting Calendar Management – Develop and manage the monthly reporting calendar with a strong focus on meeting deadlines and ensuring timely report delivery.
• Expectation Management – Communicate reporting timelines and deliverables clearly to both internal teams and clients, ensuring alignment with agreed-upon deadlines.
• Data Aggregation & Integration – Systematically collect, consolidate, and normalize data from multiple paid media platforms (Facebook, Instagram, LinkedIn, Programmatic, Paid Search) as well as email, SMS, and CRM data sources.
• Reporting Dashboard Development & Maintenance – Build, manage, and maintain Looker Studio (Google Data Studio) dashboards, ensuring accurate data visualization and performance tracking.
• Data Troubleshooting & Quality Assurance – Continuously monitor dashboard reports, proactively identifying and resolving data connection or accuracy issues.
• Campaign Performance Analysis – Analyze website and media data in collaboration with the media and CRM teams, providing clear, actionable insights that align with campaign KPIs.
• Reporting Review & Quality Control – Manage reports through the agency proofing platform, ensuring accuracy from initial draft to final review, incorporating required revisions.
• Google Analytics & Tagging Understanding – Perform fundamental Google Analytics (GA4) analysis and assist in assessing Google Tag Manager (GTM) tracking needs, working with the Web Development/ Tracking team for implementation.
• Client & Internal Communication – Join and contribute to internal and client reporting discussions, supporting digital leadership with insights and recommendations.
• Process Improvement & Optimization – Proactively seek opportunities to enhance reporting processes, improve data aggregation efficiencies, and refine dashboard formats to drive better campaign insights.
• Professional Development – Engage in agency-provided talent development programs and seek ongoing learning opportunities to advance technical and analytical expertise.

QUALIFICATIONS/SKILLS

• 1-2 years of experience in media, advertising agency, or an internal marketing team
• Proficiency with Google Analytics 4 (GA4) and Looker Studio (Google Data Studio)
• Foundational understanding of Google Tag Manager (GTM)
• Foundational understanding of paid media channels, including Search, Social, Programmatic, and CRM data
• Ability to analyze and interpret marketing data to generate actionable insights
• Microsoft Excel expertise (Pivot Tables, VLOOKUP, data visualization, etc.)
• Project management skills (ability to manage reporting timelines and cross-team collaboration)
• Excellent communication skills (written, verbal, and ability to convey insights effectively)
• Detail-oriented with strong problem-solving abilities
• Ability to multi-task and manage multiple deadlines in a fast-paced environment
• Strong organizational skills for managing large datasets and reports
• Superior communication skills, both written and verbal; ability to be highly persuasive when necessary.