Actuarial Analyst III

Imperial Health Plan of California, Inc.; Pasadena (CA); On-site; USD 95,000 - 135,000; Full time

Job summary

Imperial Health Plan of California, Inc. is hiring an Actuarial Analyst III to work with the lead actuary on data-driven tasks and reporting projects.

The role focuses on relational databases, process automation, and timely delivery of analyses for the actuarial and finance teams. The candidate will automate processes using SQL, Power BI and Excel, maintain data accuracy, and document methodologies while collaborating with management and external vendors.

Qualifications

• Bachelor's degree in actuarial science or related field.
• Experience with SQL, Power BI and Excel required.
• Actively pursuing SOA exams; at least four exams completed or in progress.

Responsibilities

• Support analysis for the actuarial department and finance teams.
• Engage with outside vendors for pricing, risk score initiatives, and quality measures.
• Produce periodic utilization and cost reporting.
• Support revenue cycle activities.
• Create dashboards and consolidate data management.
• Automate processes using SQL, Power BI and Excel.
• Ensure data accuracy, documentation of methodologies, and project communications.

Skills

SQL

Power BI

Excel

Data analysis

Process automation

Documentation

Communication

Confidentiality

Education

Bachelor’s degree in Actuarial Science, Mathematics, Statistics, Economics, or related field

Actively pursuing SOA exams

4+ actuarial exams completed/ongoing

Tools

SQL

Power BI

Excel

Job description

Job Description

JOB TITLE: Actuarial Analyst III 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. Must have extensive working experience on relational database and process automation. In addition to technical data concepts, must have the desire to learn and be able to conduct detailed analysis and provide results. Is responsible for managing reporting projects to ensure that data and analysis requests are completed timely, accurately to meet the needs of the requesting department.

Essential Job Functions

• Support analysis for the actuarial department and finance teams.
• Key tasks include supporting engagements with outside venders. Vendor engagements include pricing work, risk score initiatives, and quality measures.
• 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

• Takes 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 related supervisors as soon as practicable.
• Supports and demonstrates safety throughout all duties performed.
• Follows established policies and procedures and understands and complies with all regulators

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 four exams and actively pursuing exams through the Society of Actuaries.
• EZCAP experience preferred but not required.
• 4+ years of experience with SQL reporting and analytics with data analysis, extraction, and manipulation.
• 4+ years designing reports and developing executive level presentations.
• 4+ years experience in healthcare (Medicare Advantage, Medicaid, Exchange/ACA Markets).

Skills/Knowledge/Ability

• Thorough knowledge of MS Office Suite particularly Excel.
• Outstanding organizational and problem-solving aptitude, solution oriented and willingness to dig into the details
• 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 an 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