About Us:

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.

About the role:

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.

What you’ll do:

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.
• Develop, deploy, and maintain 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)

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

We take care of you:

• Comprehensive and competitive benefits package that includes medical, vision, dental, and pharmacy coverage; life insurance; retirement; long-term care insurance; and disability coverage.

• Come. Work. Stay. Play. The U of M is conveniently accessible by light rail, bus, and bike. And we offer discounted bus transportation through our “U-Pass” program.

• The University of Minnesota embraces diversity and equal opportunity. We are committed to building a team that represents a variety of backgrounds, perspectives, and skills.

Qualifications:

• 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 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.

Diversity:

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.

Employment Requirements

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 report complete vaccination against COVID-19 or submit documentation requesting a medical or religious exemption on their first day of employment. To learn more, please visit the University's COVID-19 Response webpage.

How to Apply:

Applications must be submitted online through the U of M Careers site.  To submit your application, please follow this link: https://hr.myu.umn.edu/jobs/ext355688. If you have any difficulties or questions while applying feel free to contact Andrew Hanson, Sr. HR Generalist at adhanson@umn.edu.

Organization Details