Senior Analytics Reporting Specialist to support the migration of our Power BI dashboards from on-premises infrastructure to Microsoft Fabric

• Contract: 12 months + 9 months
• Hybrid of three (3) days in the office and two (2) days work from home. This is the standard and can be adjusted depending on what is required for the project. The client would also like the professional resource to be flexible with their schedule and be onsite when needed. Address: 40 College Street, Toronto, ON, M5G 2J3
• 35 hours per week

This role will support the migration of client's Power BI dashboards from on-premises infrastructure to Microsoft Fabric. This role will also play a critical part in the transition to a new Records Management System (RMS) and database environment. The ideal candidate will bring deep expertise in data visualization, reporting, and stakeholder engagement to help modernize client's analytics capabilities.

Must Haves:

• Proven experience as a Power BI Developer working with enterprise-scale datasets.

• Must have previous experience with development in the Microsoft ecosystem (.Net framework) and specifically in the Microsoft Azure and Power BI.

• Strong expertise in Power BI Dataflows, DAX, and Power Query (M language).

• Hands-on experience designing and building interactive dashboards and reports.

• Solid understanding of data modeling, ETL processes, and relational databases (SQL Server, Azure SQL, or similar).

• Ability to work independently with minimal oversight while engaging stakeholders in a professional, consultative manner.

• Strong communication, presentation, and organizational skills; ability to adapt communication style and message based on audience (peers, stakeholders, executives)

• Bachelor’s in computer science, Information Technology, or a related field

Nice to Have:

• Development experience with geospatial dashboards using Esri ArcGIS technology

Analytics Reporting Specialist:

This role will support the migration of our Power BI dashboards from on-premises infrastructure to Microsoft Fabric. This role will also play a critical part in the transition to a new Records Management System (RMS) and database environment. The ideal candidate will bring deep expertise in data visualization, reporting, and stakeholder engagement to help modernize our analytics capabilities.

Key Responsibilities:

• Design, build, and maintain Power BI dashboards and reports that effectively convey insights and drive decision making

• Optimize existing dashboards and reports for performance, scalability, and usability.

• Implement performance optimization techniques for performance and scalability

• Collaborate with business stakeholders, analysts, and data engineers to gather requirements and translate them into actionable reporting solutions.

• Develop documentation, training, and best practices for end users to maximize adoption of reporting tools.

• Work with the Data Management team and other stakeholders to ensure the team has access to the data required for analytics and insights.

Description of Work:

The work to be carried out includes a comprehensive assessment of the current TPS reporting environment, identification of areas for improvement, and implementation of modern solutions.

This will involve:

• Conducting a thorough analysis of the existing reporting systems and processes.

• Designing and developing a modernized reporting framework that leverages the latest technologies. • Integrating the new framework with existing systems to ensure seamless data flow and compatibility.

• Testing and validating the new reporting environment to ensure it meets the required standards and performance metrics. • Providing training and support to the staff to ensure smooth transition and adoption of the new system. This includes utilizing problem-solving skills to understand requirements and troubleshoot as challenges arise. This individual will apply proven development skills to design, test and knowledge share developed products.

Deliverables:

The deliverables for this project include:

• A detailed assessment report of the current TPS reporting environment.

• A comprehensive design document outlining the new reporting framework along with security and privacy controls and data models. • The developed and integrated modernized reporting system to ensure the designs adhere to data management standards and best practices in collaboration with data analysts, data governance and business partners.

The development of robust, reusable, and scalable data solutions and pipelines for automating the ingestion, processing, and delivery of batch and real-time or near real-time data.

• Test and validation reports demonstrating the performance and reliability of the new system and benchmarking for the data quality.

• Training materials and sessions for the staff.

• Data literacy, data mapping, data quality monitoring and lineage artifacts to ensure that all stakeholders understand the data and its implications.

• Documentation of ETL (Extract, Transform, Load) processes, including detailed descriptions of data extraction, transformation, validation and loading procedures.

• Documentation of business rules and transformations applied to the data to ensure consistency and accuracy.

• A final project report summarizing the work carried out, the outcomes achieved, and recommendations for future improvements.