Employment opportunities

Position description

Position title: SQL Programmer Analyst

Reports to: Associate Vice President of Integrated Technology

Position summary:

Responsible for the design, development and implementation of the reporting required to support University operations. Collaborates with the MIS team to design data models, data definitions, and reporting services. Participates in data integration strategy, including planning, development and implementation. Identifies common data and associated relationships, resolves data definition and ownership issues, and ensures data integrity. Coordinates process to develop data standards policy to improve data accuracy, integration, access and integrity. Provides technical support, analysis and solutions to staff, faculty and students (end users) using the University's databases and report development tools.

Mission and strategic plan

This position supports the efforts of SMU staff and faculty in their efforts to increase enrollment, advise students, and improve alumni relationships. This will be accomplished through focused business process analysis, information management and information analysis.

Level of supervision and supervisory responsibility

General Supervision: The employee carries out recurring assignments without specific instruction. The supervisor intercedes and provides direction for only new or unusual problems which involve deviations from normal policies, procedures and work methods. The employee’s work is reviewed upon completion and only periodically to verify compliance with policies and procedures.

Responsibilities and essential functions

  • Develop SQL Reporting Service reports and oversee the functioning of the university report server. Assist end users in all aspects of reporting, including development of reports using SunGardHE PowerCAMPUS reporting tools, SSIS solutions, and SQL Reporting Services. Monitor report delivery and security.
  • Collaborate with MIS team in the maintenance of settings and processes in the university’s student information systems and enterprise systems with an emphasis on data standards and consistency.
  • Document and diagram business processes and solutions. Develop and maintain up-to-date documentation in the university's knowledgebase.
  • Communicate with and participate in technology planning with other university staff. Analyze needs, propose and develop solutions.
  • Facilitate and participate in the testing/debugging of system upgrades and new functionality. Diagnose and resolve problems occurring in multiple software and database platforms.
  • Other related duties as assigned.


  • Possess a "big picture" understanding of the University's business needs, processes and departments.
  • Ability and willingness to participate in training to maintain and expand knowledge of Ellucian PowerCAMPUS, Ellucian Self-Service, and other applications and skills needed to perform duties.
  • Demonstrated ability to initiate, manage, and complete projects within required deadlines.
  • Ability to manage a complex workload and set priorities based on established goals.
  • Ability to work collaboratively and collegially with faculty and staff in units across the university.
  • Experience training others in use of above or related technology.
  • Excellent customer service and interpersonal communication skills.
  • Demonstrated self-starter skills with the ability to research, troubleshoot and acquire additional skills.
  • Must be supportive of a Catholic, Benedictine philosophy of education.

Physical demands:

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

  • Moves objects (less than 20 pounds) long distances (more than 20 feet).
  • Ability to be mobile campus wide for appropriate business needs.
  • Operates a variety of standard office equipment requiring continuous or repetitive arm-hand movements.
  • Reading, writing, speaking, hearing, standing, bending, sitting.
  • Learning and comprehending.
  • Requires visual concentration on detail.
  • Manual dexterity and precision required for keyboarding.
  • Must be able to sit for long periods at a time at a computer.
  • May occasionally be required to deal with distraught people.
  • Must be able to concentrate on details and process complex information while experiencing frequent interruptions.
  • Must be able to communicate effectively with people at all levels under stressful conditions.

The principles of the Catholic Benedictine tradition, equal employment opportunity, and nondiscrimination are fundamental to the mission, goals, and objectives of Saint Martin’s University. The University does not discriminate in employment or in the delivery or administration of its educational programs, policies, scholarship and loan programs, athletic or other University programs on the basis of sex, sexual orientation, race, color, religion (except as a bona fide occupational qualification for certain select positions), marital status, national or ethnic origin, military or veteran status, age, or disability.

Students or employees with concerns or complaints about discrimination on the basis of sex in employment or an education program or activity, or any other inquiries related to the University's non-discrimination policy, may contact the following individual:

Cynthia Johnson
Director of Human Resources/Title IX Coordinator
5000 Abbey Way SE, Lacey WA 98503

Consistent with the requirements of Title IX of the Education Amendments of 1972 and the regulations adopted under that law, the University has designated the above individual as the University's Title IX Officer, responsible for coordinating the University's Title IX compliance. Individuals may also contact the Office for Civil Rights, U.S. Department of Education, 915 2nd Avenue, Room 3310 Seattle, WA 98174-1099, Telephone: (206) 220-7900, TDD: (206) 220-7907.