Snowflake Subject Matter Expert

4 days ago

Hyderabad, Telangana, India Zorba AI Full time ₹ 8,00,000 - ₹ 24,00,000 per year

Experience:
8+ Years

Location Options:

  • Bay Area (Local Candidates Preferred) – Travel on need basis
  • Hyderabad (Local Candidates Only) – 5 days onsite Employment Type: Full-time / Contract

Role Summary
As a
Snowflake Subject Matter Expert (SME)
, you will be responsible for architecting, developing, and optimizing data warehouse and lakehouse solutions using the
Snowflake platform
. Your expertise will enable the data team to build a
modern, scalable, and high-performance data platform
that supports business analytics, data science, and reporting needs.

You will work closely with data architects, engineers, and business stakeholders to ensure robust data ingestion, storage, and access frameworks that meet
security, compliance, and performance
standards.

Key Responsibilities

  • Design and implement Snowflake data warehouse and lakehouse architectures.
  • Develop and optimize Snowflake SQL, stored procedures, and data transformation logic.
  • Manage Snowflake account configurations, resource monitors, virtual warehouses, and access controls.
  • Integrate Snowflake with Databricks, Azure Data Factory, and cloud storage (ADLS/S3/GCS).
  • Implement best practices for data partitioning, clustering, and caching for performance optimization.
  • Participate in data ingestion automation, metadata management, and pipeline monitoring.
  • Collaborate with security and governance teams to enforce RBAC, encryption, and compliance policies.
  • Contribute to CI/CD automation for Snowflake deployments and pipeline orchestration.
  • Provide technical leadership, mentoring, and knowledge sharing across teams.

Required Skills & Qualifications

  • 8+ years of experience in Data Engineering, with 3+ years in Snowflake.

  • Deep expertise in Snowflake features:

  • Performance tuning & query optimization

  • Time Travel, Zero-Copy Cloning, Streams, Tasks, and Materialized Views

  • Data sharing and data marketplace

  • Strong SQL and ETL/ELT development skills.

  • Experience with data modeling (Kimball/Inmon/Dimensional).

  • Hands-on experience with:

  • Databricks or PySpark for transformation

  • Azure Data Factory / Airflow / DBT for orchestration

  • Cloud storage (Azure Data Lake, S3, or GCS)

  • Knowledge of data governance, RBAC, encryption, and compliance frameworks (GDPR, HIPAA, etc.).

  • Familiarity with CI/CD pipelines (Azure DevOps, GitHub Actions, Jenkins).
  • Strong problem-solving and communication skills.

Preferred / Good To Have

  • Experience with Snowpipe and auto-ingestion.
  • Exposure to Delta Lake and Unity Catalog.

  • Certifications:

  • SnowPro Core / Advanced Architect / Data Engineer

  • Azure / AWS Data Engineer certifications.

Skills: azure,python,sql,snowflake

  • Snowflake Subject Matter Expert

    10 hours ago

    Hyderabad, Telangana, India Zorba Consulting Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Description : About the job Experience : 8 Years Location Options : - Bay Area (Local Candidates Preferred) - Travel on need basis - Hyderabad (Local Candidates Only) - 5 days onsite Employment Type : Full-time / Contract Role Summary : As a Snowflake Subject Matter Expert (SME), you will be responsible for architecting, developing, and...

  • Subject Matter Expert

    2 weeks ago

    Hyderabad, Telangana, India IntouchCX Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    About the JobThe Subject Matter Expert (CSR2) plays a critical role within IntouchCX. The ideal candidate will provide front-line direction to our Customer Service Representatives, and ensure quality service is provided in every customer interaction.As Subject Matter Expert (CSR2), You WillRepresent our client partners, and learn and maintain knowledge of...

  • Subject Matter Expert

    2 days ago

    Hyderabad, Telangana, India Crescent Tax Filing Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    A Subject Matter Expert (SME) in U.S. Taxation is responsible for providing advanced expertise and authoritative guidance on federal, state, and local tax laws, regulations, and compliance requirements. The SME supports tax strategy, compliance, planning, and reporting efforts by ensuring all activities align with current U.S. tax codes, IRS regulations, and...

  • Subject Matter Expert

    2 days ago

    Hyderabad, Telangana, India Sri Gajanan E-slates Private Limited Full time ₹ 4,80,000 - ₹ 6,60,000 per year

    We Are #Hiring. Know anyone who might be interestedInterested Candidates Share your Resumes: Job Title: Subject Matter Expert (Mechanical)Job Location: Hitech City, HyderabadInterview Mode: F2FSalary: Depends on InterviewExperience: 2-5yrsTimings: 10am - 6:30pmWorking Days: Monday – SaturdayCompany DescriptionEKALASAALA is a pioneer in Career Guidance &...

  • Subject matter expert

    2 weeks ago

    Hyderabad, Telangana, India BOSSBERRY LEARNING Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Subject Matter Expert (SME)Location:Gachibowli, Hyderabad (Work from Office)Company:Shubhanga PublicationsAbout UsShubhanga Publications is a leading educational publishing house with 400+ titles across CBSE, Karnataka, Andhra Pradesh, and Telangana syllabi, serving the K–10 segment. Our vision is to deliver high-quality, innovative, and engaging learning...

  • Science - Subject Matter Expert

    2 weeks ago

    Hyderabad, Telangana, India Mdn Edify Education Full time ₹ 6,00,000 - ₹ 12,00,000 per year

    MDN Edify Education is hiring a Science Subject Matter Expert for Grades 5–8. The role involves developing engaging content, designing curriculum, and providing academic support Required Candidate profileCandidates should have strong subject knowledge, excellent communication skills, and experience in school education. Must have laptop Qualification:...

  • DevOps Subject Matter Expert

    2 weeks ago

    Hyderabad, Telangana, India Randomtrees Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Job Title:DevOps Subject Matter Expert (SME) Veeva Development CloudJob Location: RemoteExperience Required: 8 12 yearsShift Timings: 4 PM - 1 AMDevOps Subject Matter Expert (SME) with deep expertise in process and toolchain assessments to support the Veeva Development Cloud (Quality, Regulatory, Safety). The SME will lead the discovery phase from offshore,...

  • Subject Matter Expert

    1 week ago

    Hyderabad, Telangana, India Locuz Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Subject Matter Expert Azure (SHI Complete and Expert support)Level : L3Exp: 7+ YrsLocation : HyderabadOverview:Azure Managed Services Providers are IT professionals responsible for managing and monitoring the operations and infrastructure of Azure cloud platformsExpertise with version control systems (such as Git, Azure DevOps). Deep understanding of Azure...

  • Snowflake Architect

    4 days ago

    Hyderabad, Telangana, India Saxon Global Full time ₹ 8,00,000 - ₹ 12,00,000 per year

    Snowflake Subject Matter Expert (SME)Local to Hyderabad. 5 days onsiteAs a Snowflake Subject Matter Expert (SME) you will be responsible for architecting, developing, and optimizing data warehouse and lakehouse solutions using the Snowflake platform.Your expertise will be crucial in enabling the Data team to build a modern, scalable data platform.You will...

  • Snowflake SME

    2 days ago

    Hyderabad, Telangana, India SuperIntelligence Technologies Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Snowflake Subject Matter Expert (SME)Job Location: HyderabadExperience: 10+ yearsAs a Snowflake Subject Matter Expert (SME) you will be responsible for architecting, developing, and optimizing data warehouse and lakehouse solutions using the Snowflake platform.Your expertise will be crucial in enabling the Data team to build a modern, scalable data...