Business Intelligence Programmer

University of Tennessee Foundation, Inc.

The University of Tennessee Foundation, Inc (UTFI) invites applications and nominations to fill the position of Business Intelligence Programmer for the Central Services office located in Knoxville, TN. Reporting to the Director of Business Intelligence, the Business Intelligence Programmer develops and maintains programs, documentation, and operating instructions, leads reusable programming solutions, participates in systems design, and manages project maintenance, major modifications, or system development.

The purpose of this position is to evaluate, develop, and implement efficient and secure processes, business rules, and workflows for data management in ACE, ensure data integrity and compliance through documentation and monitoring, collaborate with key partners to meet data needs, and identify and manage external resources and solutions for data enhancement. Job responsibilities include, but are not limited to:

Application Development: Reviews user needs, develops proposed system enhancements, and ensures adherence to project schedules. Designs, develops, and implements application enhancements, including software that supplements or integrates with existing systems. Provides technical assistance, trains users, and applies emerging technologies to improve efficiencies.

Data Systems Integration: Develop and oversee UTFI data integration strategies, architectures and workflows. Implement best solutions using best practices. Research and recommend key ETL technologies to meet business requirements, evaluate new technologies for improved functionality. Conduct data design architect reviews and troubleshoot integration processes. Document workflows and mentor IT staff on data integration best practices.

Data Maintenance and Enhancement: Evaluate, develop, and implement efficient and secure processes, business rules, and workflows for data imported/exported to and from UTFI Fundraising databases. Document and set data entry guidelines, policies and procedures to ensure compliance. Implement procedural changes for processing such transactions and manage data using department integrity queries and reports. Communicate and collaborate with key partners to identify and assess data needs and services with UTFI. Identify external data acquisition vendors, data hygiene tools, and other resources to enhance data in the database.

Required Education and Experience

The candidate who fills the Business Intelligence Programmer position is required to have:

- Bachelors Degree and 3+ years of experience is required. Experience must include:

- Enterprise- level application development

- Experience in at least two of the following using SQL, PL/SQL, ASP.NET, JavaScript, XML, C/C++, C#

- CRM databases focusing on data management

- Proficiency of Web Services protocols such as REST, SOAP, and API design for extensibility and portability

- Applications programmer on large- scale data base management systems

- Experience with complex relational database structures

- Experience in system analysis

Preferred Education and Experience

In addition to meeting the required qualifications, the preferred candidate will have:

- Knowledge of middleware systems including LDAP, CAS, security and user authorization systems

- Experience with Ascend or other fundraising software

- Experience with Tableau Cloud

- Experience with a University Enterprise Information System (Payroll, Student, Alumni, etc)

- Understanding of Institutional Advancement

Application Process: Priority will be given to applications received on or before September 24, 2024 via our Taleo application system. Applications must include a completed candidate profile, cover letter, resume, and contact information for three professional references. References will not be contacted without explicit permission of the candidate.

When determining minimum qualifications, only information entered into the candidate profile can be considered. Please ensure your candidate profile is completed in its entirety as it relates to qualifying education/work experience.

Questions about the search may be directed to hr@utfi.org.

Target Start Date: October 2024

Benefits: Recognized as a Top Employer by Knoxville Top Workplaces in 2022 and 2023, the Foundation’s greatest asset is our team. Foundation employees are eligible for a comprehensive suite of benefits that includes:

- Generous paid leave, accruing up to 24 days of vacation and 12 days of sick leave annually, plus 14 paid holidays and administrative closing days

- Flexible work arrangements, offering a hybrid schedule to most team members

- Education benefits for employees and their dependents at UT System campuses

- Retirement and deferred compensation plans, including 401(k), 403(b), etc.

- Comprehensive medical, dental, and vision insurance plans

- Employee discounts to attractions, services, and goods

_________

The Foundation: The University of Tennessee Foundation, Inc. is a not-for-profit 501(c)3 organization that serves as the preferred channel for private contributions benefiting students and faculty within the UT System. With a vision of being one of the top-performing advancement organizations in higher education, UTFI is committed to enhancing the educational landscape across the University of Tennessee campuses.

The UT System: The University of Tennessee System is comprised of campuses at Knoxville, Chattanooga, Pulaski, Martin and the Health Science Center at Memphis; the Institute of Agriculture; and the Institute for Public Service.

The University of Tennessee Foundation, Inc. is an EEO/AA/Title VI/Title IX/Section 504/ADA/ADEA employer. All qualified applicants will receive equal consideration for employment without regard to race, color, national origin, religion, sex, pregnancy, marital status, sexual orientation, gender identity, age, physical or mental disability, genetic information, veteran status, and parental status, or any other characteristic protected by federal or state law.