Data Warehouse ETL Developer and Administrator (Epic)

OVERVIEW: Resource will provide medical claims and payor data (eligibility, medical, vision, lab, pharmacy)Extract, Transform and Load (ETL) services using Structured Query Language (SQL) to:

(1)migrate Claims processing from the County s custom schema to Epic standard Caboodleschemas;

(2) combine custom SQL Server Integration Services (SSIS) packages for QualityIncentive Program (QIP) Payor Data into one QIP master package; and

(3) standardize andoptimize QIP Claims eligibility processing.

Required Skills & Abilities: Minimum 3 years of ETL development, at least one of which in the Epic domain a plus Strong SQL development using best practice industry standards Working knowledge of healthcare related financial and transactional files (including billing, eligibility, claims) Experience in building scalable data architecture Experience in full data integration solutions with existing data architectures

Experience in importing from and to 3rd party agency or vendor data: Experience designing, implementing, and maintaining sustainable, scalable ETL processes Must be a self-starter comfortable working under general direction (opposed to active supervision)Desired Skills & Abilities: Strong Microsoft SSIS experience Strong Microsoft SQL experience Strong Caboodle development experience for both Epic and Non-Epic data Strong Epic Clarity and Caboodle data model knowledge, including all financial aspects as well as relevant clinical aspects that drive coding and billing Healthcare financial data acumenCertifications Epic Clarity or Epic Caboodle Data Model and Development Certification(s) - Clinical or Financial (or legacy equivalents)