Sault Area Hospital is seeking a Systems and Technical Innovation Analyst who will work closely with a cross-functional and collaborative team to provide consultative and analytic support to our organization and partners. The successful incumbent will be responsible for the administration and maintenance of various electronic databases as well as the advancement of data management, data governance, and technical innovation within the hospital. This pivotal role within the Analytics team ensures the security, accuracy, integrity of clinical, financial, and business data. We are looking for someone with a passion for using technology and data for the purpose of continuous improvement and a drive to use research and innovation to advance health systems. This position reports to the Manager of Analytics, Sault Area Hospital.

Duties and Responsibilities:

1. Daily monitoring of performance, transfer jobs and error logs on the data repository
2. System administration for business intelligence applications
3. Multi-site/multi-department coordination and execution during testing/troubleshooting for systems upgrades
4. On-going administration and maintenance of reporting schedules and data extraction routines (e.g., SSIS packages)
5. Lead work with external partners in the preparation and delivery of large data extractions (e.g., case costing)
6. Development of data warehouse business rules and the creation of SQL views, stored procedures, etc.
7. Creation and maintenance of multidimensional and data mining models using SSAS
8. Advises on new and/or innovative ways to collect, integrate, and produce strategic information for the purpose of evidence-based decision making
9. Network and collaborate with sites on shared systems, partners within the Algoma Ontario Health Team, and other external partners in order to promote data sharing and accessibility
10. Work closely with leaders within the organization to provide tailored, standardized, and timely utilization and performance reports
11. Explore custom solutions using tools such as MS Excel, Access, and VBA
12. Pursue innovative approaches to data collection, analysis, communication, and predictive analytics
13. Provide education on data integrity and best practices in data collection, storage, extraction, and security
14. Other duties and responsibilities as assigned

Qualifications:

1. University Degree in Information Systems Management, Computer Science, or other related discipline
2. 3 years of experience in data management, linkage, analysis, interpretation, and reporting
3. Advanced knowledge and experience with SQL Programming, SQL Server data tools (SSRS, SSIS, SSAS), Power BI, MS Excel, Access, VBA
4. Familiarity with Ontario Healthcare Reporting Standards (OHRS)

Knowledge & Skills:

1. Highly collaborative with an ability to build trusting relationships with an interdisciplinary team and external stakeholders
2. Ability to work independently with minimal supervision; to manage time wisely and prioritize multiple competing projects with tight timelines
3. Self-directed and motivated in the collation, interpretation, and analysis of various sources of data in order to provide stakeholders with comprehensive information from which to base their decisions
4. Experience presenting technical content (written and oral) in a meaningful and relatable way to a variety of audiences
5. Proven ability in leading organizational change management activities related to data governance and data management policies; project management experience an assess
6. Experience in report writing using Crystal Reports and/or M-AT/NPR; experience with SharePoint an asset
7. Committed to upholding integrity in data collection and reporting processes and adherence to strict privacy standards
8. Strong attention to detail and critical thinking skills
9. Understanding of, and commitment to, SAH’s vision, mission and values

To apply to this exciting opportunity please send a cover letter and resume outlining how your knowledge, experience, and personal attributes are a good fit with the requirements of this position.