Snowflake Engineer Lead/Architect

Dice is the leading career destination for tech experts at every stage of their careers. Our client, eGrove Systems Corporation, is seeking the following. Apply via Dice today! Looking for Snowflake Engineer Lead/Architect Must be able to go Onsite 3 Days/Week in Minneapolis, Minnesota Must be able to go for the F2F Interview in the same city. Job Description - < style="box-sizing: border-box; margin: 1.5rem 0px 1rem; font-family: 'Helvetica Neue'; font-weight: bold; color: #333333; font-size: 13px; margin-block-start: 1.33em;">Please read the job description and please pay attention to the bolded red . This is an onsite interview, so your candidates have to be local . Also, you make sure they candidates are sending the correct e-mail and not just a work related e-mail. Send me your Top candidate 2 and if they do not have all of the red do not send. They will all have to take a Flow Career Test so send testing availability for Tuesday , Wednesday or Thursday. Also must have Linkedin with photo, personal email & write up!< style="box-sizing: border-box; margin: 1.5rem 0px 1rem; font-family: 'Helvetica Neue'; font-weight: bold; color: #333333; font-size: 13px; margin-block-start: 1.33em;"> < style="box-sizing: border-box; margin: 1.5rem 0px 1rem; font-family: 'Helvetica Neue'; font-weight: bold; color: #333333; font-size: 13px; margin-block-start: 1.33em;">Additional Job Information:< style="box-sizing: border-box; margin: 1.5rem 0px 1rem; font-family: 'Helvetica Neue'; font-weight: bold; color: #333333; font-size: 13px; margin-block-start: 1.33em;">Title: Developer - CTH Snowflake Engineer Lead/Architect Company: RBC Start Date: 06/05/2025 # of Openings: 1 Position Type: contract to hirer Location: Minnesota Onsite Flexibility: Hybrid 3 days a week in the office < style="box-sizing: border-box; margin: 1.5rem 0px 1rem; font-family: 'Helvetica Neue'; font-weight: bold; color: #333333; font-size: 13px; margin-block-start: 1.5rem 0px 1rem; font-family: 'Helvetica Neue'; font-weight: bold; color: #333333; font-size: 13px; margin-block-start: 1.33em;"> < style="box-sizing: border-box; margin: 1.5rem 0px 1rem; font-family: 'Helvetica Neue'; font-weight: bold; color: #333333; font-size: 13px; margin-block-start: 1.33em;">Legal First Name: < style="box-sizing: border-box; margin: 1.5rem 0px 1rem; font-family: 'Helvetica Neue'; font-weight: bold; color: #333333; font-size: 13px; margin-block-start: 1.33em;">Legal Last Name: < style="box-sizing: border-box; margin: 1.5rem 0px 1rem; font-family: 'Helvetica Neue'; font-weight: bold; color: #333333; font-size: 13px; margin-block-start: 1.33em;">Available Date: < style="box-sizing: border-box; margin: 1.5rem 0px 1rem; font-family: 'Helvetica Neue'; font-weight: bold; color: #333333; font-size: 13px; margin-block-start: 1.33em;"> < style="box-sizing: border-box; margin: 1.5rem 0px 1rem; font-family: 'Helvetica Neue'; font-weight: bold; color: #333333; font-size: 13px; margin-block-start: 1.33em;">Submittal Comments: Please do not forget to send • < style="box-sizing: border-box; margin: 0px 0px 1rem; font-weight: bold; font-size: 1em; margin-block-start: 1.33em;">Middle Initial: • < style="box-sizing: border-box; margin: 0px 0px 1rem; font-weight: bold; font-size: 1em; margin-block-start: 1.33em;">Date of Birth (mmddyr): • < style="box-sizing: border-box; margin: 0px 0px 1rem; font-weight: bold; font-size: 1em; margin-block-start: 1.33em;">SSN (last 4): • < style="box-sizing: border-box; margin: 0px 0px 1rem; font-weight: bold; font-size: 1em; margin-block-start: 1.33em;">Gender: < style="box-sizing: border-box; margin: 1.5rem 0px 1rem; font-family: 'Helvetica Neue'; font-weight: bold; color: #333333; font-size: 13px; margin-block-start: 1.33em;"> < style="box-sizing: border-box; margin: 1.5rem 0px 1rem; font-family: 'Helvetica Neue'; font-weight: bold; color: #333333; font-size: 13px; margin-block-start: 1.33em;">Qualifications:< style="box-sizing: border-box; margin: 1.5rem 0px 1rem; font-family: 'Helvetica Neue'; font-weight: bold; color: #333333; font-size: 13px; margin-block-start: 1.33em;"> < style="box-sizing: border-box; margin: 1.5rem 0px 1rem; font-family: 'Helvetica Neue'; font-weight: bold; color: #333333; font-size: 13px; margin-block-start: 1.33em;"> < style="box-sizing: border-box; margin: 1.5rem 0px 1rem; font-family: 'Helvetica Neue'; font-weight: bold; color: #333333; font-size: 13px; margin-block-start: 1.33em;"> Client: RBC Wealth Management Location: Minneapolis, MN Hybrid (3 days/week onsite) Type: Contract-to-Hire Overview: Job Title: Lead Snowflake Data Engineer / Architect Location: Minneapolis, MN (Hybrid 3 days/week onsite) Type: Contract-to-Hire (6 12 months with likely extensions) Client: RBC (Wealth Management division)< style="box-sizing: border-box; margin: 1.5rem 0px 1rem; font-family: 'Helvetica Neue'; font-weight: bold; color: #333333; font-size: 13px; margin-block-start: 1.33em;"> < style="box-sizing: border-box; margin: 1.5rem 0px 1rem; font-family: 'Helvetica Neue'; font-weight: bold; color: #333333; font-size: 13px; margin-block-start: 1.33em;"> • • Overview:< style="box-sizing: border-box; margin: 1.5rem 0px 1rem; font-family: 'Helvetica Neue'; font-weight: bold; color: #333333; font-size: 13px; margin-block-start: 1.33em;">RBC is seeking a hands-on Lead Data Engineer/Architect • • to join our Snowflake engineering team. This role will lead enterprise-scale data architecture and engineering initiatives in a hybrid Snowflake and cloud environment (AWS). You ll help shape our long-term data strategy while mentoring engineers and ensuring scalable, high-quality data solutions.< style="box-sizing: border-box; margin: 1.5rem 0px 1rem; font-family: 'Helvetica Neue'; font-weight: bold; color: #333333; font-size: 13px; margin-block-start: 1.33em;"> < style="box-sizing: border-box; margin: 1.5rem 0px 1rem; font-family: 'Helvetica Neue'; font-weight: bold; color: #333333; font-size: 13px; margin-block-start: 1.33em;">Key Responsibilities: • < style="box-sizing: border-box; margin: 0px 0px 1rem; font-weight: bold; font-size: 1em; margin-block-start: 1.33em;">Serve as technical lead for multiple Snowflake-based data initiatives • < style="box-sizing: border-box; margin: 0px 0px 1rem; font-weight: bold; font-size: 1em; margin-block-start: 1.33em;">Architect and build scalable, high-performance Snowflake data pipelines and solutions • < style="box-sizing: border-box; margin: 0px 0px 1rem; font-weight: bold; font-size: 1em; margin-block-start: 1.33em;">Convert conceptual and logical data models into robust physical implementations • < style="box-sizing: border-box; margin: 0px 0px 1rem; font-weight: bold; font-size: 1em; margin-block-start: 1.33em;">Guide and mentor a team of Snowflake and ETL engineers • < style="box-sizing: border-box; margin: 0px 0px 1rem; font-weight: bold; font-size: 1em; margin-block-start: 1.33em;">Collaborate closely with Product Owners, Domain Architects, QA, and business stakeholders • < style="box-sizing: border-box; margin: 0px 0px 1rem; font-weight: bold; font-size: 1em; margin-block-start: 1.33em;">Create and maintain source-to-target mappings, and ensure data integrity across systems • < style="box-sizing: border-box; margin: 0px 0px 1rem; font-weight: bold; font-size: 1em; margin-block-start: 1.33em;">Optimize pipeline performance and ensure solutions meet non-functional requirements • < style="box-sizing: border-box; margin: 0px 0px 1rem; font-weight: bold; font-size: 1em; margin-block-start: 1.33em;">Support Agile delivery practices across teams and projects < style="box-sizing: border-box; margin: 1.5rem 0px 1rem; font-family: 'Helvetica Neue'; font-weight: bold; color: #333333; font-size: 13px; margin-block-start: 1.33em;"> < style="box-sizing: border-box; margin: 1.5rem 0px 1rem; font-family: 'Helvetica Neue'; font-weight: bold; color: #333333; font-size: 13px; margin-block-start: 1.33em;">Tech Stack: • < style="box-sizing: border-box; margin: 0px 0px 1rem; font-weight: bold; font-size: 1em; margin-block-start: 1.33em;">Must-Have: Snowflake, AWS, SQL, Snowpipe/Ingestion pipelines • < style="box-sizing: border-box; margin: 0px 0px 1rem; font-weight: bold; font-size: 1em; margin-block-start: 1.33em;">ETL: Informatica, DataStage, or similar tools • < style="box-sizing: border-box; margin: 0px 0px 1rem; font-weight: bold; font-size: 1em; margin-block-start: 1.33em;">Bonus: Databricks, Python, Oracle, Azure, ERwin, PowerDesigner < style="box-sizing: border-box; margin: 1.5rem 0px 1rem; font-family: 'Helvetica Neue'; font-weight: bold; color: #333333; font-size: 13px; margin-block-start: 1.33em;"> < style="box-sizing: border-box; margin: 1.5rem 0px 1rem; font-family: 'Helvetica Neue'; font-weight: bold; color: #333333; font-size: 13px; margin-block-start: 1.33em;">Required Qualifications: • < style="box-sizing: border-box; margin: 0px 0px 1rem; font-weight: bold; font-size: 1em; margin-block-start: 1.33em;">12 20 years of IT experience with a strong focus on data engineering and architecture • < style="box-sizing: border-box; margin: 0px 0px 1rem; font-weight: bold; font-size: 1em; margin-block-start: 1.33em;">7+ years of experience building enterprise data solutions and warehouses • < style="box-sizing: border-box; margin: 0px 0px 1rem; font-weight: bold; font-size: 1em; margin-block-start: 1.33em;">Expertise in Snowflake architecture, implementation, and pipeline optimization • < style="box-sizing: border-box; margin: 0px 0px 1rem; font-weight: bold; font-size: 1em; margin-block-start: 1.33em;">Strong data modeling (3NF, dimensional), SQL, and DDL scripting skills • < style="box-sizing: border-box; margin: 0px 0px 1rem; font-weight: bold; font-size: 1em; margin-block-start: 1.33em;">Experience with ingestion frameworks, data quality, and governance • < style="box-sizing: border-box; margin: 0px 0px 1rem; font-weight: bold; font-size: 1em; margin-block-start: 1.33em;">Proven leadership experience with the ability to lead and mentor technical teams • < style="box-sizing: border-box; margin: 0px 0px 1rem; font-weight: bold; font-size: 1em; margin-block-start: 1.33em;">Excellent communication and collaboration skills across technical and business groups • Financial services experience (especially in data warehousing) • Experience with Agile/SAFe methodologies • Familiarity with data cataloging tools (e.g., Informatica EDC) and governance frameworks • Certifications: CDMP, CBIP, Snowflake, AWS, or equivalent