Programmer Analyst

SUMMARY OF POSITION: Reporting to the Chief Information Officer, the Programmer Analyst will be primarily responsible for supporting the university's enterprise system by managing complex system requests, consulting with stakeholders about system requirements and conducting research. This role supports the university's existing Integration platform and researches new platforms as needed. Maintains software environments for development and testing. Perform software upgrades, uploads, and deploy university and/or third party software. Setup, test and maintain test databases and/or testing environments and will execute test plans and test cases from specifications and compile results as well as performing programming, scripting task and perform other related duties as assigned.

ESSENTIAL DUTIES/NON-ESSENTIAL DUTIES AND RESPONSIBILITIES:

Database 30%

• Create and maintain accurate and efficient SQL code, views, stored procedures and scripts in accordance with conventional best practices
• Builds and maintains reports and data extraction processes through SQL, SSRS, Jenzabar, InfoMaker, and other BI tools as needed
• Continued validation of reports, scripts and processes ensuring data integrity and privacy prior to releasing information
• Manipulates database using software packages as well as original source-language programs.

Systems and Programming 50%

• Participate in all aspects of software development including requirements analysis, effort estimation, technical investigation, software design and implementation, unit testing, and error correction
• Prepares data for analysis using software packages and original programs.
• Consults with data owners and users to clarify requests and/or intended use of data and explain results.
• Writes and documents computer programs/software packages requiring knowledge of software logic and some programming languages and statistical programs to run analysis of data.
• Collaborates with functional areas on requirements for KPIs and collaborates on the availability of data, reporting and analysis.
• Working with functional users and supporting partners to develop and support integrations between on- and off-premises systems, including authentication. Ensuring compatibility and interoperability of systems
• Conducts research on software products, tools and technologies to maintain understanding of emerging technologies, standards and tools to justify recommendations for improvement sustainability and to support purchasing efforts

Security 20%

• Managing system change requests, coordinating testing, recommending and implementing security changes
• Maintain and enhance technical documentation and assist in training administrators and end users with how to use the business systems.
• Responsible for periodic review of data security and privacy practices, to include but not limited to user, group, and role-based permissions on tables, views, stored procedures and systems that access the data.
• Works closely and collaboratively with the Network Administrator, System Administrator and Chief Information Officer to ensure the security and the backup of systems and data is performed at accurate and at predetermined intervals

JOB QUALIFICATIONS:

MINIMUM QUALIFICATIONS:

• Bachelor's degree in computer science or information technology
• Two years' experience working with SQL, APIs, and ETL

PREFERRED QUALIFICATIONS:

• Experience working with Jenzabar, our ERP/SIS
• Project management experience
• Working knowledge of process improvement and workflow modeling

KNOWLEDGE, SKILLS, AND ABILITIES:

• Working knowledge of Identity and Access Management
• Ability to communicate with self-awareness, sensitivity, and professionalism in a diverse work environment.
• Ability to prioritize work effectively and be self-motivated to work independently and follow-through to meet department deadlines.
• Ability to deliver high-level customer service.
• Excellent written and verbal communication skills.
• Experience with troubleshooting system problems and command line skills strongly preferred.
• Familiarity with project management methodology and ability to both lead, and participate in, projects.
• Strong computer, hardware, software, and analytical skills.
• Well-grounded philosophy of honesty, integrity and respect
• Demonstrated ability to establish and maintain effective working relationships with various constituents including both internal to the organization and with the public
• Plan, design, and maintain custom and third party programs
• Provide technical support to users
• Explain technical concepts in non-technical terms to faculty, staff and students;

GUIDELINES AND SUPERVISION: Programmer Analyst will report to the Chief Information Officer and should be able to work autonomously with limited supervision. The position requires the use of sound independent judgment and the ability to work both independently and as a member of the Campus Technology team. The Programmer Analyst must maintain strict confidentiality of records and respect and that all aspects of the office work will be accomplished with the highest professional standards.

Work Schedule: Hybrid

Hours: The university's operating hours are Monday through Thursday 8am - 5pm and Friday 8am - 1pm. This position requires occasional weekends and hours outside of regular business hours.

Licenses: NA

DISCLAIMER: The preceding job description has been designed to indicate the general nature and essential duties and responsibilities of work performed by employees within this classification. It may not contain a comprehensive inventory of all duties, responsibilities, and qualifications required of employees to do this job.

We believe that a diverse faculty and staff are essential to achieving academic excellence; thus, we strongly encourage applications from candidates from all racial, ethnic, and cultural backgrounds.