Job Number: 115770
Job: Administrative/Service
Primary Location: Ontario-Hamilton
This position will be located at: 293 Wellington
Organization: Business & Support Solutions
Status: Regular Full-time
Hours per week: 37.5
Number of Openings: 1
Union Code: Non Union Employees
Salary: 40.4300 – 51.8300 Hourly
Post Date: Oct 16, 2024, 12:00:00 AM
Close Date (Period for Applying) – External: Oct 29, 2024, 11:59:00 PM

Unit Summary

As part of the Hamilton Health Sciences’ Digital Health Plan, the Hospital is embarking upon a new and exciting transformational journey with the introduction of an enterprise-wide Health Information System using the Epic HIS system. This HIS initiative and associated process redesign will play a significant foundational role as a catalyst for an improved patient care at HHS.

We are looking for top-talent to join the hospital’s Epic Project Team and be a part of this exciting Hospital Information System (HIS) implementation project. To ensure this project is successful, we need you and the knowledge that you bring from your current role to this team! Project positions are open to ALL HHS and external staff who are interested in contributing to the evolution of our clinical and business systems, with the ultimate goal of improving high quality care for all.

A variety of roles (clerical, support, clinical – to name a few) are essential to the successful implementation of this new system. Your front-line expertise makes a difference every day! Apply that expertise to an exciting new role on our HIS team to help remove barriers to the flow of health information.

Please ensure to include a cover letter highlighting why you would be an asset to the project and your reason for wishing to participate.

Position Summary

The Application Specialist – Cogito/Business Intelligence (BI) Developer’s primary role is to program and implement new BI solutions, reports, or implement changes to the data warehouse model, and designing enterprise-level solutions for medium to large databases. Additional responsibilities include: debugging, monitoring and troubleshooting BI solutions; creating and deploying reports; writing relational and multidimensional database queries; and creating, deploying and maintaining SQL jobs.

High Level Accountabilities include:
• Integrate new data sources, develop ETL processes and validate data.
• Code and implement proof-of-concept solutions, early proving of capabilities before they are made available for wider consumption.
• Technical and functional development of new reporting solutions.
• Execute unit and integrated system testing on programming changes to ensure viability and accuracy by creating test cases.
• Troubleshoot and resolve technical issues, debug, tune and optimize report performance.
• Ensures Business Intelligence environment is optimized to address business requirements by diagnosing and repairing user and performance issues, and testing, monitoring and tuning software.

Schedule Work Hours

Monday – Friday, 7.5 hours per day (flexibility to work evenings and weekends as required).

Qualifications

1. University degree or college diploma in Computer Science or related discipline
2. Minimum 3 years of experience in business intelligence and data warehousing application development in an IT or software development organization, healthcare application experience is preferred
3. Advanced knowledge of Microsoft SQL Server, Microsoft SQL Server 2012, including Reporting Services, Analysis Services and Integration Services
4. Working knowledge of Visual Studio 2010/2012 (C# or VB.NET), ASP.NET
5. Advanced knowledge of relational databases, working experience with multidimensional databases
6. Good understanding of system environment of Windows Server 2003 and IIS, SAN, personal computers and web applications.
7. Demonstrated analytical skills
8. Motivation and commitment to self-improvement and learning
9. Excellent interpersonal, oral and written communication skills and commitment to quality customer service
10. Ability to exercise independent judgment and take action on it, logical and efficient, with keen attention to detail
11. Ability to meet, prioritize and manage multiple simultaneous tasks and deadlines
12. Demonstrated high level of initiative and self-directive and ability to work as part of a team as well as independently

Hamilton Health Sciences fosters a culture of patient and staff safety, whereby all employees are guided by our Mission, Vision, Values, and Values Based Code of Conduct. Hamilton Health Sciences is a teaching hospital and all staff and physicians are expected to support students and other learners.

To be considered for this opportunity applicants must apply during the posting period. All internal and external applicants may ONLY apply via the Careers website.

Hamilton Health Sciences is an equal opportunity employer and we will accommodate any needs under the Canadian Charter of Rights and Freedom, Accessibility for Ontarians with Disabilities Act and the Ontario Human Rights Code. Hiring processes will be modified to remove barriers to accommodate those with disabilities, if requested. Should any applicant require accommodation through the application processes, please contact HR Operations at 905-521-2100, Ext. 46947 for assistance. If the applicant requires a specific accommodation because of a disability during an interview, the applicant will need to advise the hiring manager when scheduling the interview and the appropriate accommodations can be made.

This competition is open to all qualified applicants, however, qualified internal applicants will be considered first. Past performance will be considered as part of the selection process. If you are a previous employee of Hamilton Health Sciences, please note: the circumstances around an employee’s exit will be considered prior to an offer of employment

Proficiency in both Official Languages, French and English, is considered an asset

If this position is temporary, selection for this position will be as per the outlined Collective Agreements:

APPLY