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