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
Liberty Mutual Insurance Seattle, Washington, USA Office
1001 4th Avenue, Seattle, WA, United States, 98154
Similar Jobs at Liberty Mutual Insurance
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
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Handle inbound calls and warm leads, consult customers on insurance needs, recommend appropriate property and casualty coverage, and convert prospects into policyholders. Complete paid training and obtain a Property and Casualty license if needed. Representatives must work designated weekday and weekend schedules, maintain a professional home workspace, and meet wired internet requirements.
Top Skills:
Cable InternetDslFiber InternetPcWired High-Speed Internet
What you need to know about the Seattle Tech Scene
Home to tech titans like Microsoft and Amazon, Seattle punches far above its weight in innovation. But its surrounding mountains, sprinkled with world-famous hiking trails and climbing routes, make the city a destination for outdoorsy types as well. Established as a logging town before shifting to shipbuilding and logistics, the Emerald City is now known for its contributions to aerospace, software, biotech and cloud computing. And its status as a thriving tech ecosystem is attracting out-of-town companies looking to establish new tech and engineering hubs.
Key Facts About Seattle Tech
- Number of Tech Workers: 287,000; 13% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Amazon, Microsoft, Meta, Google
- Key Industries: Artificial intelligence, cloud computing, software, biotechnology, game development
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Madrona, Fuse, Tola, Maveron
- Research Centers and Universities: University of Washington, Seattle University, Seattle Pacific University, Allen Institute for Brain Science, Bill & Melinda Gates Foundation, Seattle Children’s Research Institute
