Job Description :
SUMMARY
This job performs analytical services to design or redesign multiple, integrated system workflow and process mapping to ensure that processes are customer focused, consistent, effective and efficient for multiple lines of insurance – Medicare Supplement, Medicare Advantage, Long-Term Care, Hospital Indemnity and Life.

ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties may be assigned.
Design, Build, Update and Deploy all Premium Rate Increase Control Reports for all Long-term care products
Update and Maintain all end user computing tools that have been built to support the operational departments
Performs and assists in the system configuration of premium rate increase implementation for Long-Term Care policyholders, such as:
o Product and rating system configuration (actuarial rate tables and rating directives)
o Testing of premium rate increase implementation
o Work with the information technology team to copy data from testing environment to production environments
o Implementation of premium rate action
Collaborate with our client’s actuarial department to perform complex capacity models and control reports to ensure that the function is appropriately staffed, that we are implementing the process according to capacity and that we have systematic reports and controls to ensure the accuracy of the premium rate increase activity implemented
Provide service and follow-up on LTC insurance questions by researching company records to obtain information requested by customer / client
Maintains working knowledge base of all company products and services.
Complying with company regulations regarding HIPAA, confidentiality, and private health information.
Assist with configuration and testing of premium rate increase notification letter from the creation of the template through printing instructions with vendor
Ability and Flexibility to work overtime as required.


SUPERVISORY RESPONSIBILITIES
This job has no supervisory responsibilities.

QUALIFICATIONS
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Read / Write SQL statement / Sequel Server
Read / Write VB for complex macro’s
MS Access form builder and table structures
Database structures and OLAP tools, including ETL
Excellent oral, written and interpersonal communication skills
Excellent attention for detail
Strong problem solving skills
Critical thinking and independent decision making using sound judgment
Exceptional analytical skills
Demonstrated ability to work well independently and in a team environment
Ability to provide and support company goals


EDUCATION and/or EXPERIENCE
Minimum of bachelor’s degree in computer science, information technology and /or business analytics
5 years related experience in an analytical technical position; or equivalent combination of education and experience.
Superior knowledge of all Microsoft Office applications
Long-Term Care or Insurance Industry experience preferred
Six Sigma preferred

LANGUAGE SKILLS
Need the ability to read and comprehend simple and complex instructions, correspondence, and memos.
Candidate should have the ability to write correspondence / emails with minimal errors.
Ability to effectively present information in a logical manner in one-on-one conversations, small group situations, with clients, and with other employees of the organization.

COMPETENCIES
Promote an exceptional level of excellence and pride in Customer Service
Integrity/Honesty
Motivation
Ability to multi-task and work in a fast paced environment
Organizational/Planning/Organizing

MATHEMATICAL SKILLS
Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals
Ability to compute rate, ratio, and percent and to draw and interpret bar graphs
Financial aptitude in product pricing, accounting and banking methodologies
Data science, algorithms, and probabilities