Data Product Engineer
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 de-identified commercial 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 national “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 Data Product Engineer 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 Data Product Engineer 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 technical, 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
- Design, develop and automate custom data processes using workflow tools to create FAIR Health data products.
- Coordinate efforts across multiple teams to optimize and automate data processes.
- Translate business needs into development requirements and data-driven deliverables.
- Debug, investigate and resolve errors that occur within database-stored procedures.
- Create and understand advanced SQL queries to analyze large datasets.
- Work with database technologies, such as Oracle, and statistical analytical tool sets, such as SAS/R, to evaluate datasets and produce result sets.
- Understand and analyze healthcare claims data to identify trends, patterns and other salient information.
- Design and oversee the implementation of data product enhancements and the creation of new data products.
- Create and execute test plans of functional and nonfunctional test cases that verify requirements and validate functionality within the database and application layers.
- Define and execute regression testing of database and application changes.
- Liaise between cross-functional teams (Information Technology, Quality Assurance and business users) 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.
Knowledge and Skill Requirements
Required
- Master’s degree in computer science, statistics, public health or related field, or equivalent work experience.
- 3-7 years’ professional work experience.
- Self-motivated and intellectually curious with strong analytic and problem-solving skills.
- Ability to conduct research and analysis on large data sets, interpret results and communicate findings.
- Proficient in SQL, PL/SQL or equivalent database query language.
- Experience with Python for the purpose of data processing and analytics.
- Strong interpersonal skills, including the ability to work in a highly cross-functional, multilocation organization.
- Ability to work independently and appropriately self-manage multiple projects simultaneously.
- Excellent written and verbal communication skills.
- Expert proficiency with Microsoft Excel and Word.
Preferred
- Advanced data mining skills and experience with SAS, R or related statistical software.
- 2+ years’ experience 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.
Location: Remote or work from our New York City or Syracuse office.