Job ID359764 LocationTwin Cities Job FamilyInformation Technology Full/Part TimeFull-Time Regular/TemporaryRegular Job Code8631BI Employee ClassCivil Service About the Job 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. Qualifications 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 About the Department At th 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. Benefits Working at the University At the University of Minnesota, you'll find a flexible work environment and supportive colleagues who are interested in lifelong learning. We prioritize work-life balance, allowing you to invest in the future of your career and in your life outside of work. The University also offers a comprehensive benefits package that includes: Competitive wages, paid holidays, and generous time off Continuous learning opportunities through professional training and degree-seeking programs supported by the Low-cost medical, dental, and pharmacy plans Healthcare and dependent care flexible spending accounts University HSA contributions Disability and employer-paid life insurance Employee wellbeing program Excellent retirement plans with employer contribution Public Service Loan Forgiveness (PSLF) Financial counseling services Employee Assistance Program with eight sessions of counseling at no cost with free or reduced rates in the Twin Cities metro area Please visit the for more information regarding benefits. How To Apply 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. 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: 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. About the U of M The University of Minnesota, Twin Cities (UMTC) The University of Minnesota, Twin Cities (UMTC), is among the largest public research universities in the... For full info follow application link. 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.