Snowflake Data Engineer

Snowflake Data Engineer

Hybrid Minneapolis, MN

6mo Contract to Hire

Description

RBC is seeking a snowflake engineer to join their team. The enterprise (Canada) has began the journey to Snowflake, and now the US teams are beginning their migration. They are migrating from several disperse systems to Snowflake/ The team is looking for a Sr. Snowflake Engineer, someone who can educate others on Snowflake and help support the migration long with the Snowflake Lead on the team. The organization is still maturing their data domains and are beginning the journey of migrating to snowflake, and this person will be a go-to from a technical perspective. There is also a Snowflake architect on this team who this person will partner closely with.

We are seeking a highly skilled Snowflake Engineer to join our team. management, with a strong focus on Snowflake. This role requires a deep understanding of domain-based consumption assets and the ability to work with unmodeled app data.

Responsibilities:
Develop and maintain data models, ensuring data quality and effective data management.
Utilize Snowflake for data warehousing and management.
Implement ETL processes, potentially using Informatica Cloud, and understand both batch and real-time pipelines.
Lead a team of engineers, providing guidance and support.
Work on an ingestion platform, focusing on data quality and management using IDMC (Informatica Data Management Cloud).
Implement CI/CD processes with Snowflake, using tools like GitHub, Jenkins, and Helious.
Build data products for business consumers, focusing on both ingestion and consumption.
Answer technical interview questions such as the differences between materialized views and dynamic tables in Snowflake.

Top Skills Details

1. Senior level data engineer with 5yrs experience supporting a Snowflake migration effort
2. Strong ETL, data modeling and data management experience
3. Proven ability to lead and mentor jr. and mid level engineers