Data Solutions Analyst

Pattern Data; Pittsburgh (Allegheny County); On-site; USD 80,000 - 110,000; Full time

Job summary

Pattern Data, an AI-powered platform for mass tort litigation, is hiring a Data Solutions Analyst to support settlement programs and provide data-driven answers to clients and internal teams.

You will write scripts, validate outputs, and collaborate across litigation management, engineering, and product teams while employing SQL, Python, and advanced Excel skills. Some travel or after-hours availability may be required.

Qualifications

• 1+ year of experience working with SQL data sources.
• Experience with Python or a similar scripting language for validation.
• Advanced Excel proficiency and strong attention to detail.

Responsibilities

• Support settlement programs by answering data questions and validating outputs.
• Develop long-term data solutions and collaborate with clients and internal teams.
• Translate client questions into clear data answers using settlement data and tooling.
• Write and run scripts to validate claimant data, calculations, and outputs.
• Perform quality checks and troubleshoot data discrepancies.
• Collaborate with litigation, engineering, and product teams to resolve issues.

Skills

SQL

Python

Excel

Data analysis

Attention to detail

Education

Bachelor's degree in Economics, Data Science/Analysis, Computer Science, or related field

Job description

Pattern Data is an AI-powered platform built for the complexities of mass tort litigation. We help leading law firms automate case analysis, accelerate settlement decisions, and manage high-volume inventories that were traditionally manual and time-intensive.

The problems we work on are complex and high-stakes, requiring precision, adaptability, and a deep understanding of both data and client needs.

We’re a collaborative, high-ownership team that moves quickly and takes pride in solving hard problems well. People at Pattern go deep to understand the “why,” build solutions that hold up, and stay focused on what drives real outcomes for our customers. We value transparency, thoughtful problem-solving, and authenticity in how we work together and we’re looking for someone who’s excited to contribute to a team that’s actively building and improving every day.

What You’ll Do

As a Data Solutions Analyst at Pattern Data, you will specialize in settlement support, becoming a trusted resource on the facets of each settlement program. You’ll partner with clients and internal teams to solve data questions, build long term solutions, and validate outputs to ensure accuracy across every settlement you support. At Pattern, you will be responsible for the following:

• Be available and responsive to client and internal requests across settlement programs
• Become an expert on the eligibility criteria, claims data, and valuation methodology specific to each settlement to provide informed, accurate guidance and data solutions
• Provide client and internal support on Pattern's API capabilities
• Provide data support, translating client questions into clear, accurate answers using settlement data and platform tooling
• Write and run simple scripts and queries (SQL, Python, or similar) to validate claimant data, calculations, and outputs
• Perform quality checks and troubleshoot data discrepancies flagged by clients or internal teams
• Document recurring questions and solutions to build institutional knowledge across the our settlement programs
• Collaborate cross-functionally with litigation management, engineering, and product teams to resolve settlement-specific data issues

What You’ll Bring

• Strong analytical and problem-solving skills, with the ability to quickly learn the details of multiple settlement programs and translating them into data solutions
• Excellent communication skills, with the ability to explain technical concepts and data findings clearly to both technical and non-technical stakeholders
• Comfort managing multiple, sometimes competing priorities across concurrent projects
• 1 or more years of experience working with SQL data sources, with comfort writing and debugging queries
• Familiarity with Python or a similar scripting language for data validation and automation
• Exceptional attention to detail and a client-first mindset, with a willingness to serve as a flexible, on-call resource across programs
• Advanced proficiency in spreadsheet tooling i.e. Excel
• Bachelor's degree in Economics, Data Science/Analysis, Computer Science, or a related field, or equivalent experience
• Willingness to travel or be available outside standard business hours as settlement deadlines require
• Experience in the legal industry is a plus

Pay Transparency Disclosure

The estimated base salary range for this role is $80,000-$110,000 per year, plus commission and benefits. At Pattern Data, our compensation philosophy is built around fairness, transparency, and market alignment. Base salary represents just one part of our total compensation package, which also includes performance-based incentives, comprehensive benefits, and other rewards. Final compensation will be determined based on several factors, including skills, experience, qualifications, geographical location and internal equity across the team.

Pattern Data is committed to pay equity and to maintaining competitive, transparent compensation practices across all roles and teams.

Equal Employment Opportunity

As set forth in Pattern Data’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making an appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

• A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.
• A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.
• An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.
• An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.