We have an immediate long-term opportunity with one of our prime clients for a position of Programmer/Analyst 3to work on Remote basis.
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.
ALL successful candidates for this position are required to work directly for PRIMUS. No agencies please only W2**