Snowflake - Add EU LMI to Snowflake

Snowflake - Add EU LMI to Snowflake

 

Created Date

Jul 14, 2023

Target PI

PI 5

Target Release

Jira Epic

Document Status

Draft

Epic Owner

@Oree Wyatt

Stakeholder

@Bram Velthuis @David Beauchamp @John Pernsteiner @Nathan Snider

Engineering Team(s) Involved

LMIData Deliver API team

PART 1

Customer/User Job-to-be-Done or Problem

The Scope of the user problem should be narrowed to the scope you are planning to solve in this phase of work. There may be other aspects you are aware of and plan to solve in the future. For now, put those in the Out of Scope section.

When I as a customer is looking for government LMI data in Europe and use Snowflake, I want to consume European LMI data via Snowflake, so I can integrate with my existing systems.

 

Value to Customers & Users

In the JTBD framework, these are the “pains” and “gains” your solution will address. Other ways to think about it: What’s the rationale for doing this work? Why is it a high priority problem for your customers and how will our solution add value?

Customers receive LMI data for European countries, including existing customers who are global in scope and looking to augment what we already provide to them.

Value to Lightcast

Sometimes we do things for our own benefit. List those reasons here. 
We grow our global brand and satisfy an existing request from current customers totaling over 2 million in yearly revenue. In addition this helps us maintain parity of data across our data delivery methods.

Target User Role/Client/Client Category

Who are we building this for?

Customers interested in European market data.

Delivery Mechanism

How will users receive the value?

Snowflake (data is already available via API).

Success Criteria & Metrics

How will you know you’ve completed the epic? How will you know if you’ve successfully addressed this problem? What usage goals do you have for these new features? How will you measure them?

European LMI data is in Snowflake and ready to be shared to customers.

Aspects that are out of scope (of this phase)

What is explicitly not a part of this epic? List things that have been discussed but will not be included. Things you imagine in a phase 2, etc.

 

PART 2

Solution Description

Early UX (wireframes or mockups)

<FigmaLink>

 

Non-Functional Attributes & Usage Projections

Consider performance characteristics, privacy/security implications, localization requirements, mobile requirements, accessibility requirements

 

Dependencies

Is there any work that must precede this? Feature work? Ops work? 

 

Legal and Ethical Considerations

Just answer yes or no.

Have you thought through these considerations (e.g. data privacy) and raised any potential concerns with the Legal team?

High-Level Rollout Strategies

  • Initial rollout to [internal employees|sales demos|1-2 specific beta customers|all customers]

    • If specific beta customers, will it be for a specific survey launch date or report availability date 

  • How will this guide the rollout of individual stories in the epic?

  • The rollout strategy should be discussed with CS, Marketing, and Sales.

  • How long we would tolerate having a “partial rollout” -- rolled out to some customers but not all

 

Risks

Focus on risks unique to this feature, not overall delivery/execution risks. 

 

Open Questions

What are you still looking to resolve?

 


Complete with Engineering Teams

 

Effort Size Estimate

Estimated Costs

Direct Financial Costs

Are there direct costs that this feature entails? Dataset acquisition, server purchasing, software licenses, etc.?

 

Team Effort

Each team involved should give a general t-shirt size estimate of their work involved. As the epic proceeds, they can add a link to the Jira epic/issue associated with their portion of this work.

Team

Effort Estimate (T-shirt sizes)

Jira Link

Team

Effort Estimate (T-shirt sizes)

Jira Link