Senior Reconciliation & Recovery Analyst
Greenwood, IN - USA
Job Summary
Duties & Responsibilities:
Operate with intellectual curiosity and critically assess existing processes and procedures to identify opportunities for improvement
Develop complex analyses requiring the integration of multiple data sources evaluation of data quality and standardization of data to consistent format/structure
Create advanced queries and reports that extract data to support business teams needs including working with nesting tables and temp tables and writing multiple conditions against varying data sets
Summarize and present data outcomes recommendations and methodology to Reconciliation and Recovery leadership E&B leadership and enterprise stakeholders
Create and run routine reporting to monitor the enrollment activities of a defined population and ensure data accuracy
Analyze large data sets and identify patterns within the defined population to organize the backlog determine outliers and identify root-causes of membership payment or other data discrepancies
Determine short and long-term actions to resolve current cases of membership/ payment discrepancies and new ones from reoccurring
Understand validate and document the business rule(s) to flag membership for reconciliation and/ or premium recovery for a defined population
Liaison between department leaders subject matter experts Healthfirst finance etc.
Develop strategy and potential solutions to resolve membership discrepancies within the defined population
Establish job-aids to enable user-correction of membership errors and/or submission of information to the DOH and NYSoH
Work with outsourced vendors to enable them to resolve cases flagged for manual correction
Partner with the Quality Assurance (QA) team to develop a QA model to ensure quality compliance and regulatory standards are met
Work collaboratively across the department and organization to share best-practices and coordinate corrective actions applicable to other populations
Establish tracking mechanism to track effectiveness and data accuracy within the defined population and report results to senior leadership
Other duties as assigned or requested
Minimum Qualifications:
Bachelors degree from an accredited institution
Working experience exhibiting strong critical thinking and analytical skills
Familiarity with writing SQL queries for the purpose of analyzing data and establishing business rules and requirements
Familiarity with relational database structures theories principles and practices
Familiarity with data models and/or data modelling
Ability to understand the data lifecycle within the organization and its impact on the business
Experience working in a team-oriented collaborative environment
Ability to communicate effectively verbally and in writing while demonstrating good grammar spelling and punctuation skills
Ability to work effectively with both business and technical stakeholders
Work experience requiring meticulous attention to detail
Preferred Qualifications:
Degree in Mathematics Computer Science Data Sciences Engineering Business Analytics Informatics or similar concentration
Experience with Alteryx Tableau Amazon Redshift or other similar tools/platforms
Familiarity with statistical principles such as standard deviations normal distributions and regressions
Familiarity with healthcare data especially enrollment data
WE ARE AN EQUAL OPPORTUNITY EMPLOYER. HF Management Services LLC complies with all applicable laws and regulations. Applicants and employees are considered for positions and are evaluated without regard to race color creed religion sex national origin sexual orientation pregnancy age disability genetic information domestic violence victim status gender and/or gender identity or expression military status veteran status citizenship or immigration status height and weight familial status marital status or unemployment status as well as any other legally protected basis. HF Management Services LLC shall not discriminate against any disabled employee or applicant in regard to any position for which the employee or applicant is otherwise qualified.
If you have a disability under the Americans with Disability Act or a similar law and want a reasonable accommodation to assist with your job search or application for employment please contact us by sending an email to or your email please include a description of the accommodation you are requesting and a description of the position for which you are applying. Only reasonable accommodation requests related to applying for a position within HF Management Services LLC will be reviewed at the e-mail address and phone number supplied. Thank you for considering a career with HF Management Services LLC.
All hiring and recruitment at Healthfirst is transacted with a valid @ email address only or from a recruitment firm representing our Company. Any recruitment firm representing Healthfirst will readily provide you with the name and contact information of the recruiting professional representing the opportunity you are inquiring about. If you receive a communication from a sender whose domain is not @ or not one of our recruitment partners please be aware that those communications are not coming from or authorized by Healthfirst. Healthfirst will never ask you for money during the recruitment or onboarding process.
Hiring Range*:
Greater New York City Area (NY NJ CT residents): $83100 - $120360
All Other Locations (within approved locations): $73400 - $109225
As a candidate for this position your salary and related elements of compensation will be contingent upon your work experience education licenses and certifications and any other factors Healthfirst deems pertinent to the hiring decision.
In addition to your salary Healthfirst offers employees a full range of benefits such as medical dental and vision coverage incentive and recognition programs life insurance and 401k contributions (all benefits are subject to eligibility requirements). Healthfirst believes in providing a competitive compensation and benefits package wherever its employees work and live.
*The hiring range is defined as the lowest and highest salaries that Healthfirst in good faith would pay to a new hire or for a job promotion or transfer into this role.
Required Experience:
Senior IC
About Company
Healthfirst offers no- and low-cost Medicare Advantage, Medicaid, and Long-Term Care plans in NYC, Long Island, Rockland, Sullivan, and Westchester counties.