Snowflake DW Senior Architect

Snowflake DW Senior Architect

Number of Openings: 1

Duration of Hiring: Sep 2021 – Mar 2022

No of years' experience: 10+

Detailed job description:

Skill Set:

• Expertise in Snowflake Architecture – data modeling, ELT/ETL using Snowflake SQL and Talend (optional)
• Certified in Snowflake SnowPro Core
• Design, Architecture and implement effective Analytics solutions and models with Snowflake.
• Examine and identify Datawarehouse structural necessities by evaluating business requirements.
• Assess Datawarehouse implementation procedures to ensure they comply with internal and external regulations.
• Prepare accurate Datawarehouse 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 Datawarehouse 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

Work Location: Rosemead, California