Analyst

WTW; Maharashtra; On-site; INR 1,400,000 - 2,200,000; Full time

Job summary

Willis Towers Watson (WTW) is seeking an experienced MI reporting professional in India to generate ad hoc and standard reports for insurers. The role requires strong Excel skills, VBA macros, and Power BI, with background in MS Access/SQL and Power Platform.

You will work with UK stakeholders to deliver insights and automate processes, supporting data integrity and efficiency. Ideal candidates will have 5–6 years in MI roles, solid analytical abilities, and excellent communication to translate

Qualifications

• 5-6 years of MI reporting and analytics experience.
• Advanced Excel with data manipulation and automation capabilities.
• 3+ years hands-on VBA Macros, automations and User Forms.
• Experience with MS Access, SQL and SharePoint for data management.
• Familiarity with Power BI and Power Platform tools (Apps/Automate) is a plus.
• Strong ability to gather requirements and deliver insights to stakeholders.

Responsibilities

• Generate ad hoc and standard MI reports for Insurers and maintain related data.
• Collaborate with UK stakeholders to create new reports and enhancements.
• Develop technical specs from business requirements for reporting.
• Build frameworks and solutions for MI data and dashboards.
• Provide basic support and debugging in test and production environments.
• Identify automation opportunities to improve accuracy and efficiency.

Skills

Advanced Excel

VBA Macros

User Forms

Analytical thinking

Stakeholder management

Education

B. Sc./M.Sc. in Computer Science/IT

Tools

MS Access

SQL

SharePoint

Power BI

Power Apps

Power Automate

AI/ML concepts

MS Office (Visio, Word, PowerPoint)

Job description

About WTW

Willis Towers Watson (NASDAQ: WTW) is a leading global advisory, broking and solutions company that helps clients around the world turn risk into a path for growth. With roots dating to 1828, Willis Towers Watson has 45,000 employees serving more than 140 countries and markets. We design and deliver solutions that manage risk, optimize benefits, cultivate talent, and expand the power of capital to protect and strengthen institutions and individuals. Our unique perspective allows us to see the critical intersections between talent, assets and ideas - the dynamic formula that drives business performance.

Description

About WTW

Willis Towers Watson (NASDAQ: WTW) is a leading global advisory, broking and solutions company that helps clients around the world turn risk into a path for growth. With roots dating to 1828, Willis Towers Watson has 45,000 employees serving more than 140 countries and markets. We design and deliver solutions that manage risk, optimize benefits, cultivate talent, and expand the power of capital to protect and strengthen institutions and individuals. Our unique perspective allows us to see the critical intersections between talent, assets and ideas - the dynamic formula that drives business performance.

Together, we unlock potential.

About The Team

FINMAR Market Services (FMS) was established to support the rationalization of Insurers of Financial Lines business for the benefit of WTW clients. FMS provides services in terms of data analytics, Insurer advocacy, renewal listings and reporting.

About The Role

The role is responsible for generating the ad hoc and standard reports for the Insurers and supports and maintains the data required for this reporting.

The candidate is required to work closely with business users and UK stakeholders for the creation of new reports, enhancements to existing reports and support & maintenance of the existing processes/systems/tools.

The candidate with strong expertise in Advanced Excel, particularly in VBA Macros and User Form development. Proficiency in Power BI and Power Apps is also essential. Additionally, experience with Power Automate will be considered a significant advantage.

Principle Duties & Responsibilities

• Maintain the integrity of the MI Process with detailed review and data cleansing to ensure all data and reports are accurate, current, complete and consistent.
• Understand the workflow for the process and manage priorities.
• Work with the business unit to understand the business requirement thoroughly and develop technical specifications based on functional requirements.
• Develop and Implement frameworks and solutions for reporting Management Information data.
• Perform basic support and debugging in test and production environment.
• Apply analytical skills to test the outputs produced.
• Maintain and support existing tools/systems/processes.
• Identify improvements in the process and stimulate automation wherever possible.
• Ensure ongoing, sustainable & dynamic relationships with stakeholders and internal MI consumers whilst managing their expectations.
• To document & update the relevant processes for further training in the team.
• Self-assured, dynamic, open to ideas, and able to influence others.
• Willing to work in day rotational shifts.

Qualifications

B. Sc./M.Sc. (Computer Science/Information Technology) from reputed College/Institute.

Desired Skills/Experience Specific To Role

• 5-6 years of experience in Management Information (MI) roles with strong expertise in reporting and analytics.
• Advanced Excel proficiency, including complex data manipulation and automation techniques.
• Strong analytical thinking and problem solving capabilities.
• Experience interacting with stakeholders and management to gather requirements, understand business needs, and deliver actionable insights.
• 3+ years of hands on experience developing VBA Macros, automations, and User Forms.
• Well versed in MS Access, SQL, and SharePoint for data management and workflow solutions.
• Basic knowledge of AI/ML concepts and their application in reporting, analytics and process optimisation (e.g. rule based automation, intelligent validation, data quality checks, reporting efficiency and insights generation).
• Willingness to continuously upskill and proactively identify opportunities to use AI and automation to reduce manual effort, improve accuracy and scale MI delivery.
• Working knowledge of MS Office tools, including Visio, Word, and PowerPoint.
• Experience creating interactive dashboards and visual reports using Power BI.
• Experience in developing applications using Power Platform tools - particularly Power Apps, Power Automate - would be an advantage.
• Effective verbal and written communication skills.

We're committed to equal employment opportunity and provide application, interview and workplace adjustments and accommodations to all applicants. If you foresee any barriers, from the application process through to joining WTW, please email [e-mail]