Are you passionate about turning complex data into clear, actionable insights? Do you excel in designing dynamic dashboards and developing end-to-end BI solutions? Our client seeks a Business Intelligence Specialist to lead the transformation of enterprise reporting from legacy platforms to Power BI, enhancing data visibility across departments. This is a key opportunity to contribute to one of the largest report modernization initiatives for the 2025–2026 fiscal year.
...
Advantages
- Contribute to the conversion of ~900 legacy reports into modern Power BI dashboards
- Work in a collaborative public sector environment on high-visibility BI and analytics initiatives
- Hybrid flexibility – 3 days onsite, 2 days remote
- Leverage your experience across Azure technologies, Power BI, and enterprise data models
Responsibilities
- Lead the report conversion activities from BOEXI to Power BI reports estimated up to 900 for 2025-26 fiscal year.
- Supports Client’s wide-ranging business information requirements, implementing and supporting business intelligence software solutions.
- Develops and supports customized query applications which analyze key business data.
- Develops and supports guided analysis and drill-down functionality, routine scheduling and notification of report generation, and effective implementation of “opportunity” and “key-trend” alerts.
- Provides Clients with approach options and tools for managing business-related data in a manner that assists in quantitative analysis of progress and the relationship between operational actions and their effect on business objectives.
- Conduct workshops and requirements-gathering sessions with clients on BI & Data Analytics Initiative.
- Conduct data integration, data cleansing, data modeling and analytics.
- Develop feedback processes to fix corrupt data in the source systems.
Qualifications
Must Haves:
- Experience using Power BI and other data visualization tools to create reports and dashboards, perform data exploration, and manage datasets.
- Expertise designing interactive and visually appealing reports and dashboards using Power BI Desktop, including selecting appropriate visualizations and arranging elements for clarity.
- Experience in performing DAX formulas and functions for performing calculations, aggregations, and custom calculations in Power BI.
- Understanding of good UI design in delivering rich user experience by creating custom visuals and themes in Power BI to enhance report aesthetics and functionality.
General Skills:
- Experience analyzing data in source systems to identify data cleanliness issues (e.g. missing values, duplicate meanings, and invalid data).
- Experience developing feedback processes to fix corrupt data in the source systems.
- Experience developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide range of data repositories (structured and semi-structured files, relational and multi-dimensional data stores).
- Experience developing, implementing and maintaining schedule/dependency logic for Extract Transform Load (ETL) scripts.
- Experience developing monitoring and error notification processes to ensure data is updated as designed.
- Experience developing automation extraction, cleansing and load scripts.
- Experience designing visual dashboards to highlight trends and Key Performance Indicators (KPIs), and developing canned reports (scheduled and ad-hoc).
- Proven troubleshooting and analytical experience.
- Experience in process decomposition/mapping and business process re-engineering and complex data models using UML.
- Experience in the use of development tools and business re-engineering software.
- Experience in developing enterprise architecture deliverables (e.g. business, logical, and physical models) based on Enterprise Application Processes and Modeling methodology and guidelines.
- Experience with the Microsoft suite of technology, including: Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI.
- Experience with data modeling and design principles for data marts and data warehouses.
Desirable Skills:
- Knowledge and experience in developing data analysis applications.
- Knowledge and understanding of Information Management principles, concepts, policies and practices.
- Ability to provide expert advice in developing and integrating process and information models to enable identifying and eliminating redundant business processes.
- Experience with developing monitoring and error notification processes to ensure data is updated as designed.
- Hands-on experience working with stakeholders to develop and document interface specifications design between Business Intelligence solutions and external applications.
- Extensive experience with conceptual, logical and physical data modelling tools like Power Designer and Visio.
- Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards.
Summary
Our client is looking for a Business Intelligence Specialist to lead enterprise-wide reporting modernization using Power BI and Azure data tools. If you’re a BI expert with a keen eye for data storytelling, interface design, and technical excellence, this opportunity offers the chance to work at scale and help reshape how data supports public service delivery.
Also, remember that updating your profile on Randstad.ca helps us find you faster when we have roles that match your skills! So, even if this role isn’t for you, please update your profile so we can find you!
We look forward to supporting you in your job search! Good luck!
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
show more
Are you passionate about turning complex data into clear, actionable insights? Do you excel in designing dynamic dashboards and developing end-to-end BI solutions? Our client seeks a Business Intelligence Specialist to lead the transformation of enterprise reporting from legacy platforms to Power BI, enhancing data visibility across departments. This is a key opportunity to contribute to one of the largest report modernization initiatives for the 2025–2026 fiscal year.
Advantages
- Contribute to the conversion of ~900 legacy reports into modern Power BI dashboards
- Work in a collaborative public sector environment on high-visibility BI and analytics initiatives
- Hybrid flexibility – 3 days onsite, 2 days remote
- Leverage your experience across Azure technologies, Power BI, and enterprise data models
Responsibilities
- Lead the report conversion activities from BOEXI to Power BI reports estimated up to 900 for 2025-26 fiscal year.
- Supports Client’s wide-ranging business information requirements, implementing and supporting business intelligence software solutions.
- Develops and supports customized query applications which analyze key business data.
...
- Develops and supports guided analysis and drill-down functionality, routine scheduling and notification of report generation, and effective implementation of “opportunity” and “key-trend” alerts.
- Provides Clients with approach options and tools for managing business-related data in a manner that assists in quantitative analysis of progress and the relationship between operational actions and their effect on business objectives.
- Conduct workshops and requirements-gathering sessions with clients on BI & Data Analytics Initiative.
- Conduct data integration, data cleansing, data modeling and analytics.
- Develop feedback processes to fix corrupt data in the source systems.
Qualifications
Must Haves:
- Experience using Power BI and other data visualization tools to create reports and dashboards, perform data exploration, and manage datasets.
- Expertise designing interactive and visually appealing reports and dashboards using Power BI Desktop, including selecting appropriate visualizations and arranging elements for clarity.
- Experience in performing DAX formulas and functions for performing calculations, aggregations, and custom calculations in Power BI.
- Understanding of good UI design in delivering rich user experience by creating custom visuals and themes in Power BI to enhance report aesthetics and functionality.
General Skills:
- Experience analyzing data in source systems to identify data cleanliness issues (e.g. missing values, duplicate meanings, and invalid data).
- Experience developing feedback processes to fix corrupt data in the source systems.
- Experience developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide range of data repositories (structured and semi-structured files, relational and multi-dimensional data stores).
- Experience developing, implementing and maintaining schedule/dependency logic for Extract Transform Load (ETL) scripts.
- Experience developing monitoring and error notification processes to ensure data is updated as designed.
- Experience developing automation extraction, cleansing and load scripts.
- Experience designing visual dashboards to highlight trends and Key Performance Indicators (KPIs), and developing canned reports (scheduled and ad-hoc).
- Proven troubleshooting and analytical experience.
- Experience in process decomposition/mapping and business process re-engineering and complex data models using UML.
- Experience in the use of development tools and business re-engineering software.
- Experience in developing enterprise architecture deliverables (e.g. business, logical, and physical models) based on Enterprise Application Processes and Modeling methodology and guidelines.
- Experience with the Microsoft suite of technology, including: Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI.
- Experience with data modeling and design principles for data marts and data warehouses.
Desirable Skills:
- Knowledge and experience in developing data analysis applications.
- Knowledge and understanding of Information Management principles, concepts, policies and practices.
- Ability to provide expert advice in developing and integrating process and information models to enable identifying and eliminating redundant business processes.
- Experience with developing monitoring and error notification processes to ensure data is updated as designed.
- Hands-on experience working with stakeholders to develop and document interface specifications design between Business Intelligence solutions and external applications.
- Extensive experience with conceptual, logical and physical data modelling tools like Power Designer and Visio.
- Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards.
Summary
Our client is looking for a Business Intelligence Specialist to lead enterprise-wide reporting modernization using Power BI and Azure data tools. If you’re a BI expert with a keen eye for data storytelling, interface design, and technical excellence, this opportunity offers the chance to work at scale and help reshape how data supports public service delivery.
Also, remember that updating your profile on Randstad.ca helps us find you faster when we have roles that match your skills! So, even if this role isn’t for you, please update your profile so we can find you!
We look forward to supporting you in your job search! Good luck!
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
show more
