CAREER
    CONTACT US
    Avatar_Color
    Back to achievements

    Snowflake migration

    • Practice
    Data Platform Data Management Data Architecture
    • Team

    1 Project manager, 1 Scrum Master, 1 BI Architect​ 1 DevOps Tech Lead Developer, 1 BI Analyst​

    • Technical environment
    1
    analytic platform
    X8
    speed execution
    +1 000 000
    queries per day
    CHALLENGES
      • Integration of Data from an Old Source System: Integrate data from an outdated source system (AIMS). It required several transformations using Python functions to format the data in a way that could be interpreted by modern storage tools.​

      ​

      • Adoption of DevOps: Another significant challenge was assisting the client in developing competency in DevOps culture and the continuous integration/continuous deployment (CI/CD) practice.​
    SOLUTION
    • Analytic Platform Modernization: Establishment of an elastic and flexible environment through the migration from on-premises to a cloud analytic platform.

     

    • The SqlServer data base is transferred to Snowflake using Fivetran, and all excel transformations are ported to DBT​

     

    • Support and Training: Assistance in the adoption of the new solution by the teams, especially for the integration of new data sources.
    BENEFITS
    • Tangible Project Outcomes: This initiative laid the foundation according to best practices for future BI projects, enabling them to autonomously integrate new data sources.​
    • Impact on the Enterprise or Client: By demonstrating the feasibility and benefits of a cloud analytic platform through an MVP, the project met its initial objectives​