Healthcare Product Data Analyst

About FAIR Health

FAIR Health, Inc., a national, independent nonprofit organization, was established in October 2009 with the mission to help assure fairness and transparency in health insurance information. FAIR Health has created a database of over 41 billion de-identified private healthcare claim records—the largest in the country—which receives claims monthly and which serves as the foundation for a variety of data products, custom analytics and consumer tools. FAIR Health has also been certified by the Centers for Medicare & Medicaid Services as a “Qualified Entity” and thus holds the entire collection of Medicare Parts A, B and D claims from 2013 to the present, which get routinely refreshed.

Our standard data modules, custom analytics and technological tools serve all participants in the healthcare sector nationwide; they are licensed to payors, third-party administrators, bill review companies, self-insured employers, government agencies, academic researchers and consultants. Our medical and dental data are used to inform statutes and regulations, healthcare cost indices, fee schedules, benefit and provider network design, practice/facility expansion, health systems research and dispute resolution, among other uses. We also offer a suite of consumer-oriented tools and resources available on our consumer website (fairhealthconsumer.org), as well as a mobile application, which can be licensed by other organizations.

Summary of Position

The Healthcare Data Product Analyst will be responsible for the design, development and implementation of data-driven processes used to create FAIR Health data products. This individual will play a significant role in identifying areas in which data processes can be optimized and automated, and will help to implement such changes. Working with multiple FAIR Health stakeholders, the Healthcare Data Product Analyst will have responsibilities throughout the product research and development life cycle, translating business needs into data-driven deliverables and analyses.

The successful candidate will have a strong analytic and statistical background with the ability to extract information from the database to inform insightful data solutions. This person should be self-motivated with the ability to problem solve independently.

The ideal candidate will have an understanding of healthcare claims data, a working knowledge of healthcare coding concepts (ICD, HCPCS, CPT etc.) and a broad knowledge of healthcare fee schedules and data products.

Primary Responsibilities

• Create and execute test plans of functional and nonfunctional test cases that verify requirements and validate functionality within the database and application layers.
• Create and understand advanced SQL queries to analyze large datasets.
• Coordinate efforts across multiple teams to optimize and automate data processes.
• Design and oversee the implementation of data product enhancements and the creation of new data products.
• Understand and analyze healthcare claims data to identify trends, patterns and other salient information.
• Debug, investigate and resolve errors that occur within database-stored procedures.
• Design, develop and automate custom data processes using workflow tools to create FAIR Health data products.
• Work with database technologies, such as Oracle, and statistical analytical toolsets, such as SAS/R, to evaluate datasets and produce result sets.
• Translate business needs into development requirements and data-driven deliverables.

• Liaise between cross-functional teams (Business Users, Information Technology, Quality Assurance) in order to assure the complete and accurate execution of requirements gathering, development and testing efforts, the implementation of data product enhancements and the creation of new data products.
• Define and execute regression testing of database and application changes.

Location: Remote or work from our New York City or Syracuse office.

Salary is commensurate with experience in the range of 65k – 102k.

FAIR Health, Inc., is an equal opportunity employer and is an E-Verify participant.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity or national origin.

FAIR Health offers a competitive compensation package and includes the following benefits: Medical, Dental, Vision, Flexible Spending and Dependent Care Accounts, Life and Disability Insurance, Paid Time Off, Paid Holidays, 401(k) and Discretionary Bonus.