Freelance Digital Analytics Coordinator
VISION
Schaefer Advertising Co. is seeking a datadriven Analytics Coordinator to join our team. As part of the Digital team this person will work under the Digital Supervisor and in collaboration with the full digital team to bring client reports to life across Schaefers three key verticals Healthcare Real Estate and Attractions Tourism & The Arts.
The Digital Analytics Coordinator is responsible for managing key aspects of Schaefers 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 detailoriented 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 handson 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 crossteam collaboration and datadriven decisionmaking the Digital Analytics Coordinator supports the agencys longterm 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 agreedupon 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 agencyprovided talent development programs and seek ongoing learning opportunities to advance technical and analytical expertise.
QUALIFICATIONS/SKILLS
- 12 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 crossteam collaboration)
- Excellent communication skills (written verbal and ability to convey insights effectively)
- Detailoriented with strong problemsolving abilities
- Ability to multitask and manage multiple deadlines in a fastpaced environment
- Strong organizational skills for managing large datasets and reports
- Superior communication skills both written and verbal; ability to be highly persuasive when necessary.
Required Experience:
Junior IC