RQ10169 - Data Analytical Specialist/Scientist - Junior

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.
  

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