shutterstock_249029374.jpg

HASHMAP SOLUTION PROFILE

US HEALTHCARE WORKFORCE SOLUTIONS

Collaborating to Develop and Deliver a Sustainable and

Cost Effective Cloud Data Platform for Reporting and Analytics

CHALLENGE

  • Accelerating a modern approach to data and analytics in the cloud and modernization of existing on premise data pipelines and analytics products with limited internal resources

  • Determining best fit solution tools and technologies for both short term wins and long term sustainability

  • Budget and time constraints that require a collaborative approach and customer-inclusive approach across design, architecture, and development 

OUTCOME

  • A quick, budget-friendly, 3 week collaborative effort that provided the client with a jump start that “would have taken months doing it on their own” 

  • A modern and cost-effective data pipelines, compute, storage, and data consumption solution

  • Knowledge transfer across multiple dimensions including design, architecture, automation, pros and cons of approaches and alternatives, and environment sustainability

APPROACH

  • Co-design and co-development of a comprehensive data and cloud solution including:

    • Snowflake - optimized design, security, cost reporting, performance/cost, AD integration, and BI integration

    • dbt - transformations, snapshots, updates, data quality testing, data cleansing, versioning

    • Azure DevOps - CI pipeline to test environment and Prod release pipeline

  • Re-use of Hashmap templates and patterns for the following:

    • Data acquisition from REST API sources

    • Data acquisition for semi-structured datasets (CSV, JSON) using Snowpipe for continuous ingestion

    • Transformation processes in dbt when source DDL changes

SOLUTION

  • Snowflake

  • dbt

  • Stitch

  • Azure DevOps

  • PowerBI

  • Hashmap Consulting Services including data and analytics modernization, data and cloud design, architecture, and engineering, and cloud automation

Connect Now >