Report Developer

Job Title: Report Developer

Location: Toronto

Work Model: Onsite

Duration: 12 months

Security Clearance: CRJMC

Must Haves

• Demonstrated working knowledge of Power BI Desktop, and Power BI Paginated Report Builder [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]
• Demonstrated work knowledge of ETL tools, such as Microsoft Azure Data Factory, and Data Bricks, as well as data modelling methodologies. [At least 2 years' experience]

Description / Responsibilities / Skills

Description

• The Justice IT Cluster provides Business Intelligence, and Analytics services to the Ministry of the Attorney General (MAG) and its program areas.
• The Justice Sector BI Enablement initiative was established to address an increased demand for BI development services.
• The Report Developer position will play a vital role in the analysis, translation and development of Power BI reports to support several requests for decision support products (i.e., Power BI Dashboards and reports).

Scope

• 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, model/process data (I.e., Extract, Transform and Loading (ETL) & data warehousing) and develop reports/dashboards/data visualizations.
• 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

Knowledge Transfer

• All documentation relating to the technology designs and technology knowledge specific to the candidate's assignment
• 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.

Deliverables

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

Experience & Skill Set Requirements

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 using ETL tools, such as Microsoft Azure Data Factory, and Data Bricks, as well as data modelling methodologies. [At least 2 years' 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

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

Desired Skills and Experience

• 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, IBM InfoSphere DataStage, etc.