HASHMAP SOLUTION PROFILE

WORLDWIDE MANUFACTURING & BUILDING MATERIALS COMPANY

Deploying AWS Cloud Infrastructure & Eliminating Data Silos with Snowflake & Matillion

CHALLENGE
  • Ensure proper design, architecture, and setup of AWS cloud infrastructure for next generation BI services and cloud modernization/migration

  • Eliminate data silos across the organization to provide better reporting visibility

  • Establish a path for migrating an on-premise data warehouse to cloud

OUTCOME
  • Built out fully operational AWS infrastructure and services to support a modern data and analytics stack

  • Stood up Snowflake, ironing out data needs, roles, warehouse, BI, and ELT connectivity 

  • Integrated Matillion with source systems for complete connectivity to move data up into Snowflake

  • Designed the solution for ELT pipelines for data ingestion 

  • Provided best practices around Snowflake & Matillion

  • Installed cloud formation templates

APPROACH
  • Discover - Worked with key stakeholders and business users to align AWS infrastructure with business outcomes

  • Design - Set up AWS Network & Management Services, Compute & Analytical Services, Security Services, AWS Organizations, Dev & DevOps Services

  • Develop - Provided cloud formation templates for Matillion Installation, Tableau Installation, and other AWS services

  • Deliver - Deployed AWS infrastructure, provided CI/CD for IaC code, provided detailed documentation around AWS infrastructure, Snowflake, & Matillion

SOLUTION
  • AWS (Multi-account landscape, single-sign on, permission sets, VPCs, Security, Route53, Transit Gateway, application firewalls, etc.

  • Snowflake Cloud Data Platform & private link 

  • Matillion 

  • Tableau 

  • Hashmap Consulting Services 

    • Cloud Data Strategy & Advisory

    • Cloud Data Design, Engineering, & Architecture

    • Optimization & Management

    • Infrastructure Setup & Deployment