Senior Analyst – Reporting & Automation (Evening Shift))

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

North America insurance operations are supported through specialized teams across India and Manila, providing centralized support throughout the insurance lifecycle. Key functions include certificate processing (COI and Auto IDs), renewal services, policy administration, client servicing, and broking/placement support. Together, these teams manage activities such as renewals, policy checks and endorsements, loss runs and exposure workbooks, binder processing, billing, market loading, operational triaging, and quality checks, enabling efficient and consistent support for North America client and broking operations.

About the Role

The Senior Analyst will design, build and support end-to-end reporting and automation solutions for the North America business. The role will translate stakeholder requirements into reliable dashboards, governing data assets, applications and automated workflows, while supporting continuous improvement across reporting operations.

Key Responsibility

• Design, develop, publish and maintain interactive Power BI dashboards and reports that provide clear, actionable business insights.

• Partner with North America and India stakeholders to understand requirements, define success measures, manage expectations and communicate delivery status, risks and dependencies.

• Write, optimize and troubleshoot SQL queries; develop stored procedures, views and other reusable database objects.

• Design, develop and maintain SSIS packages for data extraction, transformation and loading across multiple source systems.

• Build business applications using Microsoft Power Apps and automate workflows, approvals and notifications using Microsoft Power Automate.

• Create and manage data lakes and data pipelines in Microsoft Fabric, including ingestion, transformation, monitoring and support.

• Apply AI tools such as Microsoft Copilot or Claude to improve analysis, documentation and reporting workflows, while following applicable data-security and governance requirements.

• Perform testing, reconciliation, deployment support, production troubleshooting and root-cause analysis for reporting and automation solutions.

• Create and maintain solution documentation, data definitions, process flows, support guides and technical specifications.
• Identify opportunities to reduce manual effort, improve data quality and increase the scalability, reliability and maintainability of solutions.

Skills

• Power BI
• Microsoft SQL Server
• SSIS
• Power Platform
• Microsoft Fabric
• Applied AI

• 5–7 years of relevant experience in business intelligence, reporting, data engineering, application development or process automation.
• Demonstrated ownership of end-to-end solution delivery, from requirement gathering and design through development, testing, release and production support.
• Experience working with geographically distributed stakeholders, preferably supporting North America business teams.
• Bachelor’s degree in computer science, information technology, engineering, data/analytics or a related discipline is preferred; equivalent relevant experience may be considered.

• Excellent written and verbal communication skills, with the ability to explain technical concepts clearly to non-technical stakeholders.
• Strong stakeholder-management skills, including expectation setting, prioritization.
• Analytical problem-solving, attention to detail and a disciplined approach to data validation and reconciliation.
• Ability to work independently, manage multiple priorities and deliver reliably in a fast-paced, virtual environment.
• Collaborative working style and willingness to share knowledge and contribute to team standards.

• Working knowledge of VBA and Excel-based automation.
• Exposure to data governance, source-control practices, release management or Agile delivery.
• Experience in insurance or other financial-services environments

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

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 candidatehelpdesk@wtwco.com.