Data Analytical Specialist

Natural Factors; Toronto; Hybrid; CAD 60,000 - 100,000; Full time

Job summary

Join a forward-thinking company as a Junior Data Scientist, where you'll lead analytics initiatives and develop cutting-edge statistical models. This hybrid role allows you to work closely with various client groups, transforming complex data into actionable insights. You'll utilize advanced tools like R and Power BI to create visualizations and reports that drive evidence-based decision-making. If you're passionate about data and eager to make a significant impact in a collaborative environment, this is the perfect opportunity for you. Embrace the chance to grow your skills and contribute to meaningful projects in the public sector.

Qualifications

• Experience with statistical modeling and predictive analytics.
• Proficiency in data extraction, transformation, and loading processes.
• Ability to communicate technical information to non-technical audiences.

Responsibilities

• Lead analytics initiatives to support decision-making.
• Develop statistical models and machine learning algorithms.
• Collaborate with stakeholders to design Business Intelligence solutions.

Skills

Analytical Skills

Problem-Solving

Communication Skills

Statistical Analysis

Machine Learning

Data Mining

Data Visualization

Consulting Skills

Teamwork

Relationship Management

Education

Bachelor's Degree in Data Science or related field

Master's Degree in Data Science or related field

Tools

R

Power BI

SQL

Excel

Python

SAS

Tableau

ArcGIS

Job description

HM Note: This hybrid contract role is three (3) days in office. Candidates' resumes 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 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.
• Collaborate with functional area experts, Data Architects, ETL Developers, and stakeholders to understand complex business issues and develop Business Intelligence solutions.
• Design methods to capture, structure, transform, and process data for modeling.
• Build data models that are accurate, understandable, and unbiased.
• Communicate complex analyses clearly, providing visuals and summaries.
• Interpret data insights, advising clients on transforming analytics into actionable information.

General Skills

• Excellent analytical, problem-solving, decision-making, communication, interpersonal, and teamwork skills.
• Strong consulting and relationship management skills, with experience eliciting requirements and guiding solutions.
• Ability to communicate technical information to non-technical audiences.
• Experience with statistical analysis, data mining, machine learning, natural language processing, and related disciplines.
• Ability to manipulate and analyze high-volume structured and unstructured data.
• Experience with data extraction, transformation, and load processes for large data stores.
• Designing user-friendly interfaces for data presentation.
• Broad understanding of data management, financial analysis, database architecture, and visualization.
• Proficiency in query languages and constructing complex queries.
• Experience with programming or scripting languages.
• Strong mathematical and statistical skills.
• Knowledge of emerging Business Intelligence trends.
• Relevant functional area experience.
• Experience with analytical software such as R, PowerPivot, Matlab, SPSS, or SAS is an asset.
• Proficiency with desktop analysis software including Excel, Access, VBA.

Specific Scope for Junior Data Scientist

• Assess datasets from various sources like land-use, child care, and education data.
• Identify and document data gaps and resolution steps.
• Develop reports using visualization tools like GIS, Tableau, PowerBI.
• Conduct historical and predictive analytics on relational datasets.
• Document findings and report to the team.

The candidate must work in an agile/iterative environment.

Skills

• Statistical modeling with R.
• Experience with land-use, child care, demographics, Ontario Open Data is an asset.
• Integrating R with Power BI.
• Predictive analytics experience.
• Building dimensional data models/cubes.

Tools and Techniques (50%)

• Expertise in MS Excel, data validation, SQL databases, data cleaning, transformation, standards, and dimensional models.
• Experience with R, SAS, Python, Esri/ArcGIS, PowerBI, PowerViewer, Cognos is an asset.

Power BI and Analytics (25%)

• Developing BI resources and visualizations.
• Understanding data models and creating interactive visuals.

Communication Skills (20%)

• Documentation on data standards.
• Effective communication with technical and non-technical audiences.
• Proven team player and deadline-oriented.

OPS Experience (5%)

• Public sector experience in organizations similar to Ontario Public Service.

MUST HAVES:

• Proficiency in MS Excel, data validation, SQL, and PowerBI.