Description du poste
**Job Title:** Technical BI Analyst - Power BI
**Department:** Information Technology
**Reports To:** IT Manager
**Term:** Full-Time, 1-Year Fixed-Term Employment
**About Beam Radiology**
Beam Radiology is a physician-led, community-based diagnostic imaging and specialty care organization committed to compassionate patient care and service excellence for our referring practitioners. Our patients always come first.
We are an expanding diagnostic imaging practice located in Calgary, Alberta, offering a comprehensive range of imaging and specialty care services. Our clinical and operational teams work collaboratively to provide an exceptional patient experience and support positive healthcare outcomes.
Driven by clarity of vision and strong values, Beam Radiology focuses on clinical excellence, collaboration, operational innovation, and meaningful career growth opportunities for our team members.
**The Opportunity**
Beam Radiology is seeking an experienced Technical BI Analyst - Power BI to join our IT team in a full-time, 12-month fixed-term position.
Reporting to the IT Manager, this role will lead the development of Beam Radiology’s reporting and visual analytics framework. You will work closely with IT, Accounting, Finance, Clinical Operations, and executive leadership to connect clinical activity with financial performance and replace manual, spreadsheet-heavy reporting with automated, governed solutions.
Using data from systems such as Accuro EMR, Visage RIS, and Xero, you will build Power BI dashboards, data models, KPI scorecards, and automated reporting workflows that provide timely operational and financial insights.
**Key Responsibilities**
**Data Integration & Modeling**
* Extract, transform, and load data from Accuro EMR, Visage RIS, Xero, relational databases, and REST APIs.
* Develop and maintain SQL queries, data extraction workflows, and replicated database pipelines.
* Build efficient, reliable data models using Power Query and DAX while protecting live clinical system performance.
* Document data lineage, system handoffs, source-to-report mappings, and metric definitions.
**Power BI Dashboards & Analytics**
* Design, build, publish, and maintain interactive Power BI dashboards, KPI scorecards, and visual process flowcharts.
* Deliver clear reporting on study volumes, modality utilization, clinician productivity, accounts receivable, collections, and financial variances.
* Troubleshoot and optimize dashboards, calculations, data models, and report performance.
* Translate complex data into accurate, practical insights for clinical, operational, financial, and executive stakeholders.
**Financial Reporting Automation**
* Partner with Accounting and Finance to gather requirements and automate month-end reporting.
* Map clinical, payroll, billing, and financial data to support variance analysis and commission reporting.
* Build an automated clinician commission calculation model to replace fragile spreadsheet macros a