Title: RESEARCH PROGRAM SPECIALIST II Salary: $5,309.00 - $6,645.00 Posted: 01/24/2014
This position requires the incumbent maintain consistent and regular attendance; communicate effectively (orally and in writing) in dealing with the public and/or other employees; develop and maintain knowledge and skill related to specific tasks, methodologies, materials, tools and equipment; complete assignments in a timely and efficient manner; and, adhere to departmental policies and procedures regarding attendance, leave, and conduct.
Job Summary: Under supervision of senior scientific research personnel, incumbents plan, organize, and carry out independent scientific research studies of complex scientific scope; may serve as a team member on healthcare projects, provide expert consultative services on the feasibility, impact, or potential of a variety of State projects, or proposals to interested parties, advise management, departmental staff, legislative bodies, governmental entities, agencies on findings related to assigned area of research. The RPS II works independently with primary responsibility for a major project and activities. The incumbent's work is reviewed to see it conforms to established policies and procedures.
DHCS receives data requests through Public Records Act (PRA) requests, inter- and intra-departmental data sharing requests and for special projects. All data requests received by DHCS for confidential records for research or public health purposes are reviewed by DHCS’ Data and Research Committee (DRC), under the direction of the Chief Medical Information Officer (CMIO). The role of the DRC is to make recommendations to DHCS executive management regarding the potential approval or denial of a data request. The DRC oversees the process for soliciting and responding to requests from external requestors for access to protected DHCS data and assesses the appropriateness and priority of data releases for research or public health purposes. Data is extracted from the Management Information System/Decision Support System (MIS/DSS), which contains over 2.5 billion records. The MIS/DSS system includes Medi-Cal claims, pharmacy data, eligibility records, and provider data for Medi-Cal members. The Research Program Specialist II (RPS II) will assist with the ongoing development and operation of the MIS/DSS, and lead the design, development, and fulfillment for data requests coordinated by the PRA facilitator under the supervision of the CMIO. The RPS II must understand the MIS/DSS design and data processing rules, and use a variety of programs and applications to extract data from the data warehouse for research activities. The RPS II will assist with constructing Data Marts/study groups for multi-phased and longitudinal studies and analyses. The RPS II works with healthcare claims data, using knowledge of healthcare research. The applicant must be able to use other computer technologies (e.g., Word, Excel, Access, PowerPoint, and other software packages) to facilitate data extraction and analysis. The RPS II demonstrates knowledge and skill using SAS and Structured Query Language (SQL) data analytics tools to extract data from large and complex relational databases. The RPS II must also possess sound knowledge of HIPAA regulations, especially working with the release of Personal Health Information (PHI).
Description of Duties: The incumbent in this position will perform a wide variety of analytical and consultative duties as follows:
30% Coordinate the addition of data to the MIS/DSS and contribute to the design and implementation of Data Marts and report templates used for program administration. Program administration includes activities such as identifying utilization anomalies, managing providers and member information, and determining rates for Managed Health Care Plans. Works with state programs, such as the Office of Statewide Health Planning and Development and Vital Records in the California Department of Public Health, to link specific data sets with data in the MIS/DSS. Identify and implement data linkage methodologies grounded in probabilistic theory to accommodate the linkage of large databases that contain no common identifiers. Undertake scientific validation studies of chosen linkage methods, and perform sensitivity and specificity analyses to describe the robustness of the techniques employed. Use established guidelines and technical scientific procedures and adapt research methods to problems identified in the analysis of quality measures with a focus on improving data quality across different data collection and management processes to improve the accuracy of quality measures. Pull data from the MIS/DSS and other databases to prepare statistical reports, which accurately describe services provided by DHCS. Coordinate the development and analysis of reports evaluating services and quality of care based on outcomes, processes, and other performance measures with programs throughout the department.
25% Respond to data requests from researchers and departments outside of DHCS that are coordinated through the DRC. Review DRC data request materials and coordinate with requestors to fulfill approved data requests. Screen data requests to determine if data requested is confidential or de-identified. Refer de-identified data requests to the PRA coordinator. Confirm only minimum data needed is released for DRC requests. Maintain a log of all data transfers and work with DRC coordinator to track and complete appropriate forms. Assist with data quality assurance and paperwork associated with fulfilling DRC data requests. Follow department security procedures to create encrypted data files to send to outside researchers and departments based on approved DRC data requests.
20% Monitor, test and maintain the integrity of data (encounter data and Fee-For-Service) in the MIS/DSS. Apprise and consult with management in the ongoing maintenance and enhancement of the MIS/DSS. Coordinate and maintain mapping and program coding changes of values used in the MIS/DSS for all data feeds. Undertake scientific validation studies of chosen coding and linkage methods, and perform sensitivity and specificity analyses to describe the robustness of the techniques employed. Use established guidelines and technical scientific procedures and adapt research methods to problems identified in the analysis of data integrity with a focus on improving data quality across different data collection and management processes to improve the accuracy of the MIS/DSS.
10% Review PRA data requests received through the PRA coordinator. Conduct data quality assurance, confirm data being released is de-identified and assist with paperwork associated with fulfilling PRA data requests.
10% Provide technical assistance, statistical support and feedback concerning the MIS/DSS system to DHCS programs. Contribute to the publication of scientific findings, comprehensive annual reports of quality of care for the Medi-Cal Fee-for-Service and Managed Care programs, management briefs, benchmark reports and dashboards comparing various aspects of health service utilization and health outcomes of the Medi-Cal population to nationally recognized benchmarks and clinical guidelines. Identify appropriate comparison data from the literature, national reports of the Centers for Disease Control, the National Health Interview Survey and other authoritative sources.
Supplemental Application Item:
Please describe your experience working with healthcare claims data, healthcare research, SAS knowledge and skill, and knowledge of HIPAA and experience working with the release of Personal Health Information.
Instructions for Supplemental Application:
The examination process will consist of a Supplemental Application. Applicants are required to respond to the supplemental item. The supplemental item is designed to identify job achievement in specific areas that demonstrate ability to successfully perform at the Research Program Specialist II. Responses to the supplemental item will be assessed based on pre-determined, job-related rating criteria. In appraising the relative qualifications of candidates, consideration will be given to the extent and type of pertinent experience and education over and above that which is required under the minimum qualifications.
When responding to the supplemental item, applicants must follow these guidelines:
Provide enough detail. Your response should be approximately 1 page, single-spaced, with 2 spaces between paragraphs. Within the 1-page limit, you may highlight specific projects (relating to the above fields) you have led.
Your response must be typewritten or generated by word processing on 8 1/2 x 11 paper, using a 12-point font.
Ensure your response is complete, specific, clear and concise.
The results of this examination will be used only to fill this position.
If you are not a current or former State employee, you must first take an examination to obtain list eligibility. This does not apply to Student Assistant vacancies.
Learn all about it.
The State of California is an equal opportunity employer to all, regardless of age, ancestry, color, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding and related medical conditions), and sexual orientation.