The Role
Job Title: RQ07907 - Report Developer - Senior
Client: Ministry of Treasury Board Secretariat
Work Location: 720 Bay Street, Toronto, Ontario, Hybrid
Estimated Start Date: 2025-07-28
Estimated End Date: 2026-03-05
#Business Days: 150.00
Extension: 188.00
Hours per day or Week: 7.25 hours per day
Security Level: CRJMC
Must haves:
Scope
Criteria 1: Technical Knowledge - 50 Points
Client: Ministry of Treasury Board Secretariat
Work Location: 720 Bay Street, Toronto, Ontario, Hybrid
Estimated Start Date: 2025-07-28
Estimated End Date: 2026-03-05
#Business Days: 150.00
Extension: 188.00
Hours per day or Week: 7.25 hours per day
Security Level: CRJMC
Must haves:
- 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)
Scope
- Provide planning, assessment, and development effort to complete the conversion of 100+ operational reports and dashboards from JasperReports to PowerBI
- Work with Project manager and Business Areas to evaluate and modernize reports, where applicable
- Migrate report functionality to Power BI Desktop or Power BI Report Builder based on Project Team assessment
- 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 reporting needs assessment to understand the functionality and design of the current operational reports in use
- Perform assessment, and define approach in collaboration with project team and stakeholder to migrate operational reports to appropriate CDT solution standard reporting features or to a Power BI tool (i.e., Desktop or Report Builder)
- Perform design and development activities to migrate operational reports to Power BI in alignment with OPS Standards and Guidelines (i.e., AODA, WCAG 2.0 Level AA)
- Perform troubleshooting and apply corrective actions to resolve issues with migrated reports and dashboards 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
Criteria 1: Technical Knowledge - 50 Points
- Experience / demonstrated ability writing Transact-SQL (T-SQL) queries (at least 4 years of experience)
- Experience / demonstrated ability working with Power BI Desktop, and Power BI Report Builder to design and develop reports and dashboards (at least 2 years of experience)
- Experience / demonstrated ability writing DAX code, perform data modelling and implement functionality within Power BI reports and dashboards (at least 2 years of experience)
- Experience / demonstrated ability to perform technical troubleshooting, specifically within a business intelligence environment / team or against reports, dashboards, and database queries such as Transact SQL (T-SQL)
- Experience / demonstrated ability to analyze data to resolve data quality issues and perform report validation
- Demonstrated experience working within a team environment to troubleshoot and resolve technical problems
- Ability to provide analysis, developing and implementing approved new / re-engineered business process standards.
- Oral and written communication skills, interpersonal and consultative skills, facilitation skills
- Demonstrated experience working in a team environment, contributing to team meetings on work progress, communicating risks and issues, providing results from work assessments, and explaining technical tasks to non-technical team members
- Experience preparing documentation
Similar Jobs
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
SMSS Inc. is the best solution company specialized in providing Information Technology and Management Consulting. We provide value for money to our clients by delivering the best quality technical services and solutions at reasonable rates. We also provide the best working environment for our staff and consultants. It is a growing IT services provider having wide array of solutions from Business Strategy Analysis to implementation and execution of Information Technology as well as management aspects of a business entity.
