Specialized IT Consultant SeniorCWM

Must Haves:

• 5 years experience provisioning configuring optimizing Data Pipelines using Azure Synapse
• 5 years experience with Data Science / Data Modeling
• 5 years experience developing Microsoft Power BI reports and dashboards (Mobile enabled).
• Strong experience with understanding user experience and designing visually effective reports and dashboards (please include portfolio of work samples.)
• Strong experience with Power BI performance modeling and optimization.
• Strong experience developing within Microsoft Azure
• Hands-on development experience with
• Effective team player with strong interpersonal skills and the ability to communicate complex technical information in a manner that is understandable

Description

Background Information:

• The purpose of this request is to acquire a Specialized IT Consultant - Senior professional. The Central Waitlist Management (FY26-27) initiative aims to digitally enable stakeholders at a provincial regional and hospital level. Applying a user first approach requirements will be developed throughout the duration of the initiative.

Responsibilities:

• Lead design/requirements sessions with Product Management data experts and end users to document/understand the reporting and analytics needs
• Work with Business Analysts to construct wireframes mock-ups and in an Agile development process create Power BI Embedded reports.
• Resolve and troubleshoot technical problems which arise during the use and operation
• Evaluate and determine appropriate architecture technical specifications solution design and make recommendations to product management.
• Diagnose and troubleshoot functional and performance issues implement corrective fixes preventive fixes and triage as required.
• Partner with DevOps Engineer to ensure support of developed reports in all environments.

Desired Skills:

• Power BI Embedded application experience would be an asset
• Working experience of Microsoft Azure Services Azure Stream Analytics Azure Data Factory DataBricks and Azure DevOps Automation
• Expert level experience with SQL
• Working experience of security best practices
• Experience in an Agile environment
• Passion for learning the latest technologies and standards
• Self-learner and highly self-motivated
• Creative solution-oriented flexible with a positive attitude and a drive for excellence
• Ability to successfully multi-task and work to tight deadlines
• Accurate with excellent attention to detail

CRITERIA DETAILS: 100 Points

• Strong experience provisioning configuring optimizing Data Pipelines using Azure Synapse - 30 points
• Strong experience with Data Science/ Data Modeling - 30 points
• Strong experience developing Microsoft Power BI reports and dashboards - 30 points
• Experience in an Agile Environment - 10 points

Deliverables

• Include but are not limited to:
• Design and develop features based on the identified requirements
• Build functional mock-ups and assist the Product Owner in User Feedback sessions
• Implement automated tests to ensure quality of the feature
• Fix all associated bugs from the feature development
• Develop required steps for the Deployment Runbook
• Support with investigating and fixing Production bugs
• Documentation and knowledge transfer of implemented feature to the existing team

Additional Terms

• Term: The term of this Engagement Assignment is 241 Business Days. The Engagement Assignment may also be extended for unused Business Days at Agencys discretion.
• The resource will comply with Agency policies and procedures.
• Agency systems cannot be accessed from outside the province of Ontario and Agency assets including laptops and related equipment cannot be removed from the province of Ontario without prior written approval from the Agency.
• Assignment Type: This position is currently listed as Hybrid. The resource under this request will be required to work onsite as per Hiring Manager sole discretion.