Required

Epic Cogito Certified

Experience with Epic Caboodle/Clarity, especially the ability to reengineer processes/interfaces to pull directly from these applications.

5+ years of experience in data warehouse maintenance and development, including advanced capabilities using SSMS, T-SQL, and SSIS.

Able to analyze and create detailed SQL code, and to use MS tools available to ensure solid query performance.

Comfortable with extremely complex development projects.

Able to implement in and/or infer from code bases complicated business rules with multiple layers of processing and multiple output formats.

Solid knowledge of star schema output and dimensional modelling, fact table loading, data staging, backout and deduping processes.

Experience with multiple file formats and use of SSIS to accommodate imports of those source types.

Experience within a Healthcare setting.

Desired

Strong skills in run support for multiple large and complex datasets, primarily focused on Authorizations/Referrals data, including relationships to Eligibility and Claims.

Ability to support entire DW job structure regardless of subject matter expertise, monitor jobs, and to trouble shoot job errors or warnings when needed.

Experience with Epic Service Level Auth data structures, is highly desirable.

Responsibilities

Integrating Epic’s Service Level Auths data structures into an existing Data Warehouse as applicable

Research and analysis required to accommodate the above

Updating any existing/new SSIS jobs and packages to accommodate the above

Follow best practices and standards including peer and code reviews.