{bc}
Apply
oracle

Snowflake Data Engineer

exl Service.com (India) Private Limited
Pittsburgh, USA
Full-time
Mid · 5+ years experience
Hybrid
Discovered 6 days ago
azuregcppythonsnowflakesql

Full Job Posting

Qualifications

  • 5+ years of data engineering experience, with at least 3+ years of hands-on Snowflake expertise.
  • Proven experience with Snowflake Cortex AI features: LLM functions, Cortex Analyst, Cortex Search, and AI agent orchestration.
  • Hands-on experience building Streamlit in Snowflake applications deployed in production environments.
  • Proficiency in Snowpark for Python — including custom UDFs/UDTFs, stored procedures, and DataFrame API usage.
  • Strong SQL skills with deep understanding of Snowflake's execution engine, query profiling, and optimization techniques.
  • Experience with Snowflake data sharing, Marketplace, and cross-cloud/cross-region replication.
  • Familiarity with vector search, embeddings, and RAG architecture patterns within or integrated into Snowflake.
  • Good to have experience with cloud platforms: Azure, and GCP — and connecting Snowflake to cloud-native services.
  • Strong understanding of data modeling for analytics (star schema, Data Vault, Medallion/Lakehouse patterns).
  • Knowledge of Medicare Stars Patient Safety is a strong plus.

Responsibilities

  • Snowflake AI & Cortex (Core Focus)
  • Design and deploy AI-powered solutions using Snowflake Cortex, including LLM-based functions (COMPLETE, SUMMARIZE, SENTIMENT, TRANSLATE, CLASSIFY) for healthcare data use cases.
  • Build and orchestrate multi-step AI agents using Snowflake Cortex Agents and Cortex Analyst to automate data workflows and enable natural language querying of structured healthcare datasets.
  • Leverage Cortex Search for semantic and hybrid search capabilities across unstructured clinical and operational data.
  • Implement RAG (Retrieval-Augmented Generation) pipelines using Snowflake's native vector embeddings and VECTOR data type for domain-specific LLM grounding.
  • Use Arctic Embed and other Snowflake-native embedding models to build scalable, cost-effective AI features within the Snowflake perimeter.
  • Streamlit & Application Development
  • Build interactive, production-grade data applications and internal tools using Streamlit in Snowflake (SiS) for business stakeholders and data consumers.
  • Develop self-service analytics dashboards and AI-assisted exploration tools embedded directly in the Snowflake environment.
  • Create Streamlit-based front-ends for Cortex-powered features — enabling clinical users and analysts to interact with AI outputs without leaving the Snowflake ecosystem.
  • Snowpark & Data Engineering
  • Develop complex data transformations, feature engineering pipelines, and ML preprocessing workflows using Snowpark for Python.
  • Build and manage scalable ELT pipelines leveraging Snowflake Streams, Tasks, Dynamic Tables, and Snowpipe for real-time and batch ingestion.
  • Optimize Snowflake performance through micro-partition pruning, clustering keys, materialized views, search optimization, and warehouse right-sizing.
  • Design and implement Data Vault or Medallion architecture patterns for healthcare data platforms.
  • Integrate Snowflake with upstream healthcare data sources and downstream BI platforms.
  • Data Governance & Security
  • Implement Snowflake-native governance including row-level security, column masking policies, object tagging, and data classification.
  • Ensure HIPAA compliance and PHI data handling best practices across all Snowflake data assets.
  • Manage data lineage, cataloging, and access control in alignment with organizational governance frameworks.
  • Collaboration & Platform Ownership
  • Partner with data scientists, ML engineers, clinical analysts, and business stakeholders to translate requirements into robust Snowflake-native solutions.
  • Act as a Snowflake subject matter expert and internal champion — driving best practices, onboarding teams, and evangelizing new platform capabilities.
  • Participate in platform roadmap planning and contribute to Snowflake feature adoption strategy.

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at exl Service.com (India) Private Limited

Clinical Validation Auditor (CVA) Auditor III

Pittsburgh, USA

Discovered TodayFull-time

Assistant Vice President

Gurugram, IND

Discovered TodayFull-time

Lead Assistant Manager

Noida, IND

Discovered TodayFull-time

Pharmacy Auditor I

, USA

Discovered TodayFull-time

Data Scientist

, IND

Discovered TodayFull-time

Manager

Gurugram, IND

Discovered TodayFull-time

Manager

Hyderabad, IND

Discovered TodayFull-time

Project Manager - International Fan Engagement

, CAN

Discovered TodayFull-time