Data Analyst

Job Description

Data Analyst

At Fisher Phillips, we know exceptional talent is the key to our success, to providing the best service to our internal and external clients. Being a part of the Fisher Phillips team means you will work with cutting edge technology in a professional and fun environment under leadership ready to invest in your professional development. If you have a growth mindset, are eager to challenge yourself, and desire to work with a team of professionals instituting change on an ongoing basis, keep reading.

THE OPPORTUNITY

Fisher Phillips is a national labor and employment law firm, and we are looking for a talented Data Analyst to support the firm's Wage & Hour Practice Group at a national level. This position will be located in the firms New Jersey, New York or Philadelphia office and will be a hybrid position. To view information about any one of our offices, please visit our website at www.fisherphillips.com.

In this role, the Data Analyst 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 a high level of expertise in assisting clients and attorneys while managing a busy case and/or matter load. The Data Analyst 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.The Data Analyst is responsible for analyzing client data. The analyst designs, creates and analyzes data reports for results, trends and variations. The Data Analyst must have superior Excel skills and be comfortable evaluating large amounts of data and creating formulae for proper analysis.

Position 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 work with the attorneys to manipulate the data to get the information they need.
• Perform timecard 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.
• Receive confidential client data and perform quality control test. Clean, aggregate, and transform 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.
• Create 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.
• 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

• Bachelors Degree required
• 1 to 3 years data analyst experience
• Highly proficient in Microsoft Excel
• Experience with Power BI preferred
• Presents written communications that are concise and accurate.
• Exhibits confident and professional verbal communication skills.
• Effectively communicates with clients and vendors.
• Keeps appropriate people informed of the status of projects, work and deadlines.
• Maintains a positive and can do attitude when dealing with clients, co-workers, and attorneys.
• Answers questions clearly and thoroughly.
• Contributes to an atmosphere of teamwork and congeniality.
• Possesses a strong understanding and abides by the policies and procedures of the firm and local office.
• Maintains an exceptional customer service attitude and demeanor at all times.
• Flexible and willing to pitch in wherever needed.
• 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.