Healthcare Database Coordinator

COMPANY: Research & Marketing Strategies, Inc. (RMS) - Healthcare Division

LOCATION: Baldwinsville, NY

CREATION DATE: February 2025

REPORTS TO: Manager, Survey Operations

SALARY RANGE: $55,000 per year

SUMMARY OF PRIMARY RESPONSIBILITIES

The Database Coordinator will ensure coordination and management of data for patient sampling and
administration related to CAHPS®1 (healthcare survey administration) in accordance with Centers for
Medicare and Medicaid Services (CMS) quality assurance guidelines. The position requires experience with
developing and managing data in Structured Query Language (SQL) as well as writing and testing macros
and queries in programs. The position will also be responsible for troubleshooting any database issues,
implementing database system solutions and software programming updates. This position will work
collaboratively with the entire Healthcare Analytics team to ensure strict adherence to the required protocols.
The position is responsible for enhancing process efficiencies. Particular attention will be on developing
business strategies that add efficiency and standardize sampling protocols, while addressing the uniqueness
of client capabilities in providing patient data for surveying. Work will include programming as well as
developing cohesive strategies to ensure staff understand data flow using the programmed software. The
Coordinator will work with RMS’ CAHPS clients to receive their patient data through a secure transfer
environment. The Coordinator will speak to the data process flow with confidence and accuracy,
demonstrating competency and quality when interacting with CMS coordination teams during annual site
visits. The Coordinator will also work to update and maintain client data on respective portals. Demonstration
of skill sets, and execution of work will be essential in the development and management of cohesive
operational goals that will serve as a guidance document in the strategic planning of the healthcare division
infrastructure. The position will be responsible for (1) keeping abreast of CMS guidelines for survey
administration and possessing (2) an aptitude for interpreting data outputs, and (3) articulating findings to
clients.

SPECIFIC DUTIES AND RESPONSIBILITIES

1. Strong command of SQL; storing and retrieving electronic information; resolving performance problems
related to queries by using a variety of techniques via research and testing; maintaining rigorous data
security.

1 Consumer Assessment of Healthcare Providers and Systems (CAHPS): Consumer Assessment of Healthcare
Providers & Systems (CAHPS) | CMS
1 | P a g e -
Database Coordinator Healthcare Analytics Job Description
Created: 3.2025

2. Upload and convert client data into different formats (CSV, TSV, Excel) into a standard, normalized
database, allowing for efficient automation.

3. Develop, coordinate, and optimize CAHPS survey data into SQL databases for various operations.
4. Troubleshoot and “debugging” SQL code – able to clearly articulate overall logic process in running

code step by step – ability to identify why and where queries fail to run.
5. Ability to effectively manage and manipulate data stored in relational databases.
6. Perform regular quality tests to ensure all scripts and systems are running optimally.
7. Create documentation summarizing database management functions including for SQL code, database

structures, processes, and procedures for reference and reporting purposes – insuring accuracy and
integrity of coding.

8. Ensure databases are well maintained, queries optimized, and documentation is retained per CMS
requirements.

9. Work with the Manager, Survey Operations, to quality check the CAHPS product Line portal data and
functionality.

10. Overall management of all healthcare analytics project data, ensuring project processes maintain
function on an ongoing basis.

11. Assist with various assigned project management and research tasks, paying particular attention to
deliverables and specified timeframes.

12. Work in collaboration with Manager of Survey Operations to develop and manage strategies to prepare
survey data for data submission to CMS quarterly.

13. Direct data integration from multiple sources, enhancing the data with valuable and actionable
information, and analysis of the compiled data to build client deliverable solutions.

14. Provide assistance with diverse types of internal auditing to ensure quality and compliance with
regulatory and operational guidelines.

15. Ensure compliance with RMS operational policies and procedures (i.e.: criteria for establishing proper
directory set up on RMS server, etc.)

16. Assist with prospect/client interactions to explain the required data needs for appropriate survey
sampling.

17. Perform other duties as requested.

MINIMUM POSITION REQUIREMENTS

• A bachelor’s degree or commensurate experience

• Demonstrated experience with SQL programming

• Minimum of 2 years’ programming experience

• Motivated initiative-taker
• Strong analytical skills

• Strong problem-solving and critical thinking skills

• Communication and collaboration skills are essential to the function

• Ability to communicate complex technical information in layman’s terms
• Adaptability

2 | P a g e

• Effective time management skills

• Attention to detail and accuracy

• Strong written and verbal communications skills

• Excellent computer skills (including database skills)
• Evidence of certifications will be considered

• Maintain confidentiality and comply with Health Insurance Portability and Accountability Act (HIPAA)

• Willing to uphold a commitment to excellence

• This position is eligible for a hybrid work environment.
  

PHYSICAL REQUIREMENTS

Ambulatory 15%
Sedentary 85%
Computer Work 75%
Travel 10% minimal at this time.

This position requires access to patient Protected Health Information (PHI) and will also involve access to electronic Protected
Health Information (ePHI). Those in this position are required to comply with all final regulations including the Health Insurance
Portability and Accountability Act of 1996 (HIPAA). Intentional or inadvertent disclosure of PHI or ePHI violates federal law and
can result in termination and/or fines. Additionally, employees in this position are required to notify the Privacy and/or Security
Officer of any suspected incidents whereby RMS is not in full compliance with HIPAA. RMS will provide HIPAA training
opportunities and venues for the employee to remain abreast of HIPAA requirements.
To apply, please submit a resume and salary requirements to the following:
Doug Sweet, RMS Office Coordinator
Research & Marketing Strategies, Inc.
15 East Genesee St., Ste. 210
Baldwinsville, New York 13027
Or via e-mail to: Info@RMSresults.com

3 | P a g e