Competitive Salary, Hybrid Schedule, Excellent Benefits, Bonus Potential, 401k, and More!
This Jobot Job is hosted by: Sierra Johnson
Are you a fit? Easy Apply now by clicking the "Apply Now" button and sending us your resume.
Salary: $38 - $45 per hour
A bit about us:
-
We are a national labor and employment law firm with 32 offices and more than 350 attorneys across the US. Our Irvine, Ca. office is looking for an experienced and reliable Data Analyst to support the needs of our firm. If you are ready to grow and work with a law firm with an excellent work environment, please apply!
Why join us?
-

• Excellent Benefits Package (medical, dental, and vision benefits)
• PTO
• Paid Holidays
• 401(k) and Profit Sharing
• Life Insurance
• Student Loan Refinancing Program
• Pet Insurance

Job Details
-
The Data Analyst will provide a high level of expertise in assisting clients and attorneys while managing a busy case and/or matter load.
The Data Analyst is responsible for analyzing client data. The Data Analyst must have superior Excel skills and be comfortable evaluating large amounts of data and creating formulas for proper analysis.
REQUIREMENTS

• Bachelor’s Degree required
• 2 - 3 years Data Analyst experience
• Expert Microsoft Excel; and superior with Microsoft Office Professional Suite
• Experience with Microsoft Access and Visual Basic for Applications
• Critical thinking and problem-solving skills required
• Ability to multi-task and manage multiple projects, from start to finish, with shifting priority levels
• Experience with routine billable time and cost capturing for analysis performed
• 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
• Respects the time constraints faced by the lawyers in the office
• Adapts well to fluctuations in workload and changes in responsibilities

Job Duties:

• 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
• 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.
• 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.

Interested in hearing more? Easy Apply now by clicking the "Apply Now" button. #finance-accounting #cost-capturing #time-card-analysis #damage-model #microsoft-excel #microsoft-access #attorneys #analyzing-client-data #hr-data-analyst #legal-data-analyst #profit-and-loss-calculations #legal #indtier99