ITProfound Inc. Logo

ITProfound Inc.

Data Analytical Specialist/Scientist - Intermediate

Reposted 6 Days Ago
Be an Early Applicant
In-Office
Toronto, ON, CAN
Mid level
In-Office
Toronto, ON, CAN
Mid level
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.
The summary above was generated by AI
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.







Similar Jobs

5 Hours Ago
Easy Apply
Hybrid
Toronto, ON, CAN
Easy Apply
Senior level
Senior level
Cloud • Mobile • Software
Architect and build a full-stack platform spanning React frontends and Node.js backends. Lead technical decisions, design and optimize GraphQL/REST APIs and databases, improve observability, implement testing strategies, mentor engineers, introduce new technologies, and drive cross-team technical initiatives to deliver scalable, reliable software.
Top Skills: ApolloAWSAzureCi/CdDockerGCPGraphQLJavaScriptJestKafkaKubernetesMaterial-UiMySQLNode.jsPostgresPythonRabbitMQReact Testing LibraryReactRelayRest ApisSQLTypescript
8 Hours Ago
Hybrid
Vaughan, ON, CAN
Junior
Junior
eCommerce • Fashion • Retail • Sales • Wearables • Design
As Acting Store Manager, you will lead store operations, drive sales and profitability, inspire and develop a diverse team, and ensure exceptional customer experiences, all while managing daily operations and fostering an inclusive culture.
Top Skills: Inventory ManagementLabor ManagementMS OfficeRetail SystemsSales Reporting Tools
8 Hours Ago
Easy Apply
Hybrid
Toronto, ON, CAN
Easy Apply
Senior level
Senior level
Big Data • Cloud • Software • Database
As a Senior Software Engineer in Server Security, you will enhance MongoDB's security features, focusing on distributed systems, cryptography, and networking protocols while collaborating across teams to ensure quality and security best practices.
Top Skills: C++CryptographyGoJavaPkiRustTlsX.509

What you need to know about the Toronto Tech Scene

Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account