First seen by our source: just now
EPR Business Intelligence Developer Analytics & Reporting
@ St. Michael's Hospital
Toronto, Ontario
Overview
St. Michael's Hospital, part of Unity Health Toronto, is hiring a temporary EPR Business Intelligence Developer to design, build and support analytics and reporting modules for the EPR vendor. The work covers ETL development, SQL-based data sources, dashboards and stakeholder consultation. Five or more years of decision support or BI experience is required, with healthcare experience preferred.
Responsibilities:
- Design, build and support EPR analytics and reporting modules
- Write T-SQL, Netezza SQL and SAS queries for dashboards and reports
- Design and schedule ETL procedures and SSIS packages
- Lead stakeholder meetings to gather requirements and report progress
- Maintain EPR data dictionaries and enforce reporting security policy
Requirements summary:
- Bachelor's degree in a quantitative discipline; master's preferred
- Five or more years in decision support or business intelligence
- Minimum five years of SQL, with a focus on SQL Server
- Minimum three years with visualization tools; Tableau Server an asset
- Healthcare and hospital data experience preferred
Tools & skills
Source and dates
Source type not verified · apify-linkedin
- Employer posting date
- Not provided
- First seen by our source
- 2026-11-15
- Source record updated
- 2026-11-15
These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.
Job details
| Seniority | Senior |
| Department | Data & analytics |
| Experience | 5+ years |
| Travel | air: none · ground: none |
| Work setting | Office |
| Position | Mostly sitting |
| Physical demands | physical low · computer high |
| Education | Bachelor’s degree (required), Master’s degree (preferred) |
| Fields of study | Computer Science, Data Analytics, Mathematics, Statistics |
Summary and details written by AI from the posting; the employer’s posting is the authority.
St. Michael's Hospital
Saved company profile
Historical company information from a saved The Jobs API profile (LinkedIn/Crunchbase fields). It is not live-verified; figures may have changed. Missing values remain unknown.
Full company description
St. Michael’s Hospital provides compassionate care to all who enter its doors. The hospital also provides outstanding medical education to future health care professionals in 27 academic disciplines. Critical care and trauma, heart disease, neurosurgery, diabetes, cancer care, care of the homeless and global health are among the hospital’s recognized areas of expertise. Through the Keenan Research Centre and the Li Ka Shing International Healthcare Education Centre, which make up the Li Ka Shing Knowledge Institute, research and education at St. Michael's Hospital are recognized and make an impact around the world. Founded in 1892, the hospital is fully affiliated with the University of Toronto. Fully affiliated with the University of Toronto, St. Michael’s provides outstanding medical education to health-care professionals in 29 academic disciplines. Home to the Li Ka Shing Knowledge Institute, made up of the Keenan Research Centre and the Li Ka Shing International Healthcare Education Centre, the hospital is among the first in the world to bring together researchers, educators and clinicians to take best practices and research discoveries to patient bedsides faster.
- LinkedIn followers
- 75,834
- People associated on LinkedIn
- 4,844
- Reported office locations
- 30 Bond Street, Toronto, Ontario M5B 1W8, CA
- Other recorded names
- St. Michael's Hospital
- Specialties
- Trauma
- Critical and Complex care
- Research
- Inner city health
- Teaching and Education
- and Neurosurgery and Cardiovascular Surgery
- Profile identifies a recruitment agency
- No
St. Michael’s Hospital provides compassionate care to all who enter its doors. The hospital also provides outstanding medical education to future health care professionals in 27 academic disciplines. Critical care and trauma, heart disease, neurosurgery, diabetes, cancer care, care of the homeless and global health are among the hospital’s recognized areas of expertise. Through the Keenan Research Centre and the Li…
| Field | Value |
|---|---|
| Industry | Hospitals and Health Care |
| Company size | 5,001-10,000 employees |
| Headquarters | Toronto, Ontario |
| Organization type | Nonprofit |
| Year founded | 1892 |
| Specialties | TraumaCritical and Complex careResearchInner city healthTeaching and Educationand Neurosurgery and Cardiovascular Surgery |
| Open jobs on Jobsy | 3 |
| View page |
The EPR Business Intelligence Developer will be responsible for working closely with the project team as well as internal stakeholders to develop the business intelligence and reporting tools for the organization. The role is responsible for the design, build, implementation, support and optimization of the EPR vendors analytics and reporting modules.
In addition, the EPR Business Intelligence Developer is also responsible for creating Business Intelligence data sources in a database environment for use by the Decision Support team and other teams within the organization. This involves leveraging technical expertise to design the tables, creating the associated ETL processes to populate them and developing procedures to capture and track errors. This will also require the Business Intelligence Developer to work with other departments on data management and extraction from internal and external systems for the purposes of clinical and operational reporting.
Main Responsibilities
- Data Analysis & Interpretation
- Lead support for clinical and non-clinical clients in a variety of analytical needs including: development of robust analytical plans, statistical analysis, key performance indicators, benchmarking, data visualizations, and routine and ad hoc reporting as it relates to the EPR
- Work closely with clients to create high impact analytical products including, simple to more advanced analysis, models or reports that generate meaningful insights, and is presented in an effective way. Responsible for the work from start to finish including the approach, validation/data quality and the documentation of technical specifications.
- Design and build interactive and static data visualizations using various reporting software programs in order to provide insights and enable strategic business decisions to be made.
- Program complex queries using SQL Server T-SQL, IBM Netezza SQL and/or SAS in order to retrieve required data and ensure that reports contain the most up-to-date information.
- Generate results for specific metrics to be shared with external organizations in order to meet our commitments to government bodies.
- Design and develop dashboards using EPR tools and other software programs to present statistics and measures that cut across all areas within Unity Health Toronto.
- ETL Development
- Design, develop and schedule ETL procedures to transfer information needed for Business Intelligence reporting. This includes T-SQL programming, VBA programming as well as the creation and scheduling of SSIS integration packages in SQL Server.
- Conduct periodic reviews of ETL procedures on a regular basis in order to analyze execution times and other performance indicators. Make improvements in order to reduce runtimes, increase efficiency and optimize overall performance of the Business Intelligence server.
- System and Technical Support
- Provide system administration and technical support for use of Business Intelligence tools. Ensure permissions on each account are suitable for its intended purpose while maintaining information security.
- Client Consultation
- Lead meetings with stakeholders on a regular basis in order to facilitate requirements gathering for new reporting, provide status updates on work in progress and discuss findings during the development process.
- Formulate development plan for assigned projects, create design templates for new reports and provide high-level timelines to manage client expectations.
- Support data governance activities
- Implements and maintains the enterprise wide reporting and security policy including appropriate access to EPR data
- Maintains EPR data dictionaries
- Implements the build, security, and data segregation strategies for the EPR
- Reviews data requests, triages, prioritizes, tests and publishes approved requests
- Validates data requests for accuracy and to data quality standards.
- Bachelor's degree in quantitative discipline such as Computer Science, Data Analytics, Mathematics or Statistics. Masters degree preferred.
- Five (5) or more years of experience in a decision support, business intelligence or analytical environment; healthcare experience is preferred
- Minimum 3 years of experience with visualization tools. Experience with Tableau Server an asset.
- Minimum 5 years of experience in SQL with a focus on SQL Server preferred.
- Subject matter expertise in the areas of BI solutions, data warehousing and visualization.
- Experience with hospital data and/or healthcare environments is an asset.
- Experience with SAS, Python and/or R is an asset.
- Experience with SSIS is an asset.
- Experience with hospital data (e.g. DAD, NACRS); knowledgeable within the health care environment and of industry trends
- Experience working in a complex data environment, including enterprise data warehouses and other relational databases. Ability to transform data from non-traditional data sources (other reports, external sites and systems, etc.).
- Demonstrated experience leveraging data mining techniques to process large scale data and assemble complex, high quality datasets
- Ability to analyze data and present complex information in a simple to understand manner.
- Ability to work independently, prioritize multiple work assignments/timelines and manage stakeholder expectations.
- Proven oral and written communication skills.
- Demonstrated attention to detail in day-to-day work with a focus on quality of work, accuracy and customer service.
- Strong computer skills including MS Office Suite (Excel, Access, Word, and PowerPoint)
Journal
Only you can see this. Kept on this device, and in your account when you sign in.