Blue Cross Blue Shield of Michigan

Summer 2026 Intern - Data Analytics, Python, SQL

Detroit, MI (On-site)

JOB DESCRIPTION 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. 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.). QUALIFICATIONS 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. Department: A&I Clinical Data Operations SUMMARY 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. Your key responsibilities will include: 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. QUALIFICATIONS Bachelor’s degree in computer science, Information Systems, Business, Mathematics, Healthcare Information Technology or similar degree required. Masters degree is preferred. Technical Skills: 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 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)