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.