AArete Careers - Senior Data Engineer
Job description
AArete Careers { "@context": "http://schema.org", "@type": "JobPosting", "datePosted": "2026-04-07", "description": "
\u00A0
\u00A0
\u00A0
Senior Data Engineer
\u00A0
AArete is one-of-a-kind when it comes to consulting firm culture.
\u00A0\u00A0
We\u2019re a global, innovative management and technology consulting firm with offices in the U.S. and India. Our name comes from the Greek word for excellence: \u201CAret\u00E9.\u201D\u00A0 And excellence is exactly what we strive for.\u00A0\u00A0
\u00A0
We\u2019re celebrating our fourth year as one of Forbes\u2019 World\u2019s Best Management Consulting Firms \u2013 and our success starts with our people. From robust career development planning to competitive life and wellness benefits, AArete\u2019s \u201CCulture of Care\u201D takes a holistic approach to the employee experience.\u00A0\u00A0
\u00A0\u00A0
AAretians (our team members) are leaders at every level. You are encouraged to unlock your full potential by directly contributing to our mission and prioritizing personal development and fulfillment.\u00A0
\u00A0
\u00A0
The Role
\u00A0
We are hiring a Senior Data Engineer to join our Payment Intelligence (PI) 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.
\u00A0
Work You\u2019ll Do
\u00A0
- 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
\u00A0
Requirements
\u00A0
- 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
\u00A0
\u00A0
Preferred Requirements
\u00A0
- 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\u2019s degree in Computer Science, Engineering, or a related field (or equivalent practical experience)
\u00A0
Benefits
\u00A0
- Flexible Paid Time Off of up to 23 days annually, in addition to 10 paid public holidays
- Hybrid work model with flexible in-office attendance
- Comprehensive health benefits including medical insurance (Mediclaim), personal accident insurance, and term life insurance
- Generous paid parental leave program
- Attractive employee referral bonus scheme
- Transportation allowance and night shift allowance
- Employee advance salary loan facility
- Structured professional certification reimbursement policy to support ongoing learning and development
\u00A0
We put humans at the center of our work\u00A0
\u00A0\u00A0
We\u2019re a global management and technology consulting firm specializing in strategic profitability improvement, digital transformation, and strategy & change for clients. Our cross-industry solutions are powered by a digital-first mindset, market intelligence, and data-driven approach to deliver purposeful change, actionable insights, and guaranteed results.
\u00A0\u00A0
But what sets us apart is our people. We are guided by our deeply embedded guiding principles: Excellence, Passion, Loyalty to Clients, Stewardship, Family, Community, Sustainability, and Inclusion.\u00A0\u00A0
\u00A0\u00A0
And we\u2019ve been recognized as a top firm to work for by companies like Forbes, Top Workplaces Chicago Tribune, and Consulting Magazine.\u00A0\u00A0
\u00A0\u00A0
We\u2019ve earned a Great Place to Work Certification\u2122 and been named a World\u2019s Best Management Consulting Firm by Forbes, Vault\u2019s Top 50 Firms to Work For, Crain's Chicago Business Fast 50, Inc 5000\u2019s Fastest Growing Firms, and Consulting Magazine's Fastest Growing Firms. \u00A0
\u00A0
Learn more about our award-winning culture\u00A0
\u00A0
AArete, LLC (\u201CAArete\u201D) may utilize Artificial Intelligence/Automated Decision-Making Technology/Automated Employment Decision Technology tools and resources (\u201CAI\u201D or \u201Ctools\u201D or \u201Cresources\u201D) to assist humans in generating job descriptions and postings, recruitment, analyzation of information, screening candidates, evaluation of candidate information, and assisting humans in the selection of potential candidates by all levels of AArete employees for all positions.
\u00A0
AArete may use Microsoft Co-Pilot, OpenAI ChatGPT, Anthropic Claude, Google Gemini, LinkedIn Recruiter AI and Hiring Assistant, Jobvite Talent Fit and AArete HireSense. AArete may use all the information you provide. Submission of information to AArete shall serve as consent to AArete\u2019s use of AI tools and resources. AArete complies with all applicable law and does not use AI to discriminate against any individual and does not use location or geographic data like zip codes to act in a discriminatory or illegal manner. Your personal data may be used in relation to prospective employment with AArete and will only be retained for so long as legally necessary.
\u00A0
AArete shall comply with its posted privacy policies and candidates may contact Recruiting or Privacy Departments, as identified below, to request accommodations or to exercise any of your applicable rights, pursuant to applicable law:\u00A0\u00A0
\u00A0
Recruiting: [email protected]
\u00A0
Privacy: [email protected]\u00A0 \u00A0\u00A0
\u00A0
We are an Equal Employment Opportunity Employer\u00A0
\u00A0\u00A0
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.\u00A0
#LI-DNI
", "hiringOrganization": "AArete", "employmentType": "Full-Time", "industry": "Digital Technology Services", "identifier": "omBWzfwc", "jobLocation": [ { "@type": "Place", "address": { "@type": "PostalAddress", "addressCountry": "India" } } ], "title": "Senior Data Engineer", "baseSalary": { "@type": "MonetaryAmount", "currency": "", "value": { "@type": "QuantitativeValue", "minValue": "2500000", "maxValue": "3500000", "unitText": "" } } } Senior Data Engineer Digital Technology Services Pune, India Apply Description Senior Data Engineer AArete is one-of-a-kind when it comes to consulting firm culture. We’re a global, innovative management and technology consulting firm with offices in the U.S. and India. Our name comes from the Greek word for excellence: “Areté.” And excellence is exactly what we strive for. We’re celebrating our fourth year as one of Forbes’ World’s Best Management Consulting Firms – and our success starts with our people. From robust career development planning to competitive life and wellness benefits, AArete’s “Culture of Care” takes a holistic approach to the employee experience. AAretians (our team members) are leaders at every level. You are encouraged to unlock your full potential by directly contributing to our mission and prioritizing personal development and fulfillment. The Role We are hiring a Senior Data Engineer to join our Payment Intelligence (PI) 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 ConfluenceOther duties as assigned Requirements 5+ years of hands-on data engineering experienceProficiency 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 Requirements 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) Benefits Flexible Paid Time Off of up to 23 days annually, in addition to 10 paid public holidaysHybrid work model with flexible in-office attendanceComprehensive health benefits including medical insurance (Mediclaim), personal accident insurance, and term life insuranceGenerous paid parental leave programAttractive employee referral bonus schemeTransportation allowance and night shift allowanceEmployee advance salary loan facilityStructured professional certification reimbursement policy to support ongoing learning and development We put humans at the center of our work We’re a global management and technology consulting firm specializing in strategic profitability improvement, digital transformation, and strategy & change for clients. Our cross-industry solutions are powered by a digital-first mindset, market intelligence, and data-driven approach to deliver purposeful change, actionable insights, and guaranteed results. But what sets us apart is our people. We are guided by our deeply embedded guiding principles: Excellence, Passion, Loyalty to Clients, Stewardship, Family, Community, Sustainability, and Inclusion. And we’ve been recognized as a top firm to work for by companies like Forbes, Top Workplaces Chicago Tribune, and Consulting Magazine. We’ve earned a Great Place to Work Certification™ and been named a World’s Best Management Consulting Firm by Forbes, Vault’s Top 50 Firms to Work For, Crain's Chicago Business Fast 50, Inc 5000’s Fastest Growing Firms, and Consulting Magazine's Fastest Growing Firms. Learn more about our award-winning culture AArete, LLC (“AArete”) may utilize Artificial Intelligence/Automated Decision-Making Technology/Automated Employment Decision Technology tools and resources (“AI” or “tools” or “resources”) to assist humans in generating job descriptions and postings, recruitment, analyzation of information, screening candidates, evaluation of candidate information, and assisting humans in the selection of potential candidates by all levels of AArete employees for all positions. AArete may use Microsoft Co-Pilot, OpenAI ChatGPT, Anthropic Claude, Google Gemini, LinkedIn Recruiter AI and Hiring Assistant, Jobvite Talent Fit and AArete HireSense. AArete may use all the information you provide. Submission of information to AArete shall serve as consent to AArete’s use of AI tools and resources. AArete complies with all applicable law and does not use AI to discriminate against any individual and does not use location or geographic data like zip codes to act in a discriminatory or illegal manner. Your personal data may be used in relation to prospective employment with AArete and will only be retained for so long as legally necessary. AArete shall comply with its posted privacy policies and candidates may contact Recruiting or Privacy Departments, as identified below, to request accommodations or to exercise any of your applicable rights, pursuant to applicable law: Recruiting: [email protected] Privacy: [email protected] We are an Equal Employment Opportunity Employer All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. #LI-DNI Apply Apply Later ← Back to Current Openings Share lang: en_US Share LinkedIn Facebook Twitter Email Powered by JobviteAArete Careers { "@context": "http://schema.org", "@type": "JobPosting", "datePosted": "2026-04-07", "description": "
\u00A0
\u00A0
\u00A0
Senior Data Engineer
\u00A0
AArete is one-of-a-kind when it comes to consulting firm culture.
\u00A0\u00A0
We\u2019re a global, innovative management and technology consulting firm with offices in the U.S. and India. Our name comes from the Greek word for excellence: \u201CAret\u00E9.\u201D\u00A0 And excellence is exactly what we strive for.\u00A0\u00A0
\u00A0
We\u2019re celebrating our fourth year as one of Forbes\u2019 World\u2019s Best Management Consulting Firms \u2013 and our success starts with our people. From robust career development planning to competitive life and wellness benefits, AArete\u2019s \u201CCulture of Care\u201D takes a holistic approach to the employee experience.\u00A0\u00A0
\u00A0\u00A0
AAretians (our team members) are leaders at every level. You are encouraged to unlock your full potential by directly contributing to our mission and prioritizing personal development and fulfillment.\u00A0
\u00A0
\u00A0
The Role
\u00A0
We are hiring a Senior Data Engineer to join our Payment Intelligence (PI) 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.
\u00A0
Work You\u2019ll Do
\u00A0
- 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
\u00A0
Requirements
\u00A0
- 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
\u00A0
\u00A0
Preferred Requirements
\u00A0
- 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\u2019s degree in Computer Science, Engineering, or a related field (or equivalent practical experience)
\u00A0
Benefits
\u00A0
- Flexible Paid Time Off of up to 23 days annually, in addition to 10 paid public holidays
- Hybrid work model with flexible in-office attendance
- Comprehensive health benefits including medical insurance (Mediclaim), personal accident insurance, and term life insurance
- Generous paid parental leave program
- Attractive employee referral bonus scheme
- Transportation allowance and night shift allowance
- Employee advance salary loan facility
- Structured professional certification reimbursement policy to support ongoing learning and development
\u00A0
We put humans at the center of our work\u00A0
\u00A0\u00A0
We\u2019re a global management and technology consulting firm specializing in strategic profitability improvement, digital transformation, and strategy & change for clients. Our cross-industry solutions are powered by a digital-first mindset, market intelligence, and data-driven approach to deliver purposeful change, actionable insights, and guaranteed results.
\u00A0\u00A0
But what sets us apart is our people. We are guided by our deeply embedded guiding principles: Excellence, Passion, Loyalty to Clients, Stewardship, Family, Community, Sustainability, and Inclusion.\u00A0\u00A0
\u00A0\u00A0
And we\u2019ve been recognized as a top firm to work for by companies like Forbes, Top Workplaces Chicago Tribune, and Consulting Magazine.\u00A0\u00A0
\u00A0\u00A0
We\u2019ve earned a Great Place to Work Certification\u2122 and been named a World\u2019s Best Management Consulting Firm by Forbes, Vault\u2019s Top 50 Firms to Work For, Crain's Chicago Business Fast 50, Inc 5000\u2019s Fastest Growing Firms, and Consulting Magazine's Fastest Growing Firms. \u00A0
\u00A0
Learn more about our award-winning culture\u00A0
\u00A0
AArete, LLC (\u201CAArete\u201D) may utilize Artificial Intelligence/Automated Decision-Making Technology/Automated Employment Decision Technology tools and resources (\u201CAI\u201D or \u201Ctools\u201D or \u201Cresources\u201D) to assist humans in generating job descriptions and postings, recruitment, analyzation of information, screening candidates, evaluation of candidate information, and assisting humans in the selection of potential candidates by all levels of AArete employees for all positions.
\u00A0
AArete may use Microsoft Co-Pilot, OpenAI ChatGPT, Anthropic Claude, Google Gemini, LinkedIn Recruiter AI and Hiring Assistant, Jobvite Talent Fit and AArete HireSense. AArete may use all the information you provide. Submission of information to AArete shall serve as consent to AArete\u2019s use of AI tools and resources. AArete complies with all applicable law and does not use AI to discriminate against any individual and does not use location or geographic data like zip codes to act in a discriminatory or illegal manner. Your personal data may be used in relation to prospective employment with AArete and will only be retained for so long as legally necessary.
\u00A0
AArete shall comply with its posted privacy policies and candidates may contact Recruiting or Privacy Departments, as identified below, to request accommodations or to exercise any of your applicable rights, pursuant to applicable law:\u00A0\u00A0
\u00A0
Recruiting: [email protected]
\u00A0
Privacy: [email protected]\u00A0 \u00A0\u00A0
\u00A0
We are an Equal Employment Opportunity Employer\u00A0
\u00A0\u00A0
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.\u00A0
#LI-DNI
", "hiringOrganization": "AArete", "employmentType": "Full-Time", "industry": "Digital Technology Services", "identifier": "omBWzfwc", "jobLocation": [ { "@type": "Place", "address": { "@type": "PostalAddress", "addressCountry": "India" } } ], "title": "Senior Data Engineer", "baseSalary": { "@type": "MonetaryAmount", "currency": "", "value": { "@type": "QuantitativeValue", "minValue": "2500000", "maxValue": "3500000", "unitText": "" } } } Senior Data Engineer Digital Technology Services Pune, India Apply Description Senior Data Engineer AArete is one-of-a-kind when it comes to consulting firm culture. We’re a global, innovative management and technology consulting firm with offices in the U.S. and India. Our name comes from the Greek word for excellence: “Areté.” And excellence is exactly what we strive for. We’re celebrating our fourth year as one of Forbes’ World’s Best Management Consulting Firms – and our success starts with our people. From robust career development planning to competitive life and wellness benefits, AArete’s “Culture of Care” takes a holistic approach to the employee experience. AAretians (our team members) are leaders at every level. You are encouraged to unlock your full potential by directly contributing to our mission and prioritizing personal development and fulfillment. The Role We are hiring a Senior Data Engineer to join our Payment Intelligence (PI) 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 ConfluenceOther duties as assigned Requirements 5+ years of hands-on data engineering experienceProficiency 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 Requirements 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) Benefits Flexible Paid Time Off of up to 23 days annually, in addition to 10 paid public holidaysHybrid work model with flexible in-office attendanceComprehensive health benefits including medical insurance (Mediclaim), personal accident insurance, and term life insuranceGenerous paid parental leave programAttractive employee referral bonus schemeTransportation allowance and night shift allowanceEmployee advance salary loan facilityStructured professional certification reimbursement policy to support ongoing learning and development We put humans at the center of our work We’re a global management and technology consulting firm specializing in strategic profitability improvement, digital transformation, and strategy & change for clients. Our cross-industry solutions are powered by a digital-first mindset, market intelligence, and data-driven approach to deliver purposeful change, actionable insights, and guaranteed results. But what sets us apart is our people. We are guided by our deeply embedded guiding principles: Excellence, Passion, Loyalty to Clients, Stewardship, Family, Community, Sustainability, and Inclusion. And we’ve been recognized as a top firm to work for by companies like Forbes, Top Workplaces Chicago Tribune, and Consulting Magazine. We’ve earned a Great Place to Work Certification™ and been named a World’s Best Management Consulting Firm by Forbes, Vault’s Top 50 Firms to Work For, Crain's Chicago Business Fast 50, Inc 5000’s Fastest Growing Firms, and Consulting Magazine's Fastest Growing Firms. Learn more about our award-winning culture AArete, LLC (“AArete”) may utilize Artificial Intelligence/Automated Decision-Making Technology/Automated Employment Decision Technology tools and resources (“AI” or “tools” or “resources”) to assist humans in generating job descriptions and postings, recruitment, analyzation of information, screening candidates, evaluation of candidate information, and assisting humans in the selection of potential candidates by all levels of AArete employees for all positions. AArete may use Microsoft Co-Pilot, OpenAI ChatGPT, Anthropic Claude, Google Gemini, LinkedIn Recruiter AI and Hiring Assistant, Jobvite Talent Fit and AArete HireSense. AArete may use all the information you provide. Submission of information to AArete shall serve as consent to AArete’s use of AI tools and resources. AArete complies with all applicable law and does not use AI to discriminate against any individual and does not use location or geographic data like zip codes to act in a discriminatory or illegal manner. Your personal data may be used in relation to prospective employment with AArete and will only be retained for so long as legally necessary. AArete shall comply with its posted privacy policies and candidates may contact Recruiting or Privacy Departments, as identified below, to request accommodations or to exercise any of your applicable rights, pursuant to applicable law: Recruiting: [email protected] Privacy: [email protected] We are an Equal Employment Opportunity Employer All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. #LI-DNI Apply Apply Later ← Back to Current Openings Share lang: en_US Share LinkedIn Facebook Twitter Email Powered by JobviteAArete Careers { "@context": "http://schema.org", "@type": "JobPosting", "datePosted": "2026-04-07", "description": "
\u00A0
\u00A0
\u00A0
Senior Data Engineer
\u00A0
AArete is one-of-a-kind when it comes to consulting firm culture.
\u00A0\u00A0
We\u2019re a global, innovative management and technology consulting firm with offices in the U.S. and India. Our name comes from the Greek word for excellence: \u201CAret\u00E9.\u201D\u00A0 And excellence is exactly what we strive for.\u00A0\u00A0
\u00A0
We\u2019re celebrating our fourth year as one of Forbes\u2019 World\u2019s Best Management Consulting Firms \u2013 and our success starts with our people. From robust career development planning to competitive life and wellness benefits, AArete\u2019s \u201CCulture of Care\u201D takes a holistic approach to the employee experience.\u00A0\u00A0
\u00A0\u00A0
AAretians (our team members) are leaders at every level. You are encouraged to unlock your full potential by directly contributing to our mission and prioritizing personal development and fulfillment.\u00A0
\u00A0
\u00A0
The Role
\u00A0
We are hiring a Senior Data Engineer to join our Payment Intelligence (PI) 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.
\u00A0
Work You\u2019ll Do
\u00A0
- 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
\u00A0
Requirements
\u00A0
- 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
\u00A0
\u00A0
Preferred Requirements
\u00A0
- 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\u2019s degree in Computer Science, Engineering, or a related field (or equivalent practical experience)
\u00A0
Benefits
\u00A0
- Flexible Paid Time Off of up to 23 days annually, in addition to 10 paid public holidays
- Hybrid work model with flexible in-office attendance
- Comprehensive health benefits including medical insurance (Mediclaim), personal accident insurance, and term life insurance
- Generous paid parental leave program
- Attractive employee referral bonus scheme
- Transportation allowance and night shift allowance
- Employee advance salary loan facility
- Structured professional certification reimbursement policy to support ongoing learning and development
\u00A0
We put humans at the center of our work\u00A0
\u00A0\u00A0
We\u2019re a global management and technology consulting firm specializing in strategic profitability improvement, digital transformation, and strategy & change for clients. Our cross-industry solutions are powered by a digital-first mindset, market intelligence, and data-driven approach to deliver purposeful change, actionable insights, and guaranteed results.
\u00A0\u00A0
But what sets us apart is our people. We are guided by our deeply embedded guiding principles: Excellence, Passion, Loyalty to Clients, Stewardship, Family, Community, Sustainability, and Inclusion.\u00A0\u00A0
\u00A0\u00A0
And we\u2019ve been recognized as a top firm to work for by companies like Forbes, Top Workplaces Chicago Tribune, and Consulting Magazine.\u00A0\u00A0
\u00A0\u00A0
We\u2019ve earned a Great Place to Work Certification\u2122 and been named a World\u2019s Best Management Consulting Firm by Forbes, Vault\u2019s Top 50 Firms to Work For, Crain's Chicago Business Fast 50, Inc 5000\u2019s Fastest Growing Firms, and Consulting Magazine's Fastest Growing Firms. \u00A0
\u00A0
Learn more about our award-winning culture\u00A0
\u00A0
AArete, LLC (\u201CAArete\u201D) may utilize Artificial Intelligence/Automated Decision-Making Technology/Automated Employment Decision Technology tools and resources (\u201CAI\u201D or \u201Ctools\u201D or \u201Cresources\u201D) to assist humans in generating job descriptions and postings, recruitment, analyzation of information, screening candidates, evaluation of candidate information, and assisting humans in the selection of potential candidates by all levels of AArete employees for all positions.
\u00A0
AArete may use Microsoft Co-Pilot, OpenAI ChatGPT, Anthropic Claude, Google Gemini, LinkedIn Recruiter AI and Hiring Assistant, Jobvite Talent Fit and AArete HireSense. AArete may use all the information you provide. Submission of information to AArete shall serve as consent to AArete\u2019s use of AI tools and resources. AArete complies with all applicable law and does not use AI to discriminate against any individual and does not use location or geographic data like zip codes to act in a discriminatory or illegal manner. Your personal data may be used in relation to prospective employment with AArete and will only be retained for so long as legally necessary.
\u00A0
AArete shall comply with its posted privacy policies and candidates may contact Recruiting or Privacy Departments, as identified below, to request accommodations or to exercise any of your applicable rights, pursuant to applicable law:\u00A0\u00A0
\u00A0
Recruiting: [email protected]
\u00A0
Privacy: [email protected]\u00A0 \u00A0\u00A0
\u00A0
We are an Equal Employment Opportunity Employer\u00A0
\u00A0\u00A0
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.\u00A0
#LI-DNI
", "hiringOrganization": "AArete", "employmentType": "Full-Time", "industry": "Digital Technology Services", "identifier": "omBWzfwc", "jobLocation": [ { "@type": "Place", "address": { "@type": "PostalAddress", "addressCountry": "India" } } ], "title": "Senior Data Engineer", "baseSalary": { "@type": "MonetaryAmount", "currency": "", "value": { "@type": "QuantitativeValue", "minValue": "2500000", "maxValue": "3500000", "unitText": "" } } } Senior Data Engineer Digital Technology Services Pune, India Apply Description Senior Data Engineer AArete is one-of-a-kind when it comes to consulting firm culture. We’re a global, innovative management and technology consulting firm with offices in the U.S. and India. Our name comes from the Greek word for excellence: “Areté.” And excellence is exactly what we strive for. We’re celebrating our fourth year as one of Forbes’ World’s Best Management Consulting Firms – and our success starts with our people. From robust career development planning to competitive life and wellness benefits, AArete’s “Culture of Care” takes a holistic approach to the employee experience. AAretians (our team members) are leaders at every level. You are encouraged to unlock your full potential by directly contributing to our mission and prioritizing personal development and fulfillment. The Role We are hiring a Senior Data Engineer to join our Payment Intelligence (PI) 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 ConfluenceOther duties as assigned Requirements 5+ years of hands-on data engineering experienceProficiency 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 Requirements 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) Benefits Flexible Paid Time Off of up to 23 days annually, in addition to 10 paid public holidaysHybrid work model with flexible in-office attendanceComprehensive health benefits including medical insurance (Mediclaim), personal accident insurance, and term life insuranceGenerous paid parental leave programAttractive employee referral bonus schemeTransportation allowance and night shift allowanceEmployee advance salary loan facilityStructured professional certification reimbursement policy to support ongoing learning and development We put humans at the center of our work We’re a global management and technology consulting firm specializing in strategic profitability improvement, digital transformation, and strategy & change for clients. Our cross-industry solutions are powered by a digital-first mindset, market intelligence, and data-driven approach to deliver purposeful change, actionable insights, and guaranteed results. But what sets us apart is our people. We are guided by our deeply embedded guiding principles: Excellence, Passion, Loyalty to Clients, Stewardship, Family, Community, Sustainability, and Inclusion. And we’ve been recognized as a top firm to work for by companies like Forbes, Top Workplaces Chicago Tribune, and Consulting Magazine. We’ve earned a Great Place to Work Certification™ and been named a World’s Best Management Consulting Firm by Forbes, Vault’s Top 50 Firms to Work For, Crain's Chicago Business Fast 50, Inc 5000’s Fastest Growing Firms, and Consulting Magazine's Fastest Growing Firms. Learn more about our award-winning culture AArete, LLC (“AArete”) may utilize Artificial Intelligence/Automated Decision-Making Technology/Automated Employment Decision Technology tools and resources (“AI” or “tools” or “resources”) to assist humans in generating job descriptions and postings, recruitment, analyzation of information, screening candidates, evaluation of candidate information, and assisting humans in the selection of potential candidates by all levels of AArete employees for all positions. AArete may use Microsoft Co-Pilot, OpenAI ChatGPT, Anthropic Claude, Google Gemini, LinkedIn Recruiter AI and Hiring Assistant, Jobvite Talent Fit and AArete HireSense. AArete may use all the information you provide. Submission of information to AArete shall serve as consent to AArete’s use of AI tools and resources. AArete complies with all applicable law and does not use AI to discriminate against any individual and does not use location or geographic data like zip codes to act in a discriminatory or illegal manner. Your personal data may be used in relation to prospective employment with AArete and will only be retained for so long as legally necessary. AArete shall comply with its posted privacy policies and candidates may contact Recruiting or Privacy Departments, as identified below, to request accommodations or to exercise any of your applicable rights, pursuant to applicable law: Recruiting: [email protected] Privacy: [email protected] We are an Equal Employment Opportunity Employer All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. #LI-DNI Apply Apply Later ← Back to Current Openings Share lang: en_US Share LinkedIn Facebook Twitter Email Powered by Jobvite{ "@context": "http://schema.org", "@type": "JobPosting", "datePosted": "2026-04-07", "description": "
\u00A0
\u00A0
\u00A0
Senior Data Engineer
\u00A0
AArete is one-of-a-kind when it comes to consulting firm culture.
\u00A0\u00A0
We\u2019re a global, innovative management and technology consulting firm with offices in the U.S. and India. Our name comes from the Greek word for excellence: \u201CAret\u00E9.\u201D\u00A0 And excellence is exactly what we strive for.\u00A0\u00A0
\u00A0
We\u2019re celebrating our fourth year as one of Forbes\u2019 World\u2019s Best Management Consulting Firms \u2013 and our success starts with our people. From robust career development planning to competitive life and wellness benefits, AArete\u2019s \u201CCulture of Care\u201D takes a holistic approach to the employee experience.\u00A0\u00A0
\u00A0\u00A0
AAretians (our team members) are leaders at every level. You are encouraged to unlock your full potential by directly contributing to our mission and prioritizing personal development and fulfillment.\u00A0
\u00A0
\u00A0
The Role
\u00A0
We are hiring a Senior Data Engineer to join our Payment Intelligence (PI) 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.
\u00A0
Work You\u2019ll Do
\u00A0
- 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
\u00A0
Requirements
\u00A0
- 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
\u00A0
\u00A0
Preferred Requirements
\u00A0
- 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\u2019s degree in Computer Science, Engineering, or a related field (or equivalent practical experience)
\u00A0
Benefits
\u00A0
- Flexible Paid Time Off of up to 23 days annually, in addition to 10 paid public holidays
- Hybrid work model with flexible in-office attendance
- Comprehensive health benefits including medical insurance (Mediclaim), personal accident insurance, and term life insurance
- Generous paid parental leave program
- Attractive employee referral bonus scheme
- Transportation allowance and night shift allowance
- Employee advance salary loan facility
- Structured professional certification reimbursement policy to support ongoing learning and development
\u00A0
We put humans at the center of our work\u00A0
\u00A0\u00A0
We\u2019re a global management and technology consulting firm specializing in strategic profitability improvement, digital transformation, and strategy & change for clients. Our cross-industry solutions are powered by a digital-first mindset, market intelligence, and data-driven approach to deliver purposeful change, actionable insights, and guaranteed results.
\u00A0\u00A0
But what sets us apart is our people. We are guided by our deeply embedded guiding principles: Excellence, Passion, Loyalty to Clients, Stewardship, Family, Community, Sustainability, and Inclusion.\u00A0\u00A0
\u00A0\u00A0
And we\u2019ve been recognized as a top firm to work for by companies like Forbes, Top Workplaces Chicago Tribune, and Consulting Magazine.\u00A0\u00A0
\u00A0\u00A0
We\u2019ve earned a Great Place to Work Certification\u2122 and been named a World\u2019s Best Management Consulting Firm by Forbes, Vault\u2019s Top 50 Firms to Work For, Crain's Chicago Business Fast 50, Inc 5000\u2019s Fastest Growing Firms, and Consulting Magazine's Fastest Growing Firms. \u00A0
\u00A0
Learn more about our award-winning culture\u00A0
\u00A0
AArete, LLC (\u201CAArete\u201D) may utilize Artificial Intelligence/Automated Decision-Making Technology/Automated Employment Decision Technology tools and resources (\u201CAI\u201D or \u201Ctools\u201D or \u201Cresources\u201D) to assist humans in generating job descriptions and postings, recruitment, analyzation of information, screening candidates, evaluation of candidate information, and assisting humans in the selection of potential candidates by all levels of AArete employees for all positions.
\u00A0
AArete may use Microsoft Co-Pilot, OpenAI ChatGPT, Anthropic Claude, Google Gemini, LinkedIn Recruiter AI and Hiring Assistant, Jobvite Talent Fit and AArete HireSense. AArete may use all the information you provide. Submission of information to AArete shall serve as consent to AArete\u2019s use of AI tools and resources. AArete complies with all applicable law and does not use AI to discriminate against any individual and does not use location or geographic data like zip codes to act in a discriminatory or illegal manner. Your personal data may be used in relation to prospective employment with AArete and will only be retained for so long as legally necessary.
\u00A0
AArete shall comply with its posted privacy policies and candidates may contact Recruiting or Privacy Departments, as identified below, to request accommodations or to exercise any of your applicable rights, pursuant to applicable law:\u00A0\u00A0
\u00A0
Recruiting: [email protected]
\u00A0
Privacy: [email protected]\u00A0 \u00A0\u00A0
\u00A0
We are an Equal Employment Opportunity Employer\u00A0
\u00A0\u00A0
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.\u00A0
#LI-DNI
", "hiringOrganization": "AArete", "employmentType": "Full-Time", "industry": "Digital Technology Services", "identifier": "omBWzfwc", "jobLocation": [ { "@type": "Place", "address": { "@type": "PostalAddress", "addressCountry": "India" } } ], "title": "Senior Data Engineer", "baseSalary": { "@type": "MonetaryAmount", "currency": "", "value": { "@type": "QuantitativeValue", "minValue": "2500000", "maxValue": "3500000", "unitText": "" } } } Senior Data Engineer Digital Technology Services Pune, India Apply Description Senior Data Engineer AArete is one-of-a-kind when it comes to consulting firm culture. We’re a global, innovative management and technology consulting firm with offices in the U.S. and India. Our name comes from the Greek word for excellence: “Areté.” And excellence is exactly what we strive for. We’re celebrating our fourth year as one of Forbes’ World’s Best Management Consulting Firms – and our success starts with our people. From robust career development planning to competitive life and wellness benefits, AArete’s “Culture of Care” takes a holistic approach to the employee experience. AAretians (our team members) are leaders at every level. You are encouraged to unlock your full potential by directly contributing to our mission and prioritizing personal development and fulfillment. The Role We are hiring a Senior Data Engineer to join our Payment Intelligence (PI) 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 ConfluenceOther duties as assigned Requirements 5+ years of hands-on data engineering experienceProficiency 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 Requirements 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) Benefits Flexible Paid Time Off of up to 23 days annually, in addition to 10 paid public holidaysHybrid work model with flexible in-office attendanceComprehensive health benefits including medical insurance (Mediclaim), personal accident insurance, and term life insuranceGenerous paid parental leave programAttractive employee referral bonus schemeTransportation allowance and night shift allowanceEmployee advance salary loan facilityStructured professional certification reimbursement policy to support ongoing learning and development We put humans at the center of our work We’re a global management and technology consulting firm specializing in strategic profitability improvement, digital transformation, and strategy & change for clients. Our cross-industry solutions are powered by a digital-first mindset, market intelligence, and data-driven approach to deliver purposeful change, actionable insights, and guaranteed results. But what sets us apart is our people. We are guided by our deeply embedded guiding principles: Excellence, Passion, Loyalty to Clients, Stewardship, Family, Community, Sustainability, and Inclusion. And we’ve been recognized as a top firm to work for by companies like Forbes, Top Workplaces Chicago Tribune, and Consulting Magazine. We’ve earned a Great Place to Work Certification™ and been named a World’s Best Management Consulting Firm by Forbes, Vault’s Top 50 Firms to Work For, Crain's Chicago Business Fast 50, Inc 5000’s Fastest Growing Firms, and Consulting Magazine's Fastest Growing Firms. Learn more about our award-winning culture AArete, LLC (“AArete”) may utilize Artificial Intelligence/Automated Decision-Making Technology/Automated Employment Decision Technology tools and resources (“AI” or “tools” or “resources”) to assist humans in generating job descriptions and postings, recruitment, analyzation of information, screening candidates, evaluation of candidate information, and assisting humans in the selection of potential candidates by all levels of AArete employees for all positions. AArete may use Microsoft Co-Pilot, OpenAI ChatGPT, Anthropic Claude, Google Gemini, LinkedIn Recruiter AI and Hiring Assistant, Jobvite Talent Fit and AArete HireSense. AArete may use all the information you provide. Submission of information to AArete shall serve as consent to AArete’s use of AI tools and resources. AArete complies with all applicable law and does not use AI to discriminate against any individual and does not use location or geographic data like zip codes to act in a discriminatory or illegal manner. Your personal data may be used in relation to prospective employment with AArete and will only be retained for so long as legally necessary. AArete shall comply with its posted privacy policies and candidates may contact Recruiting or Privacy Departments, as identified below, to request accommodations or to exercise any of your applicable rights, pursuant to applicable law: Recruiting: [email protected] Privacy: [email protected] We are an Equal Employment Opportunity Employer All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. #LI-DNI Apply Apply Later ← Back to Current Openings Share lang: en_US Share LinkedIn Facebook Twitter EmailSenior Data Engineer
Digital Technology Services Pune, India