College Co-op: Risk Analytics Analyst

Independence Blue Cross; Philadelphia, Northern (Philadelphia County, KY); On-site; USD 25,000 - 36,000; Part time

Job summary

Independence Blue Cross in Philadelphia is seeking a Risk Analytics Co-op to support ACA and Medicare risk adjustment initiatives. You will analyze healthcare data, build reports and dashboards, automate processes, and provide insights to help operational and financial decisions.

You will gain hands-on experience with SQL, Python, Tableau, and Microsoft 365, contributing to RADV audits, data validation, and governance.

Qualifications

• Demonstrated analytical, technical, and problem-solving skills with large datasets.
• Experience with data extraction, transformation, validation, quality assurance, and reporting.
• Working knowledge of SQL and relational databases; ability to analyze large data sets.
• Experience with Tableau or other data visualization platforms preferred.
• Proficiency in Microsoft 365 apps, including Excel, PowerPoint, Word, Outlook, Teams, SharePoint, and Visio.
• Experience using Microsoft Copilot and other AI-enabled tools to automate tasks.
• Strong written and verbal communication skills.
• Ability to manage multiple priorities in a collaborative environment.
• Experience with one or more analytical tools such as Python, R, SSRS, SSIS, Visual Studio, or BigQuery preferred.

Responsibilities

• Monitor ACA EDGE Server submission operations and reporting activities.
• Assist with the RADV audit, including sample tracking, chart collection, and record preparation.
• Retrieve reports from vendor portals and secure file transfer sites; organize records and maintain tracking docs.
• Prepare, rename, batch, transmit, archive, and reconcile medical records for external auditors.
• Utilize SQL, Python, Excel, and Tableau to extract, transform, validate, and analyze large datasets.
• Develop and maintain RADV dashboards, weekly status reports, and leadership presentations.
• Investigate data discrepancies and coordinate resolution with stakeholders and vendors.
• Create and maintain process docs, workflow diagrams, and SOPs.
• Translate operational metrics into actionable insights, trends, and forecasts.
• Support process improvements and automation to enhance data quality.

Skills

SQL

Python

Tableau

Excel

Copilot

Data Analysis

Communication

Team Collaboration

Education

Business Analytics

Data Science

Economics

Information Systems

Management Information Systems

Computer Science

Artificial Intelligence & Machine Learning

Mathematics

Tools

SQL Server Reporting Services (SSRS)

SQL Server Integration Services (SSIS)

Visual Studio

Google BigQuery

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 elevate 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 Aff…

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

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.

Inclusion and Belonging

At IBX, everyone can feel valued, supported, and comfortable to be themselves, and all associates have a fair opportunity to achieve their full potential. We put these principles into action every day by acting with integrity and respect. Celebrating and embracing diverse thoughts and perspectives that make up our workforce means our company is more vibrant, innovative, and better able to support the people and communities we serve.

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.

Agency Disclaimer

All resumes submitted directly to anIndependence Blue Cross employee from a vendor via email, the Internet or in any other form without a valid written search agreement in place for this position from the Independence Blue Cross Family of Companies Human Resources Department will be deemed the sole property of Independence Blue Cross andthe Independence Blue Cross Family of Companies. Please note that no fee will be paid in the event the candidate is hired by