Junior Data Analyst

MediaCom; Toronto; On-site; CAD 40,000 - 60,000; Full time

Job summary

A leading company in the advertising industry is seeking a motivated Junior Data Analyst to support data collection, analysis, and reporting. This is an excellent opportunity for individuals eager to learn and grow in a dynamic field. Candidates from diverse backgrounds are encouraged to apply, as prior advertising experience is not required.

Benefits

Career development support

Access to real-world advertising datasets

Training opportunities

Qualifications

• 6 months to 1 year of hands-on experience working with data.
• Proficiency in Excel/Google Sheets.
• Basic knowledge of SQL or data querying.

Responsibilities

• Collect, clean, and organize large datasets.
• Perform exploratory data analysis, identifying trends.
• Support campaign performance analysis and reporting.

Skills

Data analysis

Analytical skills

Problem-solving

Communication skills

Tools

Excel

SQL

Tableau

Power BI

Job description

Location: Toronto | Job Type: Full-Time | Experience: 6 months – 1 year

About the Role

We are looking for a motivated and detail-oriented Junior Data Analyst to join our growing team in the advertising industry . The ideal candidate will have a strong foundation in data handling and a curiosity for uncovering insights that drive business decisions. While prior experience in advertising is a plus, it’s not required — we welcome candidates from diverse industry backgrounds who are eager to learn and grow.

Key Responsibilities

• Assist in collecting, cleaning, and organizing large datasets from various sources.
• Perform exploratory data analysis and identify trends, patterns, and anomalies.
• Support campaign performance analysis and regular reporting tasks.
• Collaborate with internal teams to understand data needs and deliver insights.
• Help maintain documentation for data processes and definitions.

Required Qualifications

• 6 months to 1 year of hands-on experience working with data in any industry.
• Proficiency in Excel/Google Sheets for data analysis.
• Basic knowledge of SQL or any data querying language.
• Familiarity with data visualization tools (e.g., Tableau, Power BI, or similar).
• Strong analytical and problem-solving skills.
• Good communication skills and ability to explain data findings to non-technical stakeholders.

Nice to Have

• Exposure to marketing or advertising data (e.g., campaign metrics, media performance).
• Understanding of digital media platforms (e.g., Google Ads, Meta, DSPs).
• Ability to manage multiple tasks and meet deadlines in a fast-paced environment.

Why Join Us

• Opportunity to work in a dynamic, creative industry with a data-driven focus.
• Learn from experienced analysts and marketers.
• Access to real-world advertising datasets and tools.
• Career development support and training opportunities.