Lead the implementation of Absence Management Systems by analyzing and validating leave policies, creating data solutions using Excel and Macros, and supporting operational projects.
Description and Requirements
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
About MetLife
Recognized on Fortune magazine's list of the 2025 "World's Most Admired Companies" and Fortune World's 25 Best Workplaces™ for 2024, MetLife , through its subsidiaries and affiliates, is one of the world's leading financial services companies; providing insurance, annuities, employee benefits and asset management to individual and institutional customers. With operations in more than 40 markets, we hold leading positions in the United States, Latin America, Asia, Europe, and the Middle East.
Our purpose is simple - to help our colleagues, customers, communities, and the world at large create a more confident future. United by purpose and guided by empathy, we're inspired to transform the next century in financial services.
At MetLife, it's #AllTogetherPossible . Join us!
#BI-Hybrid
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
About MetLife
Recognized on Fortune magazine's list of the 2025 "World's Most Admired Companies" and Fortune World's 25 Best Workplaces™ for 2024, MetLife , through its subsidiaries and affiliates, is one of the world's leading financial services companies; providing insurance, annuities, employee benefits and asset management to individual and institutional customers. With operations in more than 40 markets, we hold leading positions in the United States, Latin America, Asia, Europe, and the Middle East.
Our purpose is simple - to help our colleagues, customers, communities, and the world at large create a more confident future. United by purpose and guided by empathy, we're inspired to transform the next century in financial services.
At MetLife, it's #AllTogetherPossible . Join us!
#BI-Hybrid
Top Skills
Advanced Excel
Macros
MS Office
Power Query
VBA
Similar Jobs at MetLife
Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Assist in preparing financial surveys for government agencies and rating agencies, analyze financial data, and support management activities.
Top Skills:
SovosWdesk
Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
The Associate retrieves documents, reviews notes and checklists, updates group information, checks submissions for completeness, and manages email communications related to new business cases.
Top Skills:
BizflowKit TrackSm Knowledge CenterWorkdesk
Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Oversee internal audit coverage for Private Fixed Income & Alternatives and Real Estate & Agriculture businesses, ensuring compliance and effective risk management.
Top Skills:
CfaCiaCisaCpa
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
