Snowflake Data Engineer - Semantic Layer

EXL

Hyderabad, Pune District, Bengaluru

Hybrid

INR 2,800,000 - 5,000,000

Full time

6 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

EXL is seeking a Sr. Snowflake Data Engineer with Semantic Layer expertise to design, develop, and optimize enterprise-scale data platforms. You will build governed, business-friendly data models to enable self-service analytics and consistent reporting across the organization.

The role focuses on Snowflake Data Cloud, data modeling, ELT/ETL development, and BI integration, with emphasis on governance, performance tuning, and collaboration with business stakeholders.

Qualifications

  • Experience designing enterprise semantic layers for self-service analytics.

Responsibilities

  • Design, develop, and maintain scalable Snowflake pipelines.

Skills

Snowflake Data Cloud
SQL
Python
ETL/ELT
Data modeling
BI integration
Cloud platforms

Education

Bachelor's degree in CS/IT
Master's degree preferred
SnowPro Core Certification
SnowPro Advanced Data Engineer

Tools

dbt Semantic Layer
AtScale
Cube
LookML (Looker)
Power BI Semantic Models
Power BI/Tableau/Looker integrations
Azure/AWS/GCP

Job description

Sr. Snowflake Data Engineer - Semantic Layer

Location: Hybrid

We are seeking an experienced Snowflake Data Engineer with Semantic Layer expertise to design, develop, and optimize enterprise-scale data platforms. The ideal candidate will have strong experience in Snowflake Data Cloud, data modeling, semantic layer design, ELT/ETL development, and BI reporting integration. The role involves building governed, business-friendly data models that enable self-service analytics and consistent reporting across the organization.

Key Responsibilities

Snowflake Data Engineering

  • Design, develop, and maintain scalable data pipelines on Snowflake.
  • Implement ELT/ETL processes using Snowflake, SQL, Python, and cloud-native data integration tools.
  • Optimize Snowflake performance through clustering, partitioning, query tuning, and warehouse sizing.
  • Build and manage data ingestion frameworks for structured and semi-structured data.
  • Implement data security, governance, and access control policies within Snowflake.
Semantic Layer Development
  • Design and maintain enterprise semantic models that provide a single source of truth for business metrics.
  • Build reusable business definitions, KPIs, metrics, dimensions, and hierarchies.
  • Develop governed semantic layers supporting self-service analytics.
  • Ensure consistency across reporting and analytics platforms.
  • Collaborate with business stakeholders to translate business requirements into semantic models.
Data Modeling
  • Design dimensional models (Star Schema and Snowflake Schema).
  • Create fact and dimension tables optimized for analytics workloads.
  • Develop data marts supporting multiple business domains.
  • Apply data warehousing best practices and industry standards.
BI & Analytics Integration
  • Integrate semantic models with BI tools such as Power BI, Tableau, Looker, Sigma, or ThoughtSpot.
  • Support reporting, dashboards, and ad-hoc analytics requirements.
  • Enable governed self-service reporting capabilities.
  • Ensure data accuracy and consistency across analytical platforms.
Data Quality & Governance
  • Implement data quality checks and validation frameworks.
  • Create reconciliation processes and monitoring dashboards.
  • Maintain metadata, lineage, cataloging, and documentation.
  • Support data governance and compliance requirements.
Technical Skills
  • Strong expertise in Snowflake Data Cloud.
  • Advanced SQL development and optimization.
  • Experience with Semantic Layer technologies such as:
    • Snowflake Semantic Model
    • dbt Semantic Layer
    • AtScale
    • Cube
    • LookML (Looker)
    • Power BI Semantic Models
  • Data Warehousing and Dimensional Modeling.
  • ETL/ELT development expertise.
  • Python programming.
  • Experience with cloud platforms:
    • AWS, Azure, GCP
Data Integration Tools
  • Dbt, Fivetran, Matillion, Informatica, ADF (Azure Data Factory), Airflow
BI & Visualization Tools
  • Power BI, Tableau, Looker, Sigma Computing, ThoughtSpot
Version Control & DevOps
  • Git, GitHub / GitLab / Azure DevOps, CI/CD, Agile delivery methodologies
Preferred Qualifications
  • Bachelor's or Master's degree in Computer Science, Information Technology, or related field.
  • Snowflake Certification:
    • SnowPro Core Certification (Preferred)
    • SnowPro Advanced Data Engineer (Preferred)
  • Experience implementing enterprise semantic layer architecture.
  • Experience working in large-scale cloud analytics environments.
Nice to Have
  • Experience with Data Vault 2.0.
  • Knowledge of AI/ML data preparation pipelines.
  • Experience with Microsoft Fabric or Databricks.
  • Exposure to data catalog and governance tools such as Collibra, Alation, or Microsoft Purview.
Key Competencies
  • Strong stakeholder management skills.
  • Business requirement analysis and translation.
  • Problem-solving and analytical thinking.
  • Data governance and quality mindset.
  • Excellent communication and collaboration skills.
  • Leadership and mentoring capabilities.
The successful candidate will
  • Deliver a scalable and governed Snowflake data platform.
  • Build robust semantic models that standardize business metrics.
  • Enable self-service analytics across business functions.
  • Improve reporting consistency, data quality, and query performance.
  • Drive adoption of modern data engineering and semantic modeling best practices.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer Snowflake
Data Engineer Snowflake

ExlService Holdings, Inc. • Gurugram District

On-site
INR 1,200,000 - 2,400,000
Data Engineer
Data Engineer

Unison Group • Hyderabad

On-site
INR 600,000 - 1,200,000
Snowflake Architect
Snowflake Architect

Ascendion • Bengaluru

Hybrid
INR 3,500,000 - 7,000,000
Associate Principal Engineer
Associate Principal Engineer

Nagarro • Hyderabad

On-site
INR 4,000,000 - 7,000,000
Snowflake Data Engineer
Snowflake Data Engineer

Genpact Ltd. • Hyderabad, Bengaluru, Delhi

On-site
INR 3,500,000 - 7,000,000
Semantic Layer Architect
Semantic Layer Architect

EXL • Hyderabad, Pune District, Bengaluru

Hybrid
INR 1,200,000 - 2,400,000
Snowflake Architect, Data Warehousing
Snowflake Architect, Data Warehousing

Cvent, Inc. • Gurugram District

On-site
INR 1,800,000 - 3,600,000
Senior Snowflake Developer | Snowflake DW, Advanced SQL, Python
Senior Snowflake Developer | Snowflake DW, Advanced SQL, Python

Tata Consultancy Services Limited • Khordha, Hyderabad, Bengaluru

On-site
INR 1,200,000 - 2,600,000
Data Engineer
Data Engineer

Fa Ewjt Saasfaprod1 • Gurugram District

On-site
INR 600,000 - 1,200,000
Snowflake Data Architect – R01573923
Snowflake Data Architect – R01573923

Brillio • Bengaluru

On-site
INR 4,500,000 - 6,000,000