Candidates should have at least solid excel skills, they don’t need to be experts in writing “algorithms/programs” using excel but should be able to handle most intermediate type processes
A solid background in math is a requirement
Visual basic skills
For Access, look for people with experience doing “computational access development” not just experience with less complex admin type databases (forms, tracking projects, lists, etc…)
LCAT Description - Database Analyst:
Functions: Responsible for designing, developing, modifying, and troubleshooting software programs to include desktop applications and computer based Information Technology IT systems. Specifically, to design, develop, modify, and troubleshoot databases and programs; correct database and program errors using methods which include modifying program or altering sequence of program steps; analyze, review, and/or rewrite databases or programs to increase operating efficiency or to adapt program to new requirements to include web hosting of metrics; compile and write documentation for database and program development and subsequent revisions; and train users to use databases or programs.
Compiles and writes documentation of program development and subsequent revisions. Trains operators to use programs.
Experience in SharePoint.
Education: Bachelor’s degree in a related discipline from an accredited college or university
Experience: Four years of professional experience in a relevant field.