Location
: Must be local to the Seattle, Washington area
Duration:
3 months to start
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/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
Pre-Defined Deliverables:
- 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.
