Required:

• A bachelor’s degree or a combination of related education and work experience in the areas of business or systems process analysis to equal four years.
• Skills in relational database technology and SQL.
• Skills in a programming language.
• Demonstrated excellent customer service orientation, including listening skills.
• Demonstrated ability to create work plans and manage deadlines.
• Demonstrated ability to learn quickly and to independently develop solutions, analyze alternative solutions, and make recommendations. Excellent attention to detail.
• Demonstrated experience working well in a team environment.
• Excellent verbal and written communication skills.
• Excellent interpersonal skills with the ability to establish and maintain relationships at all organizational levels

Preferred:

• 1 or more years of experience with the following software:
  • Oracle 10G or above
  • SQL and PL/SQL
  • HTML and Java Script
• Experience using a fundraising software or donor management database.
• Experience working in a non-profit or higher education environment.

Overview

This is a query specialist position within the University of Minnesota Foundation’s (UMF) Information Systems (IS) department. The department provides the donor and alumni database of over a million records for the University of Minnesota on an enterprise-wide level. The systems include the donor management, fund accounting, and data warehouse applications. These systems are designed, built, and supported using state-of-the-art web-based technologies and are used by over 1,600 active users on five campuses. The highly sophisticated web system utilizes Oracle databases and development tools.

The primary responsibilities of this position are: (1) under direct supervision, provide day-to-day database query support for mission critical applications, (2) write and test ad hoc queries, (3) support existing application programs in a web environment, (4) document processes and communicate with end users.

Responsibilities

Query Support (60%)

• Create ad hoc queries for users, including communicating directly with them to clarify needs and provide expertise on data to drive insights into fundraising
• Position evaluate Foundation and user data requirements and develop analytical and reporting tools to address needs.
• Develops, deploys, and maintains reports and dashboards, which include query tools and data visualization.
• Develop and maintain a thorough working knowledge of the donor management database and how it is used to support development and alumni activities.

Program Creation and Maintenance (30%)

• Develop and execute test plans, troubleshooting when necessary.
• Assist with research related to user needs.
• Ensure overall data classification compliance and data integrity.
• Write new SQL script, procedures and packages to address data requests.
• Maintain and debug existing application programs.

Documentation and Communication (10%)

• Create technical and user documentation for new programs, functionalities and requirements.
• Assist with communication and presentations for end users.

Demonstrate commitment to valuing diversity and contributing to an equitable and inclusive working and learning environment (exhibit 100% of the time)

• Continuous learning in diversity, equity and inclusion for oneself and team via training, podcasts, articles, etc.
• Seek to explore and understand cultural differences and create a culture of belonging.
• Develop and employ anti-racist practices and principles to accomplish work.
• Advocate for employees of all ethnicities, genders, ages and backgrounds
• Cultivate and develop inclusive and equitable working relationships with employees, colleagues, stakeholders, etc.

Starting Salary: $54,000 - $64,000 based on experience

At the University of Minnesota Foundation (UMF), our mission is to connect passion with possibility, inspire generosity, and support greatness at the University of Minnesota by placing donors at the heart of everything we do and every decision we make. UMF is a nonprofit organization responsible for raising and managing gifts to the University of Minnesota.

For more information about UMF, please visit https://give.umn.edu/about/about-umf.

Applications must be submitted online. To be considered for this position, please click the Apply button and follow the instructions. You will be given the opportunity to complete an online application for the position and attach a cover letter and resume.

Additional documents may be attached after application by accessing your "My Job Applications" page and uploading documents in the "My Cover Letters and Attachments" section.

To request an accommodation during the application process, please e-mail employ@umn.edu or call (612) 624-UOHR (8647).

The University recognizes and values the importance of diversity and inclusion in enriching the employment experience of its employees and in supporting the academic mission. The University is committed to attracting and retaining employees with varying identities and backgrounds.

The University of Minnesota provides equal access to and opportunity in its programs, facilities, and employment without regard to race, color, creed, religion, national origin, gender, age, marital status, disability, public assistance status, veteran status, sexual orientation, gender identity, or gender expression. To learn more about diversity at the U: http://diversity.umn.edu

Any offer of employment is contingent upon the successful completion of a background check. Our presumption is that prospective employees are eligible to work here. Criminal convictions do not automatically disqualify finalists from employment.

Please note: All employees at the University of Minnesota are required to comply with the University’s Administrative Policy: COVID-19 Vaccination and Safety Protocol by either providing proof of being fully vaccinated on their first day of employment, or complete a request for an exemption for medical exemption or religious reasons. To learn more please visit: https://safe-campus.umn.edu/return-campus/get-the-vax

The University of Minnesota, Twin Cities (UMTC)

The University of Minnesota, Twin Cities (UMTC), is among the largest public research universities in the country, offering undergraduate, graduate, and professional students a multitude of opportunities for study and research. Located at the heart of one of the nation's most vibrant, diverse metropolitan communities, students on the campuses in Minneapolis and St. Paul benefit from extensive partnerships with world-renowned health centers, international corporations, government agencies, and arts, nonprofit, and public service organizations.