Junior Data Analyst (Media)

Responsibilities

• Analyze performance data across social media and marketing campaigns (paid and organic)
• Create client-facing reports in PowerPoint or other programs, showcasing trends, insights, and strategic recommendations
• Identify meaningful KPIs and select the right metrics to track campaign effectiveness
• Choose the right visualizations that clearly tell the performance story
• Communicate findings clearly and concisely to non-technical stakeholders
• Support data quality checks and help maintain reporting accuracy
• Collaborate with the analytics team on performance trends, testing ideas, and tool improvements
• Assist with monthly performance reviews, including writing insights and building report materials
• Partner with the team (including another analyst focused on dashboarding and data strategy) to improve overall data products and explore new analytics tools
• Stay up-to-date with industry best practices

Qualifications

• 1–2 years of relevant experience
• Strong skills in Excel and PowerPoint for analysis and reporting
• Familiarity with performance marketing or social media metrics (Meta, Instagram, TikTok, etc.)
• Foundational knowledge of data analytics and performance measurement
• Good eye for data visualization and the ability to choose the right format for the right message
• Understanding of what makes a KPI meaningful and how to tie metrics to business goals
• Some exposure to basic coding/scripting (SQL, Python) is a plus
• Brief understanding of ETL processes and how data is collected, merged, transformed, and maintained across multiple sources and platforms
• Familiar with Tableau, Power BI, or Looker Studio for data visualization
• Clear communicator with a collaborative mindset and a willingness to learn
• Curious, detail-oriented, and proactive in surfacing insights

Skills

• Basic understanding of ETL processes and how data is collected, merged, transformed, and maintained across multiple sources and platforms
• Familiar with Tableau, Power BI, or Looker Studio for data visualization
• Some exposure to basic coding/scripting (SQL, Python) is a plus

Benefits

• An exciting and intellectually challenging job within a leading, independent brand transformation agency that honors and lives its values
• A fruitful salary and benefits package
• Perks such as paid parental leave, summer flex Fridays and volunteer time off
• A hybrid work environment
• Generous amount of paid time off annually + paid holidays
• Flexible spending accounts for health and dependent care
• Health Savings Account option with employer match
• Paid short-term and long-term disability coverage
• Daily snacks, beverages, and full access to our on-site tavern and lounge
• An employee experience that fosters and provides deeper connections, vital flexibility, personal growth, holistic well-being, and shared purpose