Application Developer
UCSB Advancement Services
Summary of Job Details
The Application Developer for Advancement Services serves as the technical expert responsible for the design, development, maintenance, and optimization of the University’s enterprise Advancement CRM systems (currently Advance*) and related technologies, supported by an Oracle Database environment. Under general supervision and with a high degree of individual responsibility and integrity, this role works with a team of programmers while ensuring the successful implementation of customizations, integrations, and data management solutions that support the university’s fundraising, alumni relations, and donor stewardship efforts. The position combines advanced programming expertise with leadership experience and a strong understanding of advancement systems to ensure technical solutions align with departmental strategic goals. This position also requires strong communication and collaboration skills, working closely with university executives, fundraisers, gift administration, and prospect services staff to support reporting needs, data analysis, and the delivery of accurate and actionable advancement information that informs strategic fundraising initiatives and decision-making. Designs, develops, and optimizes complex reports and reporting frameworks. Conducts comprehensive data audit processes, establishes validation standards, and ensures consistency and accuracy across reporting outputs. Leads the department in report development, testing, and documentation. Supports advanced data analysis initiatives to identify trends and inform strategic decisions. Designs and delivers dashboards and visualizations tailored to diverse stakeholders. Promotes effective use of analytical tools in data interpretation and presentation. Manages data import processes from internal and external sources, including third-party screenings. Defines standards for data mapping, transformation, and validation. Ensures accurate integration of screening results and guides the team in maintaining efficient, repeatable workflows. Develops and maintains integrations between internal systems and third-party vendor applications/software to ensure reliable and timely data exchange. Establishes monitoring, alerting, and error-resolution protocols. Troubleshoots synchronization issues, reconciles discrepancies, and improves overall integration reliability. Defines and enforces data standards, business rules, and quality controls. Performs data cleansing, deduplication, and validation efforts. Collaborates with stakeholders to promote best practices and ensure long-term data reliability. Manages user access, roles, and permissions to ensure appropriate and secure access to sensitive data. Leads the implementation of data security protocols within the Ellucian Advance system to safeguard donor and alumni information. Ensures compliance with relevant regulations and institutional privacy policies, across all technical solutions and system customizations. Collaborates closely with the security team on campus to enforce data access controls and conducts periodic security audits while advising on best practices for secure data handling. Performs database performance tuning, maintenance, and optimization. Develops and reviews queries, stored procedures, and scripts. Supports backup and recovery planning, system upgrades, and long-term technical strategy.
Required Qualifications
- Bachelor’s Degree in Computer Science, Information Technology, Data Science, or a related field (or equivalent work experience)
- 4-6 years Expertise and working knowledge in Oracle PL-SQL, Oracle DBA, ASP.net, Visual Basic, C#, C++, Crystal Reports, MS Access, IIS, HTML, CCS, JavaScript, Perl, XML and PHP
- 4-6 years of experience and proficiency with web development, security, maintenance and interfacing complex web reporting and web applications
- Deep knowledge of database management, optimization, and reporting tools
Special Conditions of Employment
- Satisfactory criminal history background check
Hiring/Budgeted Salary or Hourly Range: $83,165 to $111,000/year.
Full Salary Range: $83,165 to $150,565/yr.
The University of California is an Equal Opportunity Employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law. To review detailed job description and apply online, please visit at https://jobs.ucsb.edu, Job # 88368.
Leave a Response