Medical Data Analyst (batch file, SQL)

These files need to be received and converted into a usable, searchable database for analytics purposes by Medicaid/HHSC programs, into the OMOP EHR database architecture. Without such a database, the real-time files will not work for the numerous use cases that are being developed. The two forms of clinical data being sent to HHSC, as part of the Health Information Exchange (HIE) Connectivity Project, are Admission, Discharge, Transfer (ADT) messages and Consolidated Clinical Document Architecture (C-CDA). This data is delivered to HHSC in individual .xml and .csv files and is currently coming through a single source. These files need to be received and converted into a usable, searchable OMOP database for analytics purposes by Medicaid/HHSC programs. Without such a database, the real-time files will not work for the numerous use cases that are being developed. Vendor focus for candidates: Strong SQL experience Medicaid or Public Health experience Good understanding of HL7 V2 and V3 data structures OMAP knowledge/experience: The Observational Medical Outcomes Partnership (OMOP) CDM model for Electronic Health Records (HER) Azure cloud development platform experience Corepoint or Rhapsody experience Python experience ETL experience (Informatica preferred) II. CANDIDATE SKILLS AND QUALIFICATIONS Minimum Requirements: Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity. Years Required/Preferred Experience 8 Required Experience with batch file programming 8 Required Experience designing and developing complex SQL scripts that are fast and efficient. 8 Required Strong analytical and problem-solving skills with experience as a system analyst for a data analytics, performance management system, or data warehousing project. 8 Required Experience on an agile sprint team 4 Preferred Experience with HL7/FHIR data structures 4 Preferred Bachelor’s degree in Computer Science, Information Systems, or Business or equivalent experience. 4 Preferred Prior experience in the Healthcare Industry 4 Preferred Prior experience with an HHS agency 4 Preferred Prior experience working with PII or PHI data 4 Preferred Experience using Corepoint/Rhapsody 4 Preferred Experience with JIRA software 4 Preferred Excellent oral and written communication skills. 4 Preferred Understanding of security principles and how they apply to healthcare data 4 Preferred Proven ability to write well designed, testable, efficient code by using best software development practices 4 Preferred Effectively manage multiple responsibilities, prioritize conflicting assignments, and switch quickly between assignments, as required. Job Types: Contract, Full-time Pay: $50.00 - $70.00 per hour Benefits: Paid time off Schedule: Monday to Friday Application Question(s): Required two professional references for the Interview process - Experience: batch file programming: 8 years (Preferred) designing and developing complex SQL scripts: 8 years (Preferred) Strong analytical and problem-solving skills: 8 years (Preferred) agile sprint team: 8 years (Preferred) HL7/FHIR data structures: 5 years (Preferred) Healthcare Industry: 1 year (Preferred) PII or PHI data: 1 year (Preferred) Ability to Commute: Austin, TX 78701 (Preferred) Ability to Relocate: Austin, TX 78701: Relocate before starting work (Preferred) Work Location: In person