FP849W

Prof/Lecturer/11-12Mth

Programmer/Analyst

The Programmer/Analyst position will develop varied solutions working with end-users, database technologists, programmer/analysts and other IT professionals in developing and supporting the business systems of the university.

The position participates in life cycle application deployment to meet the university’s enterprise needs, including design, development, testing, and implementation.

Reporting to leadership within the Chief Technology Officer’s organization, the Programmer/Analyst position, partners with other IT staff members as necessary (engineering, communications, business office, analysts, programmers), and provide assistance to non-senior developers, as needed, and peer review code pre-production.

Specific responsibilities include (but not limited to):

• Design and develop automated and user-run processes to meet University needs. Implement additional software functionality and minor modifications to existing software, to meet the needs of functional offices.
• Troubleshoot problems with ERP system, other 3rd party applications, and university-designed software. Assist in identifying data integrity issues and software design issues.
• Write and/or modify reports as needed by functional users. Assist functional users in the development and maintenance of reports.

Education: Bachelor’s degree in Information Technology or related field or equivalent education, training or experience.

Competencies:

• Working knowledge of web applications programming.
• Demonstrated knowledge of relational databases and programming with SQL and/or PL/SQL, with the demonstrated ability to develop reports, and /or create enhancements to systems.
• Knowledge of Banner or a similar ERP system, with demonstrated skills in systems analysis, application design and programming.
• Knowledge of full life-cycle development , with strong planning and project management skills and the ability to work a project through the cycle.
• Excellent interpersonal, oral & written communication skills with the demonstrated ability to interface with a variety of customers and provide a high level of service and work collaboratively in a dynamic team environment.
• Strong organizational skills, with the ability to manage multiple projects while sustaining daily operations.

Experience:

• Experience in systems analysis, application design and application programming.
• Experience in database programming with SQL and other database programming tools.
• Experience supporting Oracle, other relational database architectures, or database systems as a programmer and analyst.
• Experience working on moderately complex IT projects with technical responsibilities.

CERTIFICATION:
Oracle or other relevant certifications.

COMPETENCIES:
Working knowledge of Python, Java, PHP or other common programming language.

EXPERIENCE:

• Solid experience programming in PL/SQL.
• Experience in a higher education IT environment.

Commensurate with Experience

3H7000 IT

William & Mary

U12

03/09/2021

Yes

Full Time Professional

12-Month

• This position is subject to additional hours beyond the typical work day/week to include weekends and holidays.

• This position may require occasional overnight travel.

• The duties of this position may be performed remotely. With the supervisor’s approval, the incumbent may have the option to work remotely on a full- or part-time basis.

Information Security: This position requires administrative access to the College’s information systems and/or sensitive College data. The incumbent is expected to be aware of and adhere to the Information Security policies of the College as well as all applicable federal, state, and local laws. Additionally, the incumbent is expected to follow information security best practices applicable to their job area and to pursue information security training and awareness opportunities when possible.

William & Mary values diversity and invites applications from underrepresented groups who will enrich the research, teaching and service missions of the university. The university is an Equal Opportunity/Affirmative Action employer and encourages applications from women, minorities, protected veterans, and individuals with disabilities.

William & Mary is committed to providing a safe campus community. W&M conducts background investigations for applicants being considered for employment. Background investigations include reference checks, a criminal history record check, and when appropriate, a financial (credit) report or driving history check.

William & Mary offers our employees a full array of benefits including retirement, health insurance with options for expanded dental and vision along with group and optional life insurance with coverage for spouse and children, flexible spending accounts, and an EAP (Employee Assistance Program).

Our employees enjoy additional university benefits such as educational assistance, professional development, wellness benefits, and a robust holiday schedule. All employees have access to fitness facilities on campus. Staff members also have access to the university libraries, and much more. To learn more, go to: https://www.wm.edu/offices/hr/currentemployees/benefits/index.php