Business Intelligence Developer (RFT 1.0 FTE)

The Royal Ottawa Health Care Group is looking for a skilled Business Intelligence Developer to join its data and analytics team onsite in Ottawa, Canada. This Regular Full Time (RFT) 1.0 FTE position will design, build, and maintain data models, integration pipelines, dashboards, and reporting solutions that keep the organization’s data environment accurate, secure, and performant.

The role is well suited to someone who enjoys turning complex data into clear, actionable insights for operational, clinical, and executive audiences. The Royal Ottawa Health Care Group operates across multiple sites and relies on a mature BI culture to support patient care and decision-making. If you excel at partnering with users, IT, and external partners to deliver reliable analytics services, this could be a strong fit.

Based in Ottawa, you will contribute to enterprise projects and ongoing data initiatives that impact care delivery and business operations, using a Microsoft-based analytics stack and Epic data where appropriate.

The Work You’ll Do as a BI Developer

The role centers on translating validated requirements into scalable BI solutions for large healthcare systems, and it involves designing and maintaining data models, data dictionaries, data maps, and metadata repositories to support data integrity and governance.

You’ll build and optimize dashboards, KPIs, data queries, and reports that inform operational, clinical, and executive decisions, while applying knowledge of OLAP/OLTP data modeling and ETL/ELT practices to keep performance strong.

Using Epic EMR data alongside industry-standard BI tools, you’ll develop, configure, and support data-driven applications, and you’ll manage ETL/ELT processes that integrate data from multiple sources, ensuring accuracy, governance compliance, and overall system performance.

As a liaison between users, IT, and external partners, you’ll gathered reporting and analytics requirements, provide training and support, and strive to deliver consistent analytics services across The Royal’s multi-site organization.

Maintenance and improvement of BI infrastructure will also be part of your remit, including performance tuning, upgrades, issue resolution, and ongoing development practices around data governance and documentation. You’ll participate in enterprise projects such as Epic implementation, data migration, system integration, and digital transformation initiatives.

The Right Candidate for This BI Developer Role

• Post-secondary diploma or degree in Computer Science, Information Technology, Software Engineering, or a related discipline.
• Minimum 4–5 years of progressive experience in business intelligence, data warehousing, and reporting development.
• Demonstrated experience with the Microsoft reporting and analytics ecosystem, including SQL Server, SQL Server Management Studio (SSMS), Azure Data Studio/Visual Studio Code, Microsoft Fabric, Power BI, Power Apps, Power Automate, and related Microsoft data and analytics technologies; advanced knowledge of relational databases, data warehousing, business intelligence, and dimensional modeling techniques.
• Proven expertise in OLAP/OLTP data modeling, ETL processes, and performance optimization.
• Experience applying Microsoft data and analytics tools to build, automate, and maintain reporting solutions in an enterprise environment.
• Skilled in data quality troubleshooting, data virtualization, and report automation.
• Demonstrated ability to manage multiple projects, collaborate with cross-functional teams, and drive innovative solutions.
• Effective communicator with strong analytical, organizational, and change management skills.
• English level A- is mandatory in oral expression, comprehension, reading, and writing. Bilingualism in French and English is considered an asset.

• Experience working within the EPIC Cogito reporting ecosystem, including Clarity, Caboodle, Reporting Workbench, Radar, SlicerDicer, and other EPIC reporting and analytics tools, is considered an asset.
• Experience integrating REST APIs, JSON, HL7/FHIR, and cloud-based healthcare systems is considered an asset.

Advice for Applicants for the BI Developer Role

Lead your resume with your healthcare BI experience and your strongest proof of delivering scalable data solutions in an enterprise setting, especially if you have 4–5 years in BI, data warehousing, and reporting.

In demonstrating the must-have skills, cite concrete projects where you designed data models and metadata, built ETL/ELT pipelines, and delivered dashboards or reports that drove decisions. Highlight your work with Epic EMR data and the Microsoft tools listed in the job description, and quantify improvements in data quality or performance where possible.

Be ready to talk through how you manage multiple projects, collaborate with diverse teams, and support end users with training and governance. You may be asked to explain your approach to data quality, data virtualization, and automated reporting in an enterprise, multi-site setting.

When you reach the interview, consider asking: How does the BI team prioritise work across Epic implementation milestones and data migration projects? What does success look like for analytics across The Royal’s sites, and how is governance structured to support it?