Data Architect - Snowflake Data Model Lead

Prairie Consulting Services

Chicago, IL

JOB DETAILS
SALARY
$83.50–$88 Per Hour
SKILLS
Analysis Skills, Banking Services, Best Practices, Business Support, Continuous Deployment/Delivery, Continuous Integration, Data Management, Data Mart, Data Modeling, Data Processing, Data Quality, Data Warehousing, DataArchitect Data Modeling Tool, Database Extract Transform and Load (ETL), DevOps, Distributed Databases, Docker, Emerging Technology, Finance, Git, Jenkins, Network Security, NoSQL, Performance Modeling, Performance Tuning/Optimization, Problem Solving Skills, Quality Metrics, Requirements Management, Snowflake Schema, Streaming Technology, Team Player
LOCATION
Chicago, IL
POSTED
2 days ago
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):
  • SnowPro 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 NoSQL, 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:
  1. Work with business owners and IT stakeholders to understand business and functional requirements to design data warehouses and data marts
  2. Develop conceptual and physical data models as well as flow diagrams illustrate current and future state data architecture
  3. Establish good data modelling principles and effective data quality standards
  4. Act as subject matter expert on all aspects of the data architecture, including models, data staging and ETL frameworks
  5. Evangelize modern ideas and technologies for data design and data architectures across the organization

About the Company

P

Prairie Consulting Services