Talent.com
ROYAL OTTAWA HEALTH CARE GROUP
Business Intelligence Developer (RFT 1.0 FTE)ROYAL OTTAWA HEALTH CARE GROUP • Ottawa, ON, Canada
Business Intelligence Developer (RFT 1.0 FTE)

Business Intelligence Developer (RFT 1.0 FTE)

ROYAL OTTAWA HEALTH CARE GROUP • Ottawa, ON, Canada
7 days ago
Job type
  • Full-time
Job description

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. Bilingualism in French and English is considered an asset.

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

Business Intelligence Developer (RFT 1.0 FTE) • Ottawa, ON, Canada

Similar jobs

Remote Investment Analyst for AI Finance Research

Call For ReferralOttawa, ON, CA
Remote
Part-time

A leading recruitment firm is seeking an experienced Equity & Investment Analyst to work remotely on a part-time basis.This role involves developing financial models and reviewing tasks pertinent t... Show more

 • Promoted

Python-Driven Automotive AI Evaluator

MindriftOttawa, ON, CA
Full-time

A technology consultancy offering project-based opportunities seeks automotive engineers for various tasks.Applicants should have a degree in automotive engineering, along with 3+ years of experien... 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

Remote AI Data Quality & Evaluation Engineer

Veeva SystemsOttawa, ON, CA
Remote
Full-time

A leading cloud technology company in Toronto is seeking an experienced professional to validate and ensure the reliability of Veeva AI Agents.The ideal candidate should have expertise in data qual... 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

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

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

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

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

Developer Advocate, AI Enablement

BDO CanadaOttawa, ON, CA
Full-time

Putting people first, every day.BDO is a firm built on a foundation of positive relationships with our people and clients.Our professionals provide exceptional service and advice that clients can t... Show more

 • Promoted

Cybersecurity Analyst & AI Tutor — Remote Threat Hunter

MindriftOttawa, ON, CA
Remote
Part-time

A technology consulting firm based in Canada is seeking a Freelance Cybersecurity Analyst - AI Trainer to collaborate on innovative AI projects.The role involves analyzing security alerts, conducti... Show more

 • Promoted

AI Prototyping Developer in Remote Innovation

Tech Talent InternationalOttawa, ON, CA
Remote
Full-time

Spearhead AI prototyping projects as a skilled Developer specializing in experimentation.This remote position focuses on transforming high-risk AI ideas into working prototypes at the forefront of ... Show more

 • Promoted

Remote AI & ML Developer — LLMs, RAG & APIs

OrganimiOttawa, ON, CA
Remote
Full-time

A leading B2B SaaS company is seeking an experienced AI / Machine Learning Developer to work on innovative AI models and systems.The candidate will train and deploy large language models and relate... Show more

 • Promoted

Async Financial Modeling Analyst (IB/PE) — 20h/wk Contract

MercorOttawa, ON, CA
Full-time

A financial services company based in Canada is seeking an Investment Banking Analyst to work on a research project with a leading AI lab.The position offers $150 per hour and allows for asynchrono... Show more

 • Promoted

Power BI & Data Insights Analyst - Remote Canada

Source CodeOttawa, ON, CA
Remote
Full-time

A technology consulting firm is seeking an Int.Business Intelligence Analyst in Edmonton.The role focuses on delivering BI solutions using Power BI, requiring strong skills in data analysis, visual... 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

Remote Software Engineer — Train & Evaluate AI Chatbot Code

DataAnnotationOttawa, ON, CA
Remote
Full-time

An innovative company is seeking a skilled Software Engineer to help train AI chatbots.This exciting remote role allows you to work on your own schedule while contributing to the development of cut... Show more

 • Promoted

AI Developer

Hanalytica GmbHOttawa, ON, CA
Full-time

This range is provided by Hanalytica GmbH.Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.Our client is looking for an exceptional.AI and machin... Show more

 • Promoted

Analyste fonctionnel senior en intelligence d'affaires (Q7A)

TEHORA inc.Ottawa, ON, CA
Full-time

Analyste fonctionnel senior en intelligence d'affaires (Q7A).TEHORA est présentement à la recherche d’un(e) analyste fonctionnel senior en intelligence d'affaires ayant d’excellentes aptitudes tech... Show more