Actuarial Analyst III
Imperial Health Plan of California, Inc. · United States
- Hybrid
- Full-time
- $100,000 / year
- United States
Tailored resume — keyword-matched to this role.
Hiring manager — we find who's hiring.
Intro email — drafted to reach them directly.
Job highlights
- Analyze data for actuarial and finance teams.
- Manage reporting projects and vendor engagements.
- Consolidate data, build dashboards, and automate processes.
- Ensure data accuracy and document methodologies.
- Requires 4+ years healthcare and SQL experience.
About the role
Actuarial Analyst III
Imperial Health Plan of California, Inc. is seeking an experienced Actuarial Analyst III to join our Actuarial Services department. This role reports to the Senior Director, Actuarial Services and is responsible for assisting the lead actuary in task transition, process automation, and detailed data analysis.
Job Summary
The Actuarial Analyst III will work closely with the lead actuary to transition tasks and will require extensive experience with relational databases and process automation. The ideal candidate will possess a strong desire to learn, conduct detailed analysis, and provide accurate results. This role manages reporting projects to ensure timely and accurate completion of data and analysis requests from various departments.
Essential Job Functions
- Support analysis for the actuarial and finance departments, including engagements with outside vendors for pricing, risk score initiatives, and quality measures.
- Perform periodic utilization and cost reporting, and support the revenue cycle.
- Assist in consolidating data management and creating dashboards using tools such as SQL, Power BI, and Excel.
- Automate processes and improve efficiency to enhance operational workflows.
- Ensure data accuracy, integrity, and documentation of methodologies.
- Manage assigned projects and proactively communicate any potential roadblocks to leadership.
- Develop a strong understanding of Imperial's various data sources.
- Document all coding, analysis, and reporting projects according to established protocols for transparency and repeatability.
- Collaborate and maintain effective working relationships with management, internal departments, and external vendors.
- Work with management to prioritize business and information needs.
- Maintain regular and consistent attendance and adhere to Compliance Plan and HIPAA regulations.
Marginal Job Functions
- Take on special projects as needed.
- Perform other duties as assigned.
Behavioral Expectations
- Continuous Learning: Attend staff meetings, training, seminars, and workshops as required.
- Customer Focus: Maintain client/customer confidentiality and privacy in accordance with HIPAA regulations and IMAS’s Standards of Conduct. Foster appropriate communication and relations with Supervisor, co-workers, and other staff.
- Quality/Process Improvement/Safety: Report security, health, or safety issues to supervisors promptly. Support and demonstrate safety throughout all duties. Follow established policies and procedures and comply with all regulatory standards.
Position Requirements
Education/Experience
- Bachelor’s degree in Actuarial Science, Mathematics, Statistics, Economics, or a related field.
- Proficiency in SQL, Power BI, and Excel is required. Experience with other languages and platforms is a plus.
- Minimum of four years of experience in SQL reporting, analytics, data analysis, extraction, and manipulation.
- Minimum of four years designing reports and developing executive-level presentations.
- Minimum of four years of experience in the healthcare industry (Medicare Advantage, Medicaid, Exchange/ACA Markets).
- Must have completed at least four actuarial exams and be actively pursuing further exams through the Society of Actuaries.
- EZCAP experience is preferred but not required.
Skills/Knowledge/Ability
- Thorough knowledge of MS Office Suite, particularly Excel.
- Outstanding organizational and problem-solving aptitude; solution-oriented with a willingness to delve into details.
- Strong communication skills (written and verbal) in English to provide accurate information to members and staff.
- Ability to follow written and verbal directions in English.
- Ability to maintain an appropriate level of confidentiality and privacy.
- Professional interaction skills with customers, members, and co-workers, both individually and as part of a team.
- Effectively handle multiple items/tasks and adapt to changing priorities.
- Make appropriate judgments, decisions, and solve problems in a timely manner.
- Ability to effectively prioritize tasks.
- Self-starter with initiative.
- Understanding and compliance with Federal, State, and local regulations.
Licensure/Certificate/Training
- Must be actively pursuing exams under the Society of Actuaries.
Key Skills/Competency
- Actuarial Analysis
- SQL
- Power BI
- Excel
- Data Management
- Process Automation
- Reporting
- Healthcare Industry
- Project Management
- Statistical Analysis
Skills & topics
- Actuarial Analyst
- Actuarial Science
- SQL
- Power BI
- Excel
- Data Analysis
- Healthcare
- Medicare
- Medicaid
- Reporting
How to get hired
- Tailor your resume: Highlight your 4+ years of SQL reporting, data analysis, healthcare experience (Medicare/Medicaid), and proficiency in Power BI and Excel.
- Showcase project management: Emphasize your experience in managing reporting projects and developing executive-level presentations.
- Demonstrate actuarial progression: Clearly state your completed SOA exams and active pursuit of further certifications.
- Prepare for technical questions: Be ready to discuss your experience with relational databases, process automation, and tools like SQL and Power BI.
- Highlight problem-solving: Provide examples of your analytical and solution-oriented approach to complex data challenges.
Technical preparation
Master SQL for data extraction and manipulation.,Build reports and dashboards in Power BI.,Advanced Excel skills for analysis and modeling.,Understand relational database structures.
Behavioral questions
Describe a complex data analysis project you managed.,How do you ensure data accuracy and integrity?,How do you handle conflicting priorities or deadlines?,Tell me about a time you improved a process.
Frequently asked questions
- What are the key technical skills required for the Actuarial Analyst III role at Imperial Health Plan of California, Inc.?
- The Actuarial Analyst III role at Imperial Health Plan of California, Inc. requires extensive experience in SQL, Power BI, and Excel for data analysis, reporting, and process automation. Proficiency in these tools is crucial for success in this position.
- Does Imperial Health Plan of California, Inc. require specific actuarial exams for the Actuarial Analyst III position?
- Yes, Imperial Health Plan of California, Inc. requires candidates for the Actuarial Analyst III role to have completed at least four actuarial exams and be actively pursuing further exams through the Society of Actuaries. This demonstrates a commitment to professional development in the actuarial field.
- What type of healthcare experience is preferred for the Actuarial Analyst III role?
- For the Actuarial Analyst III position at Imperial Health Plan of California, Inc., at least four years of experience in the healthcare industry, specifically within Medicare Advantage, Medicaid, or Exchange/ACA Markets, is required. This industry knowledge is vital for supporting financial and risk initiatives.
- How important is process automation and data management in the Actuarial Analyst III role?
- Process automation and data management are critical components of the Actuarial Analyst III role. The position involves automating processes, consolidating data, and creating dashboards using tools like SQL and Power BI to improve efficiency and data accessibility.
- What is the reporting structure for the Actuarial Analyst III at Imperial Health Plan of California, Inc.?
- The Actuarial Analyst III at Imperial Health Plan of California, Inc. reports directly to the Senior Director, Actuarial Services. This position also works closely with the lead actuary to transition tasks and support departmental initiatives.
- Can candidates with experience in related fields like Mathematics or Statistics apply for the Actuarial Analyst III position?
- Yes, candidates with a Bachelor’s degree in Actuarial Science, Mathematics, Statistics, Economics, or a related field are encouraged to apply for the Actuarial Analyst III role. A strong analytical background combined with the required technical and industry experience is valued.