Data Analytical Specialist/Scientist

Project Overview

Develop BI solutions using Microsoft Power BI for varying business needs, following all applicable GO-ITS standards and industry best practices while adhering to the existing technological solution framework. The successful candidate will work with various technology teams to translate business needs and work through the analysis and lead the development phases. The resources will also support CSC release and infrastructure solutions support project activities, urgent priorities, changing needs, or time-sensitive infrastructure upgrades, or other project activities supporting any CSC platforms overseen by the Cluster where annual work is required.

Key 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’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
• 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
• Assist the Lead Developers with ETL and/or SSIS development where necessary
• 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

Qualifications & Requirements

REQUIRED

• Must be able to work 5 days onsite per week
• Strong data analysis and problem-solving skills
• Advanced proficiency in SQL for data extraction, transformation, and analysis
• Expertise in Power BI dashboard and report development
• Ability to design and develop interactive Power BI dashboards, scorecards, and KPI reports
• Strong knowledge of DAX and Power Query for advanced analytics and data transformation
• Experience with data modeling (fact and dimension tables, star schema)
• Data cleansing, validation, and quality management
• Experience with ETL processes and data integration from multiple sources
• Ability to gather business requirements and translate them into reporting solutions
• Strong data visualization and storytelling skills
• Experience creating executive, operational, and analytical reports
• Knowledge of Power BI Service, report publishing, workspace management, and security
• Understanding of Row-Level Security (RLS) and data governance practices
• Experience working with large datasets and data warehouses
• Familiarity with cloud analytics platforms and modern data ecosystems
• Ability to identify trends, patterns, risks, and opportunities through data analysis
• Strong stakeholder communication and presentation skills
• Experience documenting data definitions, KPIs, and reporting processes

NICE TO HAVE

• Prior OPS or Public sector Exp.

EVALUATION CRITERIA

Tools and techniques - 40%

• Experience with a range of analytical methods, techniques and tools such as statistical analysis and modelling, data mining, machine learning and algorithms, natural language processing, and other related disciplines
• Experience building visualizations in R, R Shiny, PowerBI, or other tools
• Experience with ETL and SSIS development
• Experience with scripting such as Python, and languages such as DAX to be able to do trend analysis
• Experience in Microsoft technology stack, including Azure Data Factory, SSIS, SSAS, SSRS, Power BI, and supporting tools like Visual Studio and SQL Server Management Studio.

BI and Analytics Experience - 40%

• Experience developing BI and analytics
• Experience with creating dashboards and data visualization via Power BI Server (On-Prem) and Power BI Services (Cloud) or other visualization tools
• Experience with cleaning, transforming and visualizing data sets
• Advanced experience with SQL
• Demonstrated knowledge of emerging Business Intelligence trends and directions
• Experience with dimensional data/building cubes

Soft Skills - 15%

• Outstanding 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
• Excellent analytical, problem-solving and decision-making skills
• Strong leadership and collaboration skills
• Proven track record for building strong working relationships
• A demonstrated team player with a track record for meeting deadlines

Public Sector Experience - 5%

• Previous public sector experience in an organization of equivalent size or complexity in Public Service
• Demonstrates experience designing and developing applications that comply with GOITS standards and general processes would be an asset.

Key Skills & Competencies

Azure Data Factory, Cloud analytics platforms, DAX, Data analysis, Data governance, Data integration, Data management, Data mining, Data modeling, Data quality management, Data visualization, Data warehouses, Database architecture, Dimensional data, ETL, Machine learning, Mathematics, Natural language processing, Power BI, Power BI Service, Power Query, Python, R, R Shiny, Row-Level Security, SQL, SSAS, SSIS, SSRS, SQL Server Management Studio, Statistical analysis, Statistics, Visual Studio