Data Analytical SpecialistScientist Junior

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

Description

Responsibilities:

• Work closely with clients 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.

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