EPIC ETL

Position Status:

Shift:

Hours per week:

Job Information
Exemption Status: Exempt

A Brief Overview
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.

Education Qualifications

• 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, DataMart, DataCube, 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 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

Required for All Jobs

• Complies with all policies, standards, mandatory training and requirements of Stormont Vail Health
• Performs other duties as assigned

Patient Facing Options

• Position is Not Patient Facing

Remote Work Guidelines

• Workspace is a quiet and distraction-free allowing the ability to comply with all security and privacy standards.
• Stable access to electricity and a minimum of 25mb upload and internet speed.
• Dedicate full attention to the job duties and communication with others during working hours.
• Adhere to break and attendance schedules agreed upon with supervisor.
• Abide by Stormont Vail's Remote Worker Policy and will review and acknowledge the Remote Work Agreement annually.

Remote Work Capability

• Hybrid

Scope

• No Supervisory Responsibility
• No Budget Responsibility No Budget Responsibility

Physical Demands

• Balancing: Rarely less than 1 hour
• Carrying: Rarely less than 1 hour
• Eye/Hand/Foot Coordination: Frequently 3-5 Hours
• Feeling: Occasionally 1-3 Hours
• Grasping (Fine Motor): Frequently 3-5 Hours
• Grasping (Gross Hand): Occasionally 1-3 Hours
• Handling: Occasionally 1-3 Hours
• Hearing: Frequently 3-5 Hours
• Lifting: Rarely less than 1 hour
• Pulling: Rarely less than 1 hour
• Pushing: Rarely less than 1 hour
• Reaching (Forward): Rarely less than 1 hour
• Reaching (Overhead): Rarely less than 1 hour
• Repetitive Motions: Frequently 3-5 Hours
• Sitting: Continuously greater than 5 hours
• Standing: Occasionally 1-3 Hours
• Talking: Occasionally 1-3 Hours
• Walking: Occasionally 1-3 Hours

Physical Demand Comments:
Must obtain impressions through the eyes of shape, size, distance, motion, color or other characteristics of objects. The vision requirements include close vision, ability to distinguish color.

Working Conditions

• Noise/Sounds: Rarely less than 1 hour

Stormont Vail is an equal opportunity employer and adheres to the philosophy and practice of providing equal opportunities for all employees and prospective employees, without regard to the following classifications: race, color, ethnicity, sex, sexual orientation, gender identity and expression, religion, national origin, citizenship, age, marital status, uniformed service, disability or genetic information. This applies to all aspects of employment practices including hiring, firing, pay, benefits, promotions, lateral movements, job training, and any other terms or conditions of employment.

Retaliation is prohibited against any person who files a claim of discrimination, participates in a discrimination investigation, or otherwise opposes an unlawful employment act based upon the above classifications.