Our valued not-for-profit client is seeking a Senior PowerBI Developer to develop Power BI data models, dashboards, reports, and semantic models for a non-profit client!
Initial 1-year contract in Ottawa, ON, with possibility of extension. Candidates with the ability to work on-site downtown Ottawa 3 days/week will be prioritized. 8 hours per day, Monday to Friday.
As the successful candidate, you will be supporting the introduction of a modern, cloud-based, data platform leveraging Azure and related data services; enabling capabilities for secure data / analytic sharing with external partners and stakeholders. You will be working as a member of the project team supporting this initiative; developing and delivering technology proof-of-concepts (POCs), architectural recommendations, and design documentation to support scalable Power BI operations and enterprise data processing in Microsoft Azure.
Responsibilities:
1. Design, develop, and deploy ETL/ELT components, Power BI data models, dashboards, reports, and semantic models, including associated technical specifications and development artifacts.
2. Implement Microsoft Fabric deployment standards, governance controls, and best practices, including workspace architecture, environment lifecycle management (Dev/Test/Prod), security configuration (RBAC, RLS), lineage tracking, monitoring, and performance optimization.
3. Produce comprehensive test cases, test scripts, and documentation of test execution results, defect logs, and evidence to ensure solution quality and validation.
4. Prepare end-user documentation, including user guides and operational materials, and provide regular status reporting on progress, deliverables, risks, and issues.
5. Design, develop, and deploy Power BI reports, dashboards, and semantic models aligned to business requirements.
6. Build and optimize data models integrating multiple enterprise data sources, applying best practices in star schema design, DAX, performance tuning, and usability.
7. Configure role-based access control (RBAC), data security policies, row-level security (RLS), and sensitivity labels.
8. Establish monitoring, capacity management, and performance optimization practices within Fabric.
9. Develop and maintain technical documentation, including architecture diagrams, data flow documentation, and operational procedures.
10. Share best practices and promote BI standards across the development team.
11. Execute Power BI report testing, document results, and support issue resolution.
12. Support clients during User Acceptance Testing (UAT) cycles.
Must Have Skills:
13. 5+ years' years of experience designing, developing, and implementing Microsoft Power BI dashboards and reporting solutions, including advanced data modeling using DAX (calculated columns, measures, and calculated tables).
14. 5+ years work experience with Microsoft Azure data platform: Azure Databricks, SQL Databases, Azure Data Lake.
15. Experience with additional programming languages is an asset: Scala, Python, R, SQL, Azure functions.
16. Minimum 5 years experience with the following:
17. Experience in systems development with analysis, design, development, testing and deployment of software systems.
18. Experience with the implementation of batch and stream data processing pipelines
19. Experience writing complex SQL queries, performance tuning and data optimization
20. Designing, developing, implementing, and testing data solutions for reporting applications such as Power BI
Nice-to-Have Skills:
21. Demonstrated experience delivering large-scale data analytics and business intelligence projects within complex enterprise environments.
22. Demonstrated experience deploying, administering, and governing Microsoft Fabric environments, including workspace architecture, implementation of security controls (RBAC, RLS, data security policies, sensitivity labeling), and establishment of monitoring, capacity planning, and performance optimization practices aligned with organizational governance standards.
23. Demonstrated experience working in Agile delivery environments, including sprint-based development using Azure DevOps.