Job Specifications
RQ10169 - Data Analytical Specialist/Scientist - Junior
Closing Date - 2026-03-02, 10:00 a.m.
Maximum Number of Submissions - 1 (one)
Assignment Type - 5 days Onsite
MUST HAVES:
Experience building visualizations in Microsoft PowerBI
Superior Knowledge of MS analytical products in particular Excel and data validation on Excel forms.
Experience cleaning, transforming and joining data
Experience with SQL databases
Start Date
2026-04-01
End Date
2027-03-31
Office Location
315 Front Street
Organization
Community Services Cluster
# Business Days
250.00
Max Extension Term(s)
1 Time
Data Analytical Specialist/Scientist - Junior
Note: The FFS resource is working 5 days onsite at the identified OPS location.
Responsibilities:
Work closely with client’s groups to assess current data analytics and reporting capabilities, gather future-state requirements and identify further opportunities for improvement. · Facilitate decision-making and manage client expectations.
Own the execution of analytics initiatives including end-to-end reporting and data set delivery.
Participate in documentation, development, testing, and end user training.
Work with functional area experts, Data Architects and ETL Developers and stakeholders to understand complex business issues and develop appropriate Business Intelligence solutions.
Design methods to capture, structure, transform, and process data to be used to generate models.
Build data models that provide information, which is accurate, easy to understand and unbiased.
Communicate complex quantitative analysis in a clear and precise manner, providing useful visuals and summaries.
Provide interpretation, advice, and expertise to client groups and other stakeholders, including direction on how to transform analytics into actionable information and proactive insights that support decision making.
The resources will also support CSC release and infrastructure solutions support sustainment activities, urgent priorities, changing needs, or time-sensitive infrastructure upgrades, or other sustainment activities supporting any CSC platforms overseen by the Cluster where annual work is required.
Tools and techniques - 50%
Superior Knowledge of MS analytical products in particular Excel and data validation on Excel forms.
Experience with SQL databases
Experience cleaning, transforming and joining data
Experience is creating and applying data standards
Experience with dimensional data models
Statistical modeling using R and experience integrating R with Microsoft Power BI an asset
Experience building visualizations in R Shiny, SAS, Python, Esri/ArcGIS, Microsoft PowerBI, and PowerViewer, Cognos an asset
Power BI and Analytics Experience - 25%
Experience developing business intelligence and various analytics resources
Experience with cleaning, transforming, integrating, and visualizing data sets
Experience understanding a data model
Experience creating interactive visuals
Communication Skills - 20%
Experience in developing documentation on data standardization and requirements
Demonstrated consulting and relationship management skills, with proven ability to elicit requirements, develop/consult on options and solutions, and provide effective guidance
Strong verbal and written communication skills; with both technical and non-technical audiences
A demonstrated team player with a track record for meeting deadlines
OPS Experience - 5%
Previous public sector experience in an organization of equivalent size and complexity to the Ontario Public Service.
About the Company
A.T. Consulting & Recruiting Inc. is a provider of IT & Management Consulting resources throughout the GTA. Some of our most commonly known clients include Public Sector, Financial institutions, large and small IT firms. Our business model is based on relationship building! We source the best professionals available through our team of account managers and recruiters who always meet client expectations. We are committed to achieving success for our clients and resources by working as a partner, as a team. We strive to unite ...
Know more