Senior Data Engineer

Jobtailor; Pune District; On-site; INR 1,500,000 - 3,000,000; Full time

Job summary

Jobtailor in Pune, India is seeking a seasoned Data Engineer to design, build, and maintain scalable ETL/ELT pipelines for healthcare data ingestion, transformation, and delivery. You will work with claims, EHR/EMR, eligibility, and third-party datasets to drive accurate data integration.

You will develop stored procedures in SQL Server, implement complex T-SQL transformations, optimize query performance, and leverage Azure data services such as Data Factory, Synapse, and Databricks.

Qualifications

• Bachelor’s degree or equivalent experience in CS/Engineering or related field.
• 5+ years of data engineering experience, preferably in healthcare or regulated data.
• Strong SQL and T-SQL skills, with complex stored procedures and transformations.
• Experience with SQL Server performance tuning and indexing strategies.
• Strong Python skills and Azure data services experience.
• Experience designing ETL/ELT workflows and data pipelines.
• Knowledge of healthcare data structures and data warehousing.
• Familiarity with DevOps, CI/CD, and Git.

Responsibilities

• Design, build, and maintain scalable ETL/ELT pipelines for healthcare data ingestion, transformation, and delivery.
• Develop and optimize SQL Server stored procedures and data transformations across pipelines.
• Implement complex T-SQL mapping, validation, aggregation, and data standardization.
• Optimize performance of queries, procedures, and ETL processes for large-scale data.
• Develop data solutions using Azure Data Factory, Synapse, Azure SQL, Databricks, and Data Lake.
• Lead data onboarding and client data integration efforts with cross-functional teams.
• Ensure data quality, integrity, reconciliation, and auditability; uphold HIPAA/PHI handling standards.
• Design data models, mappings, and transformations for reusable assets; document thoroughly.
• Troubleshoot pipeline failures, performance issues, and defects; contribute to process improvements.
• Mentor junior engineers and promote best practices in data engineering and documentation.

Skills

ETL/ELT Pipeline Development

SQL Server Performance Tuning

Azure Data Services

Healthcare Data Structures

Data Governance and Compliance

Education

Bachelor's degree in Computer Science/Engineering or related field

Tools

Azure Data Factory

Azure Synapse

Azure SQL

Databricks

Blob Storage

Git

Job description

• Design, build, and maintain scalable ETL/ELT pipelines supporting healthcare data ingestion, transformation, and delivery
• Sources may include claims, EHR/EMR, eligibility, pharmacy, and third-party datasets
• Develop and maintain SQL Server stored procedures that drive core data transformation logic across client-specific and standardized pipelines
• Implement complex transformation logic using T-SQL, including mapping, validation, aggregation, and data standardization
• Optimize performance of SQL queries, stored procedures, and ETL processes to ensure efficient large-scale data processing
• Develop and optimize data solutions within Azure (Data Factory, Synapse, Data Lake, SQL, Databricks)
• Lead efforts in data onboarding and implementation, ensuring timely and accurate client data integration
• Partner closely with Professional Services, Product, DevOps, and Analytics teams to gather requirements and deliver data solutions
• Ensure data quality, integrity, and validation, including reconciliation and audit processes for healthcare datasets
• Implement and maintain data governance and compliance standards, including HIPAA and PHI handling requirements
• Design and document data models, mappings, and transformation logic for standardized and reusable data assets
• Support troubleshooting and resolution of data pipeline failures, performance issues, and client-impacting defects
• Contribute to process improvement initiatives to streamline onboarding, reduce implementation timelines, and enhance data reliability
• Mentor junior team members and promote best practices in data engineering and documentation

Requirements

• Bachelor’s degree in Computer Science, Engineering, or related field (or equivalent experience)
• 5+ years of experience in data engineering, preferably within healthcare or regulated data environments
• Strong proficiency in SQL and T-SQL, with hands-on experience building complex stored procedures and data transformations
• Experience with SQL Server performance tuning, query optimization, and indexing strategies
• Strong Python (or similar programming language) skills
• Hands-on experience with Azure data services (e.g., Data Factory, Synapse, Azure SQL, Blob Storage/Data Lake)
• Experience designing and managing ETL/ELT workflows and data pipelines
• Solid understanding of healthcare data structures (claims, encounters, provider, member, etc.)
• Experience with data warehousing and modeling (star schema, dimensional modeling)
• Familiarity with DevOps practices, CI/CD pipelines, and version control (Git)

Core Competencies

Demonstrates expertise in designing and maintaining scalable ETL/ELT pipelines, with a strong focus on healthcare data ingestion and transformation. Proficient in SQL, T-SQL, and Azure data services, ensuring data quality, compliance, and effective collaboration across teams.

Highest-signal resume keywords

• ETL/ELT Pipeline Development
• SQL Server Performance Tuning
• Azure Data Services
• Healthcare Data Structures
• Data Governance and Compliance

ATS Optimization Keywords

Hard Skills

• SQL
• T-SQL
• Python
• Data Transformation
• Data Warehousing
• Data Modeling
• Performance Optimization
• Stored Procedures
• Data Quality Assurance
• Data Governance

Soft Skills

• Mentoring
• Collaboration
• Process Improvement

Industry Keywords

• Healthcare Data
• HIPAA Compliance
• PHI Handling
• Data Integration
• Data Pipeline Management

Tools & Technologies

• Azure Data Factory
• Azure Synapse
• Azure SQL
• Databricks
• Blob Storage
• Git