Business Informatics, Analytics & Operations Consultant I

The Business Informatics department is responsible for all business systems in the Network as well as critical business operational activities. Business areas supported include Human Resources, Payroll, Supply Chain and Finance. Team members have 4 disciplines including Business, Project Management, Application and Technical.

The BI Consultants support all business streams. They directly support 450+ users over 60+ jobs and indirectly support all 10000+ employees and managers for their daily self-service needs.

The Business Informatics Consultant is acritical strategic partner of all business areas as well as clinical areas as needed.

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. Patches to servers should be applied once a month, or as needed based on potential 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¿s 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
• Assist in the enforcement of business system procedures and policies for the following
• Security roles and profiles
• Technical infrastructure and architecture
• Interfaces and process flows
• Storage requirements
• Backup and recovery
• Database administration
• 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 which may cause deviation from agreed upon accounting rules and guidelines

Reporting and Analytics:

• Advanced Excel VBA Execute the implementation of new techniques and standards for data analytics, metrics and reporting
• Participate in discussions with the business on the underlying data model requirements for future operational and performance reporting
• Executing the corporate business systems reporting requirements. Ensuring appropriate reporting models are developed, maintained and modified to ensure accurate and timely delivery of reporting information.
• Lead or participate in the development and maintenance of the reporting technical infrastructure
• Designing, creating and maintaining dedicated database reporting servers
• Leveraging key tools such as SSIS (SQL Server Integration Services) in order to extract, transform and load data from multiple data sources into the reporting server.
• Lead or participate in the development and maintenance of reports usingmultiple business reporting tools
• LBI (Infor) / Crystal ¿ designing and maintaining reports in multiple environments
• EZ Reports (Inhouse) ¿ designing and maintaining reports in multiple environments
• Compass (Tableau) ¿ designing and maintaining reports in multiple environments
• Lead or participate in the design, development and maintenance of all KPIs and dashboards/scorecards.
• Responsible for ensuring that the following programming skills are developed and maintained within their core competencies
• Advanced SQL
• Advanced SSIS
• Advanced C#
• Advanced VB.NET
• Lead or participate in the development and maintenance of the various security layers for reporting

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 ¿ IT or Business related
• Minimumthree (3) years¿ experience working with Integrated Systems
• Experience with Infor Hospital applications is an asset
• 3+ years accounting /business experience
• Expert knowledge of SQL
• Project Management experience ¿ 3+ years of successfully executing mid to large scale projects
• Proficient in Crystal or other reporting tools
• 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
• Must be motivated and self-directed.
• Demonstrates initiative and willingness to learn
• 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.