Experience
5 - 10 yrs
Job Location
Pune, India
Vacancy
1
Designation
Senior Data Engineer
Job Type
Not specified
Job Description
The Role
We are hiring a Senior Data Engineer to join our team within the Data Architecture & Engineering practice. You will design, build, and maintain data pipelines that power healthcare payer analytics - including claims processing, contract configuration, pricing edits, and fee schedule ingestion. This is hands-on engineering work in a Snowflake and AWS environment, not a management role.
Work You ll Do
- Design, develop, and maintain scalable data pipelines in Snowflake for healthcare claims, contract configuration, and fee-for-service reimbursement logic
- Build and optimize ELT processes using Snowflake SQL, stored procedures, and dynamic SQL for complex healthcare datasets
- Develop and maintain Apache Airflow DAGs (AWS MWAA) for pipeline orchestration, scheduling, and monitoring across multiple data domains
- Write clean, testable Python scripts for data transformation, validation, web scraping automation, and API integrations
- Implement and maintain CI/CD workflows using Bitbucket Pipelines and Liquibase for database migration and schema change management
- Support data quality and governance processes, including Snowflake role-based access control, dynamic data masking, and schema patterns
- Monitor pipeline health, troubleshoot failures, and resolve incidents across Snowflake, AWS Lambda, S3, SNS, and CloudWatch
- Leverage AI coding assistants to accelerate development, with a focus on review, refinement, and quality assurance of AI-generated output
- Collaborate with business analysts and project teams to translate healthcare business requirements into technical pipeline specifications
- Document technical processes, pipeline architecture, and operational runbooks in Confluence
- Other duties as assigned
Requirements
- 5+ years of hands-on data engineering experience
- Proficiency in Snowflake: ELT pipeline development, stored procedures, query optimization, data modeling (star, snowflake, and hybrid schemas)
- Strong SQL skills, including complex joins, window functions, CTEs, and dynamic SQL generation
- Solid Python experience in a data engineering context (Pandas, file processing, API clients, web scraping with BeautifulSoup or Scrapy)
- Experience with Apache Airflow for pipeline orchestration (AWS Managed Workflows for Apache Airflow preferred)
- Hands-on experience with AWS services: S3, Lambda, SNS, CloudWatch, IAM
- Proficiency with Git-based version control and CI/CD pipelines (Bitbucket Pipelines preferred)
- Experience with database migration tooling (Liquibase preferred)
- Demonstrated ability to work independently and manage priorities across concurrent workstreams
- Strong written and verbal communication skills in English, with the ability to collaborate effectively across time zones
- Experience working in globally distributed teams
Preferred Qualifications
- Healthcare payer domain experience: claims data, provider contracts, fee schedules, or pricing analytics
- Experience with data governance frameworks, HIPAA compliance, and PHI handling in cloud environments
- Familiarity with Power BI for data visualization and reporting
- Experience with AI-assisted development tools (Claude Code, GitHub Copilot, or similar)
- Familiarity with Terraform or infrastructure-as-code practices
- Unit testing and test-driven development practices for data pipelines
- Agile delivery experience (Scrum or Kanban), including sprint planning and backlog management in Jira
- Bachelor s degree in Computer Science, Engineering, or a related field (or equivalent practical experience)
No Referrers Available
There are currently no referrers available for this job. You can still apply, will let you know once there is any referrer available.
