Snowflake Engineer (Mid-Level)

Req ID:    

We are currently seeking a Snowflake Engineer (Mid-Level) to join our team in Bangalore, Karnātaka (IN-KA), India (IN).

"Job Duties: We are seeking a Mid-Level Snowflake Engineer to design, develop, and support data solutions on the Snowflake Data Cloud for an insurance client. The role focuses on building scalable, reliable data pipelines and analytical models that support underwriting, claims, pricing, risk, and regulatory reporting.
This is a hands-on engineering role working closely with data architects, data scientists, BI teams, and business stakeholders within an Agile delivery model.

Experience Requirements
• Total Experience: 4–7 years in data engineering / analytics roles
• Relevant Snowflake Experience: 2–4+ years hands-on
• Insurance Domain Experience: Preferred (P&C, Life, Health, or Reinsurance)

Key Responsibilities
• Design and develop Snowflake-based data models supporting insurance use cases (policy, claims, customer, risk)
• Build and optimize SQL-based ELT pipelines for large insurance datasets
• Implement performance tuning and cost optimization in Snowflake:
o Query optimization
o Warehouse sizing and clustering
• Support ingestion of data from core insurance systems (policy admin, claims, billing)
• Implement basic data quality and reconciliation checks
• Collaborate with BI and analytics teams to enable dashboards, reports, and advanced analytics
• Support Agile delivery activities and production support

Minimum Skills Required: Required Technical Skills
• Advanced SQL (complex joins, window functions, performance tuning)
• Hands-on Snowflake experience:
o Virtual warehouses
o Time travel and zero-copy cloning
o Secure data sharing
• Strong understanding of data warehousing and dimensional modelling
• Experience working with structured and semi-structured insurance data
• Familiarity with version control and CI/CD practices

Insurance Domain:
• Experience working with insurance data such as:
o Policy, endorsement, and coverage data
o Claims and loss data
o Premium, billing, and payments
o Customer and risk attributes
• Awareness of data accuracy, lineage, and audit requirements in regulated insurance environments

Nice to Have
• Snowflake certification
• Exposure to actuarial or risk analytics datasets
• Experience with BI tools (Power BI, Tableau)
• Experience in regulated financial services environments"

About NTT DATA

NTT DATA is a $30 billion business and technology services leader, serving 75% of the Fortune Global 100. We are committed to accelerating client success and positively impacting society through responsible innovation. We are one of the world's leading AI and digital infrastructure providers, with unmatched capabilities in enterprise-scale AI, cloud, security, connectivity, data centers and application services. our consulting and Industry solutions help organizations and society move confidently and sustainably into the digital future. As a Global Top Employer, we have experts in more than 50 countries. We also offer clients access to a robust ecosystem of innovation centers as well as established and start-up partners. NTT DATA is a part of NTT Group, which invests over $3 billion each year in R&D.