Snowflake Architect

Overview

On Site
Depends on Experience
Contract - Independent
Contract - W2
Contract - 12 Month(s)

Skills

Snowflake
Oracle DBA

Job Details

Job Title: Snowflake Architect

Location: Chicago, IL (Onsite)

Project Duration: 12+ months Contract to Hire/Full Time

Only W2 Contracts

Job Summary:

We are seeking a highly skilled Snowflake Architect with proven experience in the insurance domain to lead our data architecture and cloud transformation initiatives. The ideal candidate will have deep expertise in Snowflake Data Cloud, cloud data warehousing, data modeling, and ETL/ELT architecture. The role requires working onsite in Chicago, IL, collaborating with business stakeholders, data engineers, and analysts.

________________________________________

Key Responsibilities:

  • Design and implement scalable Snowflake architecture to support business data needs and analytics.
  • Lead data migration efforts from legacy systems (Teradata, Oracle, etc.) to Snowflake.
  • Collaborate with business stakeholders to understand data and reporting requirements, especially within the insurance sector (e.g., policy, claims, underwriting, etc.).
  • Optimize data pipelines and ELT/ETL processes using tools like Informatica, DBT, Matillion, or custom scripts.
  • Implement security models, RBAC, and data governance best practices in Snowflake.
  • Work closely with data engineers and analysts to ensure high data quality, performance, and accessibility.
  • Establish and promote architectural standards, best practices, and reusable frameworks.
  • Troubleshoot performance issues and recommend Snowflake performance tuning strategies.
  • Stay current on Snowflake releases, features, and industry trends, especially in insurance analytics.

________________________________________

Required Qualifications:

  • 8+ years of experience in Data Engineering/Data Architecture.
  • 3+ years of hands-on experience as a Snowflake Architect.
  • Strong experience with data modeling (dimensional, normalized) and data warehouse design.
  • Hands-on experience with ELT/ETL development using tools such as Informatica, Talend, DBT, Fivetran, etc.
  • Experience in cloud platforms (AWS, Azure, or Google Cloud Platform); Snowflake on AWS is preferred.
  • Strong knowledge of SQL, performance tuning, views, and stored procedures.
  • Demonstrated experience working in the Insurance domain knowledge of claims, policies, customers, premiums, actuarial, and regulatory data is a big plus.
  • Experience with CI/CD pipelines, version control, and DevOps practices in data engineering.
  • Strong communication skills and ability to present technical ideas to business users.

________________________________________

Preferred Qualifications:

  • Snowflake certification (e.g., SnowPro Advanced Architect).
  • Experience with data governance tools like Collibra, Alation, or Informatica EDC.
  • Experience in regulatory reporting and compliance in the insurance sector.
  • Familiarity with Python, Spark, or other data processing tools.

________________________________________

Work Environment:

  • This is a 100% onsite role based in Chicago, IL.
  • Must be comfortable working in a fast-paced, collaborative environment.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.