College Co-op: Product Analyst
About the Hiring Department:
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
· Data Analytics
· Statistics
· Database Management / SQL
· Finance
· Accounting
· Information Systems
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!
Equal Employment Opportunity
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 an Independence 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 and the Independence Blue Cross Family of Companies. Please note that no fee will be paid in the event the candidate is hired by Independence Blue Cross or the Independence Blue Cross Family of Companies as a result of the referral or through means other than our established process.