Junior Data Analyst

Hart, Inc.; Detroit (MI); Hybrid; USD 50,000 - 75,000; Full time

Benefits offered by this job

Hybrid work environment

Paid time off

Health Savings Account

Disability coverage

On-site snacks and lounge

Job summary

Hart, Inc. is seeking a proactive Junior Data Analyst to join our Analytics team. The role blends data storytelling with actionable insights, building client-facing reports and visualizations to guide decisions across departments.

This position offers growth in analytics, cross-functional collaboration, and exposure to performance metrics. The hybrid setup requires proximity to Detroit, Columbus, or Toledo offices with Tue–Thu in-person work and Mon/Fri optional remote.

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
• 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

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

Skills

Excel

PowerPoint

Data visualization

Performance marketing metrics

SQL

Python

Tableau

Power BI

Looker Studio

Communication

Education

Bachelor's degree in a related field

Tools

Power BI

Tableau

Looker Studio

Job description

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

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.

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:
  • 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 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 and continually 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.