What are the responsibilities and job description for the Database Coordinator Healthcare Analytics position at Research & Marketing Strategies, Inc. (RMS)?
COMPANY: Research & Marketing Strategies, Inc. (RMS) - Healthcare Division
ORIGINATION DATE: May 2025
REPORTS TO: Manager, Survey Operations
LOCATION: Baldwinsville, New York
SALARY: $55,000 annually
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’ clients to receive
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.
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.
1 Consumer Assessment of Healthcare Providers and Systems (CAHPS): Consumer Assessment of Healthcare
Providers & Systems (CAHPS) | CMS
Database Coordinator Healthcare Analytics Job Description
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 project
folders on the shares drive, 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
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
2 | P a g e
Database Coordinator Healthcare Analytics Job Description
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, salary history and cover letter to the following:
Doug Sweet
Research & Marketing Strategies, Inc.
15 East Genesee Street, Suite 210
Baldwinsville, New York 13027
Or via e-mail to: Info@rmsresults.com
3 | P a g e
Salary : $55,000
