shutterstock_1701979699.jpg

HASHMAP SOLUTION PROFILE

US INSTITUTIONAL INVESTMENT MANAGEMENT

Deploying a Modern Data Stack with Modern Software Practices and DevOps in the Cloud

CHALLENGE
  • Accelerate the development of key data models through the use of Fivetran, dbt, Snowflake, and Azure DevOps.

  • Limited hands-on experience with the cloud and the data engineering toolset and architectural approach.

  • Sustainable and repeatable data ingestion, transformation, and data product and cloud automation along with the development of key data models.

  • Limited knowledge in best practices, understanding of approaches, patterns, and solution options.

OUTCOME
  • Designed, architected, and delivered a collaborative solution that enables delivering of key data models for clients and partners to develop insights for financial portfolio management

  • Provided an elastic, scalable solution including data collection and acquisition with error handling, data models and comprehensive transformations in dbt, data persistence in Snowflake, and a variety of data consumption options

  • Delivered automated processing in Azure DevOps, designed and delivered a secure architecture in Snowflake with visibility into users, roles, and objects, and provided documentation and collaborative knowledge training and skills transfer on both Snowflake and dbt
     

APPROACH
  • Create a modern data stack solution supporting current and future advanced analytics workloads and a variety of client and partner requirements

  • Collaborative solution development through the use of Hashmap’s extensive domain experience in cloud data platforms, cloud data engineering, and software development combined with ready to use templates and best practices in Azure

  • Agile development with the client’s partner providing input on file ingestion format required, the client developing processes for file copying and exporting and results output, and Hashmap focused on data acquisition and ingestion pipelines and transformation using dbt in Snowflake along with cloud automation
     

SOLUTION
  • Snowflake in Azure

  • dbt

  • Azure Blob Storage

  • Microsoft .NET Adapter

  • SQL Server

  • Hashmap Consulting Services including strategy, design, and architecture, data engineering, data pipelining, data integration, and cloud automation

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.