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
- Analyze data for actuarial and finance teams.
- Manage reporting projects and vendor engagements.
- Automate processes using SQL, Power BI, Excel.
- Ensure data accuracy and document methodologies.
- Collaborate with internal departments and external vendors.
About the role
Actuarial Analyst II
Job Title: 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 vendors, including pricing work, risk score initiatives, and quality measures.
- Perform periodic utilization and cost reporting.
- 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.
- 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
- Project Management
- Statistical Analysis
Skills & topics
- Actuarial Analyst
- Actuarial Science
- Mathematics
- Statistics
- Economics
- SQL
- Power BI
- Excel
- Data Analysis
- Reporting
- Healthcare
- Medicare Advantage
- Medicaid
- ACA
- Risk Management
- Project Management
- Society of Actuaries
How to get hired
- Tailor your resume: Highlight your SQL, Power BI, Excel, and healthcare analytics experience.
- Showcase actuarial exams: Emphasize your progress with Society of Actuaries exams.
- Quantify achievements: Use data to demonstrate impact in previous reporting roles.
- Prepare for technical questions: Be ready to discuss relational databases and data analysis.
- Demonstrate collaboration: Highlight your experience working with finance and external vendors.
Technical preparation
Master SQL for data extraction and manipulation.,Become proficient in Power BI for dashboard creation.,Practice advanced Excel functions for analysis.,Understand relational database structures and joins.
Behavioral questions
Describe a time you managed a complex project.,How do you ensure data accuracy and integrity?,How do you handle conflicting priorities?,Discuss your approach to continuous learning.
Frequently asked questions
- What are the key technical skills required for the Actuarial Analyst II role at Imperial Health Plan?
- The Actuarial Analyst II role at Imperial Health Plan requires strong proficiency in SQL, Power BI, and Excel for data analysis, reporting, and automation. Experience with relational database concepts, table design, joins, and data normalization is also essential.
- What level of actuarial exam progress is needed for the Actuarial Analyst II position?
- Candidates for the Actuarial Analyst II position must have passed at least two exams and be actively pursuing further exams through the Society of Actuaries. This demonstrates a commitment to the actuarial profession and a solid foundational knowledge.
- Does Imperial Health Plan of California, Inc. prefer candidates with specific healthcare market experience for the Actuarial Analyst II role?
- Yes, Imperial Health Plan of California, Inc. prefers candidates with at least 2 years of experience in healthcare markets, specifically Medicare Advantage, Medicaid, or Exchange/ACA Markets, for the Actuarial Analyst II role. This experience is crucial for understanding the specific data and reporting needs of the company.
- What kind of analytical and problem-solving skills are expected from an Actuarial Analyst II at Imperial Health Plan?
- The Actuarial Analyst II is expected to conduct detailed analysis, identify trends and patterns in data, and provide actionable results. Strong analytical and problem-solving skills are critical for success in this role, as is the ability to understand technical data issues.
- How important is project management experience for the Actuarial Analyst II role?
- Project management experience is important for the Actuarial Analyst II. You will be responsible for managing assigned reporting projects, ensuring timely completion, and effectively communicating any potential roadblocks to leadership.
- What is the educational background required for the Actuarial Analyst II position at Imperial Health Plan?
- A Bachelor's degree in Actuarial Science, Mathematics, Statistics, Economics, or a related quantitative field is required for the Actuarial Analyst II position at Imperial Health Plan.
- Will the Actuarial Analyst II be working with external vendors at Imperial Health Plan?
- Yes, the Actuarial Analyst II will work closely with external vendors as part of their role, supporting engagements related to pricing, risk scores, and quality measures.