Designs and maintains SQL/Python data pipelines, warehouse models, and Power BI dashboards supporting finance planning, forecasting, budgeting, and book close. Owns solution architecture from requirements through deployment, validates data and systems, resolves process and reliability gaps, and manages multiple enhancements. Collaborates with business and technical stakeholders, mentors analysts, leads continuous improvement, documents solutions, trains users, and develops automated and AI-enabled efficiencies.
Description
Operating at the intersection of business strategy and technical development, the Data Solutions team works closely with senior leadership, IT, finance, marketing, distribution, and product teams to simplify and expand the company's ability to understand both where we've been and where we are going. By designing, building, and implementing centralized data, planning, and reporting solutions, we play a key role in connecting our USRM functions in a meaningful and impactful way.
Ready to shape how a Fortune 100 insurer sees its own business? As a Sr Data Solutions Analyst on our Data Solutions team, you'll sit at the intersection of finance and technology - designing the SQL/Python pipelines, Snowflake models, and Power BI dashboards that power enterprise planning, forecasting, and budgeting for USRM. You won't just build reports; you'll own the technical vision for how finance leadership understands where the business has been and where it's going, working hands-on with stakeholders across IT, finance, marketing, and distribution.
**This role may have in-office requirements depending on candidate location**
Candidates who live within 50 miles of Boston, MA; Portsmouth, NH; Seattle, WA; Columbus, OH; or Plano, TX will follow a hybrid schedule, coming into the office two days per week. Otherwise, this role is remote.
Responsibilities:
Preferred Qualifications:
Qualifications
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
$83,000.00 - 157,000.00
Operating at the intersection of business strategy and technical development, the Data Solutions team works closely with senior leadership, IT, finance, marketing, distribution, and product teams to simplify and expand the company's ability to understand both where we've been and where we are going. By designing, building, and implementing centralized data, planning, and reporting solutions, we play a key role in connecting our USRM functions in a meaningful and impactful way.
Ready to shape how a Fortune 100 insurer sees its own business? As a Sr Data Solutions Analyst on our Data Solutions team, you'll sit at the intersection of finance and technology - designing the SQL/Python pipelines, Snowflake models, and Power BI dashboards that power enterprise planning, forecasting, and budgeting for USRM. You won't just build reports; you'll own the technical vision for how finance leadership understands where the business has been and where it's going, working hands-on with stakeholders across IT, finance, marketing, and distribution.
**This role may have in-office requirements depending on candidate location**
Candidates who live within 50 miles of Boston, MA; Portsmouth, NH; Seattle, WA; Columbus, OH; or Plano, TX will follow a hybrid schedule, coming into the office two days per week. Otherwise, this role is remote.
Responsibilities:
- Design, build, and maintain SQL/Python-based data pipelines, models, and dashboards that support enterprise planning, forecasting, and budgeting solutions
- Own the technical architecture and design decisions for assigned data solutions, from requirements through deployment
- Manage multiple projects in parallel to implement system enhancements and new enterprise application solutions
- Collaborate with stakeholders to identify and implement innovative, data-driven solutions that increase process efficiency
- Gather and translate business requirements into technical specifications, and validate solutions through testing and user acceptance criteria
- Analyze existing tools, processes, and data sources to identify and resolve gaps in accuracy, latency, and reliability
- Mentor junior analysts and contractors, providing technical guidance and code/design review to raise the team's overall capability
- Lead continuous improvement efforts across business processes, systems, and reporting infrastructure
- Prepare and present regular status updates on ongoing projects and solutions to stakeholders and leadership
- Create and maintain technical and process documentation, and lead end-user training
- Perform monthly data load and validation activities for book close - develop automated and AI solutions to drive efficiencies.
Preferred Qualifications:
- Strong hands-on proficiency in SQL and Python with experience building and maintaining data pipelines or models
- Experience with Snowflake (or a comparable cloud data warehouse)
- Experience with Power BI (or a comparable BI/reporting tool)
- Experience with SAS and Office 365
- Solid understanding of finance and accounting concepts, and experience supporting FP&A, planning, or budgeting processes
- Demonstrated experience mentoring or leading the work of other analysts or contractors
- Highly motivated self-starter with strong ownership, curiosity, and a track record of following through on commitments
- Strong communicator able to translate between technical and business stakeholders
- Proven experience proposing and executing innovative ideas through to completion
- Strong organizational skills with the ability to prioritize and manage multiple projects under demanding deadlines
- Strong situational analysis, troubleshooting, and decision-making abilities
- Experience with Jira and Confluence, which are heavily used in this role
Qualifications
- 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
- 3-5 years experience in coding for data management, data warehousing, or other data environments, including, but not limited to, working in NoSQL implementation, ETL, Java, scripting languages (Python, Perl, Shell), and the Hadoop stack
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
$83,000.00 - 157,000.00
Similar Jobs at Liberty Mutual Insurance
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Handles inbound calls and warm leads to understand customers’ insurance needs, recommend appropriate Property & Casualty coverage, and convert prospects into policyholders. The role includes paid licensing and training, customer consultation, sales closing, brand representation, and maintaining a reliable remote work environment. Employees must work four weekdays and one weekend day, meet home-office and internet requirements, and remain in their resident state for at least one year.
Top Skills:
PcWired High-Speed Internet
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Leads a multi-state casualty claims organization of more than 300 professionals across Auto and General Liability lines. Accountable for claims outcomes, loss costs, expenses, customer experience, operational readiness, emerging risks, and talent development. Establishes regional priorities, manages resources, develops leadership pipelines, supports continuous improvement, and partners with underwriting, customers, agents, and brokers. The position requires advanced insurance and claims expertise, strong analytical and leadership capabilities, and experience managing large, complex operations.
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Handles inbound calls and warm leads, consults customers on insurance needs, recommends appropriate Property & Casualty products and coverages, and converts prospects into policyholders. The role includes paid training and licensing, remote work, customer service, sales closing, and commission opportunities. Employees must work four weekdays and one weekend day, maintain a compliant home office, and obtain a Property & Casualty insurance license after hire.
Top Skills:
PcWired High-Speed Internet
What you need to know about the San Francisco Tech Scene
San Francisco and the surrounding Bay Area attracts more startup funding than any other region in the world. Home to Stanford University and UC Berkeley, leading VC firms and several of the world’s most valuable companies, the Bay Area is the place to go for anyone looking to make it big in the tech industry. That said, San Francisco has a lot to offer beyond technology thanks to a thriving art and music scene, excellent food and a short drive to several of the country’s most beautiful recreational areas.
Key Facts About San Francisco Tech
- Number of Tech Workers: 365,500; 13.9% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Google, Apple, Salesforce, Meta
- Key Industries: Artificial intelligence, cloud computing, fintech, consumer technology, software
- Funding Landscape: $50.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Sequoia Capital, Andreessen Horowitz, Bessemer Venture Partners, Greylock Partners, Khosla Ventures, Kleiner Perkins
- Research Centers and Universities: Stanford University; University of California, Berkeley; University of San Francisco; Santa Clara University; Ames Research Center; Center for AI Safety; California Institute for Regenerative Medicine
