Junior Data Analyst

This position is a hybrid role and must be within driving distance of our Detroit, Columbus or Toledo Offices and open to working in-person Tuesday-Thursday weekly (optional work from home on Monday and Friday).

Hartis a full-service, independent brand transformation agency that creates growth for middle-market companies in the new experience economy. For over 60 years, Hart has been a valued strategic and creative partner to brands aiming to reach higher. Our promise of Every Day Greater™ is an outgrowth of our distinctive capability to move audiences from apathy to advocacy by designing and deploying empowering, unified brand experiences.

Join us in our never-ending quest to move brands to better places for a better world.

We’re looking for a proactive and insightful Junior Data Analyst to join our Analytics team. This role is perfect for someone who’s not just good with numbers, but who understands how to turn data into stories that guide decisions. You’ll help build client-facing reports, identify meaningful KPIs, and develop visualizations that clearly show performance and opportunities. You’ll work across departments, helping translate performance data into insights that matter to bring clarity to complex marketing performance.

This is a great opportunity for someone early in their analytics career who’s eager to grow their technical skills and apply data to real business questions.

• 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

• 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, Tik Tok, 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
• 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
• Clear communicator with a collaborative mindset and a willingness to learn
• Curious, detail-oriented, and proactive in surfacing insights

• You enjoy the creative atmosphere and energy a modern agency provides.
• You have strong attention to detail and are process-oriented.
• You balance multiple projects and priorities, communicating expectations and meeting deadlines.
• You are deeply fluent in digital, eager to learn, and curious.
• You are an inclusive and supportive team player who can work in cross-functional teams with people of different backgrounds.
• You have a penchant for results and an entrepreneurial mindset; you bring a can-do mentality to everything you touch.
• You can work fast and independently with great precision and accuracy.

• An exciting and intellectually challenging job within a leading, independent brand transformation agency that honors and lives its values:
  • We are Champions for Others.
  • We are Human-First.
  • We Act as One.
  • We invite Exploration.
• A fruitful salary and benefits package.
• Perks such as paid parental leave, summer flex…