Junior Data Analyst – Power BI & SQL

Data Analytical Specialist / Scientist (Junior)

📍 Location: Toronto, ON (Onsite – 5 Days per Week)

Position Overview

We are seeking a Junior Data Analytical Specialist / Scientist to support data analytics, reporting, and business intelligence initiatives. The resource will work onsite and collaborate closely with stakeholders to assess analytics capabilities, develop reporting solutions, and deliver actionable insights.

Mandatory Requirements

• Experience building visualizations in Microsoft Power BI
• Strong knowledge of Microsoft analytical tools, especially Excel (including data validation on Excel forms)
• Experience cleaning, transforming, and joining data
• Experience working with SQL databases

Key Responsibilities

• Assess current analytics and reporting capabilities and gather future-state requirements
• Facilitate stakeholder discussions and manage expectations
• Execute analytics initiatives including end-to-end reporting and dataset delivery
• Design and build accurate, structured, and unbiased data models
• Capture, structure, transform, and process data for analytical use
• Develop interactive dashboards and visual reports
• Communicate complex quantitative analysis clearly through visuals and summaries
• Provide data-driven insights and recommendations to support decision-making
• Participate in documentation, testing, and end-user training
• Support infrastructure upgrades and sustainment activities as required

Skills & Experience Requirements

Tools & Techniques (50%)

• Advanced Excel (data validation, data standards, structured forms)
• SQL database experience
• Data cleaning, transformation, and integration
• Experience applying data standards
• Knowledge of dimensional data modeling
• Statistical modeling using R (Power BI integration is an asset)
• Experience building visualizations using Power BI (R Shiny, SAS, Python, ESRI/ArcGIS, Cognos considered assets)

Power BI & Analytics (25%)

• Experience developing business intelligence solutions
• Building interactive dashboards and visualizations
• Understanding data models
• Transforming and integrating complex datasets

Communication & Consulting Skills (20%)

• Experience documenting data standards and requirements
• Strong stakeholder engagement and consulting skills
• Ability to communicate with technical and non-technical audiences
• Strong analytical, problem-solving, and teamwork skills
• Ability to meet deadlines