Talent.com
The Royal
Business Intelligence DeveloperThe Royal • Ottawa, ON, Canada
Business Intelligence Developer

Business Intelligence Developer

The Royal • Ottawa, ON, Canada
5 days ago
Job type
  • Full-time
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

#J-18808-Ljbffr
Create a job alert for this search

Business Intelligence Developer • Ottawa, ON, Canada

Similar jobs

Analyst, Business Intelligence & Data Informatics - C$81,600 - C$130,400 A Year

CienaOttawa, Canada
Full-time

Analyze data to find insights and trends, build Power BI dashboards, clean and validate data, collaborate with teams, and automate workflows using Alteryx. 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

Malta Data Architect — Hybrid, Azure & BI

Black Pen RecruitmentOttawa, ON, CA
Full-time

A leading recruitment agency is seeking a Data Architect to join a client in Malta.This full-time position involves designing and implementing Modern Data Platforms and analytics solutions.The idea... Show more

 • Promoted

ADGA Intelligence Mission Data Systems Analyst

ADGA GroupOttawa, ON, CA
Full-time

Join ADGA as an Intelligence Mission Data Systems Analyst and play a vital role in defense project analysis.Engage with users to identify and define key business needs.In this critical position, yo... Show more

 • Promoted

Business Intelligence Developer co-op

EricssonOttawa, ON, CA
Full-time

Business Intelligence Developer co-op.Duration: 8 – 16 months (for co-ops) | 8 months (for interns, with potential for extension).Please upload your unofficial transcript when applying.Use the "Cov... 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

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

The Good Quarter Company Jasper Alberta Process Intelligence Analyst

The Fairmont Jasper Park LodgeOttawa, Ontario, Canada
Full-time +1

The Good Quarter Company Jasper Alberta Process Intelligence Analyst.Job details: Temporary, full-time, fixed term contract.We are seeking a Process Analyst / Value Engineer to join our team.This r... Show more

 • Promoted

Information Technology Private Tutoring Jobs Chelsea

SuperprofChelsea, Canada
CA$20.00 hourly
Full-time +1

Superprof is Canada's #1 tutoring platform, and we're actively recruiting passionate tutors! Whether you're a student, a professional, or simply someone who loves teaching, join the largest communi... Show more

 • Promoted

Senior Research Engineer, Threat Intelligence

SecurityScorecardottawa, on, Canada
Full-time

You’ll join STRIKE, SecurityScorecard's Threat Intelligence team, as the engineering counterpart to research.STRIKE runs several research motions in parallel, each on its own clock: rapid response ... Show more

 • Promoted

Developer, Cloud

Petalottawa, on, Canada
Full-time

The Cloud Infrastructure team builds the foundation Petal's product teams rely on: the cloud primitives, deployment pipelines, observability tooling, and platform capabilities that let engineering ... Show more

 • Promoted

Senior Product Manager (Platform, Data & Intelligence)

Acuity InsightsOttawa, ON, CA
Full-time

Design the data, analytics, and intelligence foundations that products and decisions are built on.Behind every confident product decision sits a platform that gets data, analytics, and intelligence... Show more

 • Promoted

Statistics Private Tutoring Jobs Chelsea

SuperprofChelsea, Canada
CA$20.00 hourly
Full-time +1

Superprof is Canada's #1 tutoring platform, and we're actively recruiting passionate tutors! Whether you're a student, a professional, or simply someone who loves teaching, join the largest communi... Show more

 • Promoted

Statistics Private Tutoring Jobs Cantley

SuperprofCantley, Canada
CA$20.00 hourly
Full-time +1

Superprof is Canada's #1 tutoring platform, and we're actively recruiting passionate tutors! Whether you're a student, a professional, or simply someone who loves teaching, join the largest communi... Show more

 • Promoted

Looking For Jobs Near Me? - Deliver with Uber

Uber eatsCantley, QC, CA
Full-time +2

Delivering with Uber is an alternative to a part-time or full-time job and can get you earning cash quickly.Delivering with Uber allows you to earn quick cash while maintaining the flexibility your... Show more

 • Promoted

Senior Solutions Consultant-Global Trade Intelligence - C$100,000 - C$120,000 A Year - Remote

DescartesNepean, Canada
Remote
Full-time

Seeking a Senior Solutions Consultant to act as the primary architect of value for complex enterprise customers, bridging global trade challenges with technical solutions and accelerating deal velo... Show more

 • Promoted

Complete Online Surveys For Cash (Up to $25/per)

Earn HausCantley, QC, CA
Full-time +1

Looking for people to participate in taking online surveys for Fortune 500 brands.All you need to do is complete online surveys by sharing your opinion.You will help influence brand decisions on se... Show more

 • Promoted

Online Survey Participant: Work Remote and Earn Up To $25 Per Survey

Earn HausCantley, QC, CA
Remote
Full-time +1

Looking for people to participate in taking online surveys for Fortune 500 brands.All you need to do is complete online surveys by sharing your opinion.You will help influence brand decisions on se... 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

Lead Analytics Developer at Warner Bros. Discovery

CNNOttawa, ON, CA
Full-time

Explore an exciting career at Warner Bros.Discovery as a Lead Analytics Developer.Shape the future of data analytics with robust solutions impacting CNN's audience daily.As a leader within the team... Show more