Data Analyst II (California)

Data Analyst II

(California, Full-time, Remote)

Fisher Phillips, a premier international labor and employment law firm, is seeking an experienced Data Analyst II to join our team. In this essential role, the Data Analyst II 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 II to provide a high level of expertise in assisting clients and attorneys while managing a busy case and/or matter load. The Data Analyst II is expected to record 1500 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.

Key Responsibilities

• 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 in order 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 not required even though they are reading agreements. The criteria are fairly 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