Snowflake DW Architect/Lead
Listed on 2026-07-01
-
IT/Tech
Data Engineering, Data Warehousing
Snowflake DW Architect/Lead
Work Location:
Rosemead, CA
Number of Openings: 2
Duration of Hiring:
Feb - Dec 2021
No of years' experience: 10+
Skill Set:
Expertise in Snowflake – data modeling, ELT/ETL using Snowflake SQL and Talend (optional). 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
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).