Position Details

Home  /  Human Resources  /  Position Details  

Student Systems Programmer/Analyst

Human Resources
Monday, November 05, 2012
 
Responsible for analyzing the business needs of Financial Aid and other Student System-related offices to help identify business problems and propose solutions. Seeks to understand Student System administrative system best practices. Ensures seamless data transfer from the ERP system to third party databases and vendors. Consults with users to identify current operating procedures and to clarify program objectives. Extracts data for use in reports and integration activities. Provides Tier III applications support and development. Provides user training on the administrative system.
Position Type: Full Time
Department: IT Business Services
Reports To: Applications Support Manager (Wesley Shelton)
FLSA Status: Exempt
Location: Main Campus

Click here for how to apply

Job Description:

ESSENTIAL DUTIES AND RESPONSIBILITIES include the following.
Field tier-three technical requests and resolve issues, primarily for Financial Aid and Student systems.

Assist in performing system testing with sample/live data.

Review, analyze, and modify programming systems including encoding, testing, debugging and installing to support the organization's application systems.

Support ERP and other SQL database associated/connected applications and interfaces.

Work with Software-as-a-Service providers and vendors to ensure user needs are met and technical issues are resolved in a timely manner.

Work with application users to define and document application systems requirements.

Review, analyze, and evaluate application systems and user needs.

Work with university Student Systems staff to align application usage with best practices.

Work with manager to develop problem statements and modification/enhancement specifications and to formulate systems to parallel overall business strategies.

Translate problem statements and specifications into programming languages.

Code computer programs using .NET, T-SQL, Ellucian’s Envision toolkit, Colleague Studio, and/or other ERP-associated tools. 

Write queries, stored procedures and functions using Microsoft SQL Server.

Move data into and out of Microsoft SQL databases using SQL Server Integration Services.

Develop program module test procedures, generate required test data files, and execute testing procedures.

Revise existing system logic difficulties and documentation as necessary to reduce operating problems, expedite processing, and maximize systems efficiency.

Prepare system and programming documentation for users and other programmers/analyst in accordance with internal and external standards.

Provide analysis of data/information for routine and special reports.

Identify, develop, test, and deploy new functionality to enhance the IT capabilities of the institution.

Train applications users as required.
Work with business units/technical areas to conduct needs assessments to ensure training needs are met.
Other duties as assigned by the Applications Support Manager.

QUALIFICATIONS  To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

EDUCATION and/or EXPERIENCE
Bachelor’s degree in computer science or related field; three to five years systems analysis and programming experience; or equivalent combination of education and experience.  Ellucian’s Colleague or Benefactor support experience or previous administrative support in higher education is preferred.

CERTIFICATIONS
Maintenance and MCTS: SQL Server 2008, Database Development and MCTS: SQL Server 2008, Business Intelligence Development certifications highly desirable.

KNOWLEDGE, SKILLS & ABILITIES
Strong knowledge and understanding of data processing, systems analysis, and office automation.
Sound knowledge of programming methods and procedures, documentation procedures, program flow charts, and operator instructions.
Knowledge of SQL Server.
Ability to understand and work with complex database systems.
Knowledge of programming languages including Ellucian’s Envision Toolkit, Colleague Studio and T-SQL.
Ability to use ODBC to query data in central database systems with current desktop software (MS Office & Crystal Reports).
Great attention to detail with an eye towards accuracy.
Ability to work with Student Systems staff to analyze issues, research solutions, and recommend best practices.
Ability to listen actively and demonstrate understanding of others’ perspectives.
Ability to welcome and acknowledge the diverse ideas and input of others.
Ability to collaborate with others by maintaining a respectful, open-minded approach.
Ability to help others when needed and contribute productively to team goals.
Ability to recognize and acknowledge the value of others’ contributions.
Ability to seek opportunities to develop your own skills and engage in continuous learning.
Ability to provide honest, helpful feedback and guidance where appropriate to enhance others’ skill development.
Ability to share your own experience and expertise with others.
Ability to treat every individual with dignity, fairness, and respect.
Ability to demonstrate consistency between what is said and what is done.
Ability to earn the respect of others by continually delivering on promises and commitments.
Ability to accurately convey the facts without bias.
Ability to do the right thing and confront and report unethical behavior.
Ability to maintain a professional appearance and office atmosphere.
Strong organizational & time-management skills with the ability to handle multiple tasks.
Ability to provide individual and group-based seminar/workshop hardware/software training.
Ability to work independently with minimum supervision.
Ability to work cooperatively with a diverse group of individuals.
Ability to follow standard office practices and procedures.
Ability to follow University and departmental office procedures/policies.
Ability to use discretion in handling confidential matters.
Ability to work well under stressful conditions.
Ability to work in teams and lead multidisciplinary members.

LANGUAGE SKILLS Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations.  Ability to write reports, business correspondence, and procedure manuals.  Ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public.

MATHEMATICAL SKILLS Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals.  Ability to compute rate, ratio, and percent and to draw and interpret bar graphs.

REASONING ABILITY Ability to define problems, collect data, establish facts, and draw valid conclusions. Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables.

PHYSICAL DEMANDS  The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is frequently required to use hands to finger, handle, or feel and talk or hear.  The employee is occasionally required to stand, walk, sit, reach with hands and arms, and climb or balance.  The employee must frequently lift and/or move up to 10 pounds and occasionally lift and/or move up to 50 pounds.  Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, and ability to adjust focus. Must be able to move about and between campuses freely, including all offices and classroom areas. 

WORK ENVIRONMENT  The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

The noise level in the work environment is usually moderate. Evening/weekend hours as required.

 

 

To apply for an open faculty or staff position please send a current resume and a cover letter indicating position desired to: hr@txwes.edu, or Office of Human Resources, Texas Wesleyan University, 1201 Wesleyan, Fort Worth, TX 76105.

Contact Information

Office of Human Resources
Oneal-Sells Building, room 110

Phone: 817-531-4403
Fax: 817-531-4402
Email: HR@txwes.edu
Hours: Mon-Fri, 8am - 5pm


Smaller. Smarter.
Ramlink   |   BlackBoard   |   University Email   |   Faculty & Staff
Privacy Policy   |   Calendar   |   Maps   |   Employment   |   A - Z Index
A Methodist Institution Since 1890
1201 Wesleyan Street | Fort Worth, TX 76105
817.531.4444 © 2012 All Rights Reserved