Property & Specialty Insurance Product Consultant

Liberty Mutual InsuranceBoston, MassachusettsOn-siteFull-timeMid level, 2–5 yearsListed 47 minutes ago

Apply now

About this role

Description
Join the Aerial Analytics and Operations team within Personal Lines Property & Specialty Product and help shape the performance and success of our Aerial ecosystem. In this role, you’ll turn data into actionable insights, strengthen monitoring and operational capabilities, and support vendor performance, flight planning, and compliance. You’ll also collaborate closely with the Aerial Solutions team to inform roadmap priorities and investment decisions—helping ensure Aerial continues to deliver value for our business and customers.

This role will focus on monitoring, diagnosing, and improving the operational health of the Aerial ecosystem, with a particular focus on supporting the state filings and objections workstream. The chosen candidate will be responsible for integrating data analysis, operational judgment, and regulatory awareness to identify issues, assess impact, and drive resolution. The individual in this role will rely on strong analytical skills, comfort with ambiguity, and the ability to translate data into clear operational readouts, and will be energized by building deep expertise in how Aerial performs across states, vendors, and regulatory contexts.

** This position may be filled at the Senior Analyst, or Consultant level, depending on the candidate’s experience and qualifications, at the hiring manager’s discretion.  This position may have in-office requirements depending on candidate location. **

Responsibilities and attributes of the ideal candidate:

● Aerial health and monitoring : Builds and maintains Aerial monitoring dashboards and performance readouts; tracks state-level performance; conducts issue detection, root cause analysis, and impact assessment; flags anomalies and emerging trends; maintains the source of truth for Aerial operational health.

● State filings and objections : Supports the process for state filings and objections related to Aerial, partnering with compliance to respond to regulatory requests; maintains awareness of Aerial regulations and state-level implications; helps ensure Aerial practices and vendor behavior stay aligned with filed and approved use.

● Operational support : Partners with compliance to provide Aerial-specific solutions and support in response to regulatory requests; maintains posture on Aerial regulations and influences partner vendors accordingly; maintains and prioritizes the Aerial research backlog.

● Data querying and analysis : Writes and optimizes SQL queries to pull, join, and analyze large datasets; works directly in Snowflake to explore, model, and maintain data supporting Aerial performance and operational reporting.

● Data pipeline and dashboard monitoring : Monitors the performance and reliability of data pipelines supporting Aerial reporting; maintains dashboards that surface pipeline health; identifies and troubleshoots data discrepancies and gaps, escalating to data engineering as needed.

● Analytical rigor : Translates ad hoc business questions into structured analyses; derives hypotheses from data and frames conclusions using sound, evidence-based reasoning; comfortable moving between exploratory analysis and recurring reporting.

● Technical fluency : Strong working knowledge of SQL and Snowflake required; familiarity with data visualization tools (e.g., Tableau, Power BI) and basic scripting (e.g., Python) a plus.

● Dedication to quality : Produces high-quality, thoroughly vetted analysis suitable for a highly visible capability area; maintains a strong personal standard of accuracy, rigor, and polish.

● Excitement on building depth of expertise : Pursues deep, multi-layer understanding of the Aerial ecosystem — technical, operational, and regulatory — to surface unseen implications, anticipate stakeholder questions, and provide thought leadership.

● Project management skills : Manages complex, often ambiguous operational and compliance-adjacent initiatives; coordinates with cross-functional stakeholders, including compliance, vendors, and the Aerial Solutions team, to drive issues to resolution.
Qualifications
- Bachelor's degree in mathematics, economics, statistics, or other quantitative field Minimum 4 year's relevant work experience, typically 6 years.
- Master's degree beneficial. Advanced proficiency in Excel, PowerPoint, and statistical software packages (e.g., SAS, Emblem).
- Must have strong planning, organizational, analytical, decision making and communication skills.
- Experience managing projects preferred.
About Us
Pay Philosophy: The typical starting salary range for this role is determined by a number of factors including skills, experience, education, certifications and location. The full salary range for this role reflects the competitive labor market value for all employees in these positions across the national market and provides an opportunity to progress as employees grow and develop within the role. Some roles at Liberty Mutual have a corresponding compensation plan which may include commission and/or bonus earnings at rates that vary based on multiple factors set forth in the compensation plan for the role.

At Liberty Mutual, our goal is to create a workplace where everyone feels valued, supported, and can thrive. We build an environment that welcomes a wide range of perspectives and experiences, with inclusion embedded in every aspect of our culture and reflected in everyday interactions. This comes to life through comprehensive benefits, workplace flexibility, professional development opportunities, and a host of opportunities provided through our Employee Resource Groups. Each employee plays a role in creating our inclusive culture, which supports every individual to do their best work. Together, we cultivate a community where everyone can make a meaningful impact for our business, our customers, and the communities we serve.

We value your hard work, integrity and commitment to make things better, and we put people first by offering you benefits that support your life and well-being. To learn more about our benefit offerings please visit: https://www.libertymutualgroup.com/about-lm/careers/benefits

Liberty Mutual is an equal opportunity employer. We will not tolerate discrimination on the basis of race, color, national origin, sex, sexual orientation, gender identity, religion, age, disability, veteran's status, pregnancy, genetic information or on any basis prohibited by federal, state or local law.

Fair Chance Notices

- California (https://jobs.libertymutualgroup.com/wp-content/uploads/2024/02/ca-fair-chance-act.pdf)
- Los Angeles Incorporated (https://bca.lacity.gov/Uploads/fciho/FCIHO-factsheet-2024-03-05.pdf)
- Los Angeles Unincorporated (https://jobs.libertymutualgroup.com/wp-content/uploads/2025/01/FCOE-Official-Notice-Eng-Final-8.30.2024.pdf)
- Philadelphia (https://jobs.libertymutualgroup.com/wp-content/uploads/2024/02/pa-philadelphia-fair-chance-law.pdf)
- San Francisco (https://jobs.libertymutualgroup.com/wp-content/uploads/2024/02/ca-san-francisco-fair-chance.pdf)