Programmer/Analyst 3

Qualifications 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.                        

Required Interview details (if applicable):

• All interviews to be scheduled by contracting agency(accommodating interviewer schedules).

• Candidate resumes should be attached to all meeting invites.

• All interviewees should be on camera during the interview.

• Microsoft teams is the platform of choice.