Data Analytical SpecialistScientist Intermediate

Job Title: Data Analytical Specialist/Scientist - Intermediate
Location: Toronto Ontario
Work Model: Onsite
Submission Deadline::00 p.m. EST

Description / Responsibilities / Skills

Must Have

• Strong data analysis and problem-solving skills
• Advanced SQL for data extraction transformation and analysis
• Power BI dashboard and report development
• DAX and Power Query (M)
• Data modeling (star schema fact & dimension tables)
• ETL processes and data integration
• Ability to translate business requirements into reporting solutions
• Data visualization and storytelling

Description

Project Description

• Develop BI solutions using Microsoft Power BI following GO-ITS standards
• Support EYIA IT Solution development
• Lead analytics initiatives reporting and data delivery
• Support infrastructure and release-related project activities

Responsibilities

• Lead development and delivery of analytics and reporting solutions
• Assess data analytics capabilities and gather requirements
• Facilitate decision-making and manage stakeholder expectations
• Develop statistical models and machine learning algorithms
• Build data models and structured datasets
• Work with architects ETL developers and stakeholders
• Assist with ETL and SSIS development
• Perform data analysis and communicate insights
• Provide expertise and guidance for business decision making

General Skills

• Analytical problem-solving and communication skills
• Consulting and relationship management
• Ability to work with structured and unstructured data
• Experience with statistical modelling data mining machine learning
• Data visualization and information presentation
• Query language expertise and scripting knowledge
• Strong mathematics and statistical skills

Skills

Experience and Skill Set Requirements

Tools and Techniques - 40%

• Statistical analysis machine learning data mining NLP
• Visualization tools (Power BI R R Shiny)
• ETL and SSIS
• Python scripting and DAX
• Microsoft BI stack (ADF SSIS SSAS SSRS Power BI)

BI and Analytics Experience - 40%

• BI solution development
• Power BI dashboards (Server and Service)
• Data cleansing and transformation
• Advanced SQL
• Dimensional modeling and cube development

Soft Skills - 15%

• Stakeholder management
• Communication and collaboration
• Analytical thinking and leadership

Public Sector Experience - 5%

• Public sector / GO-ITS standards experience