EPIC ETL & BI Administrator - Information Systems

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

Full time

Shift: First Shift (Days - Less than 12 hours per shift) (United States of America)
Hours per week:40
* 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.

Preferred Experience Qualifications
* 2 years SQL database administration experience, including SQL server integration services, report design and development. Required
* Experience with system software installation, configuration and updates. Required
* 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. Required
* Experience designing and building ETL. Preferred
* Experience supporting business intelligence systems. Experience in Tableau and ability to maintain Tableau data sources and dashboards. Preferred
* Experience in data warehouse modeling, creation and maintenance of, Data Mart, Data Cube, data dimensioning and fact tables maintenance. Preferred

Skills and Abilities

* Must be able to express or exchange ideas by means of the spoken word. (Required proficiency)
* Must have good manual dexterity and keyboarding skills. (Required proficiency)
* Must be able to view and read information on computer screens. (Required proficiency)
Licenses and Certifications
* 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.

What you will do
* 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…