Research Data Specialist, School of Social Work

Overview

Center for Prevention Research and Development (CPRD) Located in Champaign, IL. Illinois is a world leader in research, teaching, and public engagement. We serve the state, the nation, and the world by creating knowledge, preparing students for lives of impact, and addressing critical societal needs through the transfer and application of knowledge. Illinois is the place where we embrace differences. We embrace it because we value it.

Illinois is especially interested in candidates who can contribute, through their research, teaching, and/or service, to the diversity and excellence of the Illinois community.

The Research Data Specialist for the Center for Prevention Research and Development (CPRD), within the University of Illinois’ School of Social Work, works on research teams that evaluate Medicaid-funded projects assessing continuity of care and administrative simplification for Medicaid beneficiaries. The Research Data Specialist is responsible for querying large datasets using SQL in Teradata and Postgre

SQL environments, combining and matching data from a variety of sources, performing and interpreting statistical data analysis, publishing research findings and coordinating project activities. The ideal candidate will have experience with Medicaid and/or hospital billing data as well as SQL experience with large datasets.

CPRD is a vibrant applied research center that has been in operation for 30 years. CPRD has a stable $3.5 million-dollar annual portfolio of grants in Medicaid-related projects, substance use prevention, juvenile justice, maternal and early childhood health, and teen pregnancy prevention. We work with meaningful data that has applications for the field and for impacting policy. CPRD invests in its staff with procedures to support professional development and ongoing learning opportunities.

The Research Data Specialist for the Center for Prevention Research and Development (CPRD), within the University of Illinois  School of Social Work, works on research teams that evaluate Medicaid-funded projects assessing continuity of care and administrative simplification for Medicaid beneficiaries. Responsible for querying large datasets using SQL in Teradata and Postgre

SQL environments, combining and matching data from a variety of sources, performing and interpreting statistical data analysis, publishing research findings and coordinating project activities.

• Support data services and analytics pipelines using Teradata and Postgre
  
  SQL on Linux and Windows.
• Participate in planning and carrying out migrations or upgrades of the data infrastructure and computing environments.
• Create and manipulate data sets, including large state and national datasets, for various evaluation designs.
• Implement pre-determined rules to code data, create data dictionaries, and interpret data dictionaries.
• Use SQL or other software to read in/set up data files, clean and merge datasets from various sources, run automated analysis and reporting systems, and design/write/test/maintain complex programs and for advanced statistical models.
• Develop functions, macros, templates and other utilities for creating code for data cleaning and reporting.
• Develop syntax in statistical software to construct and calculate variables.

• Clean and combine data, including merging files, recoding, dealing with missing data, and ensuring files are prepared for research analyses.
• Perform basic descriptive statistics, including means, medians, frequencies, chi-square, correlations, crosstabs, and ANOVA.
• Collaborate with other analysts at CPRD to serve as a peer support system for problem-solving and quality assurance of research projects.
• Other duties and responsibilities as appropriate.

• Translate research data output into text, bullet points, or tables/graphs/charts using APA style and/or other standard style guidelines.
• Clearly document all research procedures and analyses.
• Design, schedule, and interpret data reports from all relevant systems and distribute them to meet the project needs.
• Ef…