Financial Planning and Analytics… at Blue Cross &… · Providenc…

Summary: Blue Cross & Blue Shield of Rhode Island (BCBSRI) is looking for local undergraduate students to participate in their dynamic, paid summer internship program for 2026. The internship offers hands-on experience in various business areas, focusing on financial analysis and planning to drive positive change in the community. Responsibilities: - Assist with basic quantitative and financial analyses by gathering data, performing calculations, and organizing results for review by senior team members - Support analysis of decision alternatives by preparing spreadsheets, running standard calculations, and summarizing outputs under guidance - Assist with the development of premium, claims expense, and enrollment projections by updating models, validating inputs, and comparing historical data to current assumptions - Work with subject matter experts and team members to help understand data sources, assumptions, and reporting requirements - Support the annual budgeting process by assisting with data collection, template preparation, and reconciliation activities in accordance with established guidelines - Assist in compiling operating expense and other financial data used for pricing or regulatory reporting, ensuring accuracy and completeness of supporting documentation - Help prepare financial reports, schedules, and presentation materials for various audiences by updating spreadsheets, charts, and exhibits - Assist with monthly actual‑to‑budget comparisons by preparing variance summaries and identifying notable differences for further review - Support benchmarking activities by gathering internal or external data and maintaining comparison files or reports - Assist with monitoring actual financial results by updating tracking tools and preparing draft summaries of trends or variances - Help maintain dashboards and recurring reports by refreshing data, verifying calculations, and ensuring consistency of presentation - Support department initiatives and special projects by completing assigned analytical or administrative tasks - Assist with basic automation or system improvement efforts, such as testing spreadsheet tools, documenting processes, or helping maintain calculation models - Perform other duties as assigned to support the finance and analytics team Required Qualifications: - Basic understanding of financial statements and financial analysis concepts gained through coursework or academic projects - Introductory knowledge of managerial accounting principles and cost concepts - Familiarity with basic mathematical concepts and analytical methods, with the ability to apply them under guidance - Ability to research data, organize findings, and identify basic trends or observations for review by senior team members - Strong attention to detail and accuracy when working with numbers, data, and documentation - Ability to work effectively in a collaborative, matrixed team environment while receiving direction from multiple stakeholders - Clear written and verbal communication skills, with the ability to explain work, ask questions, and share information professionally - Ability to exercise judgment appropriate to an intern role and seek guidance when tasks or issues are unclear - Willingness to take initiative in learning new skills and contributing to solutions under supervision - Ability to build and maintain positive working relationships with team members and internal partners - Ability to organize assigned work efficiently and meet deadlines with guidance and established priorities - Good organizational skills, including maintaining orderly files, data, and documentation - Good time-management skills and reliability in completing assigned tasks on schedule - Working knowledge of Microsoft Office products, particularly Excel, Word, and PowerPoint, with a willingness to learn advanced functionality Required Skills: Financial analysis, Microsoft Excel, Data analysis Important Skills: Managerial accounting Nice-to-Have Skills: Communication skills, Attention to detail, Organizational skills, Time management Internship Start Date: Start in 2026 Summer Benefits: Flexible work arrangements that include remote and hybrid opportunities, Paid time off, Tuition reimbursement, Student-loan repayment, Health, dental, and vision insurance, Programs that support your mental health and well-being, Competitive pay, Bonuses, Investment plans, Additional paid time to volunteer