How a captive lending organization automated financial reporting and portfolio monitoring without sacrificing technical control
A leading captive finance organization had the engineering talent to build almost anything. Its team was fluent in SQL, SAS, Python, and Excel, and had already created substantial reporting logic on its own. But as the business grew, the team ran into a familiar problem: building queries was not the same thing as building a scalable analytics operating model.
To support broader reporting, daily accounting requirements, and long-term flexibility, the organization paired Gestalt’s data engineering and universal data model with Snowflake and Omni’s AI analytics platform. The result was a governed analytics stack that let the team keep technical control while dramatically improving trust, speed, and scale.
The Results
- Achieved daily, penny-perfect general ledger posting with transaction-level accuracy
- Redirected engineering time toward differentiated analytics and risk work instead of rebuilding commodity data infrastructure
The Challenge
The client did not have a talent problem. It had a scale problem. Strong engineers could answer complex business questions with SQL, but ad hoc reporting was becoming harder to distribute, harder to govern, and harder to trust across the organization. Each new request often meant another custom query, another version of a metric, and another dependency on a small group of technical people.
At the same time, the team was spending valuable cycles rebuilding foundational analytics components that many lending organizations need: time series logic, portfolio snapshots, vintage views, and standardized date structures. That work was important, but it was not differentiated. It pulled attention away from the higher-value work the business actually needed from a sophisticated analytics team.
There was also a non-negotiable operational requirement: daily general ledger posting with penny-perfect accuracy. That raised the bar for the entire data stack. The reporting layer had to be useful, but the foundation underneath it also had to be trusted at an accounting level.
“The team had the ability to build from scratch. The real question was whether rebuilding the full stack was the best use of its strongest engineers.”
– Stephanie Hanson, Gestalt CEO
The Evaluation Process
The organization needed more than a BI tool. It needed a complete approach that would preserve technical flexibility in Snowflake while making reporting easier to govern and distribute. For a sophisticated client, any solution had to satisfy four requirements:
| What the team needed | Why Gestalt + Snowflake + Omni fit |
| Direct access to Snowflake | Gestalt created an analytics-ready foundation in Snowflake without taking control away from the client. Technical teams could still query the warehouse directly, extend models, and build custom views when needed. |
| Governed BI for broader distribution | Using Omni on top of Snowflake, the team created reusable metrics and modern dashboards with scheduled deliveries to improve self-service while reducing dependency on analysts and custom scripts |
| Consistency across lending analytics | Gestalt pre-built common constructs such as snapshots, vintages, date logic, and time series views so teams did not have to recreate the same foundation work over and over. |
| Trust strong enough for accounting use cases | A hybrid data engineering approach supported daily, penny-perfect general ledger posting, proving the stack could handle both enterprise reporting and operational finance requirements. |
The Deployment
Gestalt served as the data foundation between source systems, Snowflake, and Omni. Raw operational data was organized and standardized into a universal data model in Snowflake, then curated into analytics-ready datasets for reporting, monitoring, and downstream finance workflows.
That architecture gave the client two important benefits at the same time. First, Omni could sit on top of clean, governed datasets and act as the scalable business intelligence layer for dashboards, scheduling, and controlled exploration. Second, the client still retained the freedom sophisticated teams expect: direct access to Snowflake, the ability to build custom logic where appropriate, and a foundation that could expand beyond reporting into broader analytics and operational use cases.
- Gestalt standardized definitions and prepared reusable lending analytics structures in Snowflake
- Omni delivered the governed interface for fast data exploration, dashboard distribution, scheduled reporting, and easier internal access to trusted data
- A hybrid data engineering approach supported transaction-level fidelity for daily finance and accounting workflows
- Enablement on Omni helped the client shift from query-by-query reporting to a more scalable analytics operating model
The Impact
Once the foundation was in place, the organization moved from fragmented reporting to a more durable operating posture. Analysts and business users could rely on governed dashboards in Omni instead of depending on a fresh SQL request for every question. Engineering time was freed up for risk, modeling, and strategic analytics work. And the success of daily general ledger posting created a level of trust that elevated confidence in the broader analytics environment.
Just as important, the client did not have to choose between speed and control. Gestalt reduced the data engineering burden, Snowflake remained the technical system of leverage, and Omni became the user-facing analytics layer that made trusted data easier to consume and analyze across the business.
- Improved self-service with 28 dashboards and reports launched in Omni
- Scheduled, governed reporting replaced more manual distribution patterns
- Standardized datasets reduced duplicated logic across the team
- The Snowflake foundation positioned the organization to extend into broader enterprise insights over time
The Bottom Line
This case shows what Gestalt makes possible for technically strong organizations that want both flexibility and scale. Gestalt closes that gap by doing the data engineering work that turns raw operational data into a trusted analytics foundation. This work ensures teams can get the most out of Snowflake quickly and provides a strong base to drive the governed dashboards, scheduled reports, and self-service exploration within Omni.
For sophisticated financial services clients, that means faster time to value, stronger metric consistency, better use of engineering talent, and a clearer path from raw data to enterprise-ready analytics.