Analyst

WTW; Thane; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Willis Towers Watson in India is seeking an experienced MI reporting specialist to generate ad hoc and standard reports for insurers, partnering with UK stakeholders to understand requirements and deliver data-driven insights.

The role focuses on advanced Excel (VBA and forms), Power BI and Power Apps, with Power Automate knowledge considered a major advantage; you will enhance reporting frameworks and automate repetitive tasks.

Qualifications

• 5–6 years of MI reporting and analytics experience.
• Advanced Excel proficiency including VBA macros.
• Experience with MS Access, SQL and SharePoint.
• Experience creating interactive dashboards with Power BI.
• Familiarity with Power Apps and Power Automate is a plus.
• Basic knowledge of AI/ML concepts applied to reporting.
• Strong stakeholder management and communication skills.

Responsibilities

• Maintain MI reports with data cleansing and validation.
• Understand business requirements and translate them into technical specs.
• Develop reporting frameworks and data management solutions.
• Support and maintain existing tools and processes.
• Identify automation opportunities to improve efficiency.
• Collaborate with UK stakeholders to deliver new reports.
• Document processes for team training.
• Self-motivated and able to influence others; day rotation shifts.

Skills

MI reporting & analytics

Advanced Excel

VBA Macros

Power BI

Power Apps

Power Automate

SQL

MS Access

SharePoint

AI/ML basics

MS Office

Data quality checks

Education

B. Sc./M.Sc. (Computer Science/IT)

Tools

MS Access

SQL

SharePoint

Power Apps

Power Automate

Job description

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.

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.

Responsibilities

-

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.

The Application Process

• Stage 1: Online application and recruiter review
• Stage 2: Pre-recorded video interview
• Stage 3: Live video or in person interview with hiring manager and team
• Stage 4: Offer and onboarding.

Requirements:

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]