Steneral Consulting

Data Architect (Snowflake)

Steneral Consulting Chicago, IL
Steneral Consulting

Data Architect (Snowflake)

Steneral Consulting Chicago, IL
5 months ago 44 applicants

See who Steneral Consulting has hired for this role

3 days onsite each week (Monday and Tuesday are anchors third day flexible), must be local

W2 candidates only

Need valid LinkedIn

Helping with Snowflake and all of the data engineer

Snowflake expert (optimizing snowflake)

Modern DBA

This person needs to know data engineering

Azure

Data flows/data bricks

Python

Teradata

CI/CD

Managing applications and data processes in snowflake

Understanding of devops and pipelines that interact with Snowflake

Required Skills

Kimbal

Snowpro Certificate must have/Snowflake- 5 years of exp

Python

Terraform

Project Overview

Will be responsible for design & development of data warehouses in Snowflake. Strong prior experience building data warehouses in Snowflake is necessary.

Experience Level: 10+ years

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

  • 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
  • Guide and mentor development teams on ETL, SQL queries and data design best practices
  • Evangelize modern ideas and technologies for data design and data architectures across the organization

  • Seniority level

    Mid-Senior level

  • Employment type

    Contract

  • Job function

    Engineering and Information Technology

  • Industries

    Software Development

Referrals increase your chances of interviewing at Steneral Consulting by 2x

See who you know

Get notified about new Data Architect jobs in Chicago, IL.

Sign in to create job alert

Similar jobs

People also viewed

Looking for a job?

Visit the Career Advice Hub to see tips on interviewing and resume writing.

View Career Advice Hub