Junior Data Analyst

Location - Remote - United States

Base Pay - $60000.00 - $70000.00 / Year

Employee Type - FT Exempt

Minimum Experience - 1 Year

Maximum Experience - 2 Years

Contact information

• Name - Madison Deese
• Email - mdeese@cokergroup.com

Description

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

Requirements

• Bachelor's degree in Statistics, Mathematics, or related field (or equivalent combination of education and experience)
• Proficiency in Microsoft Excel VBA for automation of sampling and reporting processes
• Experience with statistical sampling methodologies and software; experience with RAT-STATs software preferred
• Strong understanding of random sampling techniques and confidence intervals
• Experience with Microsoft Excel (including pivot tables, charts, and graphs)
• Understanding of HIPAA compliance and healthcare data privacy requirements

Preferred Qualifications

• 1-2 years of healthcare data analysis experience
• Experience with SQL and database management
• Knowledge of healthcare terminology and medical coding claims data
• Familiarity with electronic medical records (“EMR”) systems
• Experience with statistical software packages

Technical Skills

• Advanced Microsoft Excel and VBA programming
• Statistical sampling software; RAT-STATs preferred
• Basic SQL knowledge
• Data visualization tools
• Healthcare reporting systems

Summary

Key Projects Will Include

• Working with clients and compliance teams to obtain clean data and sample selection 
• Developing automated tools for random encounter selection
• Creating repeatable sampling processes for regular audits
• Building tracking systems for multi-practice audit programs
• Generating statistical reports for compliance documentation

Working Conditions

• Full-time
• Remote
• Occasional evening or weekend work may be required
• Limited travel for training or meetings

BENEFITS:

• Medical/Dental/Vision Coverage
• Health Savings Account with Employer Contribution
• 401(k) Retirement Plan with Match
• Employee Assistance Program (EAP)
• Basic Life, AD&D, Short/Long-Term Disability
• In Office Lunch Perks
• Telework Opportunities
• Paid Time Off
• Parental Leave
• Paid Holidays
• Certification and Professional Development Support

DIVERSITY IN HIRING:

Coker's success has always depended in large measure on the individual and collective ability of its people. The different perspectives, backgrounds, and individual styles of our people offer great opportunities to add value to the firm, and we believe that each person’s role is vital to Coker success. Coker is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment.