RQ07907 - Sr. Report Developer (SQL, Power BI Desktop, DAX, Azure Data Factory, Microsoft SSDT, AODA, WCAG)

RQ07907 - Sr. Report Developer (SQL, Power BI Desktop, DAX, Azure Data Factory, Microsoft SSDT, AODA, WCAG)

720 Bay Street, Toronto

Hyrbid

Contract (9 months, possible extension)

3 Openings

• 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

Must-haves:

• 4 years of experience of demonstrated working knowledge of SQL query languages (T-SQL, PL-SQL) 
• 2+ years experience of demonstrated working knowledge of Power BI Desktop and Power BI Report Builder to design and develop reports and dashboards
• 2+ Demonstrated working knowledge of DAX programming 
• Knowledge of ETL tools, such as Azure Data Factory, Microsoft SSDT
• AODA, WCAG
• Public Sector experience