Talent.com
The Royal Mental Health Centre
Business Intelligence Lead (RFT 1.0 FTE)The Royal Mental Health Centre • Ottawa, Ontario
Business Intelligence Lead (RFT 1.0 FTE)

Business Intelligence Lead (RFT 1.0 FTE)

The Royal Mental Health Centre • Ottawa, Ontario
16 days ago
Salary
CA$58.63 hourly
Job type
  • Full-time
Job description

Position Information

Posting Number: ROM26-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 Level of Police Check: Criminal Record Check Number of Vacancies: 1

About The Royal

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.

POSITION SUMMARY: 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.DUTIES:
  • 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 (., 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.
QUALIFICATIONS:
  • 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, BI/dashboard/report development, and troubleshooting complex data issues.
  • High level of technical proficiency with the Microsoft SQL Server Business Intelligence (BI) stack, including Power BI, Power Query, DAX, and Fabric, to develop innovative data management and analytics solutions.
  • Proficiency in Epic suite of BI tools including Cogito and Caboodle (preferred).
Knowledge, Skills & Abilities
  • Knowledge of Electronic Medical Record (EMR) systems and concepts.
  • Basic knowledge of project management principles and methodologies.
  • Strong analytical skills with the ability to identify problems, develop solutions, and produce clear, well‑structured documentation.
  • Proactive approach to continuous improvement and innovation in data and business intelligence.
  • Excellent oral and written communication skills, with the ability to explain technical concepts to diverse audiences.
  • Strong organizational, prioritization, and time‑management skills to manage multiple priorities and meet deadlines.
  • Strong customer service orientation, with a focus on stakeholder engagement and satisfaction.
  • Experience developing comprehensive documentation, training materials, and reference guides.
  • Familiarity with healthcare security and privacy legislation (., PHIPA, HIPAA).
  • Demonstrated leadership and collaboration skills to guide and support staff effectively.
  • Ability to work in a fast‑paced environment requiring rapid on‑the‑job learning.
REWARDS AND BENEFITS: At The Royal, we are committed to supporting your health, well-being, and financial security at every stage of your career through a comprehensive total rewards package that may include:
  • HOOPP, one of Canada's leading defined benefit pension plans, helping you build long-term financial security with a predictable lifetime retirement income and valuable employer contributions.
  • Competitive health and dental benefits through Medavie Blue Cross (MBC), supporting you and your family's health and wellness needs;
  • Life insurance and disability coverage through Manulife, including short-term and long-term disability benefits where applicable, providing added peace of mind;
  • Employee and Family Assistance Program (EFAP) through Telus Health, offering confidential counselling, wellness resources, and support services for you and your eligible family members (excluded casual staff).
Together, these benefits reflect our commitment to helping you thrive personally and professionally—today, tomorrow, and throughout your career at The Royal Salary Range: $58.63 to $67.97 per hour
Create a job alert for this search

Business Intelligence Lead (RFT 1.0 FTE) • Ottawa, Ontario

Similar jobs

Remote ERP & BI Consultant (Vista & Analytics)

Olsen ConsultingOttawa, ON, CA
Remote
Full-time

A leading consulting firm in Canada is seeking a skilled Consultant (ERP & Business Intelligence) to enhance client business processes through Vista ERP solutions.Role involves providing specialize... Show more

 • Promoted

Intelligence Operator

Canadian Armed Forces | Forces armées canadiennesGatineau, QC, CA
Full-time +1

Canadian Armed Forces | Forces armées canadiennes.Continue with Google Continue with Google.Be among the first 25 applicants.Canadian Armed Forces | Forces armées canadiennes.As a member of the mil... Show more

 • Promoted

Equity Partner & National Leader AI Business Solutions - People Machine

People Machinegatineau, qc, ca
Full-time

Equity Partner & National Leader, AI Business Solutions.This role can be located in any major city centre across Canada.Digital services within the firm.The role will focus on sales, delivery excel... Show more

 • Promoted

AI Team Lead: Strategy, Mentorship & Impact

M-FilesOttawa, ON, CA
Full-time

A global technology enterprise in Fredericton is seeking an experienced AI Team Manager to lead and grow a team focused on delivering scalable AI capabilities.This role combines technical leadershi... Show more

 • Promoted

Expert Microsoft Power BI Tutor Wanted

Varsity Tutors, a Nerdy CompanyOttawa, ON, CA
Full-time

Become an impactful Microsoft Power BI tutor with Varsity Tutors.Help students excel in data visualization remotely while enjoying a flexible schedule and competitive pay.Varsity Tutors is searchin... Show more

 • Promoted

Sr. Director/VP, Data & AI Strategy

AlcumusOttawa, ON, CA
Full-time

Be among the first 25 applicants.Alcumus is the global leader in comprehensive risk management solutions, specializing in high-risk worker qualification and safety compliance.Our technology platfor... Show more

 • Promoted

AI Lead

Super.comOttawa, ON, CA
Full-time

This range is provided by Super.Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.For our employees, our promise is that Super.We are more than a ... Show more

 • Promoted

Business Intelligence Lead

Odyssey GlobalOttawa, ON, CA
Full-time

Be among the first 25 applicants.Get AI-powered advice on this job and more exclusive features.Business Intelligence Lead – Symbio (Government of New Brunswick).Location: Remote (Monthly travel to ... Show more

 • Promoted

Remote Product Manager – Decision Intelligence & Adoption

Cpus Engineering Staffing Solutions Inc.Ottawa, ON, CA
Remote
Full-time

A recruitment agency is looking for a Product Manager.This remote role involves overseeing the design and delivery of a Decision Intelligence data product, engaging with stakeholders, and ensuring ... Show more

 • Promoted

Senior PM: Platform, Data & Intelligence - Remote Canada

Acuity InsightsOttawa, ON, CA
Remote
Full-time

A forward-thinking technology company is seeking a Senior Product Manager to direct the evolution of their platform through strategic product decisions.The successful candidate will navigate comple... Show more

 • Promoted

AI Strategy & Transformation Lead

Human AgencyOttawa, ON, CA
Full-time

A leading AI consultancy is seeking a Chief of Staff for the Managing Director of AI.This role focuses on strategic leadership and AI Process design.Responsibilities include building independent AI... Show more

 • Promoted

Strategic AI Partnerships Lead

FirstPrinciplesOttawa, ON, CA
Full-time

A non-profit organization in Canada seeks a Technical Partnerships Manager to build and manage partnerships that enhance research infrastructure.The role focuses on collaborating with technology pr... Show more

 • Promoted

Defence & Intelligence Account Executive

Computacenter AG & Co. oHGOttawa, ON, CA
Full-time

We are seeking a highly motivated and experienced Sales Account Manager to join our team.This position will be responsible for managing and growing our relationship with the Department of National ... Show more

 • Promoted

Remote Biostatistics Consulting Lead

AlimentivOttawa, ON, CA
Remote
Full-time

A leading statistical consulting firm is seeking a Consulting Statistician to work remotely in Canada or the USA.This role involves statistical consulting, analysis, and guiding clients in clinical... Show more

 • Promoted

BDR: AI-Powered Ecommerce Growth

ClearcoOttawa, ON, CA
Full-time

A leading fintech company in Canada is looking for results-driven Business Development Representatives (BDRs) to join their team.This role focuses on generating qualified opportunities through outr... Show more

 • Promoted

Lead Analytics Strategy for Innovative CPG Business Intelligence

Viral NationOttawa, ON, CA
Full-time

Drive impactful analytics as a Director of Business Intelligence in a dynamic environment.Lead a high-performing team to transform data into strategic insights for consumer packaged goods.In this l... Show more

 • Promoted

AI-Driven Analytics Leader

CSC GenerationOttawa, ON, CA
Full-time

Transform insights into actions as an AI-Driven Analytics Leader.Spearhead the analytical strategy, ensuring data quality and effective decision-making across eCommerce and operations.This pivotal ... Show more

 • Promoted

IDC Research Director for Telecom Insights

Idc-Research-Inc.Ottawa, ON, CA
Full-time

Drive significant impact as IDC's Research Director specializing in Telecom Insights.This senior role emphasizes strategic oversight and advanced market research in telecommunications.You will lead... Show more

 • Promoted

AI Implementation and Research Director

Info-Tech Research GroupOttawa, ON, CA
Full-time

Shape the future of applied AI by directing client engagements and system prototyping.This position melds hands-on delivery with innovative research to enhance AI applications.The AI Implementation... Show more

 • Promoted

Senior BD & AI Partnerships Lead (Remote)

VosynOttawa, ON, CA
Remote
Full-time

A pioneering AI company is looking for a Senior Strategic Business Development Subject Matter Expert to drive market expansion and optimize fundraising strategies.This fully remote role demands ove... Show more