Job location: University Campus

Employment Type: Full-time
Posted data: 2019-08-06
Req: R2298
Job Description Summary

The Programmer Analyst is responsible for activities relating to the software development life cycle and SQL reporting. This includes systems analysis, design, programming, end user testing/training, documentation, and support for the university SQL reporting tools, and related technologies. While this position typically works normal business hours, early mornings, nights or weekends may be required for resolution of production related issues or to assist with system implementations/upgrades.

Job Description

Duties and Tasks:

The following duties are typical of those performed by employees in this job title; however, employees may perform other related duties, and not all duties listed are necessarily performed by each employee in the job title.

• Provide SQL reporting support for the university which includes data extracted from administrative software systems such as: legacy and future ERP and Cloud Based Systems
• Provide expertise in detecting, troubleshooting, and problem resolution for SQL related issues
• Provide SQL and SQL reporting support to ensure the appropriate, efficient, and comprehensive use of system software
• Assist department and data managers in maintaining data integrity of shared databases
• Work collaboratively with users on projects to enhance customer use and reporting from applications.
• Define business requirements, design and reporting solutions through system analysis and programming, facilitate user testing, coordinate with ERP and Cloud Administrators for all production custom software installs, and perform post-implementation support and roll out activities
• Provide documentation of processes, procedures, and problem resolution following departmental procedures
• Develop skills with new technologies required to stay current with applications support needs
• Cultivate positive and productive relationships with other departments and demonstrate creativity in recommending solutions to user problems to enhance and streamline their processes
• Attend Users’ Group meetings, workshops, and training sessions for job related functions
• Perform other related duties as assigned

REQUIRED KNOWLEDGE, SKILLS AND ABILITIES:

Knowledge:

• Bachelor’s degree in computer science or related field and three to five years systems analysis, reporting and programming experience or a combination of education and experience totaling 6 years
• Minimum three years’ experience in SQL reporting (higher education environment is preferred)
• Experience with SSRS, SSIS and related reporting and data analysis tools (ex: Tableau or Power BI)
• Demonstrated experience with structured programming & query languages
• Broad knowledge of troubleshooting in resolving a variety of complex user problems
• Must possess an understanding of and a commitment to, the university mission and core values

Skills:

• Experience supporting and collaborating with end-users of various skill level
• Excellent communication skills, both verbal and written
• Excellent written and oral communication skills
• Excellent interpersonal skills
• Solid organizational and time management skills

Abilities:

• Desire and ability to learn and apply new skills/technologies quickly
• Ability to read, interpret, and apply technical publications, manuals, and other documents
• Ability to analyze programs, rules, regulations, ordinances, and legislation and how those are or may be applied to technical systems, workflows, and reports
• Ability to deliver secure code that passes application security standards
• Ability to establish, maintain, and foster positive and harmonious working relationships with those contacted in the course of work
• Ability to convey technical information to non-technical audiences
• Ability to work positively and cooperatively with others
• Flexible and adaptable to changing activities and work loads
• Ability to multi-task effectively and balance multiple priorities
• Ability to plan, prioritize, and follow through on assignments
• Strong problem solving skills and decision making ability
• Demonstrated ability to work as a “self-starter”
• Ability to use discretion in handling confidential matters
• Ability to work independently

ENVIRONMENT: 

The work environment characteristics described here are a representation of those an employee encounters while performing the essential functions of this job.  Reasonable accommodations may be made to enable qualified individuals with disabilities to perform the essential functions.  The term “qualified individual with a disability” means an individual with a disability who, with or without reasonable accommodation, can perform the essential functions of this position.

While performing the duties of this job, the employee is regularly required to communicate professionally in person, over the telephone, through email and other electronic means, move about the office and University, handle various type of media and equipment, and visually or otherwise identify, observe and assess.   The employee is occasionally required to lift up to 10 pounds unless otherwise specified in the job description.

NOTICE:

The intent of this job description is to provide a representation of the types of duties and responsibilities that will be required of positions given this title and shall not be construed as a declaration of the total specific duties and responsibilities of any particular position.  Employees may be directed to perform job-related tasks other than those specifically presented in this description.  Saint Leo University is an Equal Opportunity Employer and embraces diversity as a critical step in ensuring employee, student and graduate success.