What are the responsibilities and job description for the Junior Data Analyst position at Coker Group Holdings LLC?
We are seeking a detail-oriented Junior Data Analyst to join our healthcare regulatory compliance and audit team. This role will primarily focus on medical audit sampling, data analysis, and reporting to support our organization's compliance and audit initiatives. The ideal candidate will have experience with healthcare data analysis and the ability to automate sampling processes.
Essential Duties and Responsibilities
- Design and execute random sampling methodologies for medical record audits across multiple practices and hospitals
- Develop and maintain VBA macros to automate encounter selection and streamline audit processes
- Use statistical software (RAT-STATS or similar) to determine appropriate sample sizes and confidence levels and calculate repayments based upon statistical principles
- Create and maintain audit tracking spreadsheets and reports
- Generate detailed documentation of sampling methodologies and selection criteria
- Collaborate with compliance teams to ensure audit data selection and sampling requirements are met
- Communicate with client organizations to obtain clean claims data for purposes of initiating data sampling
- Support data collection and analysis for quality improvement initiatives
- Maintain strict patient and organizational confidentiality
