College Co-op: Sales Analytics & Reporting Analyst

Independence Blue Cross; Philadelphia (Philadelphia County); Sur place; USD 28 000 - 34 000; Temps partiel

Résumé du poste

Independence Blue Cross (IBX) is seeking a Sales Analytics & Reporting Co-op in Philadelphia to support enterprise membership reporting and forecasting initiatives. You will work with cross-functional teams across Sales, Finance, Actuarial, and Executive Leadership to deliver accurate dashboards and insights.

The role emphasizes hands-on work with enterprise data, reporting tools, and forecasting processes, offering hands-on experience in a dynamic health insurance environment.

Qualifications

• Experience with Excel for data analysis, pivot tables, lookups, and data visualization.
• Exposure to SQL through coursework or internships; ability to understand and modify queries.
• Experience with Power BI, Tableau, or similar visualization tools.
• Strong written and verbal communication skills.
• High attention to detail with commitment to data accuracy.
• Ability to work independently and collaboratively in a team.
• Willingness to learn new tools, technologies, and business processes.

Responsabilités

• Assist with the preparation and maintenance of dashboards, presentations, and reports using Excel, Power BI, and other tools.
• Support data validation and quality assurance across multiple data sources.
• Research and analyze variances in membership, sales, and forecasting data.
• Assist with membership reporting and forecasting processes through data collection and analysis.
• Document reporting processes and data definitions to improve knowledge sharing.
• Take on additional projects and assignments as needed.

Connaissances

Excel proficiency

SQL exposure

Power BI/Tableau

Effective communication

Attention to detail

Team collaboration

Willingness to learn

Formation

Business Analytics (preferred major)

Junior or Senior standing

Recent graduate (within 1 year)

GPA 3.0 or higher

Description du poste

College Co-op: Sales Analytics & Reporting Analyst

The Sales Analytics & Reporting team is responsible for enterprise membership reporting, forecasting, and analytics across Independence Blue Cross and its family of companies. The team serves as the primary source for membership reporting and provides analytical support to Sales, Finance, Actuarial, Underwriting, and Executive Leadership.

Co-op Position Overview:

The Sales Analytics & Reporting Co-op will support the team in delivering accurate, timely, and meaningful reporting and analysis. This role offers hands-on experience working with enterprise data, reporting tools, forecasting processes, and cross-functional business partners.

Key Responsibilities:

• Assist with the preparation and maintenance of dashboards, presentations, and reports using Excel, Power BI, and other reporting tools.
• Support data validation and quality assurance activities by reviewing information from multiple sources, including Informatics, Finance, and Actuarial.
• Research and analyze variances in membership, sales, and forecasting data.
• Assist with membership reporting and forecasting processes through data collection, organization, and analysis.
• Document reporting processes, business rules, data definitions, and reporting procedures to enhance knowledge sharing and operational efficiency.
• Perform additional projects and assignments as needed.

Required Skills & Qualifications:

• Strong proficiency in Microsoft Excel, including formulas, pivot tables, lookups, and data analysis techniques.
• Exposure to SQL through coursework, academic projects, or internships; ability to understand, modify, and execute existing queries is preferred.
• Experience with Power BI, Tableau, or other data visualization tools through coursework, academic projects, or internships is preferred.
• Effective written and verbal communication skills.
• Strong attention to detail with a commitment to data accuracy and quality.
• Ability to work both independently and collaboratively in a team environment.
• Willingness to learn new tools, technologies, and business processes.

Preferred Majors:

Business Analytics

Classification:

• Junior or Senior standing
• Recent graduate (must be within one year of the program start date)

GPA Requirement:

3.0 or higher

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, 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.