MetLife

The primary responsibility of this position is to review/analyze history files on FML, State FML and Company leave policies and create Macros basis requirement to have output basis catalyst system requirement to appropriately intake and administer a customer’s absence claims. The Implementation leader, Disability Consultant or Project lead sends history files of different Vendors to validate and Run files which has detailed provisions of the leave policies, set-up and test the back-end systems.  This position relies heavily on analytical and problem-solving skills, combined with a detailed knowledge of Macros, FMLA regulations, to drive the successful implementation of our Absence Management Systems.

Responsible for the creation of solution using Advance excel, Macros, VBA, Power Query and set up file to be feed in catalyst system for history file cases. Subject matter expert with internal and external customers on FML, State FML and leave policies, as well as eligibility requirements. Partnering with account teams, Disability Operational Process Leads, and Customer Delivery for changes to existing TAM/Catalyst customers.  Analyze impact of change to current set-up, develop solution and implement. Attend conference calls related to Absence set-up issues/topics and provide consultation relative to resolution and next steps. Support internal/external projects for the building of business requirements, design input and UAT. Identify, solution and implement process and system improvements through continuous business and procedural analysis. Performs other duties as assigned or required.

Ability to comprehend requirements and conceptualize data analysis and visualization 

Strong data analysis and superior problem-solving skills

Strong PC Application Skills (MS Office, including PowerPoint and Advanced Excel)

Strong VBA and macro development skills

Strong knowledge of Power Query

Proficient in Data & Business Analysis

Project Management Skills

Ability to communicate effectively both orally and in writing with various levels, including understanding, documenting complex ideas and requirements into actionable steps

Ability to drive continuous process improvement including the development of new processes and systems

Experience with a change culture and fast paced developments.

Self-starter & self-motivated, well organized and flexible with a sense of urgency approach

Used to a fast pace of working and willing to commit to long working hours to achieve project deadlines when required

Ability to establish priorities and handle multiple assignments concurrently with minimal direction in an evolving, fast paced work environment

Self-disciplined, Self-Initiating and result oriented

2-3 years relevant workplace experience of Insurance/Disability products in Business Analysis and reporting role with extensive use of Advance Excel, VBA and Power Query.

Willing to work in US shift timing