Should Your Data Warehouse Have an SLA? (Part 1)

Two hands in white dress shirts shaking hands.

Yes, if you want to build a truly data-driven organization your data warehouse needs a Service Level Agreement (SLA). At the core of any data driven organization is trust – your stakeholders must trust that when they need data, it will be there and it will be accurate. Without trust in the data warehouse, your organization will be less likely to use data to drive decisions big and small.

In my previous post Reporting is a Gateway Drug I explored reporting as a tool to build a trusting stakeholder relationship. In this post I explore trust through the concept of a data warehouse SLA. In part two I explore the people, process and tools you need to successfully implement the SLA.

Imagine this: it’s Saturday morning and something went wrong in your ETL process. The warehouse1Note: for the purposes of this post, I use the term data warehouse to refer to the data warehouse and the tools stakeholders use to access data from the data warehouse (e.g., business intelligence tools). is stale (or perhaps unavailable). What happens next? Do you call an engineer to look into this with you? Do you sacrifice your precious weekend morning for the good of the reports? Without a documented SLA you may find yourself (and your team) either

  • grinding out bug-fixes in an after-hours panic for things that don’t actually need to be fixed right away, or
  • failing to fix time-sensitive issues that are costing your business money by the minute.

Now that you have made your team indispensable, and have started building out a core piece of your company’s technical infrastructure, it is time to think about exactly what that responsibility means from a practical standpoint2Many thanks to Rebecca Green and Dylan Sather for sharing great examples of real world data warehouse SLAs.

What is an SLA?

SLA is a term used in many different business contexts. You have SLAs between companies (e.g., AWS’s 99.999% uptime), between departments (e.g., the Creative team’s 3 day production time policy) and between companies and their customers (e.g., pizza delivery in 30 minutes or less). You may even have internal and external SLAs for the same metric (e.g., we promise our customers delivery in a week, but internally we aim for 4 days).

The underlying theme in all these SLAs is an attempt to define expectations for a relationship between two parties. I think this definition from Wikipedia does a great job at explaining the core components of an SLA:

“A service-level agreement (SLA) is a commitment between a service provider and a client. Particular aspects of the service – quality, availability, responsibilities – are agreed between the service provider and the service user”

The word that jumps out to me right away is “commitment”, or as I like to think of it, a “promise.” An SLA is a promise to your stakeholders that you will deliver quality, predictable service that they can rely on. It is also a promise to communicate when your service level is compromised.

Why does a data warehouse need an SLA?

In short, you need an SLA to build trust. You may have picked up a theme in my posts – I believe, in the field of Analytics, the stakeholder relationship is critical. Data warehouses are often operated by centralized shared service teams. This means the team that produces and maintains the data does not report to the teams that use the data to operate their areas of the business. Even for the most enlightened business leaders, it is challenging to accept that something so critical to your area of the business (the data warehouse), is operated by another team.

In some ways, Analytics teams partially have themselves to blame – we have done such a great job espousing the benefits of data, but then we say you have to go through us to get it. As a result, the stakeholder relationship with the data warehouse is like a trust fall – the stakeholder needs to know the data will be there when they need it. If your data warehouse SLA is a promise, your consistent delivery on that promise will build tremendous amounts of trust.

While the data warehouse SLA should articulate your commitment to deliver exemplary data services, it should also include commitments from the stakeholder side. After all, all good relationships require both parties to participate. The stakeholder-Analytics relationship requires commitment and collaboration from both sides.

That being said, it’s important to determine the right SLA for your business. Committing to an SLA of 99.9999% uptime will require tons of careful engineering work and a rigorous on-call schedule. If you don’t actually need such a high uptime commitment, you shouldn’t have one! I will be talking more about how to find the right SLA for you in part two.

Writing your SLA

The template

The goal of writing an SLA to your internal stakeholders is not to create a detailed legal document that covers every possible situation. Instead, your SLA with your stakeholders is designed to get everyone on the same page. Issues with stakeholders are often a result of misalignment of expectations. In the spirit of formalizing the promise we are making to our stakeholders, with whom we already have a collaborative, friendly relationship, let’s write… a letter.

Here is an SLA letter template partly inspired by the elements of an SLA described by Dinesh Verma in Service Level Agreements on IP Networks. Let’s review the template here and then I will explore each section in more detail below and in part two of this post:

Dear stakeholder,

One of the core goals of the Data team is to empower you to make data driven decisions, both big and small. We are excited to see you using the data warehouse and business intelligence tool to run your area of the business, and we realize the exceptional amount of trust you have placed on us to be custodians of that data. As such, we would like to formalize our commitment to you.

The Data team promises to deliver services provided at expected performance. If there are any issues you can problem reporting and we promise to resolve the problem in response time. However, we have also established internal monitoring processes so that if there is an issue, we aim to find it first and issue communication.

To help us continue to deliver these services, we ask for your stakeholder commitment.

Sincerely,

The Data team

Stakeholders

So, who are these “stakeholders”? You probably have many stakeholders, each with different capabilities and use cases, which means different SLA requirements. Most of your stakeholder requirements will be slight variations (e.g., the same promise with different KPIs).

However, you may also have non-business area stakeholders with very specific requirements. For example, your Security & Compliance team may have concerns about PCI, PII and GDPR compliance. Alternatively, your CEO may prioritize consistent, neutral use of metrics across the business. For these stakeholders you will need a very different SLA, one that takes precedence over your other stakeholder SLAs.

In general, you will want to set clear expectations with everyone in the business who relies on your team’s services to do their jobs. The next time your service goes down, keep track of who emails or slacks you, and use that list as your starting point!

Part 2

Hopefully I have convinced you of the importance of a data warehouse SLA and you are sitting at the edge of your seat waiting for part two! In my follow up post, I explore the data warehouse SLA from the most common perspective, that of a business stakeholder. I review the remaining elements of our SLA template: services provided, expected performance, problem reporting, response time, monitoring processes, issue communication and stakeholder commitment.

  • 1
    Note: for the purposes of this post, I use the term data warehouse to refer to the data warehouse and the tools stakeholders use to access data from the data warehouse (e.g., business intelligence tools).
  • 2
    Many thanks to Rebecca Green and Dylan Sather for sharing great examples of real world data warehouse SLAs

Site Footer