Provide analysis, design, and programming support for Institutional Advancement enterprise applications including but not limited to Oracle-based Ellucian Banner ERP and aid in the implementation process of a new Institutional Advancement CRM (data cleanup, data mapping, implementation, and testing)
Essential Job Functions:
Implementation Services: Aid in the process of implementing a new CRM solution for Institutional Advancement. Serve as the primary programmer/analyst for the new CRM implementation. Perform data cleanup and mapping processes, provide input in the selection process, and aid in the implementation and integration of the new system with Banner.
Analysis: Analyze and identify user needs and develop and implement effective solutions to meet user requirements. Maintain current knowledge of the features of the Banner software and Denison modifications, and evaluate user needs in relationship to the features provided in the current Denison software set to be able to recommend Banner features and identify gaps requiring other software. Identify and implement techniques which will improve productivity for the user community
Software Development and Maintenance: Design effective solutions that may be based on either purchased software or Denison-developed software. Develop administrative applications and identify areas amenable for system enhancements; design, write, test, and document new applications and features; develop database triggers, functions, and procedures as needed, and implement purchased solutions where appropriate. Maintain software functionality: maintain data integrity for assigned systems and in compliance with campus-wide data governance processes; install, test, and implement vendor upgrades and patches in conjunction with the supported user community; maintain Denison modifications.
Collaboration and Documentation: Adhere to institutional change management/change control practices. Document all proposed changes, validate changes in test instances with ITS cooperation, and coordinate any changes to production systems with ITS resources, and during pre-approved campus maintenance windows. Track all work in the ITS development KanBan to assure project dependencies are identified. Coordinate with the Data Governance team on any proposed changes to the institutional data dictionary or potential data-dependency implications. Maintain effective communication with peer-level programmers in ITS regarding system updates, integration projects, and proposed process changes. Confer and coordinate with BI team on any potential changes to historical reports due to changes to updated data schemas.
Data Support: Develop and maintain the back-end processes to support data and needs for the continuous development of reports and dashboards for a Cognos reporting environment. Support products using business intelligence concepts of data models (Ellucian's ODS), enhanced query capabilities, dashboards, and performance metrics.
Troubleshooting: Troubleshoot issues with Banner and other related enterprise software, reconcile users' data and processing problems and coordinate inter-office projects and data dependency issues. Resolve issues to the satisfaction of the requestor.
Performs related work as required or assigned.
Associate's Degree and five years of work related experience. Must be familiar with database concepts, advanced SQL programming beyond queries, and integrating third-party software solutions with Systems of Record (both on premises and cloud-hosted).
Experience and conceptual understanding of the project life cycle process. Ability to handle multiple tasks under the pressure of tight deadlines; ability to work and learn independently; good communication skills; apply sound project management processes toward all tasks; display initiative and self- motivation.
Previous experience on a higher education Institutional Advancement programming team, or commensurate experience with other mid-size non-profit fundraising organizations. Experience working in a decentralized IT infrastructure – where change-management, documentation, inter-departmental communication and cooperation were heavily exercised.
Bachelor’s degree in a related field. Experience with higher-ed advancement solutions: (Ellucian's Banner Advancement preferred). Experience with SQL and PL/SQL. Experience with IBM Cognos, data warehousing, Linux, and Oracle technologies. Experience with modern fundraising CRM products and business processes is highly desired.
To achieve our mission as a liberal arts college, we continually strive to foster a diverse campus community, which recognizes the value of all persons regardless of religion, race, ethnicity, gender, sexual orientation, disability, or socio-economic background. For additional information and resources about diversity at Denison, please see our Diversity Guide. Denison University is an Equal Opportunity Employer.
Background Check Statement:
The final candidate will undergo a background check as a conditional offer of employment.
Internal Number: 2145
About Denison University
Denison University is an academically rigorous liberal arts college with a diverse campus community. It offers a competitive salary and a comprehensive benefits package. Denison is located in the village of Granville, 25 minutes from Columbus Ohio, the state capital, which hosts a wide range of cultural and artistic opportunities. Granville also offers an excellent public school system and easy access to outdoor activities.
BACK TO TOP
Power Platform UGs Career Center is Just One of the Benefits.
Discover what else User Group Membership has to offer!
The job you are trying to reach from was originally posted at Power Platform UGs Career Center.
Copyright 2018 Dynamic Communities. All rights reserved.