Business Intelligence Developer

Company Description

Altum Health is a department within the University Health Network with over 300 employees across several sites (Ajax, Barrie, Brampton, Cambridge, Hamilton, Mississauga, Oakville, Oshawa, Toronto, Scarborough, and Vaughan). We offer a full continuum of prevention, rehabilitation, and health care services to third party payors and individuals, including the Workplace Safety and Insurance Board (WSIB), employers, and insurers.

At Altum Health, we believe in providing “The Right Care. Always.” by offering client-centered services that address the physical, psychosocial, and behavioral issues related to injury or illness. We actively participate in outcomes data collection, analysis and reporting, continuous quality improvement and the education and training of the next generation of health and service professionals. Altum Health services prevent and manage acute and chronic injury as well as co-morbid conditions and integrate clients back into the workplace and home life. Our services result in positive outcomes and value to our clients and customers.

Job Description

Union: Non-Union
# of Vacancies: 1
Position: Business Intelligence Developer
Department: Altum Health
Reports to: Reporting and Analytics Manager
Location: Toronto (Krembil Discovery Tower)
Hours: 37.5 hours per week
Status: Permanent Full-time

Job Summary:

The Business Intelligence (BI) Developer reports to the Reporting and Analytics Manager at Altum Health, UHN, and collaborates closely with Business Intelligence Analyst and clinical/business analysts.  This role is responsible for creating data extract and analysis content based on end-user specifications. The ideal candidate will have expertise in SQL, SSIS, Epic Clarity and Caboodle database, along with excellent communication and interpersonal skills.  A solid background in data management, analytics, and business intelligence is essential for success on this role.

Duties:

• Work closely with stakeholders, subject matter experts, and end-users to understand the requirements, and analyze the needs of data consumers.
• Identify and develop the appropriate technological solutions for various data needs.
• Designs and maintains databases, tables, views, stored procedures, jobs, schedules, alerts within a Microsoft SQL Server environment and works to maintain database system integrity and daily processing.
• Write SQL queries and configure report settings for custom SQL metrics; build extract (in SQL) using Epic’s Reporting databases (Clarity and Caboodle).
• Develops data models and maintains database schemas. Automates regularly scheduled database tasks.
• Leads the development, maintenance and reporting from various internal databases (utilizing database application design, security, query, forms, reports, macros, VBA skills).
• Implements data quality checks and develops analytical reports to address data quality issues for related departments.
• Responds to data quality issues identified by audits and provides solutions/explanations to fix issues.
• Provides technical support for user testing; serves as a support resource to resolve issues related to system problems.
• Review upgrade documentation related to application features and determine how to implement the changes;
• Coordinates with the appropriate parties to resolve issues with the SQL Server.
• Automates and develop key performance metrics (KPIs) and scorecards to support performance measurement and hospital accountability.          
• Contributes to the development of BI solution and delivery requirements for data integration projects.

Qualifications

• Undergraduate Degree in Computer Science, Information system, Health Informatics, Business Analytics, or equivalent.
• A minimum 3-5 years of experience in Business Intelligence, data Analytics, and reporting tool development.
• Microsoft Certified Solutions Associate (MCSA) SQL Server or Microsoft SQL Server Certificate preferred.
• Epic Cogito Data Model Certification (Epic Cogito Fundamentals, Clarity Data Model, Caboodle Data Model, Clinical and/or revenue/access Data Model) preferred.

Skills & Experience

• Expertise in relational & dimensional database and data modeling.
• Proficiency in MS SQL Server Management Studio and MS Visual Studio.
• Hands-on experience with analytics and Business Intelligence tools.
• Familiarity with Epic application and database structure.
• Strong databases design, development, and maintenance skills.
• Excellent problem solving skills and communication skills.
• Ability to gain an in-depth understanding of data models and data structures.
• Ability to effectively work both independently and in a team-oriented environment.
• Experience with clinical and business workflows and data in a Canadian healthcare setting preferred.
• Familiarity with UHN’s system build, end user workflows, and data usage patterns preferred.

Additional Information

Why join UHN?

In addition to working alongside some of the most talented and inspiring healthcare professionals in the world, UHN offers a wide range of benefits, programs and perks. It is the comprehensiveness of these offerings that makes it a differentiating factor, allowing you to find value where it matters most to you, now and throughout your career at UHN.

• Competitive offer packages
• Government organization and a member of the Healthcare of Ontario Pension Plan (HOOPP https://hoopp.com/)
• Close access to Transit and UHN shuttle service
• A flexible work environment
• Opportunities for development and promotions within a large organization
• Additional perks (multiple corporate discounts including: travel, restaurants, parking, phone plans, auto insurance discounts, on-site gyms, etc.)

Current UHN employees must have successfully completed their probationary period, have a good employee record along with satisfactory attendance in accordance with UHN's attendance management program, to be eligible for consideration. 

Vaccines  are a requirement of the job unless you have an exemption on a medical ground pursuant to the Ontario Human Rights Code. 

UHN is a respectful, caring, and inclusive workplace. We are committed to championing accessibility, diversity and equal opportunity. Requests for accommodation can be made at any stage of the recruitment process. Applicants need to make their requirements known in advance.  Any information received related to an accommodation will be addressed confidentially. 

University Health Network thanks all applicants, however, only those selected for an interview will be contacted.