Build and Maintain Cloud Data Warehouse for an Edu-tech Company

Build and maintain cloud data warehouse system. Worked with functional teams to gather & define business needs and translate to technical requirements. Identifying business needs, designing and developing solutions for meeting those needs.

Solution

• Maintained a single destination by migrating all the tables and views from legacy SQL Server to Snowflake and updated the tableau dashboards to migrate the data sources to Snowflake
• Centralized data into destination by creating Fivetran connectors to extract the data from multiple sources and load the data to Snowflake
• Simplified the data testing and validations using DBT. Created DBT models to transform the data within the data warehouse and produce trusted data sets for reporting
• Worked with functional teams to gather requirements and developed tableau reports
• Examined existing process and suggested improvements, new releases, testing, and implementation of production enhancements, and upgrades