Business Intelligence Lead; RFT FTE

Position Information

Posting Number: ROM
26-123E
Title: Business Intelligence Lead (RFT 1.0 FTE)
Position Status: Regular Full-time
FTE: 1.0
Job Schedule: Days
Department: Health Information & Data Analytics
Union: Non-union
Site: Royal Ottawa Mental Health Centre
Number of Vacancies: 1

As one of Canada’s foremost mental health care and academic health science centres, The Royal has a clear purpose: to get more people living with mental illness into recovery faster. This is at the core of everything we do and it is driven by the passion, focus and dedication of our employees. Every day, the work that we do transforms the lives of people with mental illness through specialized mental healthcare, advocacy, research and education.

The Business Intelligence Lead is a senior member of the Data & Analytics Team at The Royal and is responsible for enabling data management, analytics, and business intelligence initiatives. This role supports effective data-driven decision making aligned with the organization’s strategic goals by working in close collaboration with clinical and corporate leaders. The incumbent provides mentorship and supervision over the activities of other members of the team in the development of data and advanced analytics solutions to ensure the development of high-quality analytics products.

• Oversee the development of advanced data models, data visualizations, and advanced analytics solutions that translate complex data into actionable insights and align with stakeholder needs, organizational objectives, and digital health initiatives.
• Champion data literacy by supporting change management, training, and adoption of BI tools among non-technical stakeholders.
• Engage internal stakeholders to gather requirements, develop key performance and clinical indicators, prioritize projects, and deliver BI solutions that support patient outcomes, resource optimization, and evidence-informed decision-making.
• Provide leadership, mentorship, and direction to the Data & Analytics team as a senior member of the team, promote best practices, ensure effective delivery.
• Champion data governance, monitor and audit data quality, oversee BI system operations, ensure external reporting compliance (CIHI, MOH, OHA), and compliance with privacy and security regulations (PHIPA, FIPPA), while promoting continuous improvement.
• Participate in the design and development of enterprise data architectures including database management systems and data warehouses, and establish data standards, governance, and security protocols to ensure data integrity, accessibility, and protection.
• Evaluate and adopt emerging BI and analytics technologies (e.g., AI/ML, predictive analytics, cloud-based platforms) to drive innovation and improve analytics capabilities.
• Maintain expertise in database architecture, data integration, and storage technologies; oversee operational support including backup, recovery, infrastructure maintenance, and access/change control processes.
• Validate and monitor data models, analytics deployments, and data extracts to ensure accuracy, consistency, and performance using tools such as Epic Caboodle, Epic Cogito, Power BI, Fabric, SSRS, SQL, and Power Query; apply statistical and data profiling methods to ensure data quality.
• Support BI system implementations, upgrades, and enhancements, and provide services across The Royal’s multi-site organization, including Ottawa and Brockville locations.

• Undergraduate in Computer Science, Information Systems, Data Science, Health Informatics, Business, or a related field required;
  Master’s degree preferred.
• Minimum of 5–7 years of progressively responsible experience in business intelligence, data management, or analytics roles, preferably within healthcare or complex organizational environments.
• Experience with healthcare data systems, standards, and regulatory environments is a significant asset (preferred).
• In‑depth knowledge of performance management and measurement tools, techniques, and frameworks.
• Strong knowledge of data governance, data quality assurance, and compliance frameworks.
• Expertise in database development,…