Summary
AArete is a global management and technology consulting firm. The company is seeking a Healthcare Data Developer to develop and test healthcare fee schedule solutions using Snowflake, SQL, and Python, while working with claims data, reimbursement requirements, pricing logic, and validation processes.
Responsibilities
- Develop and maintain healthcare fee schedule solutions using Snowflake, SQL, and Python
- Translate business and reimbursement requirements into technical logic and data transformations
- Analyze healthcare claims data to support fee schedule development and validation
- Develop SQL queries and Python scripts for data processing, transformation, validation, and automation
- Implement and validate pricing logic based on business requirements
- Perform functional, regression, integration, and data validation testing
- Compare expected versus actual pricing results and investigate discrepancies
- Identify and troubleshoot issues related to data, business rules, or technical implementation
- Develop automated validation processes to improve the efficiency and accuracy of fee schedule testing
- Work with business stakeholders to understand requirements and clarify pricing rules
- Support UAT and resolve issues identified during business testing
- Perform data reconciliation and identify gaps or inconsistencies in fee schedule coverage
- Support deployment and post-production validation
- Collaborate with data engineers, analysts, business stakeholders, and onshore/offshore development teams
- Document technical logic, testing procedures, and validation results
- Other duties as assigned
Skills
- • 3+ years of experience in healthcare data, claims processing, healthcare analytics, data engineering, or a related field
- • Strong Snowflake and SQL skills
- • Strong Python skills for data processing, transformation, validation, and automation
- • Experience working with healthcare claims data
- • Experience with data validation, testing, or QA
- • Ability to translate business requirements into technical solutions
- • Strong analytical and problem-solving skills
- • Excellent attention to detail
- • Ability to work independently and effectively collaborate with technical and business teams
- • Willingness to engage in direct client interaction, including travel to client locations
- • Must be legally authorized to work in the United States without the need for employer sponsorship
- • Experience with healthcare fee schedules or reimbursement methodologies
- • Knowledge of CPT, HCPCS, modifiers, revenue codes, DRGs/APR-DRGs, NPI, and TIN
- • Experience with professional and institutional claims management
- • Experience with healthcare payer data
- • Experience developing automated testing or validation using Python
- • Familiarity with Git, Jira, and Agile development practices
- • Based in Chicago, IL, and flexible to work from our Chicago office as needed
Qualifications
Must Haves
- • 3+ years of experience in healthcare data, claims processing, healthcare analytics, data engineering, or a related field
- • Strong Snowflake and SQL skills
- • Strong Python skills for data processing, transformation, validation, and automation
- • Experience working with healthcare claims data
- • Experience with data validation, testing, or QA
- • Ability to translate business requirements into technical solutions
- • Strong analytical and problem-solving skills
- • Excellent attention to detail
- • Ability to work independently and effectively collaborate with technical and business teams
- • Willingness to engage in direct client interaction, including travel to client locations
- • Must be legally authorized to work in the United States without the need for employer sponsorship
Nice to Haves
- • Experience with healthcare fee schedules or reimbursement methodologies
- • Knowledge of CPT, HCPCS, modifiers, revenue codes, DRGs/APR-DRGs, NPI, and TIN
- • Experience with professional and institutional claims management
- • Experience with healthcare payer data
- • Experience developing automated testing or validation using Python
- • Familiarity with Git, Jira, and Agile development practices
- • Based in Chicago, IL, and flexible to work from our Chicago office as needed
Benefits
- Flexible PTO, monthly half-day refuels, volunteer time off, 10 paid holidays
- Own Your Day flexible work policy
- Competitive majority employer-paid benefits: Medical, Dental, Vision, 401K Match
- Generous paid parental leave options
- Employer-paid Life Insurance, Short Term Disability, Long Term Disability
- Charitable contribution matching program
- New client commission opportunities and referral bonus program
- Bike share discount program