PROGRAMMER ANALYSTPosition Number:
University StaffJob Type:
Chicago-Water Tower CampusDepartment Name:
DEVELOPMENT & DONOR SERVICES (03635A)Is this split and/or fully grant funded? :
NoDuties and Responsibilities:
The Programmer Analyst is responsible for the design, implementation, and maintenance of Loyola’s Advancement reporting efforts and reporting environment.
The position works with the various departments that relate to reporting, including divisions of ITS and software vendors, as well as all units of Advancement, to meet data needs accurately and efficiently. Needs are to be met through ad hoc reporting, developing and publishing reports that are scheduled and delivered electronically or via a portal, maintaining a self-service reporting environment, providing training and writing documentation for accessing all of these options.
This position is critical to the success of Advancement efforts, in an environment that is driven by data and information. The position will interact with all Advancement departments, as well as departments throughout the University, in informing data-driven decision-making about Loyola’s constituents, alumni engagement, and fundraising financials.
DEPARTMENTAL EXPECTATION OF EMPLOYEE:
•Adheres to Loyola’s and Advancement Services’ policies and procedures
•Acts as a role model within and outside the department
•Performs duties as workload necessitates
•Maintains a positive and respectful attitude
•Abides by internal and external codes of ethics and confidentiality with regards to information maintained by Advancement
•Demonstrates flexible and efficient time management and ability to prioritize workload
•Meets department productivity standards and set goals
•Performs work with consistency, accuracy, responsiveness
•Takes ownership of assigned duties, projects and goals
•Demonstrates adaptability to change, and initiates or identifies change when necessary
•Continually maintains a detailed level of knowledge of best practices in data management, training, and business intelligence / reporting environments among peer and other institutions.
•Communicates effectively and regularly with director and co-workers about Department issues
ESSENTIAL DUTIES AND RESPONSIBILITIES
Successful candidates will be able to translate requests into accurate reflections of requirements, provide recommendations and plans for handing data, document processes, anticipate needs, write accurate and detailed reports, and develop and deliver training materials for using self-serve system functions.
•Plan, develop, organize, implement, design and evaluate reporting processes and efforts
•Write SQL and develop data models for the delivery of standard and ad-hoc reports
•Create meaningful data visualizations in Power BI to inform departmental decision making
•Translate requests into accurate reflections of requirements
•Communicate proactively with departmental stakeholders to determine data needs, to convey data limitations, and to translate needs into meaningful information
•Develop a standard timeline for all reporting projects and efforts
•Develop efficient methods for reporting productivity and engagement/fundraising progress
•Participate in the development of the department’s strategic goals and direction; set aggressive and relevant goals for the development of these functions.
•Monitor and participate in relevant online communities, training opportunities, publications, and professional groups to maintain a strong knowledge of developments in the fields of advancement, reporting, business intelligence, Oracle SQL, and database management.
•Other related duties and special projects as assigned
Bachelor’s degree or equivalent combination of education and experience in database management, programming, or data analysis.Qualifications:
Experience, Education and Licensure:
Bachelor’s degree or equivalent combination of education and experience in database management, SQL development, data analysis, or business intelligence report writing. Experience or equivalent knowledge of working in a fundraising environment preferred. An understanding of the advancement process, and advancement terminology preferred. Demonstrated superior collaborative skills strongly preferred. Demonstrated experience as a self-directed visionary who can mold existing and new tools and pieces into a streamlined client-oriented program.
Ability to communicate effectively in writing and speaking. Ability to make effective and persuasive presentations to internal groups and external individuals. Excellent interpersonal and customer relations skills.
Proficiency with InfoMaker, Powerbuilder, SQL, PL/SQL and/or related tools strongly preferred. Experience with BSR, SmartCall, PeopleSoft Student systems and/or Lawson Financials preferred. Required proficiency in information and database management.
•Ability to apply principles of logical thinking to a wide range of intellectual and practical problems
•Ability to analyze and interpret data
•Ability to carry out instructions furnished in written, oral, or diagram form
•Ability to identify patterns in data requests and translate recurring data requests to parameterized self-service reports
•Proficient in writing SQL
•Experience using Relational Database Management Systems
•Experience developing reports in WebFOCUS, or comparable reporting tools
•Experience development interactive visualizations using Microsoft Power BI, or comparable data visualization tools
•Experience using task management or ticket tracking software to track progress on tasks
•Experience with Git or other version control / code tracking system
NoRequired operation of university owned vehicles:
02/21/2021Quick Link for Posting: