Snowflake Technical Lead / Architect

Our client has an opportunity for a Senior Snowflake Technical Lead / Architect to serve as the technical authority for Snowflake platform strategy, architecture, governance, AI enablement, and large-scale data initiatives. The role combines hands-on engineering with architectural leadership to support enterprise data ecosystems at scale, mentor developers, and drive platform best practices., * Design, develop, and optimize complex Snowflake solutions.

• Lead Snowflake platform architecture, governance, security, and AI adoption initiatives.
• Architect large-scale data ingestion and integration solutions across internal and external systems.
• Design and maintain data lakes, data warehouses, and scalable enterprise data models.
• Ensure compliance with PII, GDPR, PIPL, and CCPA requirements.
• Develop platform analytics, performance analytics, and executive reporting capabilities.
• Leverage Snowflake Intelligence, Cortex AI, Streamlit, and emerging Snowflake technologies.
• Define technical standards, reference architectures, and engineering best practices.
• Partner with Product, Security, Architecture, and Operations teams to deliver strategic solutions.
• Mentor engineers through design reviews, code reviews, and technical leadership.
• Drive troubleshooting, root cause analysis, performance optimization, and platform reliability efforts.

Due to client requirements, applicants must be willing and able to work on a w2 basis. For our w2 consultants, we offer a great benefits package that includes Medical, Dental, and Vision benefits, 401k with company matching, and life insurance., * 7+ years of software engineering experience.

• 3-5+ years of hands-on Snowflake development and architecture experience.
• Proficiency with Snowflake, SQL, JavaScript, Snowflake Scripting, Snowpark, Snowpipe, and Python.
• Experience building and maintaining CI/CD pipelines.
• Expertise in Data Warehousing and Medallion Data Lake architectures.
• Experience with data governance, security, disaster recovery, and monitoring.
• Experience with REST APIs, web services, and event-driven integrations.
• Experience in Agile environments and large enterprise organizations.
• Snowflake certifications such as SnowPro Core and SnowPro Advanced Data Engineer preferred.
• Nice to have: Databricks, Azure Synapse, additional SnowPro certifications, platform analytics and cost optimization, C#/.NET, and experience with very large-scale datasets.

Skills, experience, and other compensable factors will be considered when determining pay rate. The pay range provided in this posting reflects a W2 hourly rate; other employment options may be available that may result in pay outside of the provided range.

W2 employees of Eliassen Group who are regularly scheduled to work 30 or more hours per week are eligible for the following benefits: medical (choice of 3 plans), dental, vision, pre-tax accounts, other voluntary benefits including life and disability insurance, 401(k) with match, and sick time if required by law in the worked-in state/locality. If anyone reaches out to you about an open position connected with Eliassen Group, please ensure that you are working directly with us by confirming the following:

When you work with Eliassen Group, all email communication will come from an Eliassen.com address, never Gmail, Yahoo, etc.

Eliassen Group is a strategic consulting firm that helps organizations reach further and achieve more through our technology, business advisory, and life sciences solutions. For nearly 40 years, we have combined exceptional people, deep domain expertise, and intelligent capabilities to expand our clients’ capacity and accelerate meaningful outcomes. We are driven by a purpose to positively impact the lives of our employees, clients, consultants, and the communities we serve.