Log In
Sign Up
Institute for Medical Research at the Durham VA Health Care System
Microsoft Access Developer Job Description
PI: Dr. Stephen Freedland
Occupational Summary
The Institute for Medical Research, (IMR), a private nonprofit organization that conducts cutting edge research for the Durham Veterans Affairs Health Care System (DVAHCS), is seeking to hire a Microsoft Access Developer. The successful candidate would be employed in the laboratory of Dr. Stephen Freedland, a nationally recognized leader in urology research. The Freedland Research Group primarily examines urologic and oncologic disease in veterans with a particular focus on lifestyle, race, and risk stratification, and is supported by numerous federal grants as well as leading industry sponsors.
The successful candidate will have the opportunity to be part of a highly productive and dynamic team of researchers. The Microsoft Access Developer is involved with the analysis and presentation of clinical data and will need to learn considerable knowledge of clinical research methods and clinical presentations of urologic and oncologic diseases. Applicants must have the ability to work independently, prioritize and manage the workflow of multiple projects, sit for long periods in front of computers, and be fluent in English.
Specific Qualifications
Associate s or Bachelor s degree in Computer Science, Engineering, Information Systems/Technology, or other relevant field. At least 5 years of experience as an Access developer may be considered in lieu of a degree in the computer science field
Two or more years designing Access databases
Intimate familiarity with the best practices and methodologies associated with the following practices:
Relational database tools, design, and analysis
Designing MS Access forms and queries
VBA programming language
Working with an ODBC connection to a SQL Server database backend
Experience with SQL (preferably Microsoft SQL Server/T-SQL)
Experience working in healthcare, medical research, health sciences, or related fields is a plus
Highly organized, detailed oriented with the ability to manage multiple tasks, changing priorities and deadlines
Ability to work independently
Ability to solve problems, troubleshoot, and quickly learn new skills
Excellent written and oral communication skills
Tasks Include:
Database Design for New Projects
Develop new MS Access database applications for capture of clinical research data and clinical trial enrollment according to project specifications. This requires developing the backend table structure in SQL Server as well as the frontend design in MS Access.
Exhaustively test data entry applications to ensure data accuracy and functionality of data collection tools
Integrate user feedback and testing into database backend and frontend designs
Use VBA to deploy conditional logic and conduct data validation
Ensure data security including privacy protection, backups, etc.
Maintenance of Existing Projects
Contribute to the maintenance and expansion of existing MS Access applications
Add/remove features from data entry applications upon request
Maintain documentation on versions
Ensure data security including privacy protection, backups, etc.
Document Work
Document work related to database and query design through the use of comments, codebooks, and good programming practices
Update and improve existing documentation and training modules
Provide written, oral, and/or electronic status reports of assigned tasks
Use the Jira platform to manage workflow according to best practices of Agile software development, including time estimations, acceptance criteria approvals, and QA workflows
Collaborate with Team Members
Communicate with VA technology departments to address/resolve IT needs and problems
Coordinate with research coordinators to ensure all procedures adhere to HIPAA and IRB compliance
Work closely with the project manager(s) to understand requirements and deadlines
The above statements describe the general nature and level of work being performed by individuals assigned to this classification. This is not intended to be an exhaustive list of all responsibilities and duties. Employees are expected to perform other related duties incidental to the work described herein.
This position is a time-limited, 12-month remote position, with a potential extension of time based on business needs. The individual may be an employee or contractor for either full- or part-time employment.
If full-time and non-contractor, this would be an exempt (salaried) position where the salary range is $70,000 – $95,000.
For part-time or contract, this would be a non-exempt (hourly) position where the pay rate range is $34.00 – $46.00 per hour.
For non-contract, a full- or part-time position will include benefits.
Employee Benefits: IMR offers a competitive benefits package which includes health insurance, a matching 403b retirement savings plan, and paid holiday, vacation, and sick leave. Please visit www.imr.org for information about employee benefits.
Participation in the seasonal influenza and Coronavirus Disease 2019 (COVID-19) Vaccination programs may be required for all Department of Veterans Affairs Health Care Workers Without Compensation (WOC).
Equal Opportunity Employer, including disabled persons and Veterans
Click here to apply to this position and others directly on the Institute for Medical Research Careers Page!
