*** TEKsystems' client is searching for someone who can be long term (CTH). If someone happens to have a perfect experience and isn't interested/able to go permanent without sponsorship, then the client is open to a 2 year contract *** Top Skills Details Snowflake, Data warehouse, modeling, leadership Description Our client is seeking a snowflake lead to join their team. The enterprise (Canada-based) has began the journey to Snowflake, however the US Based teams have not yet started that migration. They are going to begin migrating (from several disperse systems) to Snowflake in 2025. The team is looking for a Lead Snowflake Engineer, someone who can educate others on Snowflake and lead a team of engineers. The organization is still maturing their data domains and are starting 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 the lead will partner closely with. Must have: + Strong understanding of Cloud Data Lakehouse architectural pattern + Hands on experience on Cloud Data Lakehouse implementation including: + Experience with Snowflake troubleshooting and performance tuning + Strong understanding of the underlying Snowflake technology around data storage, security and infrastructure + Experience in leading, mentoring, and providing technical direction to a team of Data Engineers + Proven experience working with business resource in developing data domain + Experience with Financial Industry domain is a plus Additional Skills & Qualifications + Need data modeling, data quality, data management experience, strong snowflake experience + Experience with domain based consumption assets (modeling). The organization currently consumes app data without cleansing it/modeling it. + Python + ETL experience (may end up using informatica cloud). Need to understand batch and real time pipelines, data consumption, etc. + Need to understand data warehousing and data management. + Prior leadership experience, doesn’t need to be by title, but need to have experience leading a team of engineers + Familiar with Data engineering principles, toolsets and best practices + Strong proficiency in SQL and experience developing complex queries and stored procedure + Automation/scripting experience + Proven experience with Snowflake (3-5 years) + Understanding of Snowflake roles and user security + Familiarity with Snowflake features such as SnowSQL, Snowpipe, Streams, and Tasks + Experience designing solution leveraging Snowflake native capabilities + Hands-on experience with ingestion and transformation + Experience with cloud platforms such as AWS and Azure + Knowledge on one or more skills in the flowing list which include + Coding Languages, + Relational & Non-relational databases, + ETL (Extract, Transform & Load) systems/tools, + Data storage (On-prem, Cloud), + Machine Learning, + Big data tools + Cloud computing , + Data Security, + Data Modeling and Data Visualization Experience Level Expert Level Pay and Benefits The pay range for this position is $85.00 - $100.00/hr. Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: • Medical, dental & vision • Critical Illness, Accident, and Hospital • 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available • Life Insurance (Voluntary Life & AD&D for the employee and dependents) • Short and long-term disability • Health Spending Account (HSA) • Transportation benefits • Employee Assistance Program • Time Off/Leave (PTO, Vacation or Sick Leave) Workplace Type This is a hybrid position in Minneapolis,MN. Application Deadline This position is anticipated to close on Sep 8, 2025. h4>About TEKsystems: We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company. The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law. About TEKsystems and TEKsystems Global Services We’re a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We’re a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We’re strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We’re building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com. The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.