About a-team Marketing Services
The knowledge platform for the financial technology industry
The knowledge platform for the financial technology industry

A-Team Insight Blogs

Standard Life Takes Stealthy Approach to Building a Data Warehouse

Subscribe to our newsletter

A stealthy rather than Big Bang approach to data warehousing can meet business requirements in a timely and cost-conscious way, and lay the foundations for a scalable solution, said Jim Shaw, solutions architect at Standard Life, as he presented a case study of data warehouse development at last week’s Financial Information Management (FIMA) Conference in London.

“Enterprise data warehouse projects are typically large, complex, long and expensive. Significant change is required and there needs to be a high degree of senior management buy-in. That is a hard sell,” he said. “So, we reduced the complexity, time and cost, and decided to deliver an enterprise data warehouse in smaller chunks.”

Shaw’s project to build a data warehouse on an incremental basis has to abide by Standard Life rules requiring each project to have its own business case and be developed in collaboration with external partners.

In response to business requirements, Shaw and his team rolled out the first element of the data warehouse for accounting in the third quarter of 2008. This was driven by a business requirement to view accounting data across all source systems, maintain consistent data formats and provide access to data that had not previously been available to the accounting function.

A second element of the data warehouse, forward pricing, which reduced risk and allowed the movement of funds between insurance administration and investment systems, was rolled out in the fourth quarter of 2009, followed by policy assets, a core enabler of profit generation, in the fourth quarter of 2011. The next tranche of the build will support Solvency II. It will go live in 2013, delivering required balance sheets and optimising the company’s regulatory capital position.

Standard Life predefined the architecture for the data warehouse using Kimball methodology, part of its overall strategy. It then employed an Oracle database, Ab Initio extract, transfer and load tools, and Cognos business intelligence tools for data presentation to deliver the database solutions, basing what it could on reusable components such as data models and frameworks.

“The benefits of an incremental approach are productivity, data consistency and a scalable solution, but it is important to stick to strong architectural governance,” said Shaw. “The IT team worked with the business and we could support current business priorities, align with the business and structure for growth. Going forward, we will give the business control using business rules, not code, and the business will lead the extension of the enterprise data warehouse with new business processes, attributes and propositions.”

Subscribe to our newsletter

Related content

WEBINAR

Recorded Webinar: Potential and pitfalls of large language models and generative AI apps

Large language models (LLMs) and Generative AI applications are a hot topic in financial services, with vendors offering solutions, financial institutions adopting the technologies, and sceptics questioning their outcomes. That said, they are here to stay, and it may be that early adopters of Generative AI apps could gain not only operational benefits, but also...

BLOG

Snowflake Releases Arctic Open-Source LLM for Complex Enterprise Workloads

Snowflake has released Arctic, an open-source large language model (LLM) designed to deliver top-tier intelligence and efficiency at scale, and optimised for complex enterprise workloads. The company’s debut of its own open-source LLM takes it into competition with the likes of OpenAI’s GPT-4, Google’s Gemini, Meta Platforms’ Llama 2 and Mistral AI’s Mixtral. Snowflake Arctic...

EVENT

Buy AND Build: The Future of Capital Markets Technology, London

Buy AND Build: The Future of Capital Markets Technology London on September 19th at Marriott Hotel Canary Wharf London examines the latest changes and innovations in trading technology and explores how technology is being deployed to create an edge in sell side and buy side capital markets financial institutions.

GUIDE

The Global LEI System – A Solution for Entity Data?

The Global LEI System – or GLEIS – has been in development since the middle of last year. Development has been patchy at times, but much has been done, leaving fewer outstanding issues, but also raising new questions. What’s emerging is a structure for the GLEIS going forward, complete with a mechanism for registering and...