Position title: SQL Programmer Analyst
Reports to: Associate Vice President of Integrated
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
- 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
- Ability to manage a complex workload and set priorities based on established
- 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.
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
- 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
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
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
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.