Junior Excel Data Analyst Jobs in Michigan (NOW HIRING)

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).
THE ORGANIZATION
Hart is 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.
SUMMARY
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.
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
WHAT WE'RE LOOKING FOR
• 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
• 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
PERSONAL SKILLS AND CHARACTER TRAITS
• 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.
WHAT WE OFFER
• An exciting and intellectually challenging job within a leading, independent brand transformation agency that honors and lives its values:
o We are Champions for Others.
o We are Human-First.
o We Act as One.
o We incite New Growth.
o We invite Exploration.
• 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.
We employ great people from an ever-widening variety of backgrounds - not just because it's the right thing to do but also because we believe that diverse perspectives make our agency stronger and more innovative. If you share our values, come find your place in our community. Meet us on @_hartinc and hartinc.com/careers to learn more.
Hart is an equal opportunities employer andcontinually seeks to advance the concepts of equal employment opportunity to all applicants and employees. As such, Hart does not discriminate on the basis of race, color, religion, sex, national origin, age, mental or physical disability, or status as a protected veteran. This policy applies to all personnel activities and conditions of employment.