Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Snowflake Data Architect

Keeley Construction

Job Description

Job Description

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.

Vacancy posted 19 days ago
Similar jobs that could be interesting for youBased on the Snowflake Data Architect in Edwardsville, IL vacancy
  •  ...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... 
    Suggested
    Local area

    Keeley Construction Group

    Edwardsville, IL
    4 days ago
  • Keeley Construction Group is seeking a Snowflake Data Architect for our IT Team in St. Louis, MO. This role involves defining the Snowflake architecture for enterprise reporting, analytics, and decision-making across key business domains. The ideal candidate will possess... 
    Suggested

    Keeley Construction Group

    Edwardsville, IL
    5 days ago
  • Southern Illinois University Edwardsville invites applications for the position of Data Analyst /SQL/Oracle Platforms in Student Financial Aid. The role focuses on data analysis, reporting, and enabling effective financial aid administration using SQL, Oracle, Argos, and... 
    Suggested
    Work at office

    Southern Illinois University Edwardsville

    Edwardsville, IL
    1 day ago
  • Data Analyst /SQL/Oracle Platforms Student Financial Aid (CS26-195) Southern Illinois University Edwardsville (SIUE) invites applications for the position of Data Analyst /SQL/Oracle Platforms Student Financial Aid. What You Will Do Assist with the demands placed on... 
    Suggested
    Work experience placement
    Work at office

    Southern Illinois University Edwardsville

    Edwardsville, IL
    1 day ago
  • $107.66k - $161.7k

     ...implement algorithms and systems in an efficient way Take end-to-end ownership of Machine Learning systems -- from prototyping, data pipelines and training, to realtime LLM application at scale Minimum Requirements: Ability to be available for meetings and impromptu... 
    Suggested
    Remote job
    Full time
    Work experience placement
    Internship

    Quora

    Edwardsville, IL
    1 day ago
  •  ...spaces, such as matching, pricing, and geospatial, as well as foundational problems executing on a high throughput system with dynamic data. About the Job: Design, develop, and deploy machine learning solutions to tackle practical challenges in the marketplace.... 
    Permanent employment
    Full time
    Work at office
    Remote work
    Work from home
    Flexible hours

    Instacart

    Edwardsville, IL
    1 day ago
  • $87.1k - $157.45k

     ...Description If you’ve been building your skills in SQL, data engineering fundamentals, and mission‑driven development , and you’re ready for work that actually moves the needle, this is the kind of opportunity cleared engineers pursue when they want to grow while... 
    Local area
    Immediate start

    Leidos

    Edwardsville, IL
    4 days ago
  • Region Landfill Engineer -- Lead the Future of Sustainable Solid Waste Management At Waste Connections, engineers aren’t tucked away in an office — they’re boots-on-the-ground innovators shaping how communities manage waste, protect the environment, and build for the...
    Work at office

    Waste Connections

    Glen Carbon, IL
    2 hours ago
  • About Lantern Lantern is the specialty care platform connecting people with the best care when they need it most. By curating a Network of Excellence comprised of the nation's top specialists for surgery, cancer care, infusions and more, Lantern delivers excellent care...
    Full time

    Lantern

    Edwardsville, IL
    2 days ago
  •  ...Operations & Technology team, you’ll help share the client's marketing data strategy. This includes driving data governance and consistency...  .... Experience working within data platforms like Databricks/Snowflake, and analytics modeling platforms such as Tableau Strong... 
    Full time

    FocusKPI

    Edwardsville, IL
    1 day ago
  • Description The Receiving Department Team Lead is responsible for managing the daily operations of the receiving team, ensuring efficient and accurate handling of incoming goods. This role involves supervising and mentoring team members, overseeing receiving processes,...

    NPSG Global

    Edwardsville, IL
    1 day ago
  • $75k - $85k

     ...identifying new opportunities. You’ll work closely with the Senior Manager, Strategic Growth and cross-functional stakeholders to analyze data, synthesize insights, and help drive execution across a variety of projects. This is a great opportunity for someone early in... 
    Full time
    Work at office
    Local area
    Immediate start
    Remote work
    Flexible hours

    EverCommerce

    Edwardsville, IL
    2 days ago
  • $130k - $135k

     ...managing and supporting the company’s technology infrastructure, ensuring the smooth operation of hardware, software, networks, and data systems, while providing top-notch technical support to employees. By joining the Internal WWT IT team, you will play a crucial role... 
    Full time
    Remote work
    Shift work
    Weekend work

    World Wide Technology

    Edwardsville, IL
    4 days ago
  • Description: THIS IS A FRANCHISE POSITION SONIC is all about having fun while you work and gaining a sense of accomplishment along the way. Not only do you work with fantastic people, you'll get great pay, flexible hours and a cool uniform. As a Sonic ...
    Local area
    Immediate start
    Flexible hours
    Shift work
    Night shift

    Sonic

    Edwardsville, IL
    2 days ago
  • The Legal Analyst supports the warranty litigation team by managing warranty litigation claims and arbitration matters and assisting with litigation support activities as needed. This role works in close partnership with paralegals and warranty litigation attorneys to ...
    Full time
    Immediate start

    Stellantis

    Edwardsville, IL
    2 days ago
  •  ...Intelligence and Machine Learning. The intern will gain hands-on experience building intelligent systems, developing AI agents, and applying data-driven techniques to real-world EDA challenges. The ideal candidate will have skills in Python, JAVA, C# or C++, and will also... 
    Remote job
    Hourly pay
    Internship
    Work at office
    Local area

    Siemens

    Edwardsville, IL
    4 days ago
  • Walmart in Edwardsville, IL, is looking for an Asset Protection Associate to uphold security standards and compliance. The role focuses on supporting security staff, conducting audits, and ensuring regulatory adherence while enhancing workplace safety. Candidates should...

    Walmart

    Edwardsville, IL
    2 days ago
  • $49.5k - $63.5k

    At DICK'S Sporting Goods, we believe in how positively sports can change lives. On our team, everyone plays a critical role in creating confidence and excitement by personally equipping all athletes to achieve their dreams. We are committed to creating an inclusive and...

    DICK'S SPORTING GOODS INC

    Edwardsville, IL
    5 days ago
  • $16 - $19.25 per hour

    Catering Lead At Panera, our people come first. If you’re looking for a place where you can grow, feel supported, be yourself, enjoy great perks, and have a little fun along the way—you’re in the right spot. We’re here to help you succeed every day, in every way. Get ready...
    Full time
    Local area
    Flexible hours
    Shift work
    Night shift

    Dormont Manufacturing Company

    Edwardsville, IL
    2 days ago
  • 31 Junction Dr, Glen Carbon, Illinois 62034 Asan independently owned and operated Jack in the Box franchisee serving the Southern California area, we take pride in achieving excellence while enjoying what we do every day. We believe in promoting from within and fostering...
    Shift work

    Jack in the Box

    Glen Carbon, IL
    5 days ago
  •  ...The Business Analyst, Pricing and Underwriting , is responsible for the compilation, analysis, and reporting of data to support pricing contracts for Specialty services within a Pharmacy Benefit Manager (PBM) setting. Partner cross-functionally with Underwriting, Finance... 
    Full time
    Temporary work
    Work at office
    Remote work
    Work from home

    Maxor National Pharmacy Services

    Edwardsville, IL
    1 day ago
  • $175k - $225k

     ...calls, text messages, or emails from Jobot, and/or its agents and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You... 
    Local area

    Jobot

    Edwardsville, IL
    1 day ago
  • $86k - $107.5k

     ...prevention, early detection, and in‑process or post‑work inspection for designated business processes. Collect, measure, and analyze complex data to identify continual improvement opportunities for internal performance metrics and key performance indicators to ensure business... 
    Work at office
    Shift work

    World Wide Technology

    Edwardsville, IL
    4 days ago
  • $71.1k - $172.2k

     ...maintain system reliability, while maintaining public and employee safety. Monitor the Energy Management System / Supervisory Control and Data Acquisition system (EMS/SCADA) for proper operation. Qualifications A bachelor's degree in engineering from an accredited college... 
    Full time
    Temporary work

    Ameren Services Company

    Glen Carbon, IL
    5 days ago
  •  ...awards, leave, travel, training, records keeping, etc.). Prepares narrative analyses, graphs, charts, and management statistics of data for use in briefings and presentations, using office automation tools. Serves as the Unit Training Coordinator Serves as the... 
    Permanent employment
    Full time
    Temporary work
    Term time
    Work at office
    Remote work

    Defense Logistics Agency

    Edwardsville, IL
    2 days ago
  • A top law firm is seeking a Senior Infrastructure Engineer to design and manage a secure Microsoft 365 messaging environment, focusing on Exchange Online. Candidates should have over 7 years of IT infrastructure experience, with significant expertise in Exchange administration...
    Remote job

    Jobot

    Edwardsville, IL
    5 days ago
  • $19 per hour

    Role, Inc. is seeking a Store Department Supervisor in Edwardsville, Illinois, to lead and develop associates across various store departments. The role focuses on providing excellent customer service while contributing to operational and merchandising decisions. Successful...

    ROLE

    Edwardsville, IL
    3 days ago
  • $50 - $60 per hour

     ...Qualifications: Fluency in English (native or bilingual level) Detail-oriented Proficient in financial analysis, financial modeling, data analysis, and other reasoning exercises related to finance management A current, in progress, or completed Master's and/or PhD is... 
    Hourly pay
    Contract work
    For contractors
    Work experience placement
    Remote work

    Data Annotation

    Glen Carbon, IL
    more than 2 months ago
  • Graham Healthcare Group in Glen Carbon, IL seeks a Director of Regulatory & Quality - Hospice to lead compliance and quality initiatives across hospice operations. This role requires licensure as RN or LPN, a bachelor’s degree, and strong leadership to drive survey readiness...

    Kaplan International

    Glen Carbon, IL
    2 days ago
  • $128.1k - $198.7k

    Ross Stores, Inc. is seeking a District Manager located in Edwardsville, IL, accountable for all phases of district operations. This role entails managing store visits focused on people, customer service, and sales goals while leading and developing store management teams...

    Ross Stores, Inc.

    Edwardsville, IL
    5 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Snowflake Data Architect. Be the first to apply!