Overview
Remote
Depends on Experience
Contract - W2
Contract - Independent
Contract - 12 Month(s)
Skills
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.
Job Details
WhereScape RED automation tools and the ability to design and implement fully operational solutions on Snowflake Data Warehouse. Additionally, the ideal candidate will have a strong background in delivering enterprise data warehouses, data lakes, with experience in designing and engineering end-to-end data analytics solutions. The duration of the engagement is about 12 months. This is a remote position; however, they may have to travel on site or to other courts or conferences on rare occasions.
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 modeling 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.