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.
Requirements
- Proficiency in SQL and/or Python programming, with the ability to leverage advanced functions to extract, manipulate, and analyze data.
- Strong working knowledge of Microsoft tools, including: Excel (data analysis and visualization), Visio (data modeling and visualization), Access (database management), PowerPoint (presentation and communication)
- 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)
- Ability to identify and quantify data patterns and trends
- Ability to recognize potential issues and develop solutions
- Ability to standardize, harmonize, clean, and prepare data for analysis and reporting
- 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
- 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.
- 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.
Other
- 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.
- Present data insights and solutions to internal and external stakeholders in a clear, logical, and engaging manner, ensuring that complex information is easily understood.
