Core Analytic - Python

About the Team:

The Core Analytics-MATLAB team creates claims reporting tools & provides non actuarial loss data analytics across several Lines of Business, predominantly Workers’ Compensation. This is a 21-member team with a mix of skillsets that enable us to automate reports using advanced Excel features as well as VBA coding. We create interactive models in Power BI/ R for benchmarking that pull in data from various sources & make them available for use to the stakeholders/clients. We also create actuarial sound models using MATLAB & R

About the Role:

High‑performing organizations focus on cultivating and developing talent while maintaining an appropriate balance between cost and reward. Across areas such as employee benefits and executive compensation, Willis Towers Watson applies data‑driven insights, analytics, and technology to encourage workforce engagement, support wellbeing, and deliver practical solutions.

An opportunity exists for an Analyst to support consulting teams based in the United States by enabling benchmarking and analytical activities. The primary objective of this role is to support and coordinate administrative and project management‑related activities, enabling consultants to deliver client requirements efficiently. The role involves regular interaction with members of the client management team.

Roles and Responsibilities

• Review and interpret loss run data and claim-related placement data to assess data availability for analytical reporting
• Identify data gaps or inconsistencies and engage with relevant stakeholders to obtain clarification or additional information required for reporting
• Cleanse raw data in accordance with defined standard operating procedures
• Automate data processing and reporting workflows using Python programming and Server Integration Services
• Standardized datasets to enable flexible analysis and reporting across multiple dimensions
• Develop standard and customized analytical models using Microsoft Power Business Intelligence
• Apply advanced Microsoft Excel functionality, including slicers, nested formulas, and macros, to generate dynamic charts and reports aligned to policy years, including automated output where required
• Design automated standard and customized templates to reduce manual effort, minimize errors, and improve turnaround times

Skills

• Experience in developing dashboards using data visualization tools, including Microsoft Power Business Intelligence
• Experience using advanced Microsoft Excel functionality, including complex formulas, macros, and Visual Basic for Applications
• Working experience with Python programming & Structured Query Language for data processing and automation
• Bachelor’s degree in commerce, Science, or Technology, or progress toward Chartered Insurance Institute certification, which is considered an advantage

• Demonstrates clear and effective verbal and written communication

• Proficiency in reviewing, interpreting, and comprehending detailed information accurately
• Analytical approach to problem identification and solution development
• Experience collaborating effectively within team environments while meeting defined quality standards and delivery timelines

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.