State Auto Insurance Companies: Boosting productivity with advanced analytics

About State Auto Insurance Companies

State Auto offers insurance products including auto, home, and business, through independent insurance agents. Based in Ohio, State Auto operates in 33 states.

Industries: Financial Services & Insurance
Location: United States

Tell us your challenge. We're here to help.

Contact us

About Datametica

Datametica assists with EDW to Google Cloud migration through innovative frameworks that automate planning, code conversion, data migration, and validation during modernization.

Daily tasks at State Auto include running complex actuarial analysis and reports. When staff sought to move away from the company's legacy solution, reducing operating costs and improving platform performance were top priorities. Administrators also wanted to eliminate problematic data siloing to optimize network efficiency.

Google Cloud results

  • Cuts development time on new platform by 45% and maintenance costs by 55%
  • Reduces query execution times for most queries by up to 90% via BigQuery migration
  • Improves team effectiveness by introducing AI and advanced analytics through Google Cloud

50% increase in customer engagement speed

Enabling Change

Solutions: Data Analytics
Workloads: Data Warehouse; Streaming Data Analytics

BigQuery is the primary data lake solution for State Auto Insurance Companies ("State Auto"), offering substantially faster query times for employees compared to its previous data lake solution within Netezza. For instance, an 800GB query that previously took three hours on the company's legacy solution can now be executed in seven minutes.

The performance gains from BigQuery and Google Cloud allow actuaries to efficiently evaluate and process customer insurance policies, leading to additional opportunities for revenue and customer growth. Cloud Dataproc provides auto scaling and manages Apache Spark jobs, while Cloud Storage offers a unified back-end location for internal data. This in turn helps State Auto use its resources efficiently without sacrificing performance.

By moving to Google Cloud, State Auto benefited from simpler platform management resources, reduced costs, and improved data security for high-value customer information. Having its platform hosted on a single location eliminates data siloing, simplifying its IT architecture and allowing the company to explore machine learning applications to further advance its analytics abilities.

Google Cloud services partner Datametica played a vital role in the data warehouse migration process to BigQuery, helping to seamlessly implement the new processes and technologies without disruption. Datametica continues to support State Auto in its endeavors and its move to the cloud for data management and analytics capabilities.

"After moving to Google Cloud, we've seen query times go down from hours to minutes. From an IT standpoint, these types of material gains are exciting and make it easy to see the upsides of migrating to Google."

Krishna Tummalapalli, Enterprise Data Architect, State Auto Insurance Companies

Tell us your challenge. We're here to help.

Contact us

About State Auto Insurance Companies

State Auto offers insurance products including auto, home, and business, through independent insurance agents. Based in Ohio, State Auto operates in 33 states.

Industries: Financial Services & Insurance
Location: United States

About Datametica

Datametica assists with EDW to Google Cloud migration through innovative frameworks that automate planning, code conversion, data migration, and validation during modernization.