Location: Granville, OH; Hybrid 8am-4pm, 3 days a week (every Wednesday and can choose the other days)
Duration: Perm
Salary Range: $90,000 - $115,000
Must Haves:
8 years of work-related experience
Familiar with advanced database and SQL concepts (Oracle SQL or Microsoft Oracle)
Advanced programming beyond SQL quires
Integrating third party software solutions with system of record (On Premise and Cloud)
Experience with Interfaces
Proficient in excel
Experience with Razors Edge
Experience with visual basic
Plusses:
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 Functions
Learn 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 applications
Maintain 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 appropriate
Investigate 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.