Data Analyst

APEX CLASS ACTION LLC•Irvine, CA

2d•$75,000 - $110,000•Onsite

About The Position

Apex Class Action provides legal administration services to Plaintiff and Defense law firms across the nation. Our services include pre-settlement, settlement administration, and business process reengineering to improve efficiency and reduce administrative costs. At Apex Class Action, LLC, the Data Analyst is responsible for collecting, standardizing, and reviewing all settlement-related data, ensuring compliance with legal and regulatory requirements and seamless integration with internal systems. In this role, the Data Analyst works closely with Project Managers and Disbursement Specialists to effectively manage class-member datasets, resolve data discrepancies, maintain stringent data-normalization standards, calculate class-member settlement awards, and support the administration of large settlements.

Requirements

Expertise in large-scale or complex data analysis, employing advanced techniques to manage and interpret intricate data sets.
Proficient understanding of and experience with extract, transform load (ETL) concepts, tools, and practices.
Experience with relational databases and ability to comprehend moderately complex SQL logic.
Excellent verbal and written communication skills; Excellent analytical and organizational skills; Strong deductive reasoning.
Exceptional problem-solving skills, marked by the ability to diagnose challenges swiftly and devise innovative resolutions.
Ability to multi-task and work on separate projects in a fast-paced start-up company environment and extremely tight timelines
Ability to work independently with limited direction or as part of a team
Ability to work in an environment with immediate deadlines and shifting priorities.
Proficient with MS Office tools, particularly Dynamics and Excel.
Two to five years of relevant industry experience, accompanied by a proven history of delivering measurable results.

Responsibilities

Standardize Settlement Data: Leverage advanced Excel (including VBA) and script-based techniques to query, transform, and standardize data from various corporate systems, systematically identifying and resolving discrepancies to ensure initial data accuracy. Regularly propose and test new solutions or tools to further improve data extraction and quality.
Consolidate Multiple Inputs: Merge different case-related data sources and formats into a master file, restructuring large or unstructured datasets into a coherent arrangement of columns and rows for easy interpretation. Ensure these consolidated datasets meet the requirements of the settlement agreements—enabling accurate settlement award calculations and tax assessments while supporting the mail team in executing efficient, successful mailings.
Validate Information: Cross-check critical identifiers (e.g., Social Security numbers or Class Member Addresses) with authoritative databases (e.g., NCOA search and skip tracing) and review case requirement specifications to identify and resolve any gaps or inconsistencies.
Cleanse and Refine Datasets: Identify duplicate or invalid entries, correct formatting issues, and address column misalignments to ensure accurate data for the entirety of the settlement administration processes.
Migrate Datasets to Internal Systems: Upload case datasets to the case management system using Power Automate and collaborate with our Director of Product Engineering to expand and enhance database functionalities.
Collaborate and Communicate Cross-Functionally: Interact professionally with internal teams, project managers, clients, and external stakeholders, delivering regular updates on progress, issues, and data requirements.
Track Project Metrics: Log time spent on case-specific tasks to measure Key Performance Indicators (KPIs) and other performance metrics, ensuring transparency and enabling precise reporting.
Uphold Professional Standards: Must be able to meet short deadlines, coordinate with team members to resolve data challenges proactively, and maintain a solutions-focused work ethic.
Maintain SOC2 Compliance: Ensure all data processes meet internal SOC 2 related policies, assist with data classification reviews, and contribute to organization-wide risk assessment reports to uphold stringent security policies.
Drive Continuous Improvement: Continuously evaluate and adopt the most effective tools and methodologies to optimize data handling processes, while proposing innovative solutions that enhance efficiency, accuracy, and overall quality.