
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
-