College Intern - Summer 2027 - Internal Auditing

Capital District Physicians Health Plan Inc; Town of De Witt (NY); Remote; USD 25,000 - 28,000; Full time

Benefits offered by this job

Remote work option

Job summary

Capital District Physicians Health Plan Inc (CDPHP) invites undergraduates and graduates to a 10-week paid Summer College Internship Program. Interns contribute to meaningful projects, are mentored by managers, and participate in development workshops across business, IT, analytics, and more.

Selected interns work up to 40 hours/week, with mentoring and exposure to Power BI, data analysis, and policy tracking. Housing is not provided, and remote work may be available case-by-case.

Qualifications

• Pursuing undergraduate or graduate degree in business, IT or similar.
• Strong written and verbal communication skills.
• Experience with data analysis tools and ability to work independently.

Responsibilities

• Model Audit Rule Control Testing and MAR review activities.
• Attend Operational Audit Planning Meetings and assist with controls testing.
• Update and generate Audit dashboards using Power BI.
• Support policy tracking and documentation preparation.

Skills

Power BI

ACL

SAS

Python

Microsoft Office Suite

Communication skills

Self-starter

Teamwork

Education

High School diploma

Undergraduate or graduate degree program

Tools

Microsoft Excel

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.

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.

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 CDPHP Talent Acquisition team. This decision is made on a 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.