Reporting to the Senior Director – Finance, the Senior Business System Specialist supports the Finance department, as well as other departments (assigned by Finance) within the Hospital. The position will also support Manager and Operations Leads of Accounts Receivable team and is responsible for gathering report requirements, developing and maintaining reports (including use of SQL), analyzing reports, developing dashboards, reviewing workflow and workques, diagnosing issues, providing recommended solutions, creating tip sheets, implementing and rolling out solutions/new products. The position tasks will require investigation, documentation, and potentially re-engineering of end-to-end workflows including process mapping. The Specialist must have in-depth knowledge of technology tools (example EPIC system, Smart notification, Crystal, SQL, Addins, Spreadsheet designer, Design Studio) in order to execute the business initiatives.

These various tool sets are very complex and require highly skilled individuals who must constantly update their knowledge and keep abreast of technology upgrades and new functionality. The Specialist must constantly analyze these updates to determine the impact to organization and make recommendations for improvements or changes.

Requirements The position is also responsible to review and identify potential automation opportunities in existing business workflows, integration with other system and will recommend and facilitate workflow changes to support software automation. The position will spend majority of time interviewing key stakeholder to assess and determine report and workflow requirements, diagnosing issues, analyzing and recommended solutions, prioritizing needs, assist in develop reporting, planning and phasing out the project plan for implementation followed by developing, testing and promoting changes to production including strategizing and action roll-out of developed products; below is the list of some of the functions of this position:

• Development and maintenance of reports and data extracts (EPIC system);
• Using MS Excel advanced skills to build customized reporting and dashboards utilizing data extracts and reports from EPIC system;
• Creating/Updating monthly reports to specific stakeholders, e.g. Finance, Physicians, Clinical leaders etc.;
• Assessing and validating workque and reporting structure, format and data, investigation of issues, making adjustments, re-testing, verification and analysis;
• Analyzing the results and writing monthly briefing summaries for stakeholders;
• Consolidation reports, summaries, validation and other analysis as assigned;
• Performing monthly reconciliation of report and GL results, including interface data between systems;
• Diagnosing and implementing solution for the variances and errors identified in monthly reconciliations;
• Application of report changes/corrections, testing, verification and analysis;
• Development and documentation of workflows;
• General analysis, monitoring, forecasting, and all associated activities and responsibilities associated with these areas.

Responsibilities

• Responsible for implementing, maintaining and supporting the integrated technical tools and processes:
• Must maintain an in depth working knowledge of tools, systems and business processes ; t his includes integration and general working knowledge of other tools/processes and integrated applications / modules; and must be detail integrated technical tools and process focused.
• Responsible for ensuring that the tool architecture is efficient, effective, scalable, and maintainable;
• Performs on-going technical reviews to identify any gaps;
• Conducts on-going architectural reviews to ensure technology updates have been implemented;

• Responsible for addressing complex integrated technical issues or questions from stakeholders and clients.
• Responsible for the following: Defining and scoping the issue properly; Analyzing the problem; Generating potential solutions; Selecting and planning the solution; Testing and implementing the solution; and Evaluating at the appropriate interval(s) the results of the implemented solution.

• Responsible for completing changes to tool or technical processes as needed;
• Responsible for detailed system specifications requiring strong knowledge of data logic and database structures;
• Team member for the implementation or upgrade of modules, security, performance monitoring, change management, and process adjustments during implementation, updates or upgrades of the ERP systems;
• Responsible for validating technical requirements of additional systems interfacing with ERP solution;
• Responsible for investigating, proposing and implementing technical solutions that will strengthen the ERP system in order to produce outputs that are not part of the standard solution provided by the software/system;
• Responsible to ensure that new technical requirements are properly integrated with new or existing processes;
• Responsible for planning system flows from group up or existing infrastructure and processes;
• Responsible for writing technical requirements and specifications from a critical phase and then documenting the software adherence or limitations based on specifications;
• Responsible for providing and implementing alternatives where software is limiting. Responsible for providing use cases, flowcharts and database designs during system development or adjustment;
• Responsible for ensuring customer satisfaction within all user departments;
• Responsible for ensuring all communication channels are appropriate and current;
• Responsible for building strong relationships with stakeholders;
• Responsible for initiating change to processes if necessary;
• Responsible for working closely with the analysts in order to adjust integrated applications/modules as required;
• This position will specialize on certain integrated tools and processes. They will have integrated general knowledge on other tools and applications.
• Documents functional and technical specifications consistent with hospital’s standards and Process Framework;
• Managing system (EPIC, MS Access, Database tables, MS Excel including Macros/VBAs/SQL etc.) configuration including system settings processes to ensure fulfillment of business requirements and/or applicable application requirements;
• Designs, documents, develops and executes test automation and integration plans business requirements;
• Creates and deploys process automation solutions to develop continuous improvement strategies in consultation with Unity IT, Business Informatics, AR Ops Leads, AR Manager, Finance Business Partners (FBP), Business Managers, Clinical and Non-Clinical Managers, Directors, VPs, Manager Financial Planning and Analysis and other Executives with an objective to integrate business systems as much as possible
• Managing assigned project tasks consistent with project directives;
• Identify and design appropriate automation workflows in consultation with clinical and non-clinical programs;
• Implements the full end to end budget and reporting cycle steps: identifying automation opportunities, gathering requirements, implementation, testing and deployment of targeted automation solutions using leading Process Automation tools;
• Develops scalable and efficient process automations and reusable components that can be leveraged in developing new effective tools and reporting and across different functions of the hospital;
• Ensures key control activities are properly identified, while maintaining the proper design, through implementation and operational effectiveness;
• Development and documentation of workflow related to Legacy (Meditech, HRCM) and EPIC system;
• Participates in the development of the Hospital’s annual and multi-year operating budget for patient revenue, bad debts and compassionate care, financial planning strategy and performs the monitoring and forecasting of such budgets at a Hospital-wide level (with support for stakeholders);
• Lead the development of the annual and multi-year operating budget for patient revenue, bad debts and compassionate care, by monitoring and forecasting budgets on a risk-based approach, with due consideration of client consistency and expectations;
• Collaborate with Unity IT, Business Informatics, Human Resources, Decision Support, Coding, Financial Planning & Analysis, Financial Controllership teams and other stakeholders in each project, to complete assessing, analyzing and recommending the integrated solution
• Work with management to address financial issues, provide analysis, evaluation and recommendations to inform decision making;
• Work collaboratively with Finance Business Partners (FBP), clinical and non-clinical administrative leaders for the business units;
• Working as a team, effectively and efficiently engaging with key stakeholders to evaluate current workflows through research and fact finding, and identifying areas of opportunity to create efficiency;
• Serving as subject matter expert to Accounts Receivable team and others seeking to understand information flow and streamlining existing manual processes;
• Provide, as required, business process and report literacy training and guidance to clients and/or stakeholders;
• All staff are expected to carry out their assigned duties and responsibilities in a manner, which prioritizes patient and employee safety and confidentiality. Key accountabilities in this regard include:

• Performing cross-functional duties and other duties consistent with the job classification, as required;
• Strict compliance with patient/employee confidentiality and safety practices, policies and standards;
• Liaising with internal and external clients to exchange information, and providing support, as required, to facilitate management decision making;

• Appropriate identification, reporting and response to patient/employee confidentiality breaches, safety risks and incidents/events in accordance with established policies and procedures;
• All staff are expected to carry out their assigned duties and responsibilities in a manner which prioritizes patient and employee safety and confidentiality. Key accountabilities in this regard include:

• Strict compliance with patient/employee confidentiality practices and policies
• Strict compliance with patient/employee safety practices and standards.
• Appropriate identification, reporting and response to patient/employee confidentiality breaches in accordance with established policies and procedures
• Appropriate identification, reporting and response to patient/employee safety risks and incidents/events in accordance with established policies and procedures.

Qualifications

• Community College diploma required
• Bachelor’s Degree in Accounting, Business Administration and/or relevant field preferred;
• Accounting Designation – CPA-CA; CPA-CMA, CPA-CGA, or equivalent an asset;
• Minimum three (3) years’ experience working with SQL to develop reports and dashboards is required, preferably in EPIC system;
• Minimum three (3) years’ experience working with Integrated Systems is required;
• Minimum 2 years business or accounting knowledge and experience is required;
• Advanced Excel and Expert knowledge of SQL, Database management skills, including Macro development
• Proficient in Crystal or other reporting tools;
• Advanced programming/configuration/analytical skills to achieve business and or technical requirements
• Ability to work independently to resolve discrepancies, defects, incidents or problems with understanding of the business and system impacts
• Project management and Strong Communication
• Data analysis and Technical/functional expertise including Business systems maintenance
• Data Robotics or Automation knowledge, is an asset
• Experience with Infor Hospital applications is an asset;
• 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 and Access;
• Experience with Visual Basic, Microsoft Access, SQL, or any other programming language
• Analytical and problem solving skills: 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;
• Time management: need to be able to work on many projects with different deadlines;
• Must be able to work independently and under pressure with tight deadlines.
• Must be motivated and self-directed;
• Demonstrates initiative and willingness to learn;
• Ability to identify and exercise appropriate escalation communications
• Aptitude for learning and applying new and/or updated programming languages, techniques, and/or software development disciplines
• Strategic thinking and Problem solving
• Identifies and documents risks, dependencies, and assumptions in accordance with project standards
• Ability to effectively communicate to all levels of management and leadership
• Self thinker able to work through issues and escalate only when appropriate
• Basic understanding of project management techniques and methodologies
• Competent use of Microsoft Office applications including PowerPoint, Word, and Visio
• IT relationship management
• Experience with workflow re-engineering using techniques such as Lean, Six Sigma, or another industry standard practice
• Previous experience with a non for profit healthcare system preferred;
• Experience with budgeting and forecasting for large complex organizations;
• Must be proficient in written and verbal communication skills;
• Excellent analytical and problem-solving skills with an attention to detail;
• Ability to determine solutions in addition to recognizing problems;
• Astute judgment when identifying and resolving issues around time and risk management;
• Ability to prioritize and manage competing priorities;
• Strong project management and change management skills;
• Ability to operate at a high level of independent thinking;
• Resourceful and willing to take initiative;
• Ability to establish and maintain effective working relationships with hospital staff and clients;
• Ability to maintain confidential information concerning personal, financial, or medical matters;
• Team leadership and team development skills;
• Challenges and questions issues, with an inquiring mind and the ability to recommend strong solutions;
• Excellent organizational, communication and decision making/problem solving and interpersonal skills;
• Demonstrated flexibility in responding to work demands.

Unity Health Toronto is committed to creating an accessible and inclusive organization. We strive to provide a recruitment process that is barrier-free and in compliance with the Accessibility for Ontarians with Disabilities Act (AODA) and the Ontario Human Rights Code. We understand that you may require an accommodation at any stage of the recruitment process. When you are contacted, please inform the Talent Acquisition Specialist and we will work with you to meet your accommodation needs. We want to emphasize that all accommodation requests are handled with the utmost confidentiality, respecting your privacy and dignity.