Data Analyst III

ClearCompany
United States
22 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Compensation
$65,828.0 - $109,713.0
Working hours
Regular working hours

Tech stack

Microsoft Excel Spreadsheets Data Normalization Text Processing Excel Formulas Statistical Hypothesis Testing Python (Programming Language) Logistic Regression Microsoft Office Tableau (Software)

Job description

The Data Analyst III will be responsible for analyzing client data. The analyst designs, creates and analyzes data reports for results, trends and variations. The Data Analyst III must have superior excel skills and be comfortable evaluating large amounts of data and creating formulas for proper analysis., * Draft Damage Model to determine the gross damage exposure of claims that are egregious or authorized by relevant statutes. Design reports and formulae in excel that will provide the analysis needed to predict damages in different scenarios; and working with the attorneys to manipulate the data to get the information they need.

  • Perform Time Card Analysis to identify any meal period violations and provide any other insightful information. Formulae will be altered to change the parameters and lawyers will ask for “what if” analyses, like what are the penalties if there are 1,000 FTE plaintiffs and they all worked w to x while missing y number of breaks a week and working z overtime hours per month on average.
  • Receives confidential client data and performs quality control test. Cleans, aggregates, and transforms variety of data formats into excel format for analysis.
  • Check modeling results for quality and reports on data as needed
  • Analyze payroll and time data to determine if wages were appropriately disbursed.
  • Pay plan calculator design and manipulation, which involves reading the criteria for commissions and bonuses that are set forth in a pay plan or contract and designing excel spreadsheets that will allow our client to use the calculator to determine wages owed. Legal training is not required even though they are reading agreements. The criteria are clear, usually, to someone with business acumen.
  • Creating spreadsheets to analyze other business data, or manipulating spreadsheets provided by the client, on things like profit and loss calculations on a business unit related to a case we are defending
  • Manage deadlines and ensure project steps are completed and progressed in a timely fashion.
  • Interpret client data to identify statistical trends through data aggregation, sorting, and statistical analyses.
  • Collaborate with other team members, attorneys, paralegals and class action attorneys.
  • Statistical estimation and testing for adverse impact in employer hiring, promotion and termination processes.
  • Linear and logistic regression modeling and hypothesis testing used in preventative pay equity reviews.
  • Utilize Excel to work with client data to identify statistical trends in Human Resources data.
  • Work with client data to identify statistical trends in employer selection
  • General excel work beyond the capability of an admin or word processor
  • Written and verbal contact with HR and legal professionals at Fortune 500 companies.

Requirements

  • Bachelor’s Degree required.
  • 5+ years data analyst experience (legal experience preferred).
  • Highly proficient in Microsoft Excel; and superior with Microsoft Office Professional Suite.
  • Experience with Python and Tableau preferred.
  • Extremely efficient, organized and resourceful.
  • Critical thinking and problem-solving skills required
  • Ability to multi-task and manage multiple projects, from start to finish, with shifting priority levels.
  • Strong organizational and communication skills.
  • Experience with routine billable time and cost capturing for analysis performed.
  • Be consistently at work and on time; arrive at meetings and appointments on time; ensure work responsibilities are covered when absent.
  • Respond promptly to attorney and client requests for service and assistance; meet commitments.
  • Follow instructions; complete tasks on time; commit to the hours necessary to complete assignments; work independently.
  • Approach others in a tactful manner; treat others with respect; react well under pressure.
  • Contribute to building a positive team spirit; support everyone’s efforts to succeed.
  • Takes ownership; gets the job done without the need for prodding or supervision.
  • Respects the time constraints faced by the lawyers in the office.
  • Adapts well to fluctuations in workload and changes in responsibilities.
  • Maintains a professional demeanor in high-stress situations.

Benefits & conditions

The salary range for this position is $65,828 - $109,713. Actual base pay within this range will be determined by several components, including but not limited to, location, relevant experience, internal equity, skills, qualifications, and other job-related factors permitted by law. This position is also eligible for a discretionary bonus of up to 10 % of the annual salary (prorated the first year). The final bonus amount, which is based on your individual performance and other relevant factors, will be determined at the Firm’s sole discretion.

Why Join Us

At Fisher Phillips, we recognize that exceptional talent is the foundation of our success, enabling us to deliver outstanding service to both our internal and external clients. Joining our team means collaborating in a professional yet dynamic environment that leverages cutting-edge technology. Our leadership is committed to fostering your professional growth and providing opportunities to challenge yourself in meaningful ways.

We believe in rewarding talent with more than just a competitive salary. Our comprehensive benefits package includes health, dental, and vision insurance, a 401(k) with profit sharing, generous paid time off, and holidays.

Your well-being is our priority. We offer 24/7 telehealth services, a variety of wellness programs, and additional optional benefits designed to support your unique lifestyle. At Fisher Phillips, you’ll find a workplace that values your health, happiness, and continued professional development.

About the company

Fisher Phillips, a premier international labor and employment law firm, is seeking an experienced Data Analyst III to join our team. In this essential role, the Data Analyst III performs under the direction and supervision of an attorney and should strive to perform high-quality billable work for the benefit of our clients and the support of our attorneys. We expect the Data Analyst to provide high-level expertise in assisting clients and attorneys while managing a busy case and/or matter load. The Data Analyst III is expected to record 1,500 or more billable hours during the performance year. The performance year begins October 1 and ends September 30. The Data Analyst does not render legal advice to a client, ever.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on laborlawyers.hrmdirect.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

1:24 min

Estimating project expenditures with Azure Pricing Calculator

Radu Vunvulea Radu Vunvulea · WWC 2022

1:32 min

Recognizing the persistence and utility of spreadsheet applications

John Bettiol · WWC 2022

2:44 min

Integrating data analytics into the talent acquisition function

Kobi Kobi +1 · WWC 2025

6:10 min

Transitioning agile recruiting teams away from manual spreadsheet management

Rudi Bauer Rudi Bauer +1 · Cappuccino with HR

2:58 min

Onboarding corporate legal counsel into developer pull request workflows

Uwe Korn Uwe Korn · WWC Europe 2026

1:52 min

Navigating complex spreadsheets inside terminal environments

Chris Heilmann +2 · LIVE

Videos

See all

Related articles

See all