Description

You will design and maintain analytical data warehouses using Snowflake and AWS architecture.

Responsibilities

• Develop ETL pipelines using Python and Snowflake SQL to manage data movement.
• Build and manage SQL and PL/SQL procedures for complex data integration tasks.
• Create Unix shell scripts to handle data extraction and loading processes.
• Implement slowly changing dimensions and various fact table types using SQL-based processes.
• Perform SQL performance tuning, root cause analysis, and technical issue resolution.

Required Skills

• 8+ years of experience in Data Management with a focus on analytical data warehousing.
• 3+ years of hands-on experience with Snowflake Cloud Warehouse features.
• Proficiency in SQL and PL/SQL for data integration and procedure development.
• Experience developing ETL pipelines with Python and Snowflake SQL.
• Strong knowledge of AWS cloud architecture and services.
• Experience with Unix shell scripting for ETL processes.
• Understanding of logical and physical data models for BI and analytics.
• Experience with data profiling, validation, cleansing, and masking.
• Experience working in Agile environments using Jira for documentation.

Preferred Skills

• Bachelor's degree in Computer Science.

Key Skills

Education

Bachelor's degree in Computer Science