Data Analyst II

Martenson, Hasbrouck & Simon LLP is seeking a full-time experienced Data Analyst to join the Firm’s data analytics team in Orange County. The Data Analyst will develop and execute analyses that address complex legal and business questions, identify meaningful patterns and issues in data, and support the development of data-driven recommendations and strategies.

This role goes beyond traditional litigation support and requires an analyst who can independently work with large and complex datasets, identify meaningful trends and issues, develop analytical methodologies, build reporting and visualization solutions, and clearly communicate findings to both technical and non-technical audiences. The ideal candidate combines strong quantitative and technical skills with intellectual curiosity, sound judgment, and the ability to understand the business and legal questions underlying an analysis. This position will report to the Senior Data Analyst and work as part of the Firm’s broader data analytics function.

Martenson, Hasbrouck & Simon LLP is a national law firm focusing on labor and employment defense. MHS is headquartered in Atlanta, Georgia, and has over 80 attorneys across seven offices located in Atlanta, Chicago, Dallas, New York, Orange County, Sacramento, and San Diego. Our attorneys work with some of the largest employers in the United States and have extensive experience providing day-to-day employment-related advice and defending clients facing a wide range of labor and employment claims.

Key Responsibilities:

• Collect, clean, integrate, analyze, and validate large and complex datasets from a variety of sources.
• Use SQL and Python to query, transform, reconcile, and analyze data and develop repeatable analytical workflows.
• Design and develop interactive dashboards, reports, and data visualizations in Power BI to communicate key findings, trends, and metrics.
• Translate legal, business, and operational questions into appropriate analytical approaches in collaboration with attorneys and the data analytics team.
• Develop analytical methodologies and models to evaluate potential exposure, damages, trends, patterns, and other issues relevant to litigation and client decision-making.
• Investigate data anomalies, identify gaps or limitations in available information, and reconcile discrepancies across multiple data sources.
• Analyze employment-related data, including timekeeping, payroll, HRIS, scheduling, and other operational systems, in connection with wage and hour and other employment matters.
• Support analyses involving class certification, damages, sampling, pay practices, timekeeping practices, and other litigation-related issues as needed.
• Develop clear, defensible approaches for working with incomplete, inconsistent, or complex datasets and document analytical assumptions, processes, and findings.
• Identify opportunities to improve, automate, and standardize existing analytical and reporting processes.
• Prepare clear written summaries, presentations, dashboards, and other deliverables that effectively communicate analytical findings and support attorney and client decision-making.
• Manage analytical work across multiple matters, balancing competing deadlines and shifting priorities while exercising independent judgment regarding analytical approach and execution.

Martenson, Hasbrouck & Simon LLP offers a competitive benefits package that includes:

• Competitive salary
• Year-end bonus
• 401(k) with employer contributions
• Medical, dental, and vision insurance
• Paid time off
• Referral bonus program

Salary Range: $75,000 - $95,000 depending on experience.

Martenson, Hasbrouck & Simon LLP is an equal opportunity employer.