Data Analytical Specialist/Scientist - Intermediate

Posted 4 Days Ago
Be an Early Applicant
Toronto, ON, CAN
In-Office
Mid level
Information Technology • Professional Services • Software • Consulting
The Role
Design and build Power BI dashboards and reports using advanced SQL, DAX, and Power Query. Perform data modeling, ETL, cleansing, validation, and quality management. Translate business requirements into KPI scorecards, implement RLS and governance, analyze large datasets, and present insights to stakeholders.
Summary Generated by Built In
We do have a job opening for Data Analytical Specialist/Scientist - Intermediate for our direct client Province of Ontario. The position details are given below:

Job Details:
Job ID: RQ10972 - Data Analytical Specialist/Scientist - Intermediate
Client : Community Services Cluster
Location : Toronto, Ontario
Duration:  10 months + Extension

Type: Onsite


Job Description:



Must Have Skills:

Key Requirements for a Data Specialist / Analytics Role
  • Strong data analysis and problem-solving skills

  • Advanced proficiency in SQL for data extraction, transformation, and analysis

  • Expertise in Power BI dashboard and report development

  • Ability to design and develop interactive Power BI dashboards, scorecards, and KPI reports

  • Strong knowledge of DAX and Power Query for advanced analytics and data transformation

  • Experience with data modeling (fact and dimension tables, star schema)

  • Data cleansing, validation, and quality management

  • Experience with ETL processes and data integration from multiple sources

  • Ability to gather business requirements and translate them into reporting solutions

  • Strong data visualization and storytelling skills

  • Experience creating executive, operational, and analytical reports

  • Knowledge of Power BI Service, report publishing, workspace management, and security

  • Understanding of Row-Level Security (RLS) and data governance practices

  • Experience working with large datasets and data warehouses

  • Familiarity with cloud analytics platforms and modern data ecosystems

  • Ability to identify trends, patterns, risks, and opportunities through data analysis

  • Strong stakeholder communication and presentation skills

  • Experience documenting data definitions, KPIs, and reporting processes

Core Technical Skills
  • Power BI Dashboard & Report Development

  • DAX

  • Power Query (M)

  • SQL

  • Data Modeling

  • Data Visualization

  • ETL & Data Integration

  • KPI & Performance Reporting

  • Data Quality Management

  • Power BI Service & RLS

 Nice to have:

Prior OPS or Public sector Exp.







Skills Required

  • Advanced proficiency in SQL for data extraction, transformation, and analysis
  • Power BI dashboard and report development
  • Design and develop interactive Power BI dashboards, scorecards, and KPI reports
  • Strong knowledge of DAX
  • Strong knowledge of Power Query (M)
  • Experience with data modeling (fact and dimension tables, star schema)
  • Data cleansing, validation, and quality management
  • Experience with ETL processes and data integration from multiple sources
  • Ability to gather business requirements and translate them into reporting solutions
  • Strong data visualization and storytelling skills
  • Experience creating executive, operational, and analytical reports
  • Knowledge of Power BI Service, report publishing, workspace management, and security
  • Understanding of Row-Level Security (RLS) and data governance practices
  • Experience working with large datasets and data warehouses
  • Familiarity with cloud analytics platforms and modern data ecosystems
  • Ability to identify trends, patterns, risks, and opportunities through data analysis
  • Strong stakeholder communication and presentation skills
  • Experience documenting data definitions, KPIs, and reporting processes
  • Prior OPS or Public sector experience
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Woodbury, MN
50 Employees

What We Do

ITProFound Inc. is a global technology services and solutions provider specializing in software development, IT consulting, and staff augmentation. They deliver end-to-end business practice solutions, including ERP, cloud migrations, and data analytics, across various industries.

Similar Jobs

Maarut Inc. Logo Maarut Inc.

Scientist

Information Technology • Professional Services • Software • Consulting
In-Office
Toronto, ON, CAN

FloQast Logo FloQast

Business Development Representative

Artificial Intelligence • Fintech • Software
Remote or Hybrid
Toronto, ON, CAN
800 Employees
80K-110K Annually

FloQast Logo FloQast

Business Development Representative

Artificial Intelligence • Fintech • Software
Remote or Hybrid
Toronto, ON, CAN
800 Employees
80K-110K Annually

Samsara Logo Samsara

Senior Product Manager

Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Easy Apply
Remote or Hybrid
Canada
4000 Employees
127K-150K Annually

Similar Companies Hiring

Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account