Knowledge, Skills, and Abilities:
Proficiency in WhereScape RED for data warehouse automation, including designing, building, and managing data warehouses
Expertise in Snowflake's cloud data platform, including data loading, transformation, and querying using Snowflake SQL.
Experience with SQL-based development, optimization, and tuning for large-scale data processing.
Strong understanding of dimensional modelling concepts and experience in designing and implementing data models for analytics and reporting purposes.
Ability to optimize data pipelines and queries for performance and scalability.
Familiarity with Snowflake's features such as virtual warehouses, data sharing, and data governance capabilities.
Knowledge of WhereScape scripting language (WSL) for customizing and extending automation processes.
Experience with data integration tools and techniques to ingest data from various sources into Snowflake.
Understanding of data governance principles and experience implementing data governance frameworks within Snowflake.
Ability to implement data quality checks and ensure data integrity within the data warehouse environment.
Strong SQL skills for data manipulation, optimization, and performance tuning.
Experience with data visualization tools such as Power BI