Business Intelligence Developer

The Royal; Ottawa; Hybrid; CAD 80,000 - 110,000; Full time

Job summary

The Royal in Ottawa, Ontario is seeking a Business Intelligence Developer to design, build, and maintain data models, pipelines, and dashboards across healthcare analytics. You will support data-driven decisions by ensuring data accuracy, security, and performance in a hybrid on-site model.

You will work on ETL/ELT processes, Epic data integrations, and enterprise BI solutions, collaborating with IT and clinical teams to deliver reliable analytics services.

Qualifications

• 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, 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.
• 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
• Language: English is mandatory; bilingual in French/English is an asset

Responsibilities

• Gather, document, and validate business and technical requirements; design and maintain data models, data dictionaries, data maps, metadata repositories, and related artifacts; support data integrity and performance.
• Translate validated requirements into scalable BI solutions for large healthcare systems.
• Develop, maintain, and optimize dashboards, KPIs, data queries, data models, visualizations, and reports to support operational, clinical, and executive decision-making.
• Develop, configure, and support data-driven applications using Epic EMR data and standard BI tools.
• Build, manage, and optimize ETL/ELT processes, integrating data from multiple sources with governance and performance in mind.
• Serve as a liaison between users, IT, and external partners to support reporting and analytics requirements; deliver consistent analytics services across The Royal’s multi-site organization.
• Support BI infrastructure and data products through performance tuning, maintenance, upgrades, and data governance improvements.
• Participate in enterprise projects, including Epic implementation, data migration, system integration, and digital transformation initiatives.

Skills

SQL Server

SSMS

Power BI

Power Apps

Power Automate

Azure Data Studio

Visual Studio Code

Dimensional Modeling

OLAP/OLTP

Education

Degree in Computer Science / IT / Software Engineering

Tools

Epic Cogito suite (Clarity, Caboodle, Reporting Workbench, Radar, SlicerDicer)

REST APIs

JSON / HL7 / FHIR

Job description

Our current hybrid model requires employees to work on-site three days per week. On-site requirements may change based on operational needs.

About the Role

The Business Intelligence Developer supports data-driven decision-making by designing, developing, and maintaining data models, integration pipelines, dashboards, and reporting solutions that ensure The Royal’s data and analytics environment is accurate, secure, reliable, and performant.

Key Responsibilities

• Gather, document, and validate business and technical requirements; design and maintain data models, data dictionaries, data maps, metadata repositories, and related artifacts; and support data integrity, performance, issue investigation, and resolution in accordance with established standards and practices.
• Translate validated requirements into scalable Business Intelligence solutions for large healthcare systems.
• Develop, maintain, and optimize dashboards, KPIs, data queries, data models, visualizations, and standardized and ad hoc reports to support operational, clinical, and executive decision-making.
• Develop, configure, and support data-driven applications using Epic EMR data and industry-standard business intelligence tools.
• Build, manage, and optimize ETL/ELT processes, integrating data from multiple sources while ensuring data accuracy, integrity, governance compliance, and system performance.
• Serve as a liaison between users, IT, and external partners to support reporting and analytics requirements. Represent data interests on projects and working groups, provide training and support, and deliver consistent analytics services across The Royal’s multi-site organization.
• Support and optimize BI infrastructure and data products through performance tuning, maintenance, upgrades, issue resolution, and continuous improvement of data governance, standards, documentation, and development practices.
• Participate in enterprise projects, including Epic implementation, data migration, system integration, and digital transformation initiatives.

Qualifications

• 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.
• 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

Language Requirements

English level A- is mandatory in oral expression, comprehension, reading and writing. Bilingual (French/English) is considered an asset