Snowflake Subject Matter Expert

5 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

    1 week ago

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

    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...

  • Subject Matter Expert

    1 week ago

    Hyderabad, Telangana, India d0011bc3-53ad-41c0-a40a-a55b7caa8699 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

    1 day 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

    5 days ago

    Hyderabad, Telangana, India Cognizant Full time ₹ 5,00,000 - ₹ 15,00,000 per year

    Subject Matter Expert - Loan Originations live underwritingJob SummaryWe are seeking a Subject Matter Expert in Loan Originations with 4 to 6 years of experience to join our team. The ideal candidate will have strong expertise in MS Excel and a good understanding of Post Close Underwriting and Underwriting. This role requires working from the office during...

  • Subject Matter Expert

    5 days ago

    Hyderabad, Telangana, India Cognizant Technology Solutions Full time ₹ 10,000 - ₹ 20,000 per year

    Loan Underwriter IV (US) - Subject Matter ExpertJob Profile Summary: The Underwriter IV underwrites and evaluates the most complex conventional, FHA, VA, and CRA Residential Mortgage applications in compliance with bank policies and procedures. This job also underwrites and evaluates Home Equity and Consumer Loans.Depth & Scope:Underwrites complex...

  • 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

    1 day 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...

  • Subject Matter Expert Primary( Math

    7 days ago

    Hyderabad, Telangana, India Mdn Edify Education Full time ₹ 2,00,000 - ₹ 8,00,000 per year

    Looking for Subject Matter Experts for Math and Hindi with 2–6 yrs experience. Responsibilities include content creation, worksheets, assessments, and academic support. Strong subject knowledge, communication, and curriculum understanding required. Required Candidate profileSME Math & Hindi SMEs to design curriculum resources, improve learning materials,...

  • Subject Matter Expert

    1 week ago

    Hyderabad, Telangana, India MDN Edify Education Full time ₹ 2,00,000 - ₹ 6,00,000 per year

    About Edify Education:Edify Education is a leading name in K–12 schooling, known for its learner-centered approach and innovative academic programs. We are dedicated to fostering excellence in education through creative curriculum design and continuous teacher development.Role Overview:The Subject Matter Expert – Primary Hindi will be responsible for...

  • Subject Matter Expert Azure

    1 week ago

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

    Subject Matter Expert Azure (SHI Complete and Expert support)Overview: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 core services including Azure Compute,...