Business Informatics, Analytics & Operations Consultant II (Job ID: 7896)
Unity Health Toronto, comprised of Providence Healthcare, St. Joseph's Health Centre and St. Michael's Hospital, works to advance the health of everyone in our urban communities and beyond. Our health network serves patients, residents and clients across the full spectrum of care, spanning primary care, secondary community care, tertiary and quaternary care services to post-acute through rehabilitation, palliative care and long-term care, while investing in world-class research and education. Join our team in our mission to continue to put patients and families at the centre of everything we do, in the role of Business Informatics, Analytics & Operations Consultant II.
The Business Informatics department is responsible for supporting the Business Systems and Business Intelligence. Business areas supported include Human Resources, Payroll, Supply Chain, and Finance. Our team members have four areas of knowledge including Business, Project Management, Applications, and Technical.
DUTIES & RESPONSIBILITIES
Technical and Application:
• Responsible for the development and maintenance of 35+ daily health check procedures that must be completed prior to the 7am start of each day. This is to ensure all systems are fully operational and ready for use each day.
• Responsible for the development and maintenance of Servers.
• Monitoring alerts and communicating adjustments, if needed
• Investigating and determining root cause for persistent or high risk alerts
• Implementing appropriate resolution as needed
• Applying patches to all servers as they become available to ensure no security vulnerabilities. Must ensure that no servers are compromised by malicious attacks.
• Applying and maintaining certificates as needed to ensure secure communications. This will ensure that all critical user communications (like user passwords) are encrypted
• Responsible for the creation and maintenance of SQL databases across SQL database servers.
• Creating and maintaining the databases
• Managing security within the database
• Creating and/or maintaining users, tables, views and stored procedures
• Creating, maintaining and monitoring database maintenance plans which include nightly backups and performance optimization routines
• Responsible for the maintenance of Oracle databases across Oracle database environments.
• Creating and/or maintaining scripts for tables, views and stored procedures
• Responsible for the development and maintenance of multiple Environments (multiple product lines).
• Applying environmental patches (monthly), service packs (yearly) and upgrades (bi-annually)
• Applying and maintaining certificates as needed to ensure secure communication.
• This is to ensure that at a minimum, Unity maintains prerequisites to be eligible for vendor support.
• Responsible for the installation, configuration and maintenance of externally developed business applications and modules.
• Applying application patches (monthly), service packs (yearly) and upgrades (bi-annually)
• Developing, maintaining and executing technical test scripts (includes regression testing and remediation)
• Maintaining all interfaces and process flows (with Business, Clinical, IT, external)
• Partnering with business during implementation of new applications or enhancements to existing applications
• Responsible for the development and maintenance of in-house applications.
• Reviewing compatibility with operating system updates and upgrades.
• Reviewing interfaces with other systems to ensure they remain current
• Reconfiguring and modifying as needed
• Responsible for ensuring compatibility with the organizations standard desktop operating systems and applications.
• Reviewing configurations (browser and Windows) to ensure that they are appropriate or adjust if needed as the organization and standards change
• Developing, maintaining and executing test scripts (includes regression testing and remediation)
• Testing and applying changes as needed
• Responsible for the development and maintenance of process flows.
• Designing, developing and maintaining process flows to streamline and automate processes in order to ensure accuracy and create efficiencies
• Developing, maintaining and executing process flow test scripts (includes regression testing and remediation)
• Testing and deploying as needed
• Responsible for the development and maintenance of Interfaces
• Designing, developing and maintaining interfaces to automate data flows which increase accuracy and creates efficiencies
• Developing, maintaining and executing interface test scripts (includes regression testing and remediation)
• Testing and deploying as needed
• Designing, developing and maintaining a Framework that ensures consistency and standards within interface builds, and which enables optimal performance
• Developing and maintaining Java script code and SQL code which conform to standards and best practices in order to ensure that security and data integrity are not compromised
• Responsible for the development and maintenance of Security.
○ Server level access
○ Database level access
○ Application level access
• Technical infrastructure and architecture
• Interfaces and process flows
• Storage requirements
• Integrated data
• Performance monitoring
• Assist in the development and maintenance of models for technical auditing
• Change control
• Data integrity
Security access:
• Responsible for resolving all Business helpdesk tickets which average 1500+ per year
• Deconstructing issue and duplicating in test environment if valid
• Working with vendor support on patch creation, testing and implementation as needed
• Testing and adjusting application configuration logic as needed
• Responsible for the application configuration and maintenance of externally developed business applications and modules across HR, payroll, Finance and Supply Chain.
Business:
• Responsible for ensuring that they work closely with a subset of unique business roles within HR, Payroll, Supply Chain and Finance. All business application functions that these users execute as they complete their day to day tasks must be able to be fully replicated by BI.
• Responsible for BI training where it relates to the subset of business roles that they support
• Responsible for developing and maintaining models for Audit
• Responsible for enforcing infrastructure and models for application and business auditing
• Assessing risk and developing strategies for performing internal audits on master data, transactions, applications and business processes
• Responsible for executing integrated transaction analysis and reconciliations.
• Develop and maintain tools, models, KPIs and testing strategies in order to detect anomalies in the processing of source transactions
Project Management:
• Key SME on business systems operational projects.
• Participate in departmental business system operational project requests
• Completing feasibility studies
• Creating business case for proposed solution with budget, impact, risks, resources and timelines to get executive approval
• Gaining project acceptance from leadership committees
• Key SME in the execution of selected business system operational projects
• Executing code development, implementation tasks, process/procedure development.
• Carrying out monitoring processes to ensure risks are mitigated and project is on time, on budget and that success factors are met.
• Assist in developing and executing communication and change management strategies/tasks
• Executing go live tasks as well as internal post implementation audit work packages
• Developing and maintaining key budgeting KPIs
• Informing team and keeping all key stakeholders accountable - reviewing with team and stakeholders on a regular basis so that they can monitor their project charges
QUALIFICATIONS:
• 4 year university degree in IT or Business related or equivalent experience
• Experience with Infor Hospital applications is an asset
• Knowledge of SQL
• Experience with BI, ETL and Data warehousing tools an asset
• Experience with maintaining application security rules an asset
• Experience with ERS, EDI, OCR, DMS technology an asset
• Proficient in the use of Microsoft Office Products: Word, PowerPoint, Excel, Visio
• Must be motivated and self-directed.
• Demonstrates initiative and willingness to learn
• Demonstrate the ability to apply logical thinking to gathering and analyzing information, designing and testing solutions to problems, and formulating plans.
• Written and oral communication skills: the ability to communicate effectively with superiors and colleagues is essential.
#LI-MR1