Build your career at the hospital that’s building for the future

Humber River Hospital is committed to revolutionizing patient care for our diverse community. With the opening of our new facility, North America’s first fully digital hospital, scheduled for October 18, 2015, the future is very exciting for our people and programs. And we’re looking for exceptional individuals to join our great team: people who share our passion to deliver excellent, patient-focused, expert care. The Hospital is formally affiliated with both the University of Toronto and Queen’s University.

Right now we’re looking for a Senior Business Intelligence Developer Supporting the Analytics and Business Insight division of the hospital, this position is responsible for providing technical support for the Business Intelligence (BI) data models, access control, and products that help the hospital democratize the data. The Senior Business Intelligence Developer will design BI data models and products to support hospital strategy and operations including automated dashboards, scorecards, reports, and data analysis in support of strategic and operational objectives, adding visibility to key organization metrics, and driving continuous improvement initiatives.

Reporting Relationship: Manager, Application

Location: Wilson site

Hours of work: 37.5 hours

Employee Group: Non Union

Job Responsibilities:

Activities

• Develop and maintain logical BI data models that support needs that are currently defined while being adaptable to future needs
• Develop and maintain naming and object organization standards in collaboration with the BI team
• Develop Extract, Translate, and Load (ETL) processes to populate the data warehouse from various data sources and SQL
• Partner with clients and their business teams to understand their business problems and challenges and create meaningful and creative solutions that address these problems and challenges
• Design, develop, deliver and maintain clean, secure and efficient reports, visualizations, dashboard solutions using BI and Reporting Tools
• Specify and build dashboards, scorecards, tools, and reports that support strategic and operational goals
• Analyzing, developing and troubleshooting complex data systems and identifying patterns.
• Participate in designing and building tools for online analytical processing (OLAP cubes) to advance multidimensional analysis that utilizes non-relational databases.
• Testing, fixing, improving and deploying software and solutions
• Meeting project milestones and delivering working solutions
• Communicating effectively with both internal and external stakeholders
• Apply data quality principles in BI development
• Participate in the development and maintenance of meta-data

• Prepare the deliverables for the different production environments and participate in the functional validation by providing technical assistance to users
• Develop and update technical documentation for BI tools and dashboards to improve the monitoring of content and the evolution of the system.
• Document contents in a data warehouse and metadata storage.

• Support other team members in the construction of database objects and SQL queries.
• Collaborate within the team and act as a technical advisor to the members.
• Assist team with debugging issues with data, products, reports, etc.
• Be active in the developer community by ensuring technology watch.

Requirements:

• BSc/BA in Computer Science, Engineering or equivalent amount of education and work experience
• BI certification preferred (e.g. MCSE BI or MCSE Data Management and Analytics) is an asset
• Project management an asset
• 5+ years of experience as a BI Developer
• 5+ years of batch or streaming data pipelines, data warehouse / data lake design (e.g. dimensional modeling) and data mining
• In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
• 7+ years Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
• Knowledge of Oracle, PostgreSQL or SQL Server databases
• Hospital experience is preferred
• Applying Business Intelligence data modelling and design to support health care operations, hospital data sets, such as DAD, NACRS, NRS, patient information systems, operations, decision support, and metrics
• Experience with MicroStrategy
• Experience with Meditech Data Repository

Interested applicants are required to an Application. We thank all candidates that apply but only qualified candidates will be contacted for an interview

Humber River Hospital is an equal opportunity employer and we will accommodate your needs under the Ontario Human Rights Code. Upon individual request, hiring processes will be modified to remove barriers to accommodate those with disabilities. Should any applicant require accommodation through the application, interview or selection processes, please contact the Human Resources Department for assistance.

Please be advised that in order to be eligible for employment at Humber River Hospital, all new hires must have received the full series of a COVID-19 vaccine or combination of COVID-19 vaccines approved by Health Canada (e.g., two doses of a two-dose vaccine series, or one dose of a single-dose vaccine series); AND have received the final dose of the COVID-19 vaccine at least 14 days prior to the hired employee’s first date of employment  Medical exemptions or any other kind of requested exemption based upon the Hospital’s obligations pursuant to the Ontario Human Rights Code will be considered on a case-by-case basis