Skills

Communication Teamwork Python SQL Data Cleaning Problem-solving Decision-making Analytics and Reporting Training Databases power bi Analytics

Job Specifications

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

About the Company

At Digivance Solutions, we began our journey as a digital marketing company. Over time, as our clients expressed the need for reliable and strategic recruitment services, we successfully expanded our expertise to include this essential vertical. Responding to the evolving demands of our clients, we pivoted towards offering comprehensive recruitment solutions tailored to the unique requirements of various industries. With a strong focus on strategic talent acquisition, we leverage our expertise in technology and marketing to... Know more