Snowflake Data Engineer

NLB Services; Dadri; On-site; INR 2,000,000 - 3,600,000; Full time

Job summary

NLB Services is seeking a Data Warehouse Engineer to lead Snowflake analytics ecosystems, design scalable models, and optimize performance across enterprise reporting platforms such as SAP BO/Web Intelligence.

You will collaborate with Platform Administrators and BI teams to ensure secure, scalable, and cost-efficient data solutions aligned with enterprise architecture standards.

Qualifications

• Snowflake SQL: 5+ years of advanced SQL development, optimization and ETL/ELT in Snowflake.
• Snowflake Administration: 3+ years, including RBAC, security, and cost governance.
• dbt: 4+ years designing and maintaining scalable data transformations with CI/CD.
• Git: 5+ years using Git-based source control for collaborative development.
• CI/CD: 5+ years implementing pipelines for data warehouse deployments.
• Financial services experience: Preferred.
• Business Objects (SAP BO/Web Intelligence): Preferred.

Responsibilities

• Design enterprise Snowflake data models with conformed dimensions and semantic views.
• Develop advanced SQL transformations across Snowflake layers and optimize performance.
• Coordinate deployments via Git/CI-CD and ensure release readiness across environments.
• Monitor and optimize compute usage, cost, and performance metrics.
• Implement RBAC, security policies, and data sharing controls across platforms.
• Collaborate with data engineers and BI teams to optimize datasets for analytics tools.
• Maintain documentation, lineage, and governance for transformations.
• Support enterprise reporting platforms (Web Intelligence) uptime and escalation.

Skills

Snowflake SQL

Snowflake Administration

dbt

Git / Version Control

CI/CD Pipelines

Financial services experience

Business Objects (SAP BO/WebI)

Tools

GitHub/GitLab/Bitbucket

Job description

Role Overview

The Data Warehouse Engineer serves as the primary technical lead for the Snowflake data warehousing ecosystem. This role is responsible for designing scalable data models, managing Snowflake environments, optimizing performance and cost, enforcing security policies, and supporting analytics and enterprise reporting platforms, including Business Objects (BIC), across the organization. The DW Engineer ensures that Snowflake is stable, secure, and aligned with enterprise architecture standards, and collaborates with Platform Administrators and thirdparty vendors to ensure reporting platform uptime and timely escalation of issues impacting reporting availability.

Key Responsibilities

Data Modeling & Architecture

• Design enterpriselevel Snowflake models including conformed dimensions, fact tables, and semantic views.
• Document ERDs, modeling assumptions, and physical/logical architectures.
• Establish and enforce modeling standards, naming conventions, and performance optimization patterns.

Transformation & Automation

• Build advanced SQL transformations across all Snowflake layers.
• Implement automated workflows using Tasks, Streams, procedures, and timebased orchestration.
• Support schema evolution and largescale data integration patterns.

Environment & Release Management

• Coordinate Snowflake schema and object deployments via Git or CI/CD pipelines.
• Own release readiness for Snowflake across Dev, Test, and Prod.
• Ensure new models, views, RBAC changes, and stored procedures are validated prior to promotion.

Performance Optimization

• Conduct performance tuning through micropartition analysis, clustering, query plan reviews, and caching strategies.
• Implement Resource Monitors, usage alerts, and proactive performance dashboards.
• Review warehouse utilization to ensure compute resources are rightsized and costoptimized.

Security, RBAC & Controls

• Design and maintain Snowflake role hierarchies, object privileges, rowlevel security, and masking policies.
• Support audit requests, compliance checks, and evidence gathering for reviews.
• Govern secure internal and external data sharing.

Cost Management

• Produce recurring consumption reports to support conduct cost optimization analysis.
• Recommend improvements in warehouse sizing, retention policies, storage optimization, and compute scheduling.

CrossFunctional Collaboration

• Work with Data Engineers to coordinate ingestion design, transformation logic, and schema updates.
• Partner with BI teams to optimize datasets for Power BI, Qlik, and analytical tools.
• Align with Platform Administrators on environment setup, migrations, and operational readiness.

Documentation & Governance

• Maintain transformation specifications, lineage, and architectural diagrams.
• Ensure models and pipelines comply with governance policies and development standards.

Enterprise Operational Reporting Platform (Web Intelligence)

• Collaborate with Platform Administrators and the vendor to ensure reporting platform uptime and timely escalation of reporting issues.

Skills & Tools Requirements

• Snowflake SQL: 5+ years of advanced SQL development experience, including complex query optimization, data modeling, performance tuning, and ETL/ELT development within Snowflake environments.
• Snowflake Administration: 3+ years of hands-on experience administering Snowflake platforms, including security, role-based access control (RBAC), warehouse management, monitoring, performance optimization, and cost governance.
• dbt (Data Build Tool): 4+ years of experience designing, developing, and maintaining scalable data transformation frameworks using dbt, including testing, documentation, and CI/CD integration.
• Git / Version Control: 5+ years of experience using Git-based source control systems (GitHub, GitLab, or Bitbucket) for collaborative development, branching strategies, code reviews, and release management.
• CI/CD Pipelines & Deployment Automation: 5+ years of experience implementing and supporting CI/CD pipelines for data warehouse and analytics deployments, including automated testing, code promotion, release management, and deployment automation using Azure DevOps, GitHub Actions, GitLab CI/CD, or equivalent platforms
• Financial services experience: Preferred.
• Business Objects (SAP BO/Web Intelligence): Preferred.