Snowflake Data Engineer

Job Description

Snowflake Data Engineer – Semantic Layer & Analytics Engineering Location: India / Remote

Mode Operation: UK Working Hours 2pm to 10pm (IST) Rate: 30 Lacs+

Industry: Software Type: Contract

Duration: 12 Months Extendable Job Description

Snowflake Data Engineer – Semantic Layer, Analytics Engineering & Cortex AI Job Title

Snowflake Data Engineer – Semantic Layer, Analytics Engineering & Cortex AI Experience: 6–10 Years

Employment Type: Contract - 2 years Project Role Overview:

We are seeking a highly skilled and hands-on Snowflake Data Engineer with expertise in Semantic Layer, Analytics Engineering, Snowflake Cortex AI, and modern cloud data warehousing. This role requires end-to-end ownership of designing, building, optimizing, and supporting enterprise-grade data solutions that enable business intelligence, advanced analytics, and AI-driven insights. The ideal candidate should possess deep expertise in Snowflake Data Cloud, Dimensional Data Modeling, Gold Layer Development, dbt, Power BI, Cognos, and Snowflake Cortex, while working closely with business stakeholders, analytics teams, and BI developers.

Key Responsibilities: Design, develop, and optimize scalable data pipelines using Snowflake.

Design, build, and maintain Dimensional Data Models, including Star Schema, Fact Tables, and Dimension Tables. Develop and maintain Gold Layer business-ready datasets for enterprise reporting and analytics.

Design and implement Semantic Layers to enable self-service analytics and standardized business metrics. Build scalable and reusable data transformation pipelines using dbt (Data Build Tool).

Develop AI-ready datasets and leverage Snowflake Cortex capabilities for intelligent analytics, natural language processing, and AI-powered data applications. Optimize Snowflake SQL queries, warehouse sizing, clustering strategies, and overall platform performance.

Collaborate with Business Intelligence, Analytics, Product, and Business teams to understand reporting and analytical requirements. Develop and support dashboards and reports using Power BI and IBM Cognos.

Implement CI/CD pipelines and DevOps best practices for Data Engineering workflows. Ensure data quality, governance, security, and consistency across the platform.

Prepare technical documentation, architecture documents, and operational runbooks. Provide production support, troubleshoot incidents, perform Root Cause Analysis (RCA), and implement preventive solutions.

Drive continuous improvement through automation, monitoring, performance tuning, and operational excellence. Required Qualifications

Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or a related discipline. 8+ years of experience in Data Engineering and Cloud Data Warehousing.

Strong hands-on experience with Snowflake Data Cloud. Experience working with Snowflake Cortex AI services.

Expert-level SQL programming skills. Strong expertise in Dimensional Data Modeling, including:

Star Schema Fact & Dimension Modeling

Data Warehouse Design Experience developing Gold Layer and business-ready analytical datasets.

Strong understanding of Semantic Layer architecture and Analytics Engineering. Hands-on experience with dbt (Data Build Tool).

Experience with Power BI and IBM Cognos reporting and dashboard development. Expertise in ETL/ELT design and implementation.

Experience with Snowflake SQL Query Optimization, warehouse performance tuning, clustering, partitioning, and cost optimization. Knowledge of CI/CD, Git, version control, and deployment automation.

Experience implementing Data Quality, Data Validation, and Data Governance frameworks. Strong communication, stakeholder management, and problem-solving skills.

Preferred Skills: Snowflake Cortex AI / Snowpark / Python / Airflow / Azure Data Factory (ADF) / Azure DevOps / AWS or Azure Cloud / Power BI Premium / IBM Cognos Analytics / REST APIs / Data Catalog & Metadata Management / Agile/Scrum Methodologies

Core Technical Skills: Data Engineering / Snowflake Data Cloud / SQL / ETL/ELT / Data Warehousing / Analytics Engineering / Semantic Layer Design / Snowflake Cortex AI / Snowpark / Data Modeling / Star Schema / Fact & Dimension Modeling / Kimball Methodology / Gold Layer Development / Business-ready Dataset Development / BI & Reporting / Power BI / IBM Cognos / Dashboard Development / Data Visualization / Business Intelligence / Analytics Engineering / dbt / Semantic Models

Business Metrics / Data Transformation / Performance Optimization / Snowflake SQL Optimization / Warehouse Performance Tuning / Clustering Keys / Query Profiling / Cost Optimization / DevOps & Governance / Git / CI/CD / Azure DevOps / Data Quality / Data Governance / Documentation / Production Support / Incident Management / Root Cause Analysis (RCA) Primary Skills:

Snowflake / Snowflake Cortex AI / Snowpark / SQL / Data Modeling / Star Schema / Fact & Dimension Modeling / Gold Layer Development / Semantic Layer / Analytics Engineering / dbt / Power BI / IBM Cognos / ETL/ELT / Snowflake SQL / Optimization / Warehouse Performance Tuning / CI/CD / Git / Production Support / Incident Management / Root Cause Analysis (RCA) This version is comprehensive, ATS-friendly, and aligns with enterprise hiring requirements for a Snowflake Data Engineer – Semantic Layer, Analytics Engineering & Cortex AI role.

Regards, Victor