Snowflake Platform Architect

Job Title: Snowflake Platform Architect

Location: Chicago, IL

Work Arrangement: Hybrid

Employment Type: Contract

Duration: 6.5 months (Based on June 12, 2026 – December 31, 2026 timeline)

Pay Range: $45.96/hr. to $49.23/hr. on W2 | $57.14/hr. to $64.00/hr. on C2C

Domain: Banking & Financial Services

Application Deadline: June 10, 2026

SKILLS REQUIRED:

Primary (Must-Have):

✔️11 to 14 years of data architecture and engineering experience with an enterprise focus on cloud data warehouse platforms

✔️Extensive hands-on expertise in advanced Snowflake SQL development, including complex transformations, multi-tier query performance tuning, and virtual warehouse optimization

✔️Proven track record designing scalable cloud-based analytical architectures that integrate Snowflake seamlessly with upstream and downstream data systems

✔️Strong command of Snowflake security architectures, including role-based access control (RBAC), row/column-level data masking policies, and secure data sharing patterns

✔️Deep structural knowledge of analytical data modeling techniques, specifically dimensional modeling (Star/Snowflake schemas) and wide-table approaches tailored for Snowflake storage

Secondary (Good to Have):

✔️Familiarity with modern data orchestration and pipeline tools (e.g., Airflow, dbt, Matillion) to automate multi-environment workflows

✔️Experience managing Snowflake consumption costs through precise resource monitors, warehouse sizing strategies, and storage lifecycle policies

✔️Broader data engineering awareness covering data quality frameworks, metadata management, and data platform observability

✔️Experience working within strict financial sector regulatory boundaries, compliance constraints, and corporate security guidelines

POSITION OVERVIEW

We are seeking a Senior Snowflake Platform Architect with 11 to 14 years of advanced enterprise data infrastructure experience to join our team in a hybrid capacity out of Chicago. In this strategic and hands-on architecture role, you will be responsible for designing, securing, and optimizing our enterprise-wide Snowflake data platforms. Acting as the technical authority, you will translate complex financial business requirements into highly performant, secure, and cost-efficient data patterns, while establishing governance standards and mentoring engineering teams on elite development practices.

ROLES & RESPONSIBILITIES

✔️Design and implement robust, enterprise-grade Snowflake data architectures that support scalable analytics and business intelligence across multiple banking domains.

✔️Author and engineer sophisticated Snowflake SQL solutions, optimizing query performance profiles to drastically reduce compute costs and maximize analytical throughput.

✔️Partner with product stakeholders to convert raw operational requirements into structural, well-modeled, and reusable data components within the Snowflake ecosystem.

✔️Refine ingestion data pipelines by tailoring custom partitioning strategies, search optimization services, and clustering keys for high-volume datasets.

✔️Establish secure, governance-compliant access infrastructure by designing Snowflake role hierarchies, network policies, and encrypted data sharing interfaces.

✔️Architect proactive monitoring models to track real-time query behavior, storage consumption growth, and compute workload patterns to mitigate capacity risks.

✔️Create and curate centralized technical playbooks, design standards, and reference implementations to accelerate agile data initiatives across engineering teams.

✔️Provide escalation-level technical support during incident management, conducting root-cause analysis on complex platform queries or cluster configuration anomalies.

BENEFITS

Medical | Dental | Vision | 401(k)

EEOC Compliance

We are an equal opportunity employer, and all qualified applicants will receive consideration for employment.

DISCLAIMER

AI Usage Policy: Pacer Group uses AI to assist in screening applications. Final hiring decisions are made by human recruiters based on qualifications and experience.