Requisition Title: PowerBI Programmer/Developer – Level 3
Duration: 12 months
Location: Toronto, ON

Our public sector client is looking for a Power BI Programmer/Developer – Level 3. The Programmer/Developer will provide code enhancements to existing features and new features for operational support for Real Time Data Service and Digital Situational Awareness.

Deliverables:

Review and understand code and architecture of the existing code, and make updates as required to ensure the code is modular and can support scalability requirements
Code enhancements to existing features and new features as per approved requirements and design direction
Provide realistic work estimates to support project planning; capture business requirements and update business rules based on the requirements
Use structured methodologies, design best practices, implement code that is of quality, and clearly documented. The application should function as required, without any defects. The application must operate with the Operating System (OS) and other peripherals as identified
Create custom reports as required, applying Microsoft Technologies
Conduct testing, integration and deployment of the developed changes across the environment
Review, analyze and recommend solutions to any defects discovered in production
Fully document all developed code, and transition in a steady-state to a full-time resource

Must haves:

10+ years of experience with developing code in SQL and Azure SQL. Experience in SQL performance and optimization
Demonstrated experience with power query/power pivot, and being able to combine datasets from different sources
Demonstrated experience with Datafactory, On-Premise data gateway
Experience with and knowledge of UI Design Principles
10+ years of technical data warehousing experience with a focus in the design and development of Business Intelligence
Experience with Azure Analysis Services / SSAS (tabular/multidimensional), SQL Server Reporting Services (SSRS) and Power BI