Data Architect - Snowflake Data Model Lead Job Chicago area,Illinois USA,IT/Tech

Data Architect
Pay Range: $83.50 - $88.00 hourly
Experience Level:
Senior
Work Model:
Hybrid - onsite (Chicago) 3 days per week

Job Summary
We're looking for a skilled Data Architect to help shape and modernize enterprise data solutions. In this role, you'll partner with business and technology stakeholders to design scalable data warehouses, data marts, and data pipelines that support critical business initiatives. You'll lead data architecture strategy, develop conceptual and physical data models using Kimball methodology, and champion best practices for data quality, governance, and performance.

The ideal candidate brings strong experience with Snowflake, modern data architectures, real-time and streaming data concepts, data modeling, and performance optimization. Success in this role requires a blend of technical expertise, analytical problem-solving, and the ability to influence stakeholders while driving innovative data solutions across the organization.

Data Architect - Qualifications (must haves):

Snow Pro Certification required
A foundation in systems development
Data modeling using Kimball Methodology
Data design
Data Architectures
Data Pipelines
Experience in performance tuning complex queries
Real Time Data Processing, streaming, networking, and security
Established and emerging data technologies such as No

SQL, distributed databases
Communication and political savvy
Problem solving / analytical thinking and skills
Teamwork and collaboration

Nice to Have:

Experience with Devops and CI/CD technologies is a plus (such as Git, Jenkins, Docker)
Experience with streaming data processing technologies is a plus (such as Spark or Kafka)
Experience in financial industry or banking is a plus

Tasks & Responsibilities:

Work with business owners and IT stakeholders to understand business and functional requirements to design data warehouses and data marts

Develop conceptual and physical data models as well as flow diagrams illustrate current and future state data architecture

Establish good data modelling principles and effective data quality standards

Act as subject matter expert on all aspects of the data architecture, including models, data staging and ETL frameworks

Evangelize modern ideas and technologies for data design and data architectures across the organization