Commission Script Consultant Jobs in Illinois (NOW HIRING)

Healthcare Data Developer

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: "Arete." 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 looking for a Healthcare Data Developer with strong Snowflake, SQL and Python skills to support the development and testing of healthcare fee schedules. This role will work with healthcare claims data and business requirements to develop data transformations, implement pricing and reimbursement logic, and validate results.

Work You'll Do

• 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

Requirements

• 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

Preferred Requirements

• 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

Compensation & 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

The estimated base salary range for this position is $90,000 - $120,000. In addition to this base salary, individuals may be eligible for an annual discretionary bonus. This range is a part of a competitive, total compensation package together with our majority employer-paid benefits and incentive pay for eligible roles. Please note that this range is a guideline, and individual total compensation may vary due to numerous factors, including but not limited to experience level, certifications, and other relevant business considerations.

AArete will accept applications until the position is filled. The job posting will be removed once the role is no longer available.

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: recruiting@aarete.com

Privacy: privacy@aarete.com

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