Snowflake Data Engineer

Persistent Systems Limited; Pune District; Hybrid; INR 3,000,000 - 4,500,000; Full time

Benefits offered by this job

Growth opportunities

Flexible hours

Long service awards

Insurance coverage

Hybrid work

Job summary

Persistent Systems Limited is seeking a Snowflake Data Engineer to design and optimize enterprise data platforms. You will build scalable ETL/ELT pipelines, implement Snowpipe-based ingestion, and ensure governance and data quality across cloud data platforms.

The role demands 10–12 years of data warehousing experience, strong Snowflake expertise, and proficiency in SQL. Hybrid work arrangement and global projects are offered.

Qualifications

• 10+ years in Data Warehousing, Data Engineering, analytics platforms.
• Strong Snowflake development and administration experience.
• Advanced SQL with complex transformations and performance tuning.

Responsibilities

• Design, develop, and maintain Snowflake data warehouses, data marts, and enterprise platforms.
• Develop and optimize SQL queries, views, and procedures.
• Build scalable ETL/ELT pipelines for batch and real-time processing.
• Implement data ingestion using Snowpipe and external stages.
• Ensure data governance, security controls, and data quality.

Skills

Snowflake Data Engineer

SQL proficiency

ETL/ELT design

Data warehousing

Data governance

Cloud platforms

Tools

Snowflake

Snowpipe

External stages

Cloud storage

RBAC & masking

Job description

We are an AI-led, platform-driven Digital Engineering and Enterprise Modernization partner, combining deep technical expertise and industry experience to help our clients anticipate what's next. Our offerings and proven solutions create a unique competitive advantage for our clients by giving them the power to see beyond and rise above. We work with many industry-leading organizations across the world, including 20 Fortune 50 companies and 4 of the 5 top banks in both the US and India, and numerous innovators across the healthcare ecosystem.

We are seeking a highly skilled Snowflake Data Engineer with strong expertise in Snowflake, SQL, Data Warehousing, ETL/ELT processes, and Cloud Data Platforms. The ideal candidate will be responsible for designing, developing, and optimizing scalable data solutions while ensuring high performance, security, governance, and data quality across enterprise data platforms. The role requires extensive experience in Snowflake architecture, data integration, performance optimization, data transformation, and cloud-based analytics solutions. You will collaborate with business stakeholders, analytics teams, data architects, and engineering teams to build reliable and scalable data ecosystems that support business intelligence and advanced analytics initiatives.

• Role: Snowflake Data Engineer
• Location: All Persistent Locations
• Experience: 10 to 12 Years
• Job Type: Full-Time Employment

What You'll Do:

• Design, develop, and maintain Snowflake data warehouses, data marts, and enterprise data platforms.
• Develop and optimize complex SQL queries, views, stored procedures, and database objects.
• Build scalable ETL and ELT pipelines for batch and near real-time data processing.
• Implement data ingestion frameworks using Snowpipe, COPY commands, external stages, and cloud storage integrations.
• Design and develop data transformation, cleansing, and validation processes.
• Work with structured and semi-structured data formats including JSON, Parquet, CSV, and XML.
• Optimize Snowflake performance by managing compute resources, clustering, partitioning, and query tuning.
• Implement data governance, security controls, RBAC, masking policies, and access management frameworks.
• Design scalable solutions for reporting, analytics, and business intelligence workloads.
• Collaborate with business users, analysts, and architects to understand data requirements and translate them into technical solutions.
• Support enterprise data migration and modernization initiatives.
• Monitor production environments and troubleshoot performance, data quality, and integration issues.
• Implement data quality frameworks and monitoring controls.
• Participate in architecture reviews and recommend improvements for scalability and performance.
• Create technical documentation, data models, data dictionaries, and operational procedures.
• Support CI/CD, release management, and deployment activities for data platforms.
• Ensure compliance with enterprise security and governance standards.

Expertise You'll Bring:

• 10–12 years of experience in Data Warehousing, Data Engineering, and Analytics platforms.
• Strong hands‑on expertise in Snowflake Data Warehouse development and administration.
• Advanced SQL development skills including query optimization, stored procedures, views, and complex transformations.
• Extensive experience designing and implementing ETL/ELT pipelines.
• Strong understanding of dimensional data modeling, star schema, snowflake schema, and data warehouse concepts.
• Experience implementing data ingestion and integration solutions using Snowpipe and external stages.
• Strong knowledge of structured and semi‑structured data processing.
• Experience working with cloud platforms such as AWS, Azure, or Google Cloud.
• Strong understanding of Snowflake architecture, performance tuning, workload optimization, and cost management.
• Experience implementing RBAC, masking policies, data governance, and security controls within Snowflake.
• Knowledge of data quality frameworks, metadata management, and data governance practices.
• Experience supporting production environments and resolving complex data issues.
• Strong understanding of data integration, data migration, and modernization projects.
• Familiarity with orchestration and scheduling tools for data pipelines.
• Experience working with reporting, analytics, and business intelligence platforms.
• Knowledge of CI/CD practices, DevOps methodologies, and release management processes.
• Strong analytical, troubleshooting, and problem‑solving capabilities.
• Excellent communication and stakeholder management skills.
• Experience working in Agile and Scrum-based delivery environments.
• Ability to mentor junior developers and contribute to technical leadership initiatives.
• Competitive salary and benefits package
• Culture focused on talent development with quarterly growth opportunities and company-sponsored higher education and certifications
• Opportunity to work with cutting‑edge technologies
• Employee engagement initiatives such as project parties, flexible work hours, and Long Service awards
• Insurance coverage: group term life, personal accident, and Mediclaim hospitalization for self, spouse, two children, and parents

Values-Driven, People-Centric & Inclusive Work Environment:

Persistent is dedicated to fostering diversity and inclusion in the workplace. We invite applications from all qualified individuals, including those with disabilities, and regardless of gender or gender preference. We welcome diverse candidates from all backgrounds.

• We support hybrid work and flexible hours to fit diverse lifestyles.
• Our office is accessibility-friendly, with ergonomic setups and assistive technologies to support employees with physical disabilities.
• If you are a person with disabilities and have specific requirements, please inform us during the application process or at any time during your employment

"Persistent is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind."