HASHMAP SOLUTION PROFILE

NORTH AMERICAN UTILITY & ENVIRONMENTAL SERVICES COMPANY

Delivering a modern solution for analytics and reporting in the cloud to accelerate data product delivery and optimize overall cost

CHALLENGE
  • Design, architect, and deploy a cloud-based solution for data and analytics applications that will accelerate an ability to:

    • Deliver data products much faster and more seamless

    • Provide a lower total cost of ownership

    • Allow for continuous creation of data as a central asset across the enterprise from a wide variety of data sources

  • Enhance analytics and modeling capabilities and leverage best practice approaches for scale and delivery speed while not reinventing the wheel

  • Reliably and efficiently migrate and convert from an on-premise Netezza platform 

OUTCOME
  • Designed and delivered sustainable data pipelines and established data modernization approaches for on-prem data sources (both migration and CDC) to Snowflake including Netezza, Oracle, and SQLServer

  • Designed and delivered sustainable data pipelines and established data modernization approaches for cloud data sources to Snowflake including Salesforce, Salesforce Marketing Cloud, Google Analytics, Bing, and Adobe Analytics

  • Defined and deployed frameworks and techniques for data modeling and cloud security, as well cost monitoring and consumption visibility to ensure that dollars spent are delivering value

  • Deployed a self-service data experience for analytics to produce more insights at a faster velocity

APPROACH
  • Discover – Business alignment, understanding, requirements definition, and engaging with users, key stakeholders, and developers and engineers

  • Design – Approaches, pros, cons, with a foundation of clean, high quality patterns, practices, and technology choices that are defined by the use cases and the users across data acquisition, data persistence, data transformation, and data consumption and visualization

  • Develop – Implementation of a set of use cases to validate data flows, tech choices, and patterns for both on-prem data sources and cloud data sources

  • Deliver – Patterns established and use cases are executed and documented for the cloud data platform and data pipelines

SOLUTION
  • Snowflake

  • AWS

  • Matillion

  • Attunity

  • dbt

  • Control-M

  • Tableau

  • Hashmap Data & Cloud Consulting Services including

    • Strategy & Advisory

    • Solution Design Architecture & Engineering

    • Cloud and Data Modernization and Migration Enablement

    • Cloud Optimization and Management

HashmapLogoBlack_edited.png
  • Hashmap on LinkedIn
  • Tweet Hashmap
  • Hashmap on Facebook
  • Hashmap Stories
  • Data Rebels on Tap on Spotify
  • Hashmap on YouTube
  • Hashmap on Instagram

© 2020 by Hashmap, Inc.