Join our team as a Power BI Developer to modernize over 100 operational reports, migrating them from JasperReports to Power BI. In this hybrid role (3 days onsite/2 remote), you will assess, design, and develop dashboards and visualizations using Power BI Desktop, Report Builder, and DAX. You'll leverage strong SQL skills (T-SQL, PL/SQL) and work closely with project teams to ensure report accuracy, accessibility (AODA/WCAG), and effective knowledge transfer. Ideal candidates have experience in BI environments, troubleshooting report issues, and optimizing performance. Strong communication, documentation, and problem-solving skills are essential for success in this role.

 

A Note on Assignment Type:

 

This position is currently listed as "Onsite"; however, the Assignment under this request will provisionally be "Hybrid", working 7.25 hours per calendar day, sometime between 8:00 AM and 5:00 PM (excluding breaks) Monday to Friday inclusive, unless otherwise identified. These conditions are subject to change as the OPS reflects on its current situation. During the duration of the assignment, you will be under the discretion of the Hiring Manager's requirements for the Project you are assigned to.

 

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

 

Assignment Deliverables

 

• 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

Skills

Experience and Skill Set Requirements

A Note on the VOR Master Service Agreement:

 

The VOR Master Service Agreement which expires on April 5, 2025, leaves some Contracts with funding unassigned for fiscal 2025-26. If the current statement of work expires on March 31, 2025, the remaining funds can be used to exercise an option to extend the SOW beyond March 31, 2025, based on business case approvals. Such extensions will be allowable, only if the Master Service Agreement is extended beyond April 5, 2025, and be upon the same terms, conditions, and covenants contained in the SOW.  

 

The start date is subject to change based on security clearances and contract signing timelines.

 

Experience and Skillset Requirements

 

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)

 

Desired Skills and Experience

 

• Technical skills and expertise to design and develop in Jasper Report Tool 
• 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
• Knowledge of ETL tools, such as Azure Data Factory, Microsoft SSDT

 

Resumes Evaluation/Criteria:

 

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)

 

Criteria 2: Analytical and Problem Solving Skills - 30 Points

 

• 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.

 

Criteria 3: Communication Skills - 20 Points

 

• 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 

 

Knowledge Transfer

 

What needs to be KT

• 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)

 

To whom

• Project Manager/Team Members

 

When

• 1:1 meetings / team meetings / documentation on SharePoint site, throughout the duration of the project life cycle etc

Supplier Comments

This position is currently listed as "Onsite"; however, the Assignment under this request will provisionally be "Hybrid", working 7.25 hours per calendar day, sometime between 8:00 AM and 5:00 PM (excluding breaks) Monday to Friday inclusive, unless otherwise identified. These conditions are subject to change as the OPS reflects on its current situation. During the duration of the assignment, you will be under the discretion of the Hiring Manager's requirements for the Project you are assigned to.

 

Max no of submission- 3 (three)

 

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)