Employer Active
Assignment: RQ07099 Report Developer Senior
Start Date:
End Date:
Office Location: Onsite / 21 College Avenue Toronto
Organization: Justice Technology Services
Ministry: Ministry of Solicitor General
# Business Days: 166.00 plus Extension # of Days: 272.00
Title: CDT One (1) Report Developer Senior
HYBRID: three (3) days onsite and two (2) days remote (offsite)
Must haves:
Demonstrated working knowledge of Power BI Desktop At least 2 years of experience
Demonstrated working knowledge of SQL query languages (TSQL PLSQL) 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 migration of approximately 270 operational reports from Courts legacy systems to new CDT solution.
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
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 prerelease testing
Work with project team to provide relevant and required documentation to support migration activities and knowledge transfer
Participate in knowledge transfer activities
MANDATORY REQUIREMENTS:
Demonstrated working knowledge of Power BI Desktop At least 2 years of experience
Demonstrated working knowledge of SQL query languages (TSQL PLSQL) At least 4 years of experience
Demonstrated working knowledge of DAX programming (At least 2 years of experience)
SKILLS AND KNOWLEDGE:
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.
CRITERIA:
Criteria 1 Technical Knowledge (50 Points)
Experience / demonstrated ability writing TransactSQL (TSQL) 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 ProblemSolving 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 (TSQL)
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 / reengineered 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 nontechnical team members
Experience preparing documentation
Full Time