Data Engineer – Data Platforms (Snowflake)

Role Overview 

We are seeking a seasoned Data Engineer (Snowflake Specialist) with over 7 years of hands-on 

experience to lead the development of our enterprise data infrastructure. In this role, you will 

architect, build, and optimize scalable, end-to-end data pipelines that ingest, transform, and 

serve critical public sector data assets. Working directly on-site at our Bengaluru delivery center, 

you will leverage Snowflake and multi-cloud environments (AWS/Azure) to deliver robust data 

layers that power business intelligence, advanced analytics, and strategic reporting across the 

organization. 

Key Responsibilities 

Architect & Modernize Pipelines: Design, build, and maintain high-throughput end-to

end batch and streaming ELT/ETL pipelines to ingest data from APIs, event streams, 

legacy flat files, and relational/NoSQL databases into Snowflake. 

Engineered Transformations: Develop complex data transformations and business logic 

using Snowflake SQL, Python, User-Defined Functions (UDFs), and stored procedures 

tailored for enterprise-scale processing. 

Optimize Snowflake Infrastructure: Spearhead Snowflake performance management 

and platform cost governance through query tuning, dynamic warehouse sizing, micro

partition clustering, and automated resource monitoring. 

Implement Tiered Data Modeling: Design and implement scalable data architectures 

across staging, curated, and consumption layers to support BI toolsets, ad-hoc analytics, 

and enterprise reporting demands. 

Automate Cloud Data Flow: Configure automated continuous ingestion workflows using 

Snowpipe, Streams & Tasks, and cloud-native orchestration tools integrated with AWS 

and Azure storage and messaging services. 

Champion Platform Governance: Enforce public-sector level security protocols, data 

quality frameworks, operational reliability standards, and modern CI/CD data pipeline 

deployment methodologies. 

Technical Skill Requirements 

Category Required Stack & Competencies 

Data 

Warehousing 

Snowflake (Core): Snowpipe, Streams & Tasks, Clustering, 

Warehouse Management, Query Optimization 

Languages & 

Scripting 

Advanced SQL, Python (PySpark/Pandas experience preferred), 

Snowflake UDFs & Stored Procedures 

Cloud Platforms AWS & Azure: Object Storage (S3 / ADLS), Cloud Integration, Event 

Messaging Services 

Data Architecture Multi-tier Data Modeling (Staging, Refined, Consumption), Schema 

Design, ETL/ELT Design Patterns 

Experience Level 7+ Years in Data Engineering with dedicated, hands-on enterprise 

Snowflake delivery 

Professional Competencies 

Systemic Problem Solving: Deep diagnostic capability to troubleshoot complex, low

latency performance issues across distributed multi-cloud pipelines. 

Cross-Functional Engagement: Ability to articulate technical trade-offs, capacity 

planning, and data delivery timelines to business stakeholders, data scientists, and cloud 

engineers. 

Domain Expertise: Strong understanding of security, compliance, and governance 

frameworks relevant to large-scale Public Sector data environments. 

Operational Discipline: Proven track record of managing data quality, pipeline 

monitoring, and fault-tolerant automated retry mechanisms.

Thanks & Regards,

Buchi Raj – TA Specialist

[HIDDEN TEXT]

9100-2627-90