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