Job Title: Snowflake Consultant
Location: Redmond WA - Hybrid
Duration: 6 Months Contract
Skills:
Snowflake Sql Python AWS Matillion
Job description:
- 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/Hitouch 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.