Junior Data Analyst

Bletchley Institute; United States; Remote; USD 50,000 - 85,000; Full time

Job summary

An innovative institute is on the lookout for a detail-oriented Junior Data Analyst to join their healthcare regulatory compliance team. This exciting role involves designing random sampling methodologies, automating processes using VBA, and analyzing healthcare data to ensure compliance and support quality improvement initiatives. The ideal candidate will thrive in a remote work environment while collaborating with compliance teams to uphold data integrity. If you are passionate about data analysis and eager to contribute to meaningful healthcare outcomes, this position offers a fantastic opportunity to grow your skills in a supportive and dynamic setting.

Benefits

Health Savings Account with Employer Contribution

401(k) Retirement Plan with Match

Employee Assistance Program (EAP)

Paid Time Off

Paid Holidays

Certification and Professional Development Support

Qualifications

• Experience in healthcare data analysis and statistical sampling methodologies.
• Proficiency in VBA for automation in Excel.

Responsibilities

• Design random sampling methodologies for medical record audits.
• Develop VBA macros to automate audit processes.

Skills

Healthcare Data Analysis

Statistical Sampling Methodologies

VBA Programming

Microsoft Excel

Understanding of HIPAA Compliance

Education

Bachelor's degree in Statistics

Bachelor's degree in Mathematics

Tools

RAT-STATs

SQL

Data Visualization Tools

Job 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

1. Design and execute random sampling methodologies for medical record audits across multiple practices and hospitals
2. Develop and maintain VBA macros to automate encounter selection and streamline audit processes
3. Use statistical software (RAT-STATS or similar) to determine appropriate sample sizes and confidence levels and calculate repayments based upon statistical principles
4. Create and maintain audit tracking spreadsheets and reports
5. Generate detailed documentation of sampling methodologies and selection criteria
6. Collaborate with compliance teams to ensure audit data selection and sampling requirements are met
7. Communicate with client organizations to obtain clean claims data for purposes of initiating data sampling
8. Support data collection and analysis for quality improvement initiatives
9. Maintain strict patient and organizational confidentiality

Requirements

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

Preferred Qualifications

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

Technical Skills

1. Advanced Microsoft Excel and VBA programming
2. Statistical sampling software; RAT-STATs preferred
3. Basic SQL knowledge
4. Data visualization tools

Key Projects Will Include

1. Working with clients and compliance teams to obtain clean data and sample selection
2. Developing automated tools for random encounter selection
3. Creating repeatable sampling processes for regular audits
4. Building tracking systems for multi-practice audit programs
5. 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:

• Health Savings Account with Employer Contribution
• 401(k) Retirement Plan with Match
• Employee Assistance Program (EAP)
• Basic Life, AD&D, Short/Long-Term Disability
• Paid Time Off
• 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.