HM Note: This hybrid contract role is in office at the managers discretion. Candidates resume must include first and last name.
Description
Scope
- Provide planning assessment and development effort to complete the conversion of 100 operational reports and dashboards from JasperReports to PowerBI and nbsp;
- 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
and nbsp;
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 Skillset Requirements
and nbsp;
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)
and nbsp;
Desired Skills and Experience
- Technical skills and expertise to design and develop in Jasper Report Tool and nbsp;
- 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
and nbsp;
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)
and nbsp;
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 and nbsp;
and nbsp;
Knowledge Transfer
and nbsp;
What needs to be KT
- All documentation relating to the technology designs and technology knowledge specific to the candidates assignment. and nbsp;All information gathered while working with vendors and internal solutions to be shared. and nbsp;Any best practices work around lessons learned must be documented
- Codes
- Scripts
- Power BI report and dashboard specifications (PBIX files)
and nbsp;
To whom
- Project Manager/Team Members
and nbsp;
When
- 1:1 meetings / team meetings / documentation on SharePoint site throughout the duration of the project life cycle etc.
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)