Overview
Skills
Job Details
Snowflake Consultant
WA/Redmond - Hybrid at least 2 days at client
Custom Skill Requirements
Snowflake
Sql
Python
AWS
Matillion
1. Design, build, and optimize data warehouses, data models, and efficient SQL queries within Snowflake.
- Develop and maintain ETL (Extract, Transform, Load) or ELT (Extract, Load, Transform) pipelines to ingest, transform, and load data into Snowflake
- Bringing the data from treasure data/Hi-touch to snowflake
- Data reconciliation using snowflake
- Pushing the data to GBQ using snowflake/Matillion
- Sending the data to sales force marketing cloud using snowflake/Matillion
Process Flows
-Mentor and Knowledge transfer to client project team members
-Participate as primary, co and/or contributing author on any and all project deliverables associated with their assigned areas of responsibility
-Participate in data conversion and data maintenance
-Provide best practice and industry specific solutions
-Advise on and provide alternative (out of the box) solutions
-Provide thought leadership as well as hands on technical configuration/development as needed.
-Participate as a team member of the team
-Perform other duties as assigned.