Reporting Specialist

Required 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
• Demonstrated 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 Qualifications

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

This is a Reporting Specialist position within the University of Minnesota Foundation’s (UMF) Information Technology (IT) department. The department administers 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,800 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 and reporting support for mission critical applications, (2) write and test ad hoc reports, (3) support existing application programs in a web environment, (4) document processes and communicate with end users.

Starting salary: $58,000- 62,000 based on experience.
Responsibilities

Query Support (70%)

• Create ad hoc reports using SQL for users, including communicating directly with them to clarify needs and provide expertise on data to drive insights into fundraising
• Evaluate Foundation and user data requirements and develop analytical and reporting tools to address needs
• Develop, deploy, and maintain reports and datasets that support data analysis and 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 (20%)

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

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

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.

At the University of Minnesota, we are proud to be recognized by the Star Tribune as a Top Workplace for 2021, as well as by Forbes as Best Employers for Women and one of America’s Best Employers (2015, 2018, 2019, 2023), Best Employer for Diversity (2019, 2020), Best Employer for New Grads (2018, 2019), and Best Employer by State (2019, 2022).