Data Analytical Specialist Scientist (Junior) 8480-1109

Dheya; Toronto; Hybrid; CAD 50,000 - 80,000; Full time

Job summary

An innovative firm is seeking a Junior Data Analytical Specialist to drive evidence-based decision-making through data analytics. In this hybrid role, you'll collaborate with client groups to enhance analytical capabilities and deliver actionable insights. Your expertise in statistical modeling and machine learning will be crucial as you develop robust analytics solutions. This position offers the chance to work in a dynamic environment, where your contributions will significantly impact various projects. If you're passionate about data and eager to make a difference, this opportunity is perfect for you.

Benefits

Flexible working hours

Professional development opportunities

Health and wellness programs

Remote work options

Qualifications

• Experience with data analytics and reporting capabilities.
• Strong analytical and problem-solving skills are essential.

Responsibilities

• Lead development of analytics for decision-making.
• Communicate complex analyses to stakeholders effectively.

Skills

Project Management

Communication Skills

Analytical Thinking

Technical Proficiency in Software Tools

Problem Solving

Time Management

Team Leadership

Statistical Analysis

Machine Learning

Data Mining

Education

Bachelor's Degree in a related field

Tools

Microsoft PowerBI

Excel

R Shiny

Esri ArcGIS

Cognos

SQL

SAS

Python

Tableau

Job description

Data Analytical Specialist Scientist (Junior) 8480-1109

Skills Required:

• Project Management
• Communication Skills
• Analytical Thinking
• Technical Proficiency in Software Tools
• Microsoft PowerBI
• Excel
• Forms
• R Shiny
• EsriArcGIS
• PowerViewer
• Cognos
• Team Leadership
• Problem Solving
• Time Management

HM Note: This hybrid contract role is three (3) days in office. Candidates resume must include first and last name.

Description

Responsibilities:

Lead the development and delivery of functional and ministry-specific analytics to support evidence-based decision-making and produce actionable insights. Work closely with client 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. Develop robust statistical models and machine learning algorithms to model business scenarios and extract valid inferences. Participate in documentation, development, testing, and end user training.

Work with functional area experts, Data Architects, 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.

General Skills:

• Excellent analytical, problem-solving and decision-making skills, verbal and written communication skills, interpersonal skills and teamwork skills.
• Outstanding consulting and relationship management skills, with proven ability to elicit requirements, develop/consult on options and solutions, and provide effective guidance.
• Adept at communicating to both technical and non-technical audiences.
• Experience with a range of analytical methods, techniques and tools such as statistical analysis and modeling, data mining, machine learning and algorithms, natural language processing, and other related disciplines at the specified experience level.
• Ability to manipulate and analyze complex, high-volume data from structured and unstructured sources.
• Experience developing data extraction, transformation, and load functionality for large relational and multi-dimensional data stores.
• Experience designing high-quality interfaces to present information in a meaningful way to end users.
• Broad understanding of data management, financial and business analysis, database architecture, and information visualization.
• Proficiency in query languages and experience constructing complex query statements.
• Experience in one or more programming or scripting languages.
• Strong investigative and logic skills. Proficiency in mathematics and statistics.
• Awareness of emerging Business Intelligence trends and directions.
• Functional area experience as required.
• Experience with analytical software such as R, PowerPivot, Matlab, SPSS, or SAS an asset.
• Proficiency with desktop analysis software including Microsoft Excel, Access, VBA.

A junior (Level 1) Data Scientist is required to support the assessment and analytics of datasets for proofs-of-concept. The general scope of work for the data scientist involves:

• Assessing datasets from various ministry sources, including those involved with land-use planning, child care, and school-related data.
• Identifying potential gaps (e.g., inconsistencies, errors) in datasets and documenting gaps as well as steps for resolution.
• Identifying new datasets needed to improve analytical capabilities of a proof of concept; developing reports in various visualization tools (e.g., GIS, Tableau, Microsoft PowerBI).
• Conducting historical analytics on relational datasets.
• Conducting predictive analytics on relational datasets.
• Documenting the findings at each phase of work and reporting the findings to the team.

The candidate must be able to work in an agile/iterative project environment.

Skills:

• Experience with land-use planning, child care, StatsCan demographics, and Ontario Open Data is an asset.
• Experience integrating R Script into Microsoft Power BI.
• Experience with predictive analytics.
• Experience with dimensionalized data/building cubes.

Experience and Skill Set Requirements

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 in 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.

MUST HAVES:

• 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.
• Experience building visualizations in Microsoft PowerBI.