College Co-op: Risk Analytics Analyst

Independence Blue Cross; Philadelphia (Philadelphia County); On-site; USD 36,000 - 48,000; Full time

Job summary

Independence Blue Cross is seeking a Risk Analytics Co-op to support ACA and Medicare risk adjustment initiatives. You will analyze healthcare data, build dashboards, and automate processes using SQL, Python, and Tableau.

You will gain exposure to industry-leading tools within a collaborative team, contributing to operational and financial decision-making while developing technical and communication skills.

Qualifications

• Analytical and problem-solving skills with large datasets.
• Experience with data extraction, transformation, validation, and reporting.
• Working knowledge of SQL and relational databases.
• Experience with Tableau or similar data visualization tools.
• Proficiency with Microsoft 365 apps (Excel, PowerPoint, Word).
• Experience using AI tools to automate tasks.

Responsibilities

• Monitor ACA EDGE server submission operations and support data validation & reporting.
• Assist RADV audit activities including sample tracking & chart collection.
• Retrieve reports from vendor portals and organize records.
• Prepare, rename, batch, transmit, and reconcile medical records for auditors.
• Use SQL, Python, Excel, Tableau to extract, transform, validate, and analyze data.
• Develop and maintain RADV dashboards, weekly status reports, and leadership briefings.
• Investigate discrepancies and coordinate resolution with stakeholders and vendors.
• Create process docs, workflows, and SOPs to support knowledge transfer.
• Translate metrics into actionable insights for decision-making.
• Support process improvements and automation to boost efficiency.

Skills

SQL

Python

Tableau

Microsoft 365

Copilot

Data validation

Data analysis

Education

Undergraduate student (Junior or Senior)

Tools

SSRS

SSIS

Visual Studio

Google BigQuery

R

Job description

The Commercial Risk Analytics team leverages data, technology, and business insights to strengthen Independence Blue Cross's ACA and Medicare Risk Adjustment programs. The team is focused on improving data accuracy, supporting regulatory compliance, identifying financial and operational risks, and delivering actionable reporting that enables informed business decisions.

This work directly supports the IHG 2030 strategy by advancing healthcare affordability and outcomes through accurate risk adjustment, driving operational excellence through improved efficiency and automation, and helping reshape the organization through analytics, artificial intelligence, and technology-driven innovation.

Position Summary

The Risk Analytics Analyst Co-op will gain hands-on experience supporting strategic initiatives that impact key business outcomes. Working alongside experienced professionals, the co-op will analyze healthcare data, build reports and dashboards, automate processes, and develop insights that support operational and financial decision-making.

This role provides exposure to industry-leading tools and technologies, including SQL, Python, Tableau, Microsoft 365, and Microsoft Copilot. Students will have the opportunity to strengthen their technical, analytical, and communication skills while making meaningful contributions within a collaborative team environment.

Key Responsibilities

• Monitor ACA EDGE Server submission operations and support related data validation and reporting activities.
• Assist with the annual ACA Risk Adjustment Data Validation (RADV) audit, including sample tracking, chart collection, record preparation, and audit-readiness activities.
• Retrieve reports and files from vendor portals and secure file transfer sites; organize records and maintain accurate tracking documentation.
• Prepare, rename, batch, transmit, archive, and reconcile medical records submitted to external auditors while following established file-naming and data-handling protocols.
• Utilize SQL, Python, Excel, and Tableau to extract, transform, validate, reconcile, and analyze large datasets.
• Develop and maintain RADV dashboards, weekly status reports, operational forecasts, and leadership presentations.
• Investigate data discrepancies, validate reporting results, coordinate resolution efforts with internal stakeholders and external vendors, and escalate issues when appropriate.
• Create and maintain process documentation, workflow diagrams, job aids, and standard operating procedures to support consistent execution and knowledge transfer.
• Translate operational metrics into actionable business insights, trends, and forecasts that support decision-making.
• Support ongoing process improvement and automation initiatives to enhance operational efficiency and data quality.

Qualifications

• Demonstrated analytical, technical, and problem-solving skills, including experience working with large datasets.
• Experience with data extraction, transformation, validation, quality assurance, and reporting.
• Working knowledge of SQL and relational databases, with experience analyzing large data sets.
• Experience with Tableau or other data visualization platforms preferred.
• Proficiency in Microsoft 365 applications, including Excel, PowerPoint, Word, Outlook, Teams, SharePoint, and Visio.
• Experience using Microsoft Copilot and other AI-enabled tools to analyze information, automate tasks, and improve productivity.
• Strong written and verbal communication skills.
• Ability to manage multiple priorities and work effectively in a collaborative environment.
• Experience with one or more analytical tools or technologies such as Python, R, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio, or Google BigQuery preferred.

Preferred Majors

• Business Analytics
• Data Science
• Economics
• Economics & Data Science
• Economics & Mathematics
• Information Systems
• Management Information Systems
• Computer Science
• Artificial Intelligence & Machine Learning
• Mathematics
• Mathematical Statistics

Eligibility Requirements

• Junior or Senior undergraduate students
• Recent graduates (must be within one year of the co-op start date)

3.2 GPA or higher

Independence Blue Cross is an Equal Opportunity and Affi­…(text truncated for brevity)

Must have an Android or iOS device which is compatible with the free Microsoft Authenticator app.

Inclusion and Belonging

At IBX, everyone can feel valued, supported, and comfortable to be themselves... (text truncated for brevity)

About Our Company

Serving more than 8 million people nationwide, including 2.5 million in southeastern Pennsylvania, Independence Health Group — together with its subsidiaries — is the leading health insurance organization in the Philadelphia region. Our mission to build healthier lives for you, your family, and your employees shapes our actions and decisions every day.

At Independence, we see each of our members as an individual, with unique needs and concerns. We’re dedicated to harnessing the very latest ideas and technologies to deliver access to care that meets those needs and surpasses your expectations. For more information about Independence access our website at www.ibx.com . We’re revolutionizing health care, and our focus is on you!

IBX is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to their age, race, color, religion, sex, national origin, sexual orientation, protected veteran status, or disability.