Software Engineer / Senior Software Engineer - Snowflake

Legato; Bengaluru; Hybrid; INR 900,000 - 1,500,000; Full time

Job summary

Legato in Bengaluru, India is seeking a data engineer with strong Snowflake, SQL, and Python skills to design and maintain scalable data solutions for healthcare datasets. The role involves building data pipelines, optimizing queries, and ensuring data quality and compliance.

You will collaborate with analysts and stakeholders to translate requirements into technical data solutions and contribute to best practices in data engineering and analytics.

Qualifications

• 3-7 years of experience in data engineering or software engineering.
• Strong hands-on Snowflake experience including data modeling and SQL optimization.
• Expert-level SQL skills for data analysis, transformation and validation.
• Strong understanding of data warehousing concepts, dimensional modeling, ETL/ELT patterns.

Responsibilities

• Design, develop, and maintain scalable data solutions.
• Build and optimize complex SQL queries, views and transformations for healthcare datasets.
• Develop and manage data pipelines, semantic models, and data products.

Skills

Snowflake

SQL

Python

Data modeling

Job description

JOB RESPONSIBILITY :

• Design, develop, and maintain scalable data solutions using Snowflake.
• Build and optimize complex SQL queries, views, and transformations for largescale healthcare datasets.
• Should have experience to Python
• Develop and manage data pipelines, semantic models, and data products using Microsoft Data Fabric components (Lakehouse, Dataflows, Warehouses, Pipelines).
• Analyze healthcare data (claims, eligibility, provider, clinical, pharmacy) to support reporting, analytics, and business insights.
• Collaborate with business analysts and stakeholders to translate healthcare business requirements into technical data solutions.
• Ensure data quality, accuracy, performance optimization, and adherence to healthcare data standards.
• Perform rootcause analysis for data issues and implement robust, scalable fixes.
• Support UAT, data validation, reconciliation, and production support activities.
• Ensure compliance with healthcare regulations and internal data governance standards (HIPAA, PHI/PII handling).
• Contribute to design reviews, code reviews, and best practices for data engineering and analytics solutions.

EXPERIENCE:

• 3-7 years of experience in data engineering / software engineering roles.
• Strong handson experience with Snowflake (data modeling, performance tuning, SQL optimization), Python
• Expertlevel SQL skills for data analysis, transformation, and validation.
• Strong understanding of data warehousing concepts, dimensional modeling, and ETL/ELT patterns.
• Experience working with large, complex datasets in cloud data platforms.