Case Study: San Diego County Employees Retirement Association

Providing A High Performant, Scalable, Secure, and Resilient Data Lake Solution

The Challenge Peraton’s Solution The Value Delivered


The Challenge

The Office of Evaluation, Performance, and Analytics (OEPA), a department under the County of San Diego (CoSD) Chief Administrative Office, integrates evidence-building capabilities to inform policy, budget, and operational decisions for the betterment of the San Diego County region.

In late 2023, the OEPA needed an enterprise integrated data platform to support the organization’s data analytics needs, as querying multiple individual data sources across CoSD systems was simply not viable or sustainable.

Cloud-based solutions are essential to creating the right information technology environment for mission-critical systems. AWS services could both solve the customer challenge and provide a holistic, enterprise-wide data lake solution.

With more than 60 AWS certifications across the team, Peraton provides full IT services to CoSD, including requirements analysis, solution architecture and engineering, application development, and operations and maintenance (O&M), infrastructure operations, end user management, service desk, cybersecurity, project and program management, contracts management, asset management, and procurement.


Peraton’s Solution

Working with our AWS teammates, Peraton developed a solution to allow for structured, unstructured, internal, and external data to be ingested into the data lake for ease of use, performance, scalability, cost effectiveness, and compliance.The team worked across four key elements – data ingestion, data engineering, access management, and consumption – to create the enterprise data lake solution.


The Value Delivered

The resulting AWS data lake solution transformed the enterprise across the following pillars: security, performance efficiency, operational excellence, reliability, cost optimization, and sustainability.

  • Security: The solution architecture was compliant from the onset and limited access to strictly necessary personnel.
  • Performance Efficiency and Reliability: The solution is serverless, other than the Tamr component, meaning it does not need to be patched, maintained, or upgraded like traditional infrastructure. Tamr is used to find similarities and reduce redundancies within the data lake solution.
  • Operational Excellence: Using CloudTrail, the teams can rapidly ingest data so the customer can perform their queries and dashboards. With the solution, data is processed, secured, and available for querying and dashboards in less than two months versus the previous average of 12-24 months using older technology.
  • Cost Optimization: The Peraton FinOps team tracks overall AWS monthly spend to identify spikes.
  • Sustainability: The serverless solution not only reduces monthly costs but minimizes the cloud footprint, reducing environmental impact.

The data lake solution serves as a centralized repository where CoSD can store all types of data as-is, at any scale and run different types of analytics to gain better visibility into data, guide better decision-making, and save time and effort.

At the CoSD-Peraton Innovation Day in October 2024, the OEPA team testified to the value this solution brought them and can bring to other departments in the county that perform data analytics. The Chief Information Officer for the County stated that data lake is the enterprise standard, deprecating data warehouses and data marts, which is also reflected in the county approved Enterprise Standards and Patterns of 2024.


About the Customer

County of San Diego is the fifth largest county in the U.S., the second largest in California. There are four major groups in the county—Finance, Health & Human Services, Land Use & Environmental, and Public Safety. Across these groups there are 54 departments that provide a variety of services including marriage licenses, building permits, suspected child and elder abuse reporting, parcel maps, birth and death certificates, rental assistance, animal services, emergency services, parks and recreation, and medical examiner.


Published: Feb 20, 2025