Senior Data Solutions Analyst: Operational Data & Reporting team

Liberty Mutual Insurance; Columbus (OH); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Liberty Mutual Insurance seeks a data-focused professional to design and develop scalable data solutions, driving self-service data consumption and AI-enabled capabilities. You will prototype solutions, mentor teammates, and optimize data infrastructure while collaborating with stakeholders across the business.

The ideal candidate has 3–5+ years in data management, ETL, and BI tools, with strong skills in SQL, Python, and Power BI, and a Bachelor’s degree (Master’s preferred).

Qualifications

• 3+ years of experience building production data pipelines, data solutions and Power BI dashboards.
• Experience with data quality testing frameworks and automated data tests.
• Strong communication skills with both technical and non-technical stakeholders.
• 3-5+ years’ experience in data management, warehousing or related environments, including ETL and scripting languages (Python).

Responsibilities

• Design and develop scalable data solutions enabling self-service data consumption.
• Prototype and develop data solutions meeting organizational needs.
• Stay up to date with data engineering advancements and tool adoption.
• Identify opportunities to apply Gen AI for data discovery, lineage summarization, and automated documentation.
• Design proofs-of-concept with multiple languages to meet requirements and test iteratively.
• Mentor junior team members and guide technical direction.
• Optimize and tune data infrastructure for performance and cost-efficiency.
• Prioritize work based on customer value and manage complex deliverables.
• Ensure data quality with metadata, lineage, business definitions, and security."

Skills

SQL

Power BI

SAS

Python

ETL

NoSQL

Java

Data wrangling

Data manipulation

Communication

Education

Bachelor's Degree in CS/CE or related

Master's degree preferred

Tools

AWS

Snowflake

Hadoop

Job description

Description

Ensuring that data is a competitive differentiator for our enterprise, the USRM Data Office sets strategic data product visions, governs data for quality and compliance, develops best in class data and reporting solutions, and continuously seeks to optimize the value that data creates for our customers and company. Our team includes data analysts, data stewards, data strategists, and data product owners — performance-driven individuals who make sure that data is appropriately leveraged across every layer of our business.

This position may have in-office requirements dependent upon 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 and develop scalable data solutions with a focus on reusability that enable effective self-service data consumption and can describe their value to the customer.
• Independently works on prototyping/developing data solutions that meet the needs of the organization and business customers. Coding scalable proof-of-concepts and solutions.
• Stay up to date with advancements in data engineering, evaluate new tools and recommend adoption where appropriate.
• Identify opportunities to apply Gen AI for data discovery, lineage summarization, automated documentation, query generation and developer productivity (prompt engineering and code generation)
• Designs proof-of-concept solutions utilizing and advanced understanding of multiple coding languages to meet technical and business requirements with an ability to perform iterative solution testing to ensure specifications are met.
• Strive to become a technical leader and mentor for the team, providing assistance & guidance to junior team members
• Optimize and tune data infrastructure for performance, scalability, reliability and cost-efficiency
• Prioritizes efforts based on customer value and can set expectations for deliverables of high complexity.
• Ensure data solutions include activities and deliverables required to achieve high data quality and displays a strong understanding of complex, multi-tier, multi-platform systems, applying principles of metadata, lineage, business definitions, compliance and data security to project work.

The Ideal Candidate Will

• Have strong technical aptitude with data manipulation, data wrangling and Reporting tools (SQL, Power Bi, SAS, Python cloud computing: AWS and Snowflake).
• Demonstrate 3+ years of experience building production data pipelines, data solutions and Power Bi Dashboards.
• Possess hands-on experience with data quality testing frameworks and practices,and experience implementing automated data tests and validation.
• Have excellent communication skills and the ability to work with technical and non-technical stakeholders.
• 3-5+ years’ experience in coding for data management, data warehousing, or other data environments, including, but not limited to, ETL & scripting languages (Python)
• 3-5+ years’ experience with top quadrant Business Intelligence tools. Demonstrated technical knowledge and skills in coding languages and business intelligence tools (e.g., SQL, Power BI SAS, Python) and interest in expanding knowledge in this space.
• Must possess strong analytical, strategic, project management, decision-making and problem-solving skills.
• Direct Distribution domain knowledge preferred but not required.
• Demonstrates a comprehensive understanding of new technologies as needed to progress initiative and ability to adapt
• Able to describe value and support the prioritization of data solutions.
• Able to organize and address customer pain points.

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