FAIR Health is a national, independent not-for-profit corporation whose mission is to bring transparency to healthcare costs and health insurance information through comprehensive data products and consumer resources. FAIR Health uses its database of billions of billed medical and dental services to power a free website that enables consumers to estimate and plan their medical and dental expenditures. The website also offers clear, unbiased educational articles and videos about the healthcare insurance reimbursement system. In addition to its consumer offerings, FAIR Health licenses data products to businesses, governmental agencies, healthcare providers and researchers. With its professional staff of experts in healthcare, statistics, technology and communications, FAIR Health strives to offer accurate, consistent and timely information to all stakeholders in the healthcare system.

The Healthcare Data Analyst will be responsible for a variety of data analysis, evaluation and reporting solutions. This individual will support the innovation, enhancement and development of analyses of underlying claims data and product methodologies. This includes the design and development of related solutions to accomplish these tasks.

The role will also translate internal business needs into data driven deliverables and products with responsibility for the creation of SQL queries and SAS programs necessary to meet those needs. Working with other analysts and business representatives, this individual will also be able to report and present results and findings to various levels of the organization.

The successful candidate will have an understanding of healthcare claims data and a working knowledge of healthcare coding concepts (ICD, HCPCS, CPT, etc.). This individual should also have a strong analytic and statistical background and be able to extract information from the database and create usable and actionable information. This person will also have a broad knowledge of medical and dental data, healthcare fee schedules and data products, as well as an ability to apply that knowledge to data solutions.

Primary Responsibilities

• Work with SQL to query, merge and analyze large datasets.
• Evaluate analyses to derive informative and well-organized results that can be documented and presented to stakeholders in the form of tables, charts and graphs.
• Understand and work with all aspects of healthcare claims data to identify trends and other salient information.
• Work on FAIR Health data products and create reports and analytics that reflect actionable, value-infused information.
• Evaluate and establish validity of FAIR Health data product information to ensure accuracy and completeness of all reporting results.
• Work with database technologies, such as Oracle and statistical analytical toolsets, such as SAS to evaluate datasets and produce analytic result sets, including graphical representations of the data.
• Utilize healthcare data knowledge to help to craft data analyses to support client analyses and internal products.
• Investigate and resolve issues independently related to FAIR Health data products.
• Observe information security policies and HIPAA guidelines of conduct to ensure the privacy and security of nonpublic information.
• Masters degree in Public Health, Statistics or related field, or equivalent work experience.
• Strong experience with SQL and SAS.
• Experience working with large databases.
• Strong presentation skills to support presentation of technical material and concepts to senior managers and non-technical audiences.
• Comfortable working with various levels of an organization.
• Strong interpersonal skills, including the ability to work in a highly cross-functional, multi-location organization.
• Highly proficient with MS Excel, PowerPoint and Word.
• Ability to proactively engage in all aspects of project definition through implementation, problem assessment through resolution and reporting for presentation, focusing on both big picture and specific project detail.
• Ability to self-manage and appropriately govern multiple projects on a day-to-day basis.
• Experience with the application of statistical methods, including correlations, t-tests, and logistic and linear regression.

Preferred Skills

• 2+ years working for a health insurer or healthcare-related organization, including consulting or technology companies with responsibility for analysis of large healthcare datasets.
• Knowledge of medical claims data, including, but not limited to, professional claims, outpatient claims, inpatient claims, specialty pharmacy and pharmaceutical claims.
• A working knowledge of healthcare coding (CPT, HCPCS, ICD, revenue codes, DRG).
• Familiarity with healthcare fee schedules, including, but not limited to, Medicare, Workers Compensation and Medicaid.
• Knowledge of business intelligence toolsets, such as Tableau.
• Experience with the use of advanced statistical methods, including propensity score matching and outlier detection methods, such as cluster analyses.

Location: Remote or a possibility to work from our New York City office post-pandemic.