Actuarial Intern - Blue Cross of Idaho (hybrid)
This is a Boise State WorkU internship opportunity! If you don't know what Work U is or need a refresher, please check out our webpage here. When you apply to Work U, you will be able to list your top three Work U opportunities. A full list of available Work U opportunities can be found here. READY TO APPLY? Start your application here!
Overview of Organization: Blue Cross of Idaho is the largest health insurance carrier in Idaho. The actuarial department manages the pricing, valuation, and forecasting for insurance policies. This internship will coordinate files sent to the BCBSA and how those files can be used by external self-funded clients.
Responsibilities:
- Learning and analyzing submission files for membership and claims.
- This include education on how insurance policies are marketed and sold, how claims are processed and various components of the payment method
- Importing the data files and local data into appropriate data tools using Excel and SQL.
- Developing authentication measures and statistics to confirm validity of the data against the local data files.
- Review claims data for verification and analysis by automating statistical models in excel
- Creating dashboards in Excel or Tableau that can be repeatedly run by various individuals
- Develop various models in Excel using SQL, power, pivot, and VBA.
Qualifications / Applicant Requirements:
- Curious
- independent thinker
- solid communicator
- analytical
Skills intern will develop:
- Statistical, modeling, excel tools, business analysis
Additional Requirements (such as a background check that is administered by your organization, drug testing, etc.)
- Criminal background check and drug screen