Skip to the content of the web site.

Data Administrator

Date: November, 2012
Reports to (Job Title): Clnical Scientist Responsible for Data Integrity
Jobs Reporting (Job Titles): None
Location: School of Optometry and Vision Science


35 hr/wk

Primary Purpose

This position is responsible for maintaining the integrity and security of all CCLR study data as well as preparing it for analysis according to Good Clinical Practice requirements and the needs of each study.

Key Accountabilities:

1.Development of Multiple Databases and Web Applications



2.Administration and Maintenance of Database Systems



3.Development and Maintenance of Datasets



4.IT Coordination





6.Teamwork  and Leadership





Position Requirements


Degree in Computer Science or related field.  In-depth knowledge of managing large and small data sets using RDBMS. Working Knowledge of IT infrastructure, network servers, and the configurations of database and software applications is required.  Database Certification in MS SQL Server or other equivalent RDBMS is preferred. 


In-depth working experience with designing, developing, administrating and troubleshooting databases and their applications using MS SQL Server, My SQL and MS Access and other equivalent RDBMS.  Development experience using MS VBA, Macro, SQL, Pivot Table (MS Excel) to query and manipulate data sets. Development experience using PHP, JavaScript for web applications. Good oral and written communication skills with demonstrated decision-making, organizational and time management skills.  Knowledge of Good Clinical Practice guidelines is an asset.


MS Word Excel PowerPoint Other
Advanced Advanced Advanced RDBMS, SQL, Transact-SQL, MS VBA, Visual Basic, PHP, JavaScript, MS Visual Studio, MS Excel

Nature and Scope

Interpersonal Skills:

Internally this position must obtain, clarify and discuss information with CCLR research staff and other members of the data management team in order to determine the data needs of each study.  The incumbent is required to exchange data and related information with CCLR sponsors. She/he also works with UW IT personnel to maintain the required infrastructure and database applications and troubleshoot any problems that arise.

Level of Responsibility:

This position is responsible and accountable for creating, organizing, storing, documenting, extracting/exporting, converting, merging and manipulating all CCLR data, from the point that it is collected to the point where it is archived.  This includes applying knowledge to data collection and retrieval processes and providing guidance to other members of the Data Management Team as necessary.

Decision-Making Authority:

This position is required to troubleshoot problems with the web and database applications as well as those involving system backup and archiving and any others related to the integrity of the CCLR data.  The incumbent must make decisions regarding choice of application to use based on data requirements and must decide when system/application upgrades are required.  The incumbent must also be willing to follow study priorities as determined by the CCLR Senior Administrative Team and be able to manage workload accordingly.

Physical and Sensory Demands:

The incumbent experiences physical and sensory demands typical of a position whose main focus involves attention to detail and computer use.  It requires extension sitting, repetitive hand/finger movements and concentrated visual tasks.  Frequent breaks are encouraged.

Working Environment:

There is minimal exposure to disagreeable conditions typical of an administrative position required to occupy a cubical in an office shared with three or four other individuals.  This position is contingent upon funding.