Senior Report Developer (Power BI)

Senior Report Developer (Power BI)

Duration: 243250 Days
Location: Onsite (5 Days/Week)
Hours: 7.25 hours/day between 8:00 AM 5:00 PM
Client: Ontario Public Sector (OPS)

Position Overview

The Senior Report Developer will support the migration of approximately 270 operational reports from legacy court systems to the new Court Digital Transformation (CDT) solution. The resource will assess existing reports recommend modernization opportunities and redesign develop test and implement reports using Power BI Desktop and Power BI Report Builder while ensuring compliance with OPS standards accessibility requirements and reporting best practices.

Key Responsibilities

Report Assessment & Migration

• Analyze existing operational reports and reporting requirements.
  
• Conduct reporting needs assessments with business stakeholders.
  
• Evaluate report functionality and determine migration approach.
  
• Modernize legacy reports where appropriate.
  
• Migrate reports to:
  • Power BI Desktop
    
  • Power BI Report Builder
    
  • CDT standard reporting solutions
    

Design & Development

• Design and develop Power BI reports and dashboards.
  
• Create and optimize Power BI data models.
  
• Develop DAX calculations measures and business logic.
  
• Write and optimize SQL queries using T-SQL and PL/SQL.
  
• Build reporting solutions aligned with business intelligence and analytics requirements.
  
• Design build and test databases and reporting objects.
  

Testing & Troubleshooting

• Perform report validation and reconciliation activities.
  
• Troubleshoot data quality and reporting issues.
  
• Resolve defects identified during testing.
  
• Support pre-release testing activities.
  
• Validate migrated reports against business requirements.
  

Business Intelligence & Analytics

• Design and deploy data models optimized for reporting and analytics.
  
• Support advanced analytics and business intelligence initiatives.
  
• Conduct prototyping and proof-of-concept activities.
  
• Integrate reporting solutions with third-party systems.
  

Documentation & Knowledge Transfer

• Produce technical and functional documentation.
  
• Document report specifications data mappings and development standards.
  
• Provide knowledge transfer to project teams and OPS staff.
  
• Share lessons learned best practices scripts code and report artifacts.
  

Mandatory Qualifications

Power BI Development

• Minimum 2 years experience with:
  • Power BI Desktop
    
  • Power BI Report Builder
    
• Experience designing and developing reports dashboards and data visualizations.
  

SQL Development

• Minimum 4 years experience with:
  • T-SQL
    
  • PL/SQL
    
• Strong experience writing complex queries and database analysis.
  

DAX Development

• Minimum 2 years experience with:
  • DAX measures
    
  • Calculated columns
    
  • Advanced Power BI functionality
    

Preferred Qualifications

• Experience building enterprise reporting and dashboard solutions.
  
• Data modelling expertise for Business Intelligence environments.
  
• Financial reporting and data reconciliation experience.
  
• ETL development experience using:
  • Azure Data Factory (ADF)
    
  • SQL Server Data Tools (SSDT)
    
• Experience integrating data from multiple systems.
  
• Prototyping and requirements gathering experience.
  
• Experience implementing BI and analytics solutions in large organizations.
  

Technical Skills

Reporting & Analytics

• Power BI Desktop
  
• Power BI Report Builder
  
• Power BI Service
  
• DAX
  
• Data Visualization
  
• Dashboard Development
  
• Report Migration
  

Database Technologies

• SQL Server
  
• T-SQL
  
• PL/SQL
  
• Database Design
  
• Query Optimization
  

Data Integration

• Azure Data Factory (ADF)
  
• ETL Processes
  
• SQL Server Data Tools (SSDT)
  
• Data Modelling
  

Accessibility & Compliance

• AODA Compliance
  
• WCAG 2.0 Level AA
  
• OPS Standards and Guidelines
  

Evaluation Criteria

1. Technical Knowledge (50%)

• Power BI Desktop & Report Builder development
  
• DAX programming
  
• T-SQL development
  
• Data modelling
  
• ETL tools (ADF SSDT)
  
• Dashboard and report development
  

2. Analytical & Problem Solving Skills (30%)

• Troubleshooting BI solutions
  
• Data quality analysis
  
• Report validation
  
• Complex reporting implementations
  
• Performance optimization
  

3. Communication Skills (20%)

• Stakeholder engagement
  
• Documentation preparation
  
• Knowledge transfer
  
• Team collaboration
  
• Ability to explain technical concepts to non-technical audiences
  

Ideal Candidate Profile

The ideal candidate will be a senior Power BI developer with strong experience in report migration projects advanced SQL development DAX programming data modelling and business intelligence solutions. Experience working within Ontario Public Sector or large government environments combined with knowledge of AODA/WCAG accessibility standards would be highly beneficial. The candidate should demonstrate strong analytical abilities stakeholder communication skills and experience delivering enterprise-scale reporting solutions.

Required Skills:

Mandatory Skills & Experience Cloud & Infrastructure Engineering Proven experience designing deploying and maintaining hybrid infrastructure environments across: Microsoft Azure Amazon Web Services (AWS) Linux-based environments SaaS solutions COTS solutions On-premises systems Strong experience with Windows and Linux server administration including: CentOS Ubuntu CoreOS Experience supporting modern web technology stacks including: LAMP MEAN Drupal Elasticsearch Experience with virtualization platforms storage solutions networking and enterprise infrastructure services. Strong understanding of cloud architecture frameworks technology assessments and cloud solution strategies. Identity & Access Management Experience managing and supporting identity and access controls using: Active Directory Microsoft Entra ID Enterprise IAM solutions Experience implementing authentication authorization and access governance controls. DevOps & CI/CD Automation Strong experience designing building and administering CI/CD pipelines for continuous integration and deployment. Experience with development and collaboration tools including: Azure DevOps JIRA Confluence Maven Jenkins Experience with Infrastructure as Code (IaC) and version-controlled deployments. Strong knowledge of DevOps methodologies automation frameworks and release management best practices. Experience with containerization and orchestration technologies including: Docker Kubernetes AKS / EKS Experience automating operational and compliance-related activities using: PowerShell Bash Python Programming & Scripting Hands-on experience with scripting and programming languages including: Python Bash PHP Java JavaScript Experience with build and configuration management tools including: Git Ansible Chef Puppet API & Integration Experience Experience building and consuming APIs and integration endpoints. Experience integrating cloud platforms enterprise systems and deployment pipelines. Understanding of enterprise integration architectures and service-based deployments. Security Monitoring & Compliance Strong understanding of infrastructure security cloud security and DevOps security best practices including: Least privilege access Secure logging Secrets management Vulnerability remediation Experience with security and monitoring tools including: Radware Dynatrace Splunk Azure Monitor / Log Analytics AWS CloudTrail / CloudWatch ELK Stack / SIEM solutions Experience implementing centralized audit logging and monitoring across enterprise platforms. Ability to support internal and external audits through reporting evidence gathering and log analysis. Experience supporting forensic investigations audit remediation and incident reviews. Familiarity with Government of Ontario I&IT Directives Policies and Information Technology Standards. Release Management & Operational Support Experience coordinating infrastructure and application releases across technical and business teams. Knowledge of change management processes deployment approvals rollback planning and release governance. Experience with release readiness reviews deployment validation and post-release monitoring. Ability to maintain release documentation operational records and audit artifacts. Project Management & Communication Strong project planning coordination and resource management skills. Experience with roadmap planning modernization initiatives and infrastructure investment planning. Strong stakeholder communication and cross-functional collaboration skills. Ability to explain complex technical concepts to business users leadership teams and non-technical stakeholders. Strong documentation reporting presentation and technical writing skills. Mobile Device Management Experience supporting mobile device management for cellular devices and tablets across multiple platforms and operating systems. Desirable Skills Experience supporting Government of Ontario enterprise environments. Experience with enterprise modernization and cloud transformation initiatives. Familiarity with enterprise governance compliance frameworks and audit readiness programs. Experience mentoring and coaching junior DevOps and infrastructure resources. Strong understanding of operational resilience disaster recovery and enterprise monitoring strategies. Additional Information Strong hands-on DevOps cloud infrastructure automation CI/CD security and enterprise release management experience is mandatory for this role.

Employment Type : Full Time
Experience: years
Vacancy: 1
Monthly Salary Salary: 70 - 70