EPIC ETL & BI Administrator 3 - Information Systems Applications - FT - Day

Stormont Vail Health•Topeka, KS

7d•Hybrid

About The Position

This role covers five primary responsibilities: • Epic Data Warehouse • Clarity Analytics Servers • SAP Business Objects • Tableau • SlicerDicer An employee in this role is responsible for creating and maintaining the Epic reporting analytical databases (Clarity), installs and maintains the Epic Data Warehouse (Caboodle), ensures that the extract, transfer, and load (ETL) processes complete daily, develops custom ETL import packages and data models, and installs, configures, manages, and monitors the SAP Business Objects Business Intelligence (BI) platform used for Epic-BI integrations.

Requirements

Master's Degree IT, computers, data science or a related field. Master's is only required if applicant has no project management experience or active industry certification.
Experience with system software installation, configuration and updates.
Spends at least 6 months per year managing projects. Eligible projects will be at least a month in length and approved by the employees manager/director as an eligible project. Approved projects should involve multiple teams such as the vendor, different application teams, or end users/testers. Education or active industry certification may be substituted for this project management requirement.
Experience designing and building ETL.
Must be able to express or exchange ideas by means of the spoken word.
Must have good manual dexterity and keyboarding skills.
Must be able to view and read information on computer screens.
2 active industry certifications (like MCSA or HIMSS) is required if applicant does not meet education requirement or project management experience.
Support for some vendor applications requires formal certification. For positions that primarily support Epic applications, vendor certification is required within 4 months of the last date of training for a given certification track. If certification is not achieved within this timeframe employee will voluntarily resign from this position.

Nice To Haves

2 years SQL database administration experience, including SQL server integration services, report design and development.
Experience supporting business intelligence systems.
Experience in Tableau and ability to maintain Tableau data sources and dashboards.
Experience in data warehouse modeling, creation and maintenance of, DataMart, DataCube, data dimensioning and fact tables maintenance.

Responsibilities

Responds timely to user concerns regarding issues and acts to address needs; involves vendor when needed.
Tracks users’ concerns and looks for patterns in problems; utilizes support center software to log or follow up on each customer call, enter call status and document resolution.
Assists with resolution of hardware related issues, including printing.
Follows operational processes to assure systems stability and availability.
Tests any changes to system in test environment and works collaboratively with IS staff to ensure changes are moved to live environment in a coordinated manner, utilizing defined change management process.
Ensures appropriate application downtime procedures are communicated.
Creates and maintains documentation related to reporting functionality, support, application testing, downtime process, and restore.
Assists in development of end-user education.
Work with vendors to ensure appropriate installation of new applications, updates and upgrades.
Uses project management skills to effectively manage implementations, upgrades, and activities.
Serves as liaison between IS and patient care staff including physicians.
Seeks to understand the needs of report requestors.
Works with end-users to optimize use of the system, paying special attention to workflow.
Develops and implements system changes based on user recommendations and leadership approval.
Ensures changes needed to meet regulatory requirements, safety and financial requirements are appropriately prioritized.
Applies appropriate customer service concepts to daily activities such as communicating service levels, providing necessary status reports, maintaining high customer satisfaction levels, maintaining an awareness of industry trends/changes, and creating solutions that meet customer needs.
Provide on-call support for the application, ensuring 24x7 support.
Provides assistance to any staff member where priorities have been assigned by immediate supervisor.
Applies appropriate customer service concepts to daily activities such as communicating service levels, providing necessary status reports, maintaining high customer satisfaction levels, maintaining an awareness of industry trends/changes, and creating solutions that meet customer needs.
Work with Epic TS to determine cause of any reporting issues and perform necessary build, set up, backfill, etc. needed to resolve the issue.
Identifies and validates the appropriate technical solutions for various reporting needs.
Validates Epic Foundation Systems build and modifies existing or creates custom ETLs as needed to meet the data needs of the organization.
Assist the development of new Epic reporting tools and upgrades to existing applications.
Complete any build or set up required for system update.
Actively pursues the identification, development and implementation of improved processes within the reporting department based on personal or customer feedback.
Perform daily, weekly, monthly tasks as well as bi-monthly system update related to all reporting server systems.
Review system update Nova Notes related to Clarity, Caboodle and Business Intelligence.
Perform backfills to ensure data accuracy.
Ensure data integrity after system updates.
Coordinate data extracts into Clarity tables and Compass Upgrades.
Monitor, maintain and update Tableau data sources and dashboards
Complies with all policies, standards, mandatory training and requirements of Stormont Vail Health
Performs other duties as assigned