Lead the design and implementation of AI-powered analytics and applications using Snowflake Cortex. Develop semantic models, search and retrieval solutions, agents, AISQL workflows, Snowflake databases, and scalable ETL/ELT pipelines. Optimize performance, security, governance, and data quality while guiding high-impact initiatives and aligning data engineering solutions with organizational goals. Collaborate with technical and business stakeholders and provide executive guidance.
Core Responsibilities
AI & Snowflake Cortex Responsibilities
- AI Solution Design & Implementation: Build AI‑powered analytics, semantic insights, and business applications using Snowflake Cortex capabilities.
- Semantic Models & Views: Develop and maintain semantic layers enabling natural language querying, governed metrics, and business‑friendly data access.
- Cortex Search & Knowledge Retrieval: Design and optimize enterprise search solutions for document intelligence and knowledge retrieval.
- Cortex Agents: Configure and orchestrate agents to unify structured and unstructured data sources for automated workflows.
- AISQL Functions: Implement summarization, classification, extraction, sentiment analysis, and content generation use cases.
- AI Application Development: Build interactive AI applications using Streamlit, Snowsight, and Python frameworks within Snowflake.
- Testing & Improvement: Validate, monitor, and continuously enhance AI models, agents, and applications.
General Snowflake Development Responsibilities
- Database Design & Management: Create and manage Snowflake databases, schemas, tables, and objects for efficient, organized data storage.
- SQL Development: Write complex SQL queries to extract, transform, and load (ETL/ELT) data for analytics, reporting, and AI workflows.
- Data Pipeline Development: Build and maintain scalable ETL/ELT pipelines to ingest data from diverse sources into Snowflake with high quality and reliability.
- Performance Optimization: Monitor and optimize Snowflake performance through query tuning, clustering, micro‑partitioning, and workload scaling.
- Security & Access Control: Implement RBAC, data governance, user permissions, and security policies to protect sensitive information.
- Collaboration: Work closely with data engineers, analysts, architects, and business teams to translate requirements into scalable data and AI solutions.
- Testing & Documentation: Conduct unit testing, code reviews, and maintain clear documentation for data workflows, pipelines, and AI applications.
Required Skills & Experience
Snowflake & AI Expertise
- Hands‑on experience with Snowflake Cortex: Cortex Analyst, Cortex Search, Cortex Agents, AISQL Functions, Semantic Models.
- Strong understanding of Snowflake’s CoCO, Snowpark, and platform‑native AI capabilities.
Technical Skills
- Proficiency in SQL, Python, and ETL/ELT tools ( Informatica, dbt etc.).
- Experience with cloud platforms such as AWS, Azure, or GCP.
- Familiarity with Spark, Kafka, and modern data engineering frameworks.
Data Warehousing & Modeling
- Strong knowledge of dimensional modeling(star Schema), semantic modeling, data architecture, and analytical data design.
- Experience integrating AI/ML patterns into enterprise data platforms.
Generative AI & LLMs
- Experience with prompt engineering, RAG architectures, embeddings, and agent design.
- Understanding of LLM‑driven workflows and enterprise AI application patterns.
Soft Skills
- Strong problem‑solving abilities and analytical thinking.
- Effective communication with technical and non‑technical stakeholders.
- Ability to work collaboratively and take ownership of projects.
Certifications (Preferred)
- Snowflake Certified Developer / SnowPro
- Cloud certifications (AWS, Azure, GCP)
Similar Jobs
Artificial Intelligence • Legal Tech • Software
Lead Legora’s global governance, risk, and compliance function, including SOC 2, ISO 27001, and ISO/IEC 42001 assurance programs. Own risk assessments, audits, certifications, controls, evidence, remediation, AI governance, regulatory requirements, and customer security engagements. Develop the GRC team, advise executives, improve automated evidence collection and control monitoring, and collaborate with Security, Engineering, Legal, and global business teams.
Top Skills:
Ai GovernanceFedrampIso 27001Iso/Iec 42001Soc 2
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Owns the end-to-end design, development, deployment, and operation of visualization, analytics, and collaboration platforms for integrative biology research. Builds cloud-native workloads across AWS and GCP using Kubernetes, infrastructure-as-code, containers, and production software. Partners with scientific and engineering stakeholders to translate research needs into technical roadmaps, establishes standards, leads contractors, and improves platform reliability, security, scalability, and observability.
Top Skills:
Amazon CloudwatchAmazon EksArgo CdAWSD3DashDockerFluxGCPGithub ActionsGoogle Cloud MonitoringGoogle GkeGrafanaHelmJavaScriptKubernetesPlotlyPrometheusPythonReactSpotfireTableauTerraformTypescript
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Lead Samsara’s AI initiatives across the software development lifecycle, including developer agents and SRE AI. Set strategy, select experiments, make build-versus-buy decisions, control infrastructure and token costs, scale automated incident response, and build trust in AI-driven actions. Manage and grow a team of five to ten senior engineers while partnering directly with R&D leaders and developers.
Top Skills:
Ai AgentsClaudeCloud InfrastructureCodexIncident Response AutomationIotModel Context Protocol (Mcp)Sre Tooling
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory



