Snowflake Data Architect

At Keeley Companies, we believe in empowering our people and fulfilling career aspirations. Keeley is a career destination with countless opportunities for advancement, and a world-class family culture that is centered around creating the best possible environment for our people to thrive.

Keeley Companies is looking to hire a Snowflake Data Architect for our IT Team in St. Louis, MO.

Primary Responsibilities

• Define and execute the target-state Snowflake architecture supporting enterprise reporting, analytics, and decision-making across key business domains.
• Establish enterprise data modeling standards, architectural patterns, governance frameworks, and golden-source strategies.
• Design scalable logical and physical data models for Project Management, HR, Finance, Accounting, Legal, and Operations data domains.
• Develop and maintain a multi-year enterprise data warehouse and data modernization roadmap aligned with business objectives.
• Design AI-ready data architectures that support both structured and unstructured data for advanced analytics and generative AI use cases.
• Establish Snowflake governance standards including security, cost management, performance optimization, data sharing, monitoring, and observability.
• Design and implement Snowflake Cortex capabilities, including AI SQL, LLM functions, document intelligence, vector functions, and Snowpark solutions.
• Lead the development of scalable data ingestion frameworks integrating enterprise applications such as CMiC, UKG, Salesforce, and other critical systems.
• Oversee enterprise data quality, testing, validation, reconciliation, and observability standards.
• Drive Snowflake performance tuning initiatives through query optimization, clustering strategies, workload management, and concurrency scaling.
• Lead large-scale data warehouse modernization and legacy data migration efforts.
• Partner with business and technology leaders to translate complex requirements into scalable data platform solutions.
• Mentor and guide data engineers, analysts, and data scientists in implementing enterprise data architecture and engineering best practices.

Minimum Qualifications

• Bachelor's degree in Computer Science, Engineering, Information Systems, or a related field required.
• 8+ years of enterprise data architecture, data warehousing, and data platform experience.
• <span style="font-family: arial, helvetica,