Snowflake Data Architect at Keeley Construction

<div class="content-intro"><p><span style="font-size: 14pt; color: #000000;"><strong>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.</strong></span></p></div><p><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Keeley Companies is looking to hire a<strong> Snowflake Data Architect</strong> for our IT Team in St. Louis, MO.</span></p> <p><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"></span></p> <h3 data-section-id="1t73xls" data-start="0" data-end="28"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Primary Responsibilities</span></h3> <ul data-start="30" data-end="1762"> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;" data-section-id="1t1uuce" data-start="30" data-end="183"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Define and execute the target-state Snowflake architecture supporting enterprise reporting, analytics, and decision-making across key business domains.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;" data-section-id="x1662l" data-start="184" data-end="308"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Establish enterprise data modeling standards, architectural patterns, governance frameworks, and golden-source strategies.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;" data-section-id="i1erod" data-start="309" data-end="444"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Design scalable logical and physical data models for Project Management, HR, Finance, Accounting, Legal, and Operations data domains.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;" data-section-id="1m3djfp" data-start="445" data-end="571"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Develop and maintain a multi-year enterprise data warehouse and data modernization roadmap aligned with business objectives.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;" data-section-id="tmvb3v" data-start="572" data-end="711"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Design AI-ready data architectures that support both structured and unstructured data for advanced analytics and generative AI use cases.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;" data-section-id="8udwcf" data-start="712" data-end="862"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Establish Snowflake governance standards including security, cost management, performance optimization, data sharing, monitoring, and observability.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;" data-section-id="ukkwrk" data-start="863" data-end="1014"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Design and implement Snowflake Cortex capabilities, including AI SQL, LLM functions, document intelligence, vector functions, and Snowpark solutions.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;" data-section-id="p0ksvc" data-start="1015" data-end="1170"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Lead the development of scalable data ingestion frameworks integrating enterprise applications such as CMiC, UKG, Salesforce, and other critical systems.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;" data-section-id="1kfwmvr" data-start="1171" data-end="1271"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Oversee enterprise data quality, testing, validation, reconciliation, and observability standards.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;" data-section-id="dlxnge" data-start="1272" data-end="1417"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Drive Snowflake performance tuning initiatives through query optimization, clustering strategies, workload management, and concurrency scaling.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;" data-section-id="tvme9n" data-start="1418" data-end="1500"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Lead large-scale data warehouse modernization and legacy data migration efforts.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;" data-section-id="1s9fqye" data-start="1501" data-end="1620"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Partner with business and technology leaders to translate complex requirements into scalable data platform solutions.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;" data-section-id="r8n2cv" data-start="1621" data-end="1762"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Mentor and guide data engineers, analysts, and data scientists in implementing enterprise data architecture and engineering best practices.</span></li> </ul> <h3 data-section-id="1h7doky" data-start="1764" data-end="1790"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Minimum Qualifications</span></h3> <ul data-start="1792" data-end="3513" data-is-last-node="" data-is-only-node=""> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;" data-section-id="r2jc0p" data-start="1792" data-end="1895"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Bachelor's degree in Computer Science, Engineering, Information Systems, or a related field required.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;" data-section-id="1uj14je" data-start="1896" data-end="1987"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">8+ years of enterprise data architecture, data warehousing, and data platform experience.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;" data-section-id="yhlnah" data-start="1988" data-end="2103"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">4+ years of hands-on experience designing and leading Snowflake implementations in cloud production environments.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;" data-section-id="1rfh4lf" data-start="2104" data-end="2212"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Proven experience delivering enterprise-scale data warehouse, analytics, and data transformation programs.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;" data-section-id="16mlirk" data-start="2213" data-end="2385"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Deep expertise in Snowflake architecture, including storage and compute separation, micro-partitioning, clustering, performance tuning, governance, and cost optimization.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;" data-section-id="pv5fzw" data-start="2386" data-end="2497"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Advanced knowledge of dimensional modeling, enterprise data architecture, and data governance best practices.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;" data-section-id="mb429g" data-start="2498" data-end="2628"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Strong SQL development skills and experience with modern ELT/ETL tools such as dbt, Fivetran, SSIS, and orchestration platforms.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;" data-section-id="1c2vlr1" data-start="2629" data-end="2748"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Experience integrating structured and unstructured data sources, including documents, spreadsheets, emails, and PDFs.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;" data-section-id="r2hgo1" data-start="2749" data-end="2847"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Strong understanding of Microsoft Azure cloud services and enterprise data integration patterns.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;" data-section-id="dunod8" data-start="2848" data-end="2983"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Experience implementing Snowflake Cortex, Snowpark (Python), AI SQL, and AI-driven analytics capabilities in production environments.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;" data-section-id="1iybvk6" data-start="2984" data-end="3080"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Experience supporting database administration, data migrations, and modernization initiatives.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;" data-section-id="2sh6hn" data-start="3081" data-end="3221"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Strong leadership, communication, and stakeholder management skills with the ability to present technical strategy to executive audiences.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;" data-section-id="1f7kpno" data-start="3222" data-end="3341"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Demonstrated ability to mentor technical teams and align data platform strategies with long-term business objectives.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;" data-section-id="fwvo0d" data-start="3342" data-end="3385"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">SnowPro Advanced Certification preferred.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;" data-section-id="1j7sasb" data-start="3386" data-end="3513" data-is-last-node=""><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Experience supporting construction, project-based, HR, finance, accounting, legal, or operations data environments preferred.</span></li> </ul> <p><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">#LI-AG1 #LI-Hybrid</span></p><div class="content-conclusion"><p style="text-align: center;"><em>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.</em></p> <p style="text-align: center;"><em>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.</em></p></div>