Blue Shield of CA
Medical Informatics Analyst, Associate
Blue Shield of CA, San Diego, California, United States, 92189
Your Role
The rating model team supports large group pricing through model programming, data validation and general model support for users. The Medical Informatics Analyst will report to the Actuary Manager. In this role you will execute the monthly data load process to collect and validate data from multiple sources into the rating model database and refresh the rating factor dashboard. You will execute batch runs to produce rating model output on the entire book of business. You will assist in implementing rating model changes including rating methodology changes, data enhancements, state and federal legislation, in addition to communicating current and proposed rating methodologies amongst stakeholders.
Your Work
In this role, you will:
Conduct independent analysis of low complexity under moderate supervision and guidance
Develop documentation and create and execute workplans for analyses of low complexity
Conduct analysis of moderate complexity by following explicit instructions provided by Medical Informatics Analyst II/III/IV/V, supervisor or manager
Support the development of reports and analyses by validating, testing, and documenting analytical processes and completing other defined, related tasks
Create and distribute previously established, routine reports to multiple departments
Troubleshoot and resolve user issues and update existing tools
Identify and resolve gaps in process efficiency and key controls
Test model changes
Reconcile monthly data
Your Knowledge and Experience
Requires a bachelor's degree or equivalent experience
Requires 0-2 years of prior relevant experience
Requires Intermediate Excel skills
SQL relational database experience preferred, with further preference for T-SQL
VBA programming for Excel and experience using ADO to retrieve and manipulate datasets preferred
SAS programming experience preferred
Proficiency in Python and PowerBI is preferred
Pay Range:
The pay range for this role is: $ 31.73 to $ 44.41 for California.
Note:
Please note that this range represents the pay range for this and many other positions at Blue Shield that fall into this pay grade. Blue Shield salaries are based on a variety of factors, including the candidate's experience, location (California, Bay area, or outside California), and current employee salaries for similar roles.
#J-18808-Ljbffr
The rating model team supports large group pricing through model programming, data validation and general model support for users. The Medical Informatics Analyst will report to the Actuary Manager. In this role you will execute the monthly data load process to collect and validate data from multiple sources into the rating model database and refresh the rating factor dashboard. You will execute batch runs to produce rating model output on the entire book of business. You will assist in implementing rating model changes including rating methodology changes, data enhancements, state and federal legislation, in addition to communicating current and proposed rating methodologies amongst stakeholders.
Your Work
In this role, you will:
Conduct independent analysis of low complexity under moderate supervision and guidance
Develop documentation and create and execute workplans for analyses of low complexity
Conduct analysis of moderate complexity by following explicit instructions provided by Medical Informatics Analyst II/III/IV/V, supervisor or manager
Support the development of reports and analyses by validating, testing, and documenting analytical processes and completing other defined, related tasks
Create and distribute previously established, routine reports to multiple departments
Troubleshoot and resolve user issues and update existing tools
Identify and resolve gaps in process efficiency and key controls
Test model changes
Reconcile monthly data
Your Knowledge and Experience
Requires a bachelor's degree or equivalent experience
Requires 0-2 years of prior relevant experience
Requires Intermediate Excel skills
SQL relational database experience preferred, with further preference for T-SQL
VBA programming for Excel and experience using ADO to retrieve and manipulate datasets preferred
SAS programming experience preferred
Proficiency in Python and PowerBI is preferred
Pay Range:
The pay range for this role is: $ 31.73 to $ 44.41 for California.
Note:
Please note that this range represents the pay range for this and many other positions at Blue Shield that fall into this pay grade. Blue Shield salaries are based on a variety of factors, including the candidate's experience, location (California, Bay area, or outside California), and current employee salaries for similar roles.
#J-18808-Ljbffr