Our client seeks an experienced Report Developer to contribute to the Business Intelligence (BI) initiatives of its program areas. The selected candidate will design and deliver data-driven solutions, focusing on building reports, dashboards, and visualizations that align with functional and non-functional requirements. This role requires a strong grasp of Power BI, DAX programming, and SQL query languages, with a keen focus on data accuracy, accessibility standards, and collaborative team efforts.
...
Advantages
• Competitive salary and benefits package.
• Work on exciting public-sector projects with real-world impact.
• Opportunities for professional growth and development.
• Collaborative and inclusive team environment.
Responsibilities
• Provide planning, assessment, and development effort to meet workload demand of the BI reporting enablement activity, which support program areas within the Ministry of Attorney General.
• Work with a Project Manager and Business Areas to evaluate requirements and develop reports/dashboards/data visualizations, utilizing Power BI Desktop, Power BI Report Builder (based on best fit to meet requirements).
• Work with project team to ensure reports/dashboards/data visualizations are properly reviewed for quality assurance and compliance with the Web Content Accessibility Guidelines 2.1 Level AA.
• Work with project team to complete all relevant and required documentation, such as knowledge transfer, and communication, to support the completion of the project.
• Participate in requirements gathering sessions to understand the functional and non-functional needs.
• Perform assessment, and define approach in collaboration with project team and stakeholder to successfully deliver effective BI Solutions.
• Perform design and development activities to produce reports/dashboards/data visualizations within Power BI Desktop or Power BI Report Builder.
• Perform troubleshooting and apply corrective actions to resolve issues with BI Solutions discovered during pre-release testing.
• Work with project team to provide relevant and required documentation to support migration activities and knowledge transfer.
• Participate in knowledge transfer activities.
Knowledge to be Transferred:
• All documentation relating to the technology designs and technology knowledge specific to the candidate’s assignment All information gathered while working with vendors and internal solutions to be shared Any best practices, work around, lessons learned must be documented.
• Codes.
• Scripts.
• Power BI report and dashboard specifications (PBIX files).
Knowledge to be Transferred to: Project Manager / Team members.
Qualifications
• Experience working in a business intelligence team/ environment, developing and delivering business intelligence and/or analytical reports and dashboards.
• Experience working with Power BI Desktop, and Power BI Report Builder to design and develop reports and dashboards and work with team members to explore options to redesign outdated reports.
• Experience writing and working with Microsoft Power BI DAX code to implement business logic within Power BI reports.
• Experience performing troubleshooting of SQL queries, business intelligence and analytical reports, as well as performing data analysis to complete data validation and ensure report accuracy.
• Knowledge of Microsoft SQL Server, and Oracle databases.
• Knowledge of ETL tools, such as Azure Data Factory, Microsoft SSDT.
Mandatory Requirements:
• Demonstrated working knowledge of Power BI Desktop [At least 2 years of experience]
• Demonstrated working knowledge of SQL query languages (T-SQL, PL-SQL) [At least 4 years of experience]
• Demonstrated working knowledge of DAX programming (At least 2 years of experience)
Summary
This is an exciting opportunity to make an impactful contribution to government business intelligence initiatives through innovative reporting and data visualization.
If interested and qualified for this role, please apply today for immediate consideration!
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
Our client seeks an experienced Report Developer to contribute to the Business Intelligence (BI) initiatives of its program areas. The selected candidate will design and deliver data-driven solutions, focusing on building reports, dashboards, and visualizations that align with functional and non-functional requirements. This role requires a strong grasp of Power BI, DAX programming, and SQL query languages, with a keen focus on data accuracy, accessibility standards, and collaborative team efforts.
Advantages
• Competitive salary and benefits package.
• Work on exciting public-sector projects with real-world impact.
• Opportunities for professional growth and development.
• Collaborative and inclusive team environment.
Responsibilities
• Provide planning, assessment, and development effort to meet workload demand of the BI reporting enablement activity, which support program areas within the Ministry of Attorney General.
• Work with a Project Manager and Business Areas to evaluate requirements and develop reports/dashboards/data visualizations, utilizing Power BI Desktop, Power BI Report Builder (based on best fit to meet requirements).
...
• Work with project team to ensure reports/dashboards/data visualizations are properly reviewed for quality assurance and compliance with the Web Content Accessibility Guidelines 2.1 Level AA.
• Work with project team to complete all relevant and required documentation, such as knowledge transfer, and communication, to support the completion of the project.
• Participate in requirements gathering sessions to understand the functional and non-functional needs.
• Perform assessment, and define approach in collaboration with project team and stakeholder to successfully deliver effective BI Solutions.
• Perform design and development activities to produce reports/dashboards/data visualizations within Power BI Desktop or Power BI Report Builder.
• Perform troubleshooting and apply corrective actions to resolve issues with BI Solutions discovered during pre-release testing.
• Work with project team to provide relevant and required documentation to support migration activities and knowledge transfer.
• Participate in knowledge transfer activities.
Knowledge to be Transferred:
• All documentation relating to the technology designs and technology knowledge specific to the candidate’s assignment All information gathered while working with vendors and internal solutions to be shared Any best practices, work around, lessons learned must be documented.
• Codes.
• Scripts.
• Power BI report and dashboard specifications (PBIX files).
Knowledge to be Transferred to: Project Manager / Team members.
Qualifications
• Experience working in a business intelligence team/ environment, developing and delivering business intelligence and/or analytical reports and dashboards.
• Experience working with Power BI Desktop, and Power BI Report Builder to design and develop reports and dashboards and work with team members to explore options to redesign outdated reports.
• Experience writing and working with Microsoft Power BI DAX code to implement business logic within Power BI reports.
• Experience performing troubleshooting of SQL queries, business intelligence and analytical reports, as well as performing data analysis to complete data validation and ensure report accuracy.
• Knowledge of Microsoft SQL Server, and Oracle databases.
• Knowledge of ETL tools, such as Azure Data Factory, Microsoft SSDT.
Mandatory Requirements:
• Demonstrated working knowledge of Power BI Desktop [At least 2 years of experience]
• Demonstrated working knowledge of SQL query languages (T-SQL, PL-SQL) [At least 4 years of experience]
• Demonstrated working knowledge of DAX programming (At least 2 years of experience)
Summary
This is an exciting opportunity to make an impactful contribution to government business intelligence initiatives through innovative reporting and data visualization.
If interested and qualified for this role, please apply today for immediate consideration!
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
