Snowflake Consultant

• 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

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