Database Administrator - WhereScape RED / Snowflake

Job Type: Contract (Approximately 12 months)
Work Setup: Remote (Local candidates preferred; occasional onsite visits or travel to other courts or conferences may be required)

Job Description

We are seeking a highly skilled and experienced Senior Database Administrator to join our team. The candidate should have demonstrated skills with WhereScape RED automation tools and the ability to design and implement fully operational solutions on Snowflake Data Warehouse.

The ideal candidate will have a strong background in delivering enterprise data warehouses and data lakes, with experience in designing and engineering end-to-end data analytics solutions.

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 designing and implementing data models for analytics and reporting purposes.
• Ability to optimize data pipelines and queries for performance and scalability.
• Familiarity with Snowflake 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.

Duration: Approximately 12 months
Location Preference: Local candidates preferred

Additional Detail:

• Candidate must be a US Citizen or Green Card holder only

Job Types: Full-time, Contract

Pay: $60.00 - $88.00 per hour

Ability to Commute:

• California (Preferred)

Work Location: Remote