Snowflake DW Architect/Lead
Apply NowCompany: Clifyx
Location: Rosemead, CA 91770
Description:
Job Title Snowflake DW Architect/Lead
Number of Openings 1
Duration of Hiring Jan - Jun 2022
No of years' experience 10+
Detailed job description - Skill Set: Expertise in Snowflake - data modeling, ELT/ETL using Snowflake SQL and Talend (optional)
Certified in Snowflake SnowPro Core
Design, Develop and implement effective Analytics solutions and models with Snowflake.
Examine and identify Datawarehouse structural necessities by evaluating business requirements.
ssess 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
Vendor Billing range $80/hour
Work Location Rosemead, California
Number of Openings 1
Duration of Hiring Jan - Jun 2022
No of years' experience 10+
Detailed job description - Skill Set: Expertise in Snowflake - data modeling, ELT/ETL using Snowflake SQL and Talend (optional)
Certified in Snowflake SnowPro Core
Design, Develop and implement effective Analytics solutions and models with Snowflake.
Examine and identify Datawarehouse structural necessities by evaluating business requirements.
ssess 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
Vendor Billing range $80/hour
Work Location Rosemead, California