Sign upLog in

Snowflake Platform Architect

Iconma

Chicago, IL

Apply
JOB DETAILS
SALARY
$52.14–$52.14 Per Hour
SKILLS
Analysis Skills, Architectural Services, Best Practices, Cloud Architecture, Cloud Computing, Coding Standards, Cost Control, Data Management, Data Modeling, Data Quality, Data Structures, Enterprise Architecture, Health Plan, Information Technology Consulting, Information/Data Security (InfoSec), Mentoring, Metadata, Performance Management, Performance Tuning/Optimization, Quality Management, Query Optimization, Regulations, Reliability Analysis, Reliability Engineering, Requirements Management, Resource Management, Root Cause Analysis, SQL (Structured Query Language), Sales Pipeline, Snowflake Schema, Structured Data, Technical Leadership
LOCATION
Chicago, IL
POSTED
1 day ago
Our client, a IT Services and Consulting company, is looking for a Snowflake Platform Architect for their Chicago, IL location.
 
Responsibilities:
  • Architect role in a hybrid work model focusing on designing and optimizing Snowflake based data platforms using advanced Snowflake SQL and scalable cloud patterns.
  • The professional will translate business needs into secure and efficient data solutions while mentoring teams on best practices and ensuring high standards of data quality and performance across the enterprise.
  • Design robust Snowflake based data architectures that align with enterprise standards and enable scalable analytics across multiple business domains. Develop advanced Snowflake SQL solutions that optimize query performance, reduce compute costs and improve reliability of critical analytical workloads.
  • Coordinate with product and business stakeholders to translate analytical requirements into well structured Snowflake data models and reusable components.
  • Optimize data loading pipelines into Snowflake by refining partitioning strategies, clustering approaches and resource allocation for predictable performance.
  • Establish governance friendly patterns for Snowflake role design, access management and secure data sharing to protect sensitive information. Document detailed architecture decisions, data flows and integration patterns to ensure clear understanding and future maintainability of Snowflake implementations.
  • Guide engineering teams on Snowflake best practices for coding standards, query design and environment configuration to maintain consistent quality.
  • Review proposed data solutions for adherence to architectural principles, performance targets and operational reliability objectives.
  • Introduce monitoring practices that track query behavior, storage growth and workload patterns to anticipate capacity and performance issues. Collaborate with infrastructure and security teams to ensure Snowflake deployments comply with organizational policies and regulatory obligations. Experiment with emerging Snowflake features to evaluate potential improvements in performance, cost efficiency and developer productivity.
  • Provide technical guidance during incident analysis to identify root causes related to Snowflake configurations, queries or data structures.
  • Create knowledge sharing artifacts such as design standards, playbooks and reference implementations to accelerate future Snowflake initiatives.
 
Requirements:
  • Require extensive experience in Snowflake SQL development including complex transformations, performance tuning and workload management. Require strong background in designing cloud based analytical architectures that integrate Snowflake with upstream and downstream data systems. Require hands on experience with Snowflake security constructs including roles, policies and secure data sharing patterns.
  • Require practical exposure to data modeling techniques for analytical warehouses including dimensional and wide table approaches tailored for Snowflake.
  • Nice to have familiarity with orchestration tools that manage Snowflake pipelines and automate environment workflows in a hybrid work setting.
  • Nice to have experience optimizing cost through Snowflake resource allocation strategies and storage lifecycle management.
  • Nice to have understanding of broader data engineering concepts such as data quality, metadata management and observability for Snowflake platforms.
  • Years of Experience: 14.00 Years of Experience
Skills: 
  • Category                                 Name               Required                     Importance    
  • Cloud Solutions                         Snowflake        Yes                              1                     
 
Why Should You Apply?

About the Company

I

Iconma

ICONMA is a global information consulting management firm providing Professional Staffing Services and Project-Based Solutions for organizations in a broad range of industries.

  • Corporate Headquarters in Troy, Michigan; 20+ locations worldwide.
  • Certified Woman-Owned Business Enterprise (WBE); certified by Women’s Business Enterprise National Council, National Women Business Owners Corporation (NWBOC); and California Public Utilities Commission (CPUC).
  • Founded in 2000
  • 2000+ Employees

The company was founded on the principle that success is derived from delivering high quality service and resources in the most responsive, flexible, and innovative way. ICONMA invests in people and resources with a single goal: To provide our customers with the highest quality service in the most responsive manner. Through its network of offices, ICONMA provides the resources to help clients maintain their competitive advantage.

COMPANY SIZE
2,000 to 2,499 employees
INDUSTRY
Management Consulting Services
EMPLOYEE BENEFITS
401K, Employee Referral Program, Life Insurance
FOUNDED
2000
WEBSITE
https://www.iconma.com/

Resume Resources

Free Resume TemplatesFree Resume Builder