Request ID:BL-9460-1 (97590724)
Healthcare ETL Developer with R/Python (must), SAS, SQL, DBA, MMIS and Medicaid/Medicare/Claims Processing experience
Location:Columbia SC
Qty:2
Duration:6 Months Hrs/Wk:40.00
REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):
• Master’s Degree and 3 years of relevant experience; OR Bachelor’s Degree with major courses in a technical field and five years of relevant experience or equivalent work experience
• Experience with large relational database administration
• Demonstrated experience in healthcare claims data management and analysis, such as Medicare, Medicaid, and private insurance data
• Proficiency in R/Python or other scripting language
• Experience working with ETL processes
• Interest in public health or issues relevant to health services research and health program/policy evaluation
• Ability to exercise sound judgment in making decisions and maintain thorough documentation of the decision-making process
• Exemplary communication skills and ability to effectively communicate complicated processes to diverse audiences within and outside OHSU
• Strong commitment to rigorous research methods, objectivity and accuracy of findings, and reproducibility of results
PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):
• Experience with Medicaid claims data
• Knowledge of structuring data for Tableau
• Knowledge of SAS
• Strong knowledge of SQL
• Experience working in Windows environment
REQUIRED EDUCATION/CERTIFICATIONS:
Master’s Degree and 3 years of relevant experience; OR Bachelor’s Degree with major courses in a technical field and five years of relevant experience. Or equivalent work experience.
Experience
AdministrativeVerbal Communication SkillsYes1AdvancedCurrently Using
AdministrativeWritten Communication SkillsYes1AdvancedCurrently Using
Database PlatformsScripting Language experienceYes1AdvancedCurrently Using
EducationBachelor’s degree in a technical or business fieldNo1
EducationMaster’s DegreeNo1
MiscellaneousDatabase AdministrationYes1AdvancedCurrently Using
MiscellaneousETL Process and DevelopmentYes1AdvancedCurrently Using
MMIS – Medicaid Management Informaiton SystemMedicaidNo1AdvancedCurrently Using
MMIS – Medicaid Management Informaiton SystemMedicareNo1AdvancedCurrently Using
SpecialtiesHealthcare Claims ProcessingYes1AdvancedCurrently Using
Remote Work Availability:0%
DAILY DUTIES / RESPONSIBILITIES:
• Management of large databases of health insurance claims from Medicaid, Medicare, and all-payer warehouses, other state administrative datasets, as well as EHR data, and development of validation processes to ensure data quality
• Building out and automating various Extract, Transform, Load (ETL) processes across the Institute
• Coordination and problem-solving with Institute faculty/staff in order to understand needed support and use cases
• Development of innovative solutions to fill gaps in analytics
• Active contribution to the review of working practices and the development of data analysis and management standard operating procedures
• Performance of other research related duties as assigned