Actuarial Analyst II
Imperial Health Plan of California, Inc. · United States
- Hybrid
- Full-time
- $95,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
- Actuarial Analyst II role with finance collaboration.
- Manage reporting projects and data analysis.
- Utilize SQL, Power BI, and Excel for automation.
- Gain experience in healthcare markets.
- Pursue actuarial exams and career growth.
About the role
Actuarial Analyst II
FLSA STATUS: Exempt
DEPARTMENT: Actuarial Services
REPORTS TO: Senior Director, Actuarial Services
JOB SUMMARY
This role will work closely with the lead actuary to help them transition tasks. Manages assigned reporting projects to ensure that data and analysis requests are completed timely, accurately while presented in a way that meets the needs of the requesting department. This position will work closely with the finance department.
Essential Job Functions
- Support analysis for the actuarial department and finance teams.
- Key tasks include supporting engagements with outside venders, including pricing work, risk score initiatives, and quality measures.
- Perform periodic utilization and cost reporting, and support the revenue cycle.
- Support efforts towards consolidating data management and creating dashboards.
- Automate processes and improve efficiency using tools such as SQL, Power BI, and Excel.
- Ensure data accuracy, integrity, and documentation of methodologies.
- Manage assigned projects and effectively communicate with the requestor and leadership team any project roadblocks that may jeopardize deadlines in advance of due dates.
- Responsible for understanding the various data sources available at Imperial Health Plan of California, Inc.
- Document all coding/analysis/reporting projects following established protocols to ensure transparency and repeatability.
- Collaborates and maintains effective working relationships with management, internal departments, and external vendors.
- Work with management to prioritize business and information needs.
- Maintains regular and consistent attendance.
- Adheres to Compliance Plan and HIPAA regulations.
Marginal Job Functions
- Take on special projects as needed.
- Performs other duties as assigned.
Behavioral Expectations
- Continuous Learning: Attends staff meetings as required. Attends appropriate training, seminars and workshops as required.
- Customer Focus: Maintains client/customer confidentiality and privacy in accordance with HIPPA regulations and IMAS’s Standards of Conduct. Fosters appropriate communication and relations with Supervisor, co-workers and other staff.
- Quality/Process Improvement/Safety: Reports issues of security, health and/or safety to appropriate supervisor as soon as practicable. Supports and demonstrates safety throughout all duties performed. Follows established policies and procedures and understands and complies with all regulatory standards set forth by governing entities.
Position Requirements
EDUCATION/EXPERIENCE:
- Bachelor’s degree in Actuarial Science, Mathematics, Statistics, Economics, or related field.
- Must have experience in SQL, Power BI, and Excel. All other languages and platforms are a bonus.
- Must have at least two exams and actively pursuing exams through the Society of Actuaries.
- EZCAP experience preferred but not required.
- 3+ years of experience with SQL reporting and analytics with data analysis, extraction, and manipulation.
- 3+ years designing reports and developing executive level presentations.
- 2+ years experience in healthcare (Medicare Advantage, Medicaid, Exchange/ACA Markets).
Skills/Knowledge/Ability
- Must understand relational database concepts, table design and structure, joins, data normalization, and data types.
- Must be able to conduct detailed analysis and provide results.
- Thorough knowledge of MS Office Suite particularly Excel.
- Analytical and problem-solving skills.
- Must understand the technical issues associated with collecting data, analyzing data, and reporting.
- They must be able to recognize trends and patterns.
- Willingness and ability to read, write, speak, understand English and have the communications skills necessary to provide accurate information to members and staff.
- Willingness and ability to follow written and verbal direction in English.
- Willingness and ability to maintain appropriate level of confidentiality and privacy.
- Willingness and ability to interact professionally with all customers, members, and co-workers, individually and as part of a team.
- Willingness and ability to effectively handle multiple items/tasks as required and adapt favorably to changing priorities.
- Willingness and ability to make appropriate judgments, decisions and problem solving in a timely manner and within the context of the situation at hand.
- Ability to effectively prioritize items/tasks as required.
- Willingness and ability to take initiative and be a self-starter.
- Willingness and ability to understand and comply 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
- Reporting
- Healthcare Analytics
- Risk Management
- Process Automation
- Financial Analysis
Skills & topics
- Actuarial Analyst
- Actuarial Science
- Mathematics
- Statistics
- SQL
- Power BI
- Excel
- Data Analysis
- Reporting
- Healthcare
- Finance
- Risk Management
- Process Automation
How to get hired
- Tailor your resume: Highlight SQL, Power BI, Excel, and healthcare experience.
- Emphasize actuarial exams: Showcase your progress with Society of Actuaries exams.
- Quantify achievements: Use numbers to demonstrate impact in reporting and analysis.
- Prepare for technical questions: Be ready to discuss database concepts and analytics.
- Showcase collaboration skills: Highlight experience working with finance and external vendors.
Technical preparation
Master SQL for data extraction and manipulation.,Practice Power BI for dashboard creation.,Strengthen Excel for complex analysis.,Understand database concepts and design.
Behavioral questions
How do you handle project roadblocks?,Describe a time you improved a process.,How do you ensure data accuracy?,How do you collaborate with other departments?
Frequently asked questions
- What are the key technical skills required for the Actuarial Analyst II role at Imperial Health Plan of California, Inc.?
- The Actuarial Analyst II role at Imperial Health Plan of California, Inc. requires proficiency in SQL, Power BI, and Excel for data analysis, reporting, and process automation. A strong understanding of relational database concepts is also essential.
- What is the expected experience level for an Actuarial Analyst II at Imperial Health Plan of California, Inc.?
- Imperial Health Plan of California, Inc. is looking for an Actuarial Analyst II with at least 3 years of experience in SQL reporting and analytics, and 3 years in report design and executive presentations. Additionally, 2 years of experience in healthcare markets such as Medicare Advantage, Medicaid, or Exchange/ACA is required.
- Does Imperial Health Plan of California, Inc. support career progression for Actuarial Analysts?
- Yes, Imperial Health Plan of California, Inc. encourages career progression. The role requires actively pursuing exams through the Society of Actuaries, indicating a commitment to professional development within the actuarial field.
- What type of healthcare experience is preferred for the Actuarial Analyst II position?
- For the Actuarial Analyst II position at Imperial Health Plan of California, Inc., experience in healthcare, specifically within Medicare Advantage, Medicaid, or Exchange/ACA Markets, is preferred. This experience is crucial for supporting the actuarial and finance teams effectively.
- How important is it to have passed actuarial exams for the Actuarial Analyst II role?
- It is important to have passed at least two exams and be actively pursuing further exams through the Society of Actuaries for the Actuarial Analyst II role at Imperial Health Plan of California, Inc. This demonstrates a commitment to the actuarial profession.
- What is the reporting structure for the Actuarial Analyst II at Imperial Health Plan of California, Inc.?
- The Actuarial Analyst II at Imperial Health Plan of California, Inc. reports to the Senior Director, Actuarial Services. This role also works closely with the lead actuary and the finance department.