Summer 2026 Intern - Data Analytics, Python, SQL

Blue Cross Blue Shield of Michigan•Detroit, MI

20h

About The Position

The Internship Program at BCBSM is designed to enhance the skills and abilities of young professionals as well as to identify and attract future talent for our organization. Interns will gain practical hands-on work experience as well as a solid understanding of the health insurance industry. Our program is an excellent way for interns to get a good start on their careers by working on meaningful projects, learning valuable skills, and networking with employees throughout our organization, which could potentially allow interns to build a future career at BCBSM. The A&I Clinical Data Operations team provides technical and data expertise to support informed decision-making across the HCV department, delivering high-quality data solutions and actionable intelligence to drive business growth and optimization. Key Responsibilities: As a valued member of our team, you will have the opportunity to contribute to a variety of projects and initiatives that drive business growth and improvement.

Requirements

Current undergraduate or graduate student with a 3.0 GPA or higher required.
Interns must be enrolled in a college/university or a Master’s/PhD program for the duration of the internship.
Effective verbal, written communication and interpersonal skills.
Strong analytical skills with the ability to work independently and as a member of a team.
Excellent organizational skills to deal with multiple projects and priorities.
Responsible for maintaining confidential information to the highest degree.
Proficient in Microsoft Office suites and applicable BCBSM systems.
Ability to develop and maintain effective working relationships.
Bachelor’s degree in computer science, Information Systems, Business, Mathematics, Healthcare Information Technology or similar degree required.
Programming: Proficiency in SQL and/or Python programming, with the ability to leverage advanced functions to extract, manipulate, and analyze data.
Microsoft Office Suite: Strong working knowledge of Microsoft tools, including:
Excel (data analysis and visualization)
Visio (data modeling and visualization)
Access (database management)
PowerPoint (presentation and communication)
Data Management: Understanding of data warehousing and data mining concepts, including:
ETL (Extract, Transform, Load)
Data mart design and architecture
Fact tables and dimension tables
Data views and OLAP (Online Analytical Processing)
Data models (star schemas, snowflake schemas)
Data Analysis: Ability to:
Identify and quantify data patterns and trends
Recognize potential issues and develop solutions
Standardize, harmonize, clean, and prepare data for analysis and reporting

Nice To Haves

Masters degree is preferred.
Healthcare Knowledge (preferred): Basic understanding of:
Epidemiologic principles
Population health management concepts
Healthcare terminology and plan/benefit design
Administrative claims data and standard coding schemes (ICD-9/10, HCPCS)

Responsibilities

Assist in preparing information and research materials to identify business problems, offer recommendations and assist management with implementation of solutions.
Support leaders on projects designed to enhance the overall efficiency and effectiveness of the organization.
Develop and maintain a solid understanding of BCBSM business, products, programs, data, organizational structure, controls, research.
Analyze business goals, objectives, and needs within the organization.
Participate in networking events with BCBSM leaders and other interns.
Engage in volunteer activities/community outreach to build knowledge of our communities and customers.
Participate in department meetings and events (i.e. monthly Diversity and Inclusion events, department wide team building events, weekly meetings to ensure team alignment, etc.).
Collaborating on Data-Driven Projects: Participate in projects that require data solutions, working closely with colleagues to design and implement effective data-driven approaches.
Providing Technical Expertise: Leverage your programming and data skills to support simple to moderately complex projects and ad-hoc requests, delivering high-quality solutions that meet business needs.
Effective Communication: Present data insights and solutions to internal and external stakeholders in a clear, logical, and engaging manner, ensuring that complex information is easily understood.
Data Stewardship: Standardize, harmonize, and cleanse data to ensure accuracy and consistency, sharing it with colleagues and external partners to drive informed decision-making.
Data-Centric Solution Development: Design, develop, and maintain data-driven product solutions that support provider risk-based programs, enhancing our ability to deliver high-quality services.
Reporting and Analytics: Support reporting activities, continually seeking opportunities to streamline processes and improve end-user experience through intuitive and user-friendly reporting.
Ad-Hoc Requests: Respond to special requests for data and analytics, providing timely and accurate support to business stakeholders.
Cross-Functional Collaboration: Work closely with Enterprise IT and clinical data experts to maintain and enhance our clinical programs data assets, ensuring seamless integration and optimal performance.