Team Leader - VBA Macros

Role & responsibilities :

• Responsible for the creation of Macros 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

Technical Skills :

• 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
• Working 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.

Education :

• Bachelors degree in related field or equivalent experience

Experience :

• 2-7 years relevant workplace experience of Insurance/Disability products in Business Analysis and reporting role with extensive use of VBA and macros
• Proficiency with software such as MS Office, MS Outlook, MS Project

Strong computer skills, including proficiency with Excel identifying and understanding differences and similarities within multiple large data sets and software applications

Shifts : US (1730 - 0230)

Location : Noida Sector, 144