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 38 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 are 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 Junior Database Developer will be a SQL developer with a knowledge of ETL (extract-transform-load) who is responsible for design, development, and delivery of data for external web applications. The successful candidate will be responsible for the integration of business requirements and database technologies to facilitate optimal solutions to meet business requirements. The candidate will identify areas of potential risks and suggest improvements to mitigate them. The candidate will also be responsible for plans for long-term growth and needs where possible. The candidate will also be responsible for automation, standardization, and documentation of applied methodologies within FAIR Health solution frameworks.

Primary Responsibilities

Primary MariaDB/MySQL and Postgres database developer on external web applications

Primary Elasticsearch/Oracle developer

Add new products working from Oracle (source) to Elasticsearch (application source)

Maintain products through fulfillment release cycles.

Work with business to define and refine requirements to work within existing frameworks and identify the modifications required to existing components in order to meet the business requirements.

Work with application developers to provide solutions meeting business requirements featuring stability and flexibility in a timely manner.

Design, create, modify, and remove database objects (tables, views, indexes, keys, stored procedures, functions, DB links, etc.) to support development projects.

Maintain database objects in a software version control system.

Create, document, maintain and validate backup and disaster recovery methodologies.

Ensure compliance with regulatory requirements for data transmission, storage and data access including documentation, testing and remediation.

Track and maintain work via Salesforce or RemedyForce.

Automate routine processes such as product loads where possible using available tools: procedures, packages, bash scripts, etc.

Perform unit testing and system integration testing and assist with user acceptance testing.

Ensure data quality throughout the entire data management process.

Observe information security policies and HIPAA guidelines of conduct to ensure the privacy and security of nonpublic information.

Knowledge and Skill Requirements

Bachelor?s Degree in computer science or equivalent experience required.

2-5 years programming in any programming language.

2-5 years working MariaDB/MySQL, Postgres, Oracle preferred.

Proficient in SQL with 2-5 years writing SQL code.

Proficient with Relational Database design and data modeling.

Working knowledge of ETL development.

Database centric development writing stored procedures and functions preferred.

Ability to apply technical design and development skills to the creation of database programs.

Working knowledge of data warehouse design and query performance tuning.

Working knowledge of Elasticsearch is a plus.

Ability to write/tweak Linux bash scripts with 1-5 years? experience.

Ability to pick up new skills as business solutions require them.

Ability to work independently in a fast-paced environment.

Excellent attention to detail.

Strong communication and interpersonal skills.

Strong organizational and time management skills.

Ability to work from our New York City office or remote.

Interested candidates should submit their resume to

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.