Risk Data Market Construction for a Foreign-funded Car Company - Industry Cases

Client Profile

The customer is a risk management department of a foreign-funded automotive finance company, currently using manual methods to import source data files, which has issues such as low data processing efficiency and data barriers.

Business Challenges

Currently, manual methods are used to import source data files, and lower versions of SAS tools are used to store and process data, with high personnel input, and long data implementation and update cycles.

There are data barriers between various business systems, and data inconsistencies, making it difficult to effectively integrate and share data, increasing the complexity and difficulty of data processing.

With the growth of data volume, the requirements for data processing efficiency and accuracy have increased, but the existing tools and methods cannot meet the computational needs of business scenarios and data volume.

Solution

Build a data mart: Establish a full-process risk data mart to achieve unified collection and management of risk data.

Design a graphical process automation monitoring interface: Use graphical menus to implement ETL configuration and management, achieving automated and timely data processing.

Improve the response time of data set applications: Design ETL process scheduling based on operational efficiency and scalability.

Establish a unified indicator permission management: Configure differential permissions to prevent information leakage and other risks.

Form a supporting data asset catalog: Support applications such as data queries, calculation logic, and historical change tracking.

Solution Advantages

Real-Time Automated Processing:
Ensure timely and accurate data with automated ETL and real-time triggers.
Efficient Queries & Error Prevention:
Optimize query efficiency and prevent data errors with mapping configuration and dependency checks.
Risk Control & Cross-System Sharing:
Implement a Risk Control Index 2.0 for efficient indicator calculation and cross-system collaboration.
Unified Permissions & Security:
Protect data with differentiated permissions and automated fault warning mechanisms.
User-Friendly Monitoring:
Enhance user experience with graphical ETL management and easy process monitoring.
Data Asset Catalog:
Provide comprehensive data support with a catalog for queries, calculation logic, and historical tracking.

Results & Values

Risk Data Mart:

Create a unified data platform connecting 10+ systems, streamlining data processes in the risk department.

Efficiency Gains:

Automate processes to reduce manual input and accelerate data updates.

Enhanced Security:

Protect against leaks and errors with centralized permission management and fault warnings.