Senior Professional Research Assistant

• 
  Use REDCap, Access, and SQL to create databases for research studies
  
• 
  Create and update forms/tables/queries for Access and REDCap databases according to the needs of staff and study investigators.
  
• 
  Automate REDCap data entry, where possible, using SAS, R, and/or Windows batch files.
  
• 
  Manage the LEAD Data Warehouse.
  
• 
  Ensure study data are stored and used in a HIPAA compliant manner.
  
• 
  Use SAS and/or SQL code to clean, conduct quality control, and develop reports.
  
• 
  Train study staff in database management methods as appropriate
  
• 
  Perform data cleaning, incorporate externally provided datasets, create derived variables and document data processes across multiple studies within the LEAD Center.
  
• 
  Provide summary reports of recruitment and participant demographics for regulatory/funding agencies.
  

• 
  Intermediate to advanced skills with REDCap, MS Access and/or SQL server including creating databases, creating forms, exporting/importing data and summarizing data using the REDCap report tool.
  
• 
  Experience working with SAS and/or SQL.
  
• 
  Write complex SQL queries for automated reporting
  
• 
  Experience working with relational databases (e.g., MS Access databases).
  
• 
  Experience with developing SOPs and ancillary documentation involving database management activities
  
• 
  Familiarity with Microsoft Office products, including Excel, Word, and Access.
  
• 
  Excellent written and oral communication skills.
  
• 
  Experience in a public health research environment.
  

Minimum Qualifications

• Demonstrated expertise with relational database creation and modification in at least two platforms including REDCap, SQL Server, and/or MS Access.

• Demonstrated expertise in SAS or SQL programming or other languages/syntaxes commonly used in data management.

• Prior experience working with PHI and HIPAA covered data

• Master’s degree or equivalent experience as determined by the dean or their designee.

• 3 years of experience in a research environment.

Applicants must meet minimum qualifications at the time of hire.

Conditions of Employment:

• The University of Colorado has issued a requirement for COVID-19 vaccinations and full completion thereof by the start date.

• Position requires Colorado residency; work is typically performed in person on location at the University of Colorado Anschutz Medical Campus with some flexibility at the discretion of the supervisor.

• Employee must be eligible to work in the United States. The LEAD Center does not support visa applications.

 Preferred Qualifications

• 10+ years of experience in a public health research environment.

• Demonstrated expertise with relational database creation and modification multiple platforms including REDCap, SQL Server, and MS Access.

• Experience with SAS, SQL and R preferred.

• Experience with EPIC data and/or other electronic health record data

• Prior work with public health research data on obesity, diabetes, or health across the lifecourse

• Advanced skills with database design and creation in REDCap, MS Access, and SQL

• Excellent written and oral communication skills.

• Excellent organization skills and high attention to detail.