Job Title: RQ10972 - Data Analytical Specialist/Scientist - Intermediate

I would like to present to you a new job opportunity and I think you may find it interesting.

If you are interested kindly send the following documents to [email protected] by Thursday, July 2, 10:00 AM EST if that interests you and matches your profile.

• Updated Resume in word format (Mandatory)
• References (Mandatory)
• Expected hourly rate (Mandatory)
• Visa Status (Mandatory)
• LinkedIn ID (Mandatory)

Client: Ministry of Public and Business Service Delivery and Procurement

Work Location: Toronto, Ontario, Onsite

Estimated Start Date: 2026-06-01

Estimated End Date: 2027-03-31

#Business Days: 210.00

Extension: Probable after the initial mandate

Hours per day or Week: 7.25 hours per day

Security Level: No Clearance Required

Must Haves

Key Requirements for a Data Specialist / Analytics Role

• 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

Core Technical Skills

• Power BI Dashboard & Report Development
• DAX
• Power Query (M)
• SQL
• Data Modeling
• Data Visualization
• ETL & Data Integration
• KPI & Performance Reporting
• Data Quality Management
• Power BI Service & RLS

Nice To Have

Prior OPS or Public sector Exp.

RoleOverview

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

General Skills

• Excellent analytical, problem-solving and decision-making skills, verbal and written communication skills, interpersonal skills and team work skills
• Outstanding consulting and relationship management skills, with proven ability to elicit requirements, develop/consult on options and solutions, and provide effective guidance
• Adept at communicating to both technical and non-technical audiences
• Experience with a range of analytical methods, techniques and tools such as, but not limited to: statistical analysis and modelling, data mining, machine learning and algorithms, natural language processing, and other related disciplines at the specified experience level
• Ability to manipulate and analyze complex, high-volume data from structured and unstructured sources
• Experience developing data extraction, transformation, and load functionality for large relational and multi-dimensional data stores
• Experience designing high quality interfaces to present information in a meaningful way to end users
• Broad understanding of data management, financial and business analysis, database architecture, and information visualization
• Proficiency in query languages and experience constructing complex query statements
• Experience in one or more programming or scripting languages
• Strong investigative and logic skills
• Proficiency in mathematics and statistics
• Awareness of emerging Business Intelligence trends and directions

Experience And Skill Set Requirements

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, Power BI, 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.

Note

5 days onsite