Snowflake DW Architect​/Lead

Snowflake DW Architect/Lead

Work Location:

Rosemead, California

Number of Openings: 1

Duration of Hiring:
Jul - Dec 2021

No of years' experience: 10+

Skill Set:

• Expertise in Snowflake – data modeling, ELT/ETL using Snowflake SQL and Talend (optional)
• Certified in Snowflake Snow Pro Core
• Design, Develop and implement effective Analytics solutions and models with Snowflake.
• Examine and identify Data warehouse structural necessities by evaluating business requirements.
• Assess Data warehouse implementation procedures to ensure they comply with internal and external regulations.
• Prepare accurate Data warehouse design and architecture reports for management and executive teams.
• Develop Snowflake SQLs and Stored Procedures for migration of data from Oracle DB, Files and API to new solutions.
• Monitor the system performance by performing regular tests, troubleshooting and integrating new features.
• Recommend solutions to improve new and existing Data warehouse solutions.
• Educate staff members through training and individual support.
• Offer support by responding to system problems in a timely manner.
• Understand and document data flows in and between different systems/applications
• Guidance to developers in preparing functional/technical specs to define reporting requirement and ETL process.

Technical

Skills:

• Snowflake DW Architecture
• Snowflake SQL
• Data Modeling, Framework build on Ingestion, Audit, Logging and Reconciliation
• Azure Cloud
• Talend 7.3 on Cloud (Optional)
• Big Data