RQ06248 - Data Analytical SpecialistScientist - Junior

Description

Responsibilities

Lead the development and delivery of functional and ministryspecific analytics to support evidencebased decisionmaking and produce actionable insights. Work closely with clients groups to assess current data analytics and reporting capabilities gather futurestate requirements and identify further opportunities for improvement. Facilitate decisionmaking and manage client expectations. Own the execution of analytics initiatives including endto 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 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.

General Skills

• Excellent analytical problemsolving and decisionmaking skills verbal and written communication skills interpersonal skills and team work 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 nontechnical audiences
  
• Experience with a range of analytical methods techniques and tools such as but not limited to: statistical analysis and modelling data mining machine learning and algorithms natural language processing and other related disciplines at the specified experience level
  
• Ability to manipulate and analyze complex highvolume data from structured and unstructured sources
  
• Experience developing data extraction transformation and load functionality for large relational and multidimensional 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 proofsofconcept. The general scope of work for the data scientist involves:

• Assessing datasets from various ministry sources including those involved with landuse 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; and
  
• 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:

• Statistical modelling using R script
  
• Experience with landuse 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
  

Skills

Experience and Skill Set Requirements

Tools and techniques

Requirements

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