College Intern - Summer 2027 - Healthcare Analytics
Lifetime Benefit Solutions, Inc. · DeWitt, NY · 1 mo ago
Analyst$18/hrVolunteer
We need to output HTML fragment with sections: About the role? The posting includes summary and description. We need to decide sections: maybe "About the role", "Responsibilities", "Qualifications", "Skills", "Benefits", "Pay", "Schedule". Must include only sections with real content. We have details: It's a 10-week paid internship, start date, hours, etc. That could go under "About the role" or "Schedule". Pay: compensation range $18-$20 per hour. Benefits: mention group health/dental insurance, retirement plan, wellness program, paid time away, paid holidays, possible remote work. Also mention housing not provided. Also mention development workshops, mentorship, etc.
We need to avoid boilerplate like EEO, legal, duplicated lines. Remove cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate, duplicated lines, and application instructions. So we should not include the Equal Opportunity Employer paragraph. Also not repeat compensation range twice.
We need to preserve all substantive info. Let's extract:
- Job title: Summer College Internship Program (but we don't repeat as heading).
- It's a 10-week paid internship experience for undergrad/grad students.
- Provides development workshops, networking, meaningful projects, mentorship.
- Interns can attend development workshops focused on key business concepts.
- Interns may work within skills-based tracks: list many tracks (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 help transition from school to corporate environment.
- Housing is not provided.
- Essential Accountabilities: Specific duties vary by assignment; specific divisional callouts listed below.
- Healthcare Analytics Intern specifics: embedded within Healthcare Analytics team; support projects improving healthcare affordability, quality, utilization management, data-driven decision-making.
- Extract, validate, analyze healthcare claims, enrollment, provider, quality data.
- Develop and maintain reports, dashboards, ad hoc analyses used by leadership and operational teams.
- Perform data quality reviews to identify anomalies, trends, opportunities for process improvement.
- Document business requirements, data definitions, analytical methodologies.
- Assist with data visualization and storytelling by translating complex findings into clear actionable summaries.
- Learn healthcare analytics concepts including utilization, cost and trend analysis, provider performance, quality measures, population health metrics.
- Works with a mentor and supports key strategic projects.
- Completes work assignments based on business needs, departmental priorities, individual qualifications.
- Performs a mix of technical and/or non-technical tasks covering broad range of business-related projects.
- Creates and delivers presentations at completion of internship.
- Consistently demonstrates high standards of integrity by supporting Lifetime Healthcare Companies' mission and values, adhering to Corporate Code of Conduct, leading to Lifetime Way values and beliefs.
- Maintain confidentiality and protection of member privacy per company policies.
- Regular and reliable attendance expected and required.
- Performs other functions as assigned by management.
- Minimum Qualifications: Desired Majors/Degree Programs Include: Epidemiology, Biostatistics, Public Health, Business & Management (Finance, Actuarial, Accounting, Management, Marketing, Supply Chain Management, etc.); Computing Sciences & Information Technology (Computer Science, Software Engineering, IT Networking, Cybersecurity, etc.); Social Sciences (Psychology, Sociology, Human Services, Law/Pre-Law, etc.); Health Professions & Life Sciences (Nursing, Public Health, Biology, Pharmacy, etc.) or similar program(s).
- Preferred (but not required) experience with: Candidates who are curious, analytical, interested in using data to solve real-world healthcare business problems.
- Experience with data analysis using SQL, SAS, or similar analytical tools.
- Proficiency in Microsoft Excel, including formulas, pivot tables, data manipulation, basic reporting.
- Familiarity with data visualization tools such as Power BI, Tableau, or similar platforms.
- Understanding of database concepts and data structures.
- 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.
- Ability to multitask in a fast-paced environment while maintaining strong attention to detail changing environment and deliver high-quality work product. (some grammar odd but keep)
- 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.
- Compensation Range(s): Level I - Minimum $18.00 - Maximum $20.00. (Repeated)
- 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.
- Also later: Please note: There may be opportunities for remote work on all jobs posted by the LBS Recruitment team. This decision is made on a case-by-case basis.
We need to include Pay section if posting actually states them. Yes, compensation range given. So include Pay.
Schedule: posting states "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)." That's schedule info. So include Schedule.
Benefits: mention group health/dental insurance, retirement plan, wellness program, paid time away, paid holidays, possible remote work. Also mention housing not provided (that's a negative but still info). Also development workshops, mentorship. So Benefits section.
About the role: could include overview of internship program, purpose, tracks, etc.
Responsibilities: could list the essential accountabilities (the Healthcare Analytics Intern duties). Could also include general responsibilities like attending workshops, networking, etc.
Qualifications: include minimum qualifications and preferred experience.
Skills: maybe list specific skills like SQL, SAS, Excel, Power BI, Tableau, etc.
We must not create sections with placeholder text. Ensure each section has substantive content.
We must not repeat job title as heading. So start with
About the role
etc. We need to output only HTML fragment, no /, no markdown. Let's craft. We'll need to use- for any list of duties/requirements/benefits. For prose use
. We need to decide what goes in lists vs prose. Probably: About the role: prose paragraph describing program. Responsibilities: list of duties (the Healthcare Analytics Intern duties) maybe also general responsibilities like attend workshops, network, etc. We'll list specific duties. Qualifications: list of desired majors, preferred experience, etc. Could be a mix. Skills: list of technical skills (SQL, SAS, Excel, Power BI, Tableau, etc.) plus soft skills? Might be okay. Benefits: list of benefits (health/dental insurance, retirement plan, wellness program, paid time away, paid holidays, remote work possibility, development workshops, mentorship, housing not provided? Actually housing not provided is a negative; maybe include as note.) Pay: paragraph with compensation range. Schedule: paragraph with dates and hours. We must avoid duplication: compensation range appears twice; we include once. We must remove EEO boilerplate, duplicated lines, application instructions. Let's craft. Check for any repeated lines: "Compensation Range(s): Level I - Minimum $18.00 - Maximum $20.00" appears twice; we include once. Also "Please note: There may be opportunity for remote work..." appears twice with slightly different wording; we can combine into one note. Now produce HTML. We'll start:
About the role
The Summer College Internship Program is a 10‑week paid internship that offers undergraduate and graduate students the chance to attend development workshops, network, and contribute to meaningful projects while being mentored by respective managers. Interns can work within a variety of skills‑based tracks such as Business Administration, Information Technology, Actuarial, Human Resources, Analytics & Data, Communications, Finance, Marketing & Sales, Project Management, Clinical Studies, Customer Experience, Digital Operations, and other technical or non‑technical degree programs. The program runs from the first Monday in June to the second Friday in August, with up to 40 hours per week.
Responsibilities
- Extract, validate, and analyze healthcare claims, enrollment, provider, and quality data.
- Develop and maintain reports, dashboards, and ad hoc analyses used by leadership and operational teams.
- Perform data quality reviews to identify anomalies, trends, and opportunities for process improvement.
- Document business requirements, data definitions, and analytical methodologies.
- Assist with data visualization and storytelling by translating complex findings into clear, actionable summaries.
- Learn healthcare analytics concepts including utilization, cost and trend analysis, provider performance, quality measures, and population health metrics.
- Work with a mentor and support key strategic projects.
- Complete work assignments based on business needs, departmental priorities, and individual qualifications.
- Perform a mix of technical and/or non‑technical tasks covering a broad range of business‑related projects.
- Create and deliver a presentation at the conclusion of the internship.
- Maintain confidentiality and protect member privacy in accordance with company policies.
- Ensure regular and reliable attendance.
- Perform other functions as assigned by management.
Qualifications
- Desired majors/degree programs include Epidemiology, Biostatistics, Public Health, Business & Management (Finance, Actuarial, Accounting, Management, Marketing, Supply Chain Management, etc.), Computing Sciences & Information Technology (Computer Science, Software Engineering, IT Networking, Cybersecurity, etc.), Social Sciences (Psychology, Sociology, Human Services, Law/Pre‑Law, etc.), Health Professions & Life Sciences (Nursing, Public Health, Biology, Pharmacy, etc.) or similar programs.
- High school diploma plus proof of continuous full‑time undergraduate or graduate enrollment.
- Must be in good academic standing.
- Preferred (but not required) experience with:
- Curiosity, analytical mindset, and interest in using data to solve real‑world healthcare business problems.
- Data analysis using SQL, SAS, or similar tools.
- Proficiency in Microsoft Excel (formulas, pivot tables, data manipulation, basic reporting