Description and Requirements
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:
Bachelor’s 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
Hiring Range*:
Greater New York City Area (NY, NJ, CT residents): $83,100 - $120,360
All Other Locations (within approved locations): $73,400 - $109,225
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.