Case Study: Snowflake Financial Services End-to-End Deployment
Written by Jared Hillam
About Customer
[Financial Services Client] provides loan servicing and asset management solutions for their clients. [Financial Services Client] is now one of the largest privately-held providers of end-to-end outsourcing support services for both credit card and installment loan products in North America.
Challenges
[Financial Services Client] needed a full lifecycle data ingestion and integration pipeline that could service all their business lines. The lack of information was frustrating to the Business Stakeholders. Any linked information across subjects was instantly difficult to come by because data lived in so many silos. Additionally, the existing infrastructure to deliver this information was costly, antiquating, and required a time investment from valuable team members to maintain. To fix this situation, [Financial Services Client] began evaluating scalable solutions. The breadth of the solutions reach would cross all the organization's domains, thus it required a solid end-to-end framework. Early on, Snowflake introduced Intricity to guide architectural discussions about the desired future state.
Full executive sponsorship was required at the highest levels in the financial institution, which ultimately went to the board of directors for approval. With a close partnership between Intricity’s Executives, the [Financial Services Client] CEO acted as the champion taking on the skepticism of the Board of Directors for adopting Snowflake at such an early stage. Years later as Snowflake went public, the CEO’s bold stance was shown to be visionary.
Navigating Constraints
- The organization had 20 years of historical data iterated through many organizational changes.
- Data was very siloed with multiple ownership parties
- The business was hungry for information, with multiple parties seeking their rollout of data
- Over 25 large operational sources of information
Win 1: Centralized Single Version of the Truth
Intricity and [Financial Services Client] created a partnership to define the future state architecture which would generate a single curated data source for delivering information to the organization. The joint teams designed data domains and their rollout timing which the rest of the organization could get behind. The establishment of these subject matters encapsulated the 20 years of historical data into a conformed Data Warehouse. Users with credentials could cross-examine the various business domains.
Win 2: High-Efficiency Queries
The joint [Financial Services Client]/Intricity teams developed naming conventions and methodologies that maximized the performance of Snowflake's queries. Using these best practices, the [Financial Services Client] was able to deliver their end-user requirements under the budgeted compute requirements.
Win 3: Maintenance Free Environment
[Financial Services Client] board members and others had skepticism that Snowflake could deliver the query performance and truly meet the "maintenance free" promise. Not only did Snowflake deliver on the maintenance freedom, but also [Financial Services Client] and Intricity were able to automate many of the scaling policies to control compute consumption.
Win 4: Dynamic Obfuscation
Through tokenization in the cloud, Intricity and [Financial Services Client] were able to control the obfuscation of the data to govern its usage amongst team members. This system was connected to existing entitlement solutions to dynamically assign content to users and groups.
Win 5: Proof of Market Presence
The success of the project's deployment was only emphasized when the IPO became the largest software offering in history, further establishing the leadership of the CEO with the Board of Directors.
Who is Intricity?
Intricity is a specialized selection of over 100 Data Management Professionals, with offices located across the USA and Headquarters in New York City. Our team of experts has implemented in a variety of Industries including, Healthcare, Insurance, Manufacturing, Financial Services, Media, Pharmaceutical, Retail, and others. Intricity is uniquely positioned as a partner to the business that deeply understands what makes the data tick. This joint knowledge and acumen has positioned Intricity to beat out its Big 4 competitors time and time again. Intricity’s area of expertise spans the entirety of the information lifecycle. This means when you’re problem involves data; Intricity will be a trusted partner. Intricity's services cover a broad range of data-to-information engineering needs:
What Makes Intricity Different?
While Intricity conducts highly intricate and complex data management projects, Intricity is first a foremost a Business User Centric consulting company. Our internal slogan is to Simplify Complexity. This means that we take complex data management challenges and not only make them understandable to the business but also make them easier to operate. Intricity does this through using tools and techniques that are familiar to business people but adapted for IT content.
Thought Leadership
Intricity authors a highly sought after Data Management Video Series targeted towards Business Stakeholders at https://www.intricity.com/videos. These videos are used in universities across the world. Here is a small set of universities leveraging Intricity’s videos as a teaching tool:
Talk With a Specialist
If you would like to talk with an Intricity Specialist about your particular scenario, don’t hesitate to reach out to us. You can write us an email: specialist@intricity.com
(C) 2023 by Intricity, LLC
This content is the sole property of Intricity LLC. No reproduction can be made without Intricity's explicit consent.
Intricity, LLC. 244 Fifth Avenue Suite 2026 New York, NY 10001
Phone: 212.461.1100 • Fax: 212.461.1110 • Website: www.intricity.com