IT Systems Analyst

Position Information

University Code 24242 University Title Information Technology Systems Analyst 2 University Job Family Information Technology ORP Eligible No For more information on ORP, visit: Retirement Plans
Recruitment Pool All Applicants Recruitment Type Single Title Scope of Search Local Working Title IT Systems Analyst Position Number 559800 Is this employee on a H1B Visa? Position Type Staff Job Status Full-Time FLSA Indicator Exempt Employee Group University Employee Department Telecommunications Services Organizational Overview

At VCU, we Make it Real through learning, research, creativity, service and discovery — the hallmarks of the VCU experience. A premier, urban, public research university nationally recognized as one of the best employers for diversity, VCU is a great place to work. It’s a place of opportunity, where your success is supported and your career can thrive. VCU offers employees a generous leave package, career paths for advancement, competitive pay, and an opportunity to do mission-driven work.

Position Primary Purpose and General Responsibilities

VCU Telecommunications Services has an exciting opportunity for an IT Systems Analyst to join our team!

To support, maintain and troubleshoot the telecommunications expense management system ( PCR -360), other third party applications including the Avaya Communications Manager, voice messaging and adjunct systems/servers integrated with the Telecommunications Services operation as well as the university-wide managed print program, OnePrint.

Minimum Hiring Standards

•Demonstrated technical ability with relational databases (Oracle, SQL, MySQL), reporting tools (Crystal Reports), PHP and SQL programming.
•Strong analytical skills with demonstrated ability to collect, organize, analyze and disseminate significant amounts of data into various formats, for presentation and discussion, with meticulous attention to detail and accuracy.
•Solid hands-on experience developing new and/or modifying existing programs, SQL queries and/or reports that are logical and optimize programming resources and meet user requirements.
•Proficient in Microsoft Excel and Access (able to create and manipulate reports, custom formulas and pivot tables, V-lookups).
•Excellent organizational and time management skills including the ability to establish priorities, exercise good judgment, meet deadlines and ensure issues are addressed in a timely manner.
•Ability to support and report on multiple projects with a focus on data quality issues and problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
•Excellent problem-solving, critical thinking and quantitative skills, including the ability to disaggregate issues, identify root causes and recommend solutions.
•Ability to work effectively with end users to provide technical support (i.e., troubleshoot, test and debug programs), consultation and training for telecommunications applications.
•Ability to create proficient documentation to provide user support for new and modified programs.
•Excellent communication skills; ability to communicate complex information so that it is understandable to novice computer users; ability to communicate effectively in writing, particularly with regard to the development of manuals, procedures, instructional materials and reports.
•Demonstrated ability to provide quality customer service in a professional manner; communicating clearly and confidentially, both orally and in writing, with employees of various levels within the organization and with people from diverse backgrounds
•Ability to work successfully in teams and independently.
•Graduate of college/university with major studies in areas of information systems, computer science or any related field, or the equivalent job experience and training.
•Exposure to voice telecommunications technologies.
• Demonstrated experience working in and fostering a diverse faculty, staff and student environment or commitment to do so as a staff member at VCU .
• Other duties as assigned.

Preferred Hiring Standards

•Focus on Avaya and VoIP technology.
•Experience with APIs.
•Working knowledge of TerminalFour for managing web content.
•Experience in a university and/or hospital environment.
•Project management experience.
•Experience with other programming or scripting languages, such as Python, and/or shell scripting (Linux or Windows).

Required Licenses/ Certifications Anticipated Hiring Range $53,000-$60,000 Application Process/Additional Information Campus Monroe Park Campus Hours/Week 40 Normal Work Days/Hours 8am-4:30pm Job Open Date 03/03/2021 Posting will close on or before Open Until Filled Yes Job Category Information Technology Is this a restricted position? No Is this position eligible to participate in alternative work arrangements? Yes Sensitive Position No Resource Critical Yes Quick Link https://www.vcujobs.com/postings/103871 Posting Specific Questions

Required fields are indicated with an asterisk (*).

1. * Please rate your experience using SQL.
   • Very Experienced: Using SQL is one of my main responsibilities in my current/recent job and am able to provide a sample of my work.
   • Somewhat Experienced: I have used it in the past but do not use it in my present position.
   • No Experience: I am willing to learn and believe I possess the skill set use SQL.
2. * Please describe your experience with advanced SQL queries, reading query plans, and troubleshooting performance issues.
   
   (Open Ended Question)
   
   
3. * Do you have experience with programming in PERL, C++, Java, or PHP? List the computer languages with which you have proficiency.
   
   (Open Ended Question)
   
   
4. * 1. Please provide the number of years of experience you have in collecting, organizing and analyzing data?
   • 0-2 years
   • 3-5 years
   • 5-10 years
   • 10 year +
5. * Please list your experience in developing reports using either Crystal Reports or Microsoft reports tools:
   • None
   • Less than 6 months
   • 6 months - less than 2 years
   • 2 years - less than 5 years
   • 5 or more years

Optional & Required Documents
Required Documents

1. Cover Letter/Letter of Application
2. Resume

Optional Documents

1. Reference Letter - 1
2. Reference Letter - 2