Engineer Inspecting Gas Line_edited.jpg

HASHMAP SOLUTION PROFILE

FORTUNE 100 ENERGY COMPANY

Accelerating Digital Marketing Campaigns with Snowflake

CHALLENGE
  • Measuring the effectiveness of marketing campaigns by collecting participation data from key partners and sales records from retailers

  • Adapting campaigns by consumer

  • Curating information around unique consumer by assessing participation

  • Verifying accuracy of data

OUTCOME
  • Enabled an in-depth understanding of consumers

  • Identified consumers by their phone number and curated data model to account for data source reliability

  • Built end-to-end data pipelines & detailed mappings adaptable to various data sources and changes in business logic

  • Enabled rapid dashboard development by building on top of new curated data sets

APPROACH
  • Discover - Coordinated detailed discussions with key parties involved in marketing campaigns to iron out a data integration approach

  • Design - Created implementation blueprints for end-to-end pipelines and detailed mappings for each stage of the pipeline from data source to final curation

  • Develop - Engineered and architected data pipelines for multiple use cases to enable rapid dashboard development per specifications provided by the business

  • Deliver - Tested all data pipelines from end-to-end to ensure data loading and validation of curated data sources prior to loading

SOLUTION
  • Snowflake

  • Tableau

  • Azure

  • Azure Data Factory

  • Azure Functions

  • Azure DevOps

  • Hashmap Consulting Services: 

    • Snowflake and Azure Cloud Data Strategy & Advisory

    • Snowflake and Azure Cloud Data Design, Engineering, & Architecture

    • Snowflake and Azure Optimization & Management