Analyst Product Analysis
Description
Join our Data Intelligence and Underwriter Tools team in Small Commercial Underwriting to design, build, and maintain reporting solutions that drive data‑informed decisions across the organization. In this role you will consult with business stakeholders to define reporting requirements, develop and deploy reporting tools (Power BI, Excel/VBA, dashboards, automated extracts), and establish monitoring and maintenance practices to ensure accuracy and reliability. You will synthesize analytic findings into clear insights and recommendations and present them to technical and non‑technical audiences.
Key Responsibilities:
Partner with stakeholders to gather reporting requirements and translate business needs into scalable reporting solutions.
Design, develop, and maintain interactive dashboards and reports using Power BI and Excel (including VBA), ensuring performance, usability, and secure access.
Implement automated refresh schedules, validation checks, and monitoring to ensure data integrity and timely delivery of reports.
Troubleshoot production issues, manage versioning, and document report logic and data lineage.
Analyze reported data, identify trends and anomalies, and prepare actionable insights and recommendations tailored to stakeholder audiences.
Present findings and proposed solutions to stakeholders and leadership; translate complex technical concepts into clear business implications.
Stay current on reporting best practices, visualization standards, and relevant technologies to continuously improve our reporting capabilities.
Maintain attention to detail and quality while balancing pragmatic delivery and the broader business impact.
Qualifications
Hands‑on experience with Power BI and advanced Excel (including VBA/macros) required.
Strong SAS/SQL skills.
Experience implementing data refresh automation, monitoring, and validation processes.
Excellent written and verbal communication skills; proven ability to present technical findings to non‑technical stakeholders.
Strong problem solving, organization, and documentation practices; detail oriented with an eye for data quality.
Collaborative, solutions‑oriented mindset and ability to work across cross‑functional teams.
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://LMI.co/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
About the job
Apply for this position
Analyst Product Analysis
Description
Join our Data Intelligence and Underwriter Tools team in Small Commercial Underwriting to design, build, and maintain reporting solutions that drive data‑informed decisions across the organization. In this role you will consult with business stakeholders to define reporting requirements, develop and deploy reporting tools (Power BI, Excel/VBA, dashboards, automated extracts), and establish monitoring and maintenance practices to ensure accuracy and reliability. You will synthesize analytic findings into clear insights and recommendations and present them to technical and non‑technical audiences.
Key Responsibilities:
Partner with stakeholders to gather reporting requirements and translate business needs into scalable reporting solutions.
Design, develop, and maintain interactive dashboards and reports using Power BI and Excel (including VBA), ensuring performance, usability, and secure access.
Implement automated refresh schedules, validation checks, and monitoring to ensure data integrity and timely delivery of reports.
Troubleshoot production issues, manage versioning, and document report logic and data lineage.
Analyze reported data, identify trends and anomalies, and prepare actionable insights and recommendations tailored to stakeholder audiences.
Present findings and proposed solutions to stakeholders and leadership; translate complex technical concepts into clear business implications.
Stay current on reporting best practices, visualization standards, and relevant technologies to continuously improve our reporting capabilities.
Maintain attention to detail and quality while balancing pragmatic delivery and the broader business impact.
Qualifications
Hands‑on experience with Power BI and advanced Excel (including VBA/macros) required.
Strong SAS/SQL skills.
Experience implementing data refresh automation, monitoring, and validation processes.
Excellent written and verbal communication skills; proven ability to present technical findings to non‑technical stakeholders.
Strong problem solving, organization, and documentation practices; detail oriented with an eye for data quality.
Collaborative, solutions‑oriented mindset and ability to work across cross‑functional teams.
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://LMI.co/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