For more than 150 years, the School of the Art Institute of Chicago (SAIC) has been a leader in educating the world’s most influential artists, designers and scholars. Located in downtown Chicago with a fine arts graduate program consistently ranking among the top four graduate fine arts programs in the nation by U.S. News and World Report, SAIC provides an interdisciplinary approach to art and design as well as world-class resources, including the Art Institute of Chicago museum, on-campus galleries and state-of-the-art facilities. SAIC’s undergraduate, graduate and post-baccalaureate students have the freedom to take risks and create the bold ideas that transform Chicago and the world—as seen through notable alumni and faculty such as Michelle Grabner, David Sedaris, Elizabeth Murray, Richard Hunt, Georgia O’Keeffe, Cynthia Rowley, Nick Cave, and LeRoy Neiman.
Utilizes extensive functional and technical knowledge to provide systems support to a broad spectrum of administrative and enrollment entities across the School, working in a collaborative work environment with administrative users across the School. Provides business and system analysis and design. Manages all data integrations for School. Assists the Executive Director with strategic planning, project management, and system implementation and administration for technology that meets a wide-variety of School administrative business process and workflow needs.
1. Business systems analysis. Identifies and implements information system solutions that support efficient, effective work at the School. Analyzes data for possible new systems to implement or old systems to improve. Serves as project manager for various administrative technology projects for the School’s administrative, operational, enrollment, and student services areas. Works with clientele to make sure all needs are met by the new or improved implemented system.
2. System data integrations. Serves as the project manager, designer, and developer for various School system interfaces using Jitterbit Harmony and complementary tools. Defines interface requirements and develops these system interfaces for both internal and external systems across the institution, including interfaces and data loads between core systems and third-party systems. Designs, develops, and supports automated processes to support over thirty administrative system interfaces between the institution’s internal and external system solutions, including an ever-growing web of systems and applications used by the School to meet its broad scope of business needs and workflows.
3. Data warehouse/data mart integration and support. Supports the planning, development, and maintenance of a Data Warehouse for the School’s executive management planning and forecasting needs using Microsoft SQL Server Enterprise and Microsoft Power BI Pro.
4. Data analytics and reporting. Analyzes the requirements, develops specifications, and writes complex queries and reports for end-users using any of the School’s many administrative technologies, as appropriate, including PeopleSoft Campus Solutions, the School’s primary Student Information System (SIS).
5. System and process improvements. Evaluates PeopleSoft delivered new and existing functionality and assesses the institution’s need for that functionality. Responsible for analyzing business process needs related to the School’s SIS solutions and making recommendations for improvements, modifications, and planning for the School’s future SIS solution(s).
6. System user security. Designs, manages, and maintains or oversees administrative application user security needs, including School SIS administrative and self-service end-user security needs, including School User IDs, Roles, and Permission Lists.
7. System administration support. Serves as a system administrator for various School software solutions, as appropriate, including Blackboard Transact and ID Works system. Designs and develops add-on solutions and modifications to these systems as needed.
8. Supports the Executive Director with the business analyses and project development of administrative technology for the School's administrative, operational, enrollment, and student services departments and strategic planning.
9. Serves on institutional committees, as necessary.
10. Maintains familiarity with the latest trends in technology.
Experience designing and maintaining user security structures for a variety of applications is preferred.
Knowledge of SQL scripting and SQL database administration, Common App (Admissions), Cashnet (tuition payments), Marketo (Marketing Automation), RMS (residence management), Salesforce (CRM) SEVIS (Homeland Security Exchange Visitor program), SlideRoom (student e-portfolio and Admissions), Exact Target (Marketing Automation), Collegiate Link (student groups), EMS (course and event scheduling), Medicat (student medical records).
Knowledge of VBA programming and MS Access database/application development and database administration is beneficial.
Experience handling escalated requests for IT assistance from other School employees that may include server access, data migration, and system errors.
Excellent oral and written skills.
Demonstrated ability to work in a team environment.
Demonstrated initiative—dedicated, reliable, and detail-oriented.
Strong computer skills, both functional and technical.
The Art Institute of Chicago is an equal opportunity, equal access employer fully committed to achieving a diverse and inclusive workplace.