College Intern - Summer 2027 - Internal Auditing

Excellus BCBS; City of Rochester (NY); On-site; USD 25,000 - 28,000; Full time

Benefits offered by this job

Remote work possibility

Job summary

Excellus BCBS in Rochester, NY is offering a Summer College Internship Program for 10 weeks of paid experience from June to August. Interns work on meaningful projects across tracks such as Business Administration, IT, Analytics, Finance, Marketing, and more, under the guidance of mentors.

The program includes development workshops, networking opportunities, and exposure to real corporate challenges. Eligible undergraduates and graduates will gain hands-on experience, participate in Power BI and

Qualifications

• Must be enrolled in an undergraduate or graduate degree program.
• Strong communication skills and ability to work independently.
• Familiarity with Power BI and data analysis tools is a plus.

Responsibilities

• Attend development workshops and participate in projects across tracks.
• Work with a mentor and support key program initiatives.
• Assist with data tasks and prepare presentations as needed.

Skills

Power BI

MS Office

Communication

Self-motivation

Education

Business & Management programs

Computing Sciences & IT programs

Management Information Systems programs

High School diploma with continuous college enrollment

Tools

ACL

SAS

Python

Job description

Job Description

The Summer College Internship Program is a 10-week paid internship experience that provides undergraduate and graduate students with the opportunity to attend development workshops, network, and be part of our company. Our college interns work on meaningful projects, are mentored under their respective managers, and continue to develop throughout the entire summer. Through the internship program, our interns can attend development workshops that are focused on key business concepts. Interns may work within the skills-based tracks of Business Administration, Information Technology, Actuarial, Human Resources, Analytics & Data, Communications, Finance, Marketing & Sales, Project Management, Clinical Studies, Customer Experience, Digital Operations, and other non-technical and/or technical based degree programs.

• This is a paid 10-week summer internship from the first Monday in June to the second Friday in August (up to 40 hours per week).
• Interns may reside in either a technical or non-technical area.
• Development workshops are provided to help with the transition from school to the corporate environment.
• Housing is not provided as part of our program.

Summary

Job Description

The Summer College Internship Program is a 10-week paid internship experience that provides undergraduate and graduate students with the opportunity to attend development workshops, network, and be part of our company. Our college interns work on meaningful projects, are mentored under their respective managers, and continue to develop throughout the entire summer. Through the internship program, our interns can attend development workshops that are focused on key business concepts. Interns may work within the skills-based tracks of Business Administration, Information Technology, Actuarial, Human Resources, Analytics & Data, Communications, Finance, Marketing & Sales, Project Management, Clinical Studies, Customer Experience, Digital Operations, and other non-technical and/or technical based degree programs.

• This is a paid 10-week summer internship from the first Monday in June to the second Friday in August (up to 40 hours per week).
• Interns may reside in either a technical or non-technical area.
• Development workshops are provided to help with the transition from school to the corporate environment.
• Housing is not provided as part of our program.

Essential Accountabilities

• Specific duties will vary by assignment; specific divisional callouts are listed below.
• Model Audit Rule Control Testing, MAR Process Narrative Tracking and Review, MAR Balance Sheet Review and Mapping Analysis

Operational Audit

• Attend Operational Audit Planning Meetings, Support Auditor in Charge with Operational Audit Controls and Substantive Testing, Participate in Entrance and Exit Meetings
• Assist with Policy tracking
• Assist with uploading policies to Logic Gate
• Attend Quarterly CPC Meeting if available
• Update and Generate Audit Dashboard Using Power BI
• Assist with creation of External Auditor Status Document
• Works with a mentor and supports key strategic projects.
• Completes work assignments based on business needs, departmental priorities, and individual qualifications.
• Performs a mix of technical and/or non-technical tasks that will cover a broad range of business-related projects.
• Creates and delivers presentations at completion of internship.
• Consistently demonstrates high standards of integrity by supporting the Lifetime Healthcare Companies' mission and values, adhering to the Corporate Code of Conduct, and leading to the Lifetime Way values and beliefs.
• Maintain confidentiality and protection of member privacy in accordance with the company policies.
• Regular and reliable attendance is expected and required.
• Performs other functions as assigned by management.

Minimum Qualifications

• Desired Majors/Degree Programs Include: Business & Management (i.e. Finance, Actuarial, Accounting, Management, Marketing, Supply Chain Management, etc.); Computing Sciences & Information Technology (i.e. Computer Science, Software Engineering, IT Networking, Cybersecurity, etc), Management Information Systems, or similar program(s)
• Preferred (but not required) experience with: Microsoft Office Suite, communication skills, self-starter, ability to work independently, Experience using Power BI, ACL, SAS R, Python or other data analysis and coding tools is preferred.
• High School diploma along with proof of continuous college enrollment (enrolled in a full-time undergraduate or graduate degree program).
• Must be in good academic standing.
• Excellent written and verbal communication skills, with ability to interact with technical and non-technical audiences and interface with staff at all levels of the company.
• Ability to multitask in a fast-paced environment while maintaining strong attention to detail changing environment and deliver high-quality work product.
• Ability to work well in a team establishing good working relationships with peers.
• Demonstrates strong organizational, analytical, problem-solving and prioritization skills.
• Proactive approach to work, displaying creativity and flexibility in completing assigned tasks.
• Commitment to continuous improvement of skills and team functioning.
• Self-motivated and able to work independently, as well as on intra- and inter- departmental teams as needed.
• Experience with Microsoft Office Suite.
• Experience using a desktop computer in a professional environment.

Physical Requirements

• Ability to work while sitting and/or standing at a workstation viewing a computer and using a keyboard, mouse and/or phone for three (3) or more hours at a time.
• Ability to travel across the Health Plan service region for meetings and/or training courses as needed.

In support of the Americans with Disabilities Act, this job description lists only those responsibilities and qualifications deemed essential to the position.

Equal Opportunity Employer

Compensation Range(s)

Level I - Minimum $18.00 - Maximum $20.00

The salary range indicated in this posting represents the minimum and maximum of the salary range for this position. Actual salary will vary depending on factors including, but not limited to, budget available, prior experience, knowledge, skill and education as they relate to the position’s minimum qualifications, in addition to internal equity. The posted salary range reflects just one component of our total rewards package. Other components of the total rewards package may include participation in group health and/or dental insurance, retirement plan, wellness program, paid time away from work, and paid holidays.

Please note: There may be opportunity for remote work within all jobs posted by the Excellus Talent Acquisition team. This decision is made on a case-by-case basis.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.