Actuarial Analyst II

Essential Job Functions

• Support analysis for the actuarial department and finance teams.
• Key tasks include supporting engagements with outside vendors.
• Vendor engagements include pricing work, risk score initiatives, and quality measures.
• Periodic utilization and cost reporting.
• 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.
• Manage regular and consistent attendance.
• Adhere to Compliance Plan and HIPAA regulations.

Marginal Job Functions

• Take on special projects as needed.
• Perform other duties as assigned.

Position Requirements

• Educational Background: Bachelor’s degree in Actuarial Science, Mathematics, Statistics, Economics, or related field.
• Experience: 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/Certification/Training: Must be actively pursuing exams under the Society of Actuaries.