Designs and develops scalable data products for Distribution and Marketing using Snowflake, SQL, and Python. Translates ambiguous business needs into technical requirements, prototypes solutions, builds data models and transformation logic, and partners with engineers to deliver production-ready systems. The role includes data quality, governance, security, stakeholder management, technical leadership, mentorship, and evaluating AI-enabled approaches.
Description
The USRM Data Office turns data into a competitive advantage. As a Principal Data Solutions Analyst, you'll design and develop solutions that power Distribution & Marketing-translating business needs into technical requirements, building prototypes, and partnering with data engineers to deliver scalable data products on Snowflake. You'll use advanced SQL and Python skills to solve complex problems, balance competing priorities, and help stakeholders make faster, better business decisions.
About the team
The Data Office within Insights & Solutions at Liberty Mutual partners across USRM to define data strategy, deliver data products, and govern data for quality, security, and compliance. Our performance-driven team is passionate about using data to create value for customers and drive business results. The Distribution & Marketing Data Products team partners with business, reporting, and analytics stakeholders to identify emerging data needs and turn them into reliable, reusable solutions.
Why this role?
This is a ranged posting. Grade level offered will be determined based on individual skills & experience.
For this role, we are unable to provide visa sponsorship now or in the future.
**This role may have in-office requirements dependent upon candidate location.**
What you'll do
Under minimal direction, you will:
Ideal candidate will have:
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
$94,000.00 - 176,000.00
The USRM Data Office turns data into a competitive advantage. As a Principal Data Solutions Analyst, you'll design and develop solutions that power Distribution & Marketing-translating business needs into technical requirements, building prototypes, and partnering with data engineers to deliver scalable data products on Snowflake. You'll use advanced SQL and Python skills to solve complex problems, balance competing priorities, and help stakeholders make faster, better business decisions.
About the team
The Data Office within Insights & Solutions at Liberty Mutual partners across USRM to define data strategy, deliver data products, and govern data for quality, security, and compliance. Our performance-driven team is passionate about using data to create value for customers and drive business results. The Distribution & Marketing Data Products team partners with business, reporting, and analytics stakeholders to identify emerging data needs and turn them into reliable, reusable solutions.
Why this role?
- Solve high-impact Distribution & Marketing challenges through hands-on data solutioning.
- Collaborate with business and technical leaders to build our modern data landscape.
- Help shape scalable, AI-ready data products that enable better business decisions.
This is a ranged posting. Grade level offered will be determined based on individual skills & experience.
For this role, we are unable to provide visa sponsorship now or in the future.
**This role may have in-office requirements dependent upon candidate location.**
What you'll do
Under minimal direction, you will:
- Translate ambiguous business needs into scalable data solutions. Partner with D&M stakeholders to clarify problems, analyze data, and define detailed requirements and acceptance criteria. Recommend approaches that balance business needs, technical feasibility, scalability, and end-user experience.
- Prototype solutions to complex data challenges. Build, test, and maintain prototypes and proofs of concept, assessing their viability, performance, and scalability.
- Develop reliable, maintainable data products. Refine data models, transformation logic, and documentation to support product-oriented solutions on Snowflake.
- Manage competing priorities and stakeholder needs. Collaborate with product owners and delivery partners to align customer value, dependencies, and sequencing. Communicate trade-offs and set realistic expectations.
- Build quality controls into delivery. Embed data quality, governance, security, and compliance into requirements, testing, and implementation.
- Communicate clearly across audiences. Present findings, recommendations, progress, and risks in plain language to business partners, technical teams, and senior leaders.
- Explore emerging technologies and AI-enabled approaches. Use practical experimentation to assess their potential and demonstrate business value.
- Provide technical leadership and mentorship. Promote sound development practices and help junior associates strengthen their analytical and technical skills.
Ideal candidate will have:
- Advanced SQL and Python skills in complex transformations, query optimization, reusable code, and automation.
- Hands-on experience with data solutioning spanning modeling, warehousing, ELT/ETL, and cloud platforms - preferably Snowflake - with strong testing, version control, and documentation practices.
- Strong analytical and problem-solving skills to translate ambiguous business needs into clear requirements, form hypotheses, develop and test prototypes, and recommend scalable solutions.
- Effective prioritization and communication to manage complex solutions, navigate competing stakeholder needs, and explain technical concepts across business and engineering teams.
- Knowledge of data quality, governance, privacy, and security practices, plus experience working with data engineers to move prototypes into production.
- Independent execution and technical leadership, including cross-team influence and mentorship.
- D&M domain experience, preferably in property and casualty insurance.
- A bachelor's degree in a quantitative field and at least 4 years of relevant work experience; typically, 6 years. A master's degree and project management experience are preferred.
- Strong written and oral communication skills required.
- Bachelor`s Degree in Computer Science, Computer Engineering, or related discipline preferred.
- Master`s in same or related disciplines strongly preferred.
- 5-7+ years experience in coding for data management, data warehousing, or other data environments, including, but not limited to, working in Python, SQL, ETL, Spark, Snowflake.
- 5-7+ years experience as developer with top quadrant Business Intelligence tools.
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
- Los Angeles Incorporated
- Los Angeles Unincorporated
- Philadelphia
- San Francisco
$94,000.00 - 176,000.00
Similar Jobs at Liberty Mutual Insurance
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Manages medical and disability claim caseloads using nursing expertise to coordinate treatment, negotiate return-to-work plans, facilitate maximum medical improvement, and support claim resolution. Communicates with injured employees, providers, attorneys, employers, and claims teams; documents case strategies and nursing activities; coordinates utilization, peer, vocational, and medical director resources; and manages complex or catastrophic cases.
Top Skills:
Internet ExplorerMS Office
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Owns the product vision, roadmap, backlog, prioritization, user stories, and delivery outcomes for a workers compensation claims transformation program. Collaborates with business and technology stakeholders, agile squads, architects, and leadership to define customer value, remove execution roadblocks, manage KPIs, support planning and ceremonies, assess feasibility and costs, and ensure regulatory alignment. Leads customer-driven design, usability testing, market analysis, and communication of product priorities and expected value.
Top Skills:
Agile
Yesterday
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Manage high-severity personal lines auto and homeowners liability claims involving serious injuries, fatalities, complex coverage and liability issues, attorney representation, and litigation. Investigate claims, evaluate damages, negotiate settlements, maintain reserves, identify fraud and subrogation opportunities, coordinate counsel, attend legal proceedings, communicate with stakeholders, and recommend resolutions. The role may also involve regulatory representation, mentoring, presentations, and special projects.
What you need to know about the Edinburgh Tech Scene
From traditional pubs and centuries-old universities to sleek shopping malls and glass-paneled office buildings, Edinburgh's architecture reflects its unique blend of history and modernity. But the fusion of past and future isn't just visible in its buildings; it's also shaping the city's economy. Named the United Kingdom's leading technology ecosystem outside of London, Edinburgh plays host to major global companies like Apple and Adobe, as well as a growing number of innovative startups in fields like cybersecurity, finance and healthcare.

