Systems Programmer/Analyst II

The Office of Data Management (ODM) is a shared data management resource for the Department of Psychiatry. Our database managers support multiple grants for multiple investigators. Example research areas include Alzheimer’s/Dementia, Brain research and neuro imaging, Mid Life and Adolescent research, Autism, Sleep and Circadian Rhythms, Schizophrenia/Schizoaffective. We are a growing team that provides vital resources to our research community.

The Systems Programmer/Analyst II will be expect to build tables and views in SQL, build data entry forms in Access/Redcap, create datasets/reports, troubleshoot data quality problems, revamp existing SQL/Access/Recap tables/views/reports/entry forms, implement data quality procedures, and follow best practices. Candidates must be willing to advance their current skill set and grow to meet the evolving needs of the researchers that we support.

This position is grant funded.

Responsibilities:

• Provides ongoing maintenance and troubleshooting for staff as necessary.
• Develop and disseminate data management and tracking programs necessary for research protocols, with an emphasis on development of common and compatible data entry and management programs.
• Assists with the creation, institution and enforcement of data collection and management policies and procedures, including the design of standard reports, database documentation, quality control procedures and security standards.
• Assists with the training of entry level personnel in the design and maintenance of forms and programs for data entry.
• Independently perform statistical analysis and design and produce ad hoc reports as needed by projects.
• Communicate effectively with the research, clinical and administrative staff to maintain efficient communication about data gathering, data entry and statistical analysis.
• Data management and tracking.
• Participates in meetings, schedule training sessions, and collaborative learning opportunities.
• Meets percentage effort on assigned projects.
• Creates/maintains documentation on assigned projects: entity relationship diagrams (ERD), standard operating procedures (SOP),and  README documents.