System Analyst

Position: Application & Systems AdminLocation: Granville, OH; Hybrid 8am-4pm, 3 days a week (every Wednesday and can choose the other days)Duration: PermSalary Range: $90,000 - $115,000Must Haves: 8 years of work-related experienceFamiliar with advanced database and SQL concepts (Oracle SQL or Microsoft Oracle)Advanced programming beyond SQL quiresIntegrating third party software solutions with system of record (On Premise and Cloud)Experience with InterfacesProficient in excelExperience with Razors EdgeExperience with visual basicPlusses:Prior experience on a higher education Instructional Advancement programming team, or commensurate experience with other mid-sized non-profit fund-raising organization.Experience working in a decentralized IT infrastructure where change management documentation, interdepartmental communication and cooperation are heavily exercised.Experience with modern fundraising CRP products and business processes is highly desired.Job Description: Provide analysis, design, and integration support for Institutional Advancement applications including but not limited to Raiser's Edge, Fundraising Performance Management and Aqueduct data warehouse. Provide analysis for proposed new technology. Design integrations using Denison's iPaas solution and support existing integrations. Will also be creating interfaces within their system and sending that out to different divisions on campus or collecting data from other divisions to bring that information back to your division.Essential Job FunctionsLearn new technologies and evaluate them in conjunction with existing Advancement business processes.Identify, develop, and maintain any integrations for Advanced Systems e.g. Raiser's Edge, Workday, Banner, etc.. that will link with cloud services or on-premise applicationsMaintain Banner jobs written in Oracle SQL and scripted with Bash.Stay current with existing software and technologies in use at Denison including IT security and integrate best practices.Create new imports into Raiser's Edge CRM using Omatic's Importomatic tool. Stay current on Raiser Edge changes and assess how they might affect our imports and recommend moving to cloud when appropriateInvestigate automating Raiser's Edge with tools such as Power Automate. Collaborate with ITS on issues related to hosting.Learn how to use the Raiser's Edge SKY API and collaborate with other RE clients who have used the API to automate RE processes.Recommend tools and timing for moving forward with SKY API.Using MS SQL server skills maintain reporting data warehouse.

Created: 2024-11-07