About the role

Aplyr's Quick Take

This role is for a Snowflake Data Architect who will design and implement data architectures to support reporting and analytics for various business functions. You'll be responsible for establishing data modeling standards and creating a roadmap for data modernization. This is an individual contributor role focused on technical architecture rather than management.

Good fit

Ideal candidates have several years of experience in data architecture, particularly with Snowflake, and a strong background in data modeling and governance. A proactive, detail-oriented working style will thrive in this role.

Worth noting

The company emphasizes a family culture and career advancement, which could be appealing if you're looking for a supportive work environment. However, the posting lacks specifics on the team structure and day-to-day collaboration.

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.

Skills & Tags

node python go azure ai data analytics product

Aplyr's read

Keeley Construction is a dynamic firm excelling in diverse construction sectors, attracting professionals skilled in both field and management roles.
Synthesized from recent postings & public sources

What's promising

•Keeley Construction offers diverse project opportunities across commercial, industrial, and institutional sectors.
•The company has a robust hiring trend, indicating growth and stability.
•Keeley Construction values specialized roles, offering positions like Vice President of Mission Critical.

What to watch

•Frequent hiring for traveling roles may indicate high employee turnover.
•Limited public information about company culture and employee satisfaction.
•Potentially demanding work environment due to the nature of construction projects.

Why Keeley Construction

•Keeley Construction specializes in both heavy industrial and commercial projects.
•The firm hires a wide range of roles from technical to managerial positions.
•Keeley Construction's focus on mission-critical projects highlights its expertise in complex sectors.

Aplyr’s read is generated by AI from public sources. Was it useful?

About Keeley Construction

Keeley Construction

keeleyconstruction.com

View company

Keeley Construction Group is a construction management and general contracting firm that specializes in a variety of sectors including commercial, industrial, and institutional projects.