Question
Full-time
0-2

Junior Business Analyst

3/22/2026

The role involves collecting, processing, and analyzing data from various sources to drive business performance, and designing and building interactive Power BI dashboards and reports. This includes collaborating with stakeholders to translate data needs into analytical solutions and identifying trends to inform strategic decisions.

Working Hours

40 hours/week

Company Size

10,001+ employees

Language

English

Visa Sponsorship

No

About The Company
We build brands that move people and markets through the radical creativity of Truth Well Told™. We don’t make campaigns, we build brands. We don’t follow trends, we uncover enduring human truths. That has been the promise of Truth Well Told since our founding in 1912 – a promise we renew every day as an iconic brand that builds the world’s most iconic brands through finding the truth and telling it well.  Truth Well Told unites our 10,000+ people across 100+ countries, as does our commitment to Conscious Inclusion, which upholds the highest standards of bravery, integrity and generosity.   Named one of the World's Most Innovative Companies by Fast Company in 2025 and 2024, McCann was the most awarded agency at Cannes Lions 2023 and ranked Most Effective Agency Network by the Global Effie Index 2023, 2022, 2021, 2020 and 2019. 
About the Role

A Bit About Us

We are an ever-evolving company, driven by our passion for video.

We've grown from a small start-up to a thriving business, and have been a part of the biggest global ad agency for ten years.

Our main priority is maintaining our fun and determined environment and keeping our employees engaged in their work.

We are looking for a detail-oriented and proactive Business Data Analyst who is passionate about transforming data into actionable insights. This role involves working closely with cross-functional teams to support data-driven decision-making in a fast-paced environment.

You’ll play a key role in shaping data strategy and delivering insights that impact global business decisions.


Key Responsibilities:

  • Collect, process, and analyze data from various sources to drive business performance.
  • Design and build interactive Power BI dashboards and reports.
  • Collaborate with business stakeholders to understand data needs and translate them into analytical solutions.
  • Identify trends, correlations, and insights to inform strategic decisions.
  • Maintained and optimized data models, reporting pipelines, and documentation.

Requirements

  • Bachelor’s degree in a relevant field (Industrial Engineering, Statistics, Economics, Information Systems, Business Management).
  • Knowledge in Power BI, including Power Query and DAX - Advantage 
  • Excel skills for data analysis, modeling, and reporting.
  • Excellent communication skills with a high level of English (both spoken and written).
  • Strong analytical and problem-solving abilities.
  • Attention to detail and a structured approach to work.
  • SQL skills for data extraction and manipulation - Advantage 
  • 1–2 years of experience as a Data Analyst / Business Analyst / BI Developer, or in a similar role - Advantage.
  • Experience in Ad Tech or online global market companies - Big Advantage.
  • Familiarity with the Microsoft Fabric platform - Advantage.
  • Familiarity with OneLake, Spark programming, and Parquet files / Delta tables - Advantage.


Key Skills
Power BIPower QueryDAXExcelSQLData AnalysisProblem-SolvingCommunication
Categories
Data & AnalyticsTechnologySoftwareConsulting
Apply Now

Please let McCANN know you found this job on InterviewPal. This helps us grow!

Apply Now
Prepare for Your Interview

We scan and aggregate real interview questions reported by candidates across thousands of companies. This role already has a tailored question set waiting for you.

Elevate your application

Generate a resume, cover letter, or prepare with our AI mock interviewer tailored to this job's requirements.