Snowflake Data Architect
About this role
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.
- 4+ years of hands-on experience designing and leading Snowflake implementations in cloud production environments.
- Proven experience delivering enterprise-scale data warehouse, analytics, and data transformation programs.
- Deep expertise in Snowflake architecture, including storage and compute separation, micro-partitioning, clustering, performance tuning, governance, and cost optimization.
- Advanced knowledge of dimensional modeling, enterprise data architecture, and data governance best practices.
- Strong SQL development skills and experience with modern ELT/ETL tools such as dbt, Fivetran, SSIS, and orchestration platforms.
- Experience integrating structured and unstructured data sources, including documents, spreadsheets, emails, and PDFs.
- Strong understanding of Microsoft Azure cloud services and enterprise data integration patterns.
- Experience implementing Snowflake Cortex, Snowpark (Python), AI SQL, and AI-driven analytics capabilities in production environments.
- Experience supporting database administration, data migrations, and modernization initiatives.
- Strong leadership, communication, and stakeholder management skills with the ability to present technical strategy to executive audiences.
- Demonstrated ability to mentor technical teams and align data platform strategies with long-term business objectives.
- SnowPro Advanced Certification preferred.
- Experience supporting construction, project-based, HR, finance, accounting, legal, or operations data environments preferred.
#LI-AG1 #LI-Hybrid
All Keeley Brands (Keeley Construction Group, Keeley Properties, Keeley Restoration, Keeley Companies) do not accept unsolicited resumes from search firms, headhunters, or agencies. Any resume submitted to any employee of a Keeley company without a prior written search agreement will be considered unsolicited and the property of any Keeley Company. Please, no phone calls or emails.
All Keeley companies are proud to be an equal opportunity employer regardless of race, color, gender, age, sexual orientation, gender identity, gender expression, religious beliefs, marital status, genetic information, national origin, disability, protected veteran status, or any other basis protected by federal, state, or local law.
Frequently Asked Questions
Is the salary disclosed for the Snowflake Data Architect position at keeleyconstruction?
The salary for this Snowflake Data Architect role at keeleyconstruction is not publicly listed. Click "Apply Now" to learn more about the compensation package on their official careers page.
Where is the Snowflake Data Architect position at keeleyconstruction located?
This Snowflake Data Architect role at keeleyconstruction is based in St. Louis, Missouri, United States. The position is listed as on-site or hybrid. Check the full job description or apply directly to confirm the work arrangement.
Which team or department does the Snowflake Data Architect at keeleyconstruction belong to?
This Snowflake Data Architect position is part of the IT department at keeleyconstruction. See the full job description for more information about the team structure and responsibilities.
How do I apply for the Snowflake Data Architect position at keeleyconstruction?
Click the "Apply Now" button on this page. You will be redirected to keeleyconstruction's official application portal hosted on greenhouse where you can submit your application directly.
When was the Snowflake Data Architect job at keeleyconstruction posted?
This Snowflake Data Architect position at keeleyconstruction was posted on Jun 1, 2026. Apply as soon as possible — early applications are often reviewed first.
Snowflake Data Architect
keeleyconstruction
You'll be redirected to keeleyconstruction's official application page on Greenhouse.