Washington University is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity or expression, national origin, genetic information, disability, or protected veteran status.
The Manager of Data and Reporting will provide leadership to Advancement Programs in the design and use of alumni, friend, and donor data.� Work with Advancement Services and other Advancement staff to facilitate data projects and deliverables in collaboration with Advancement Services, other Advancement staff, WashU IT, and external vendors.� Design and produce reports, audit queries and other data media to support fund-raising efforts of the University and to fulfill external data requests.� Expert-level knowledge of the Alumni & Development Information System (ADIS), its data, and how that data can support WU activities.� Coordinate deadline-driven projects for the team and provide direct supervision of a team of Senior Report Analysts.� Oversee the analysis of data projects based on University Advancement strategies to evaluate existing and upcoming initiatives and campaigns.� Gather and transform large data outputs into innovative analytic solutions that effectively support the advancement of University Advancement.� Serve as a data and reporting subject matter expert resource for advancement system replacement project, assisting with the assessment, analysis, auditing, and preparation of system data in advance of system migration.� This position reports to the Senior Director of Advancement Services.
PRIMARY DUTIES AND RESPONSIBILITIES:
Produce and distribute accurate and reliable data outputs from ADIS.
Review and evaluate user requests.� Produce and/or oversee fulfillment of the most complex and sensitive data outputs.
Design solutions and develop programs to standardize frequent requests, as well as address special requests for programming needs.
Conduct analysis on data and assist in the development of improved reporting to University Advancement.
Assist in maintaining the integrity of the ADIS database through scheduled audits, control of data entry, and file and systems balancing.
Manage the data reporting and analytics functions of University Advancement.
Manage high-impact data projects in collaboration with advancement partners or other university departments.
Execute priorities established in conjunction with the Associate Vice Chancellor for Administration and Advancement Services and the Senior Director of Advancement Services.
Maintain and implement controls and procedures to ensure adherence to University and department policies related to data governance and management.
Document data reporting and analytics processes and business rules.
Coordinate data related projects for three-person team, with direct supervision of the Senior Report Analysts.
Serve as a data and reporting subject matter expert resource for the University Advancement system replacement project.
Participate in the joint Advancement/IT data and reporting working group, providing guidance and insight related to data definitions, business rules, and data usage.
Participate in data-related project work, including assessment, analysis, auditing, and preparation of system data in advance of system migration.
Participate in reporting-related project work, including inventory, assessment, analysis, and requirements for reporting and analytics needs in the new Advancement system.
Participate in other university and department-wide IT and data related projects as needed.
Oversee continuous training of University Advancement staff on data requests and data usage, including guidance on improved use of the ADIS system.� Work with Help Desk and Training Resources to develop responses to commonly asked questions.� Lead classroom sessions and brainstorming/needs assessment sessions as needed.
Oversee project list of user data requests.� Work with colleagues to develop, implement, and review quality and scheduling controls to ensure production schedules are maintained and outputs are accurate.� Document all production jobs including timing and distribution.� Maintain ongoing communication with colleagues to ensure accuracy and timeliness of user requests and other projects.� Use this information to assist in managing workflow for department.
Perform other duties as assigned.
Bachelor’s degree or equivalent work experience.
Three to five years of programming and business analysis experience, including three years of experience with SQL.
Prior use and familiarity with Microsoft Office, with emphasis on Excel and Word.
Supervisory and/or experience leading team projects.
Ability to set priorities and handle a constantly changing environment.
Ability to work well under pressure.
Ability to think strategically and analytically and to plan and implement effectively.
Demonstrated success as a team member able to work effectively within a complex organization across multiple units dealing with diverse constituents toward development objectives and building effective working relationships.
Superior verbal and written communication skills.
Excellent project management skills and ability to handle multiple projects effectively; highly organized work style.
Attention to detail, highly-motivated, organized and energetic.
Demonstrated ability to learn.
Commitment to the mission of higher education.
Strong analytical skills with the ability to collect, organize and analyze significant amounts of information with attention to detail and accuracy.
Deep understanding of data analytics and higher education to support data driven improvement efforts.
Experience with reporting services, including Cognos and/or Tableau.
Familiarity with Microsoft SharePoint.
Familiarity with HTML.
Prior experience in a higher education technology environment.
Advanced knowledge of Alumni and Development Programs data structure.
Experience in manipulating and analyzing large, complex data sets related to Advancement programs.
The hiring range for this position is $60,801 - $79,092 annually.
This position is full-time and works approximately 37.5 hours per week.
All external candidates receiving an offer for employment will be required to submit to pre-employment screening for this position. Current employees applying for a new position within the university may be subject to this requirement. The screenings will include a criminal background check and, as applicable for the position, other background checks, drug screen, employment and education or licensure/certification verification, physical examination, certain vaccinations and/or governmental registry checks. All offers are contingent upon successful completion of required screening.
Internal Applicant Instruction:
Please attach a copy of your most current signed performance evaluation (completed within the last 18 months) to your online account. If you have not received a performance evaluation, you may provide two current signed letters of recommendation (written within the last 18 months), preferably to include one letter from either a current or recent former supervisor. To attach these documents, go to: My Career Tools, Add Attachment, Attachment Type – Performance Reviews or Letters of Recommendation.
Department Name/Job Location:
This position is in the Department of University Advancement. This position is for the Danforth Campus.
Washington University in St. Louis, a medium-sized, independent university, is dedicated to challenging its faculty and students alike to seek new knowledge and greater understanding of an ever-changing, multicultural world. The University offers more than 90 programs and almost 1,500 courses leading to bachelor's, master's and doctoral degrees in a broad spectrum of traditional and interdisciplinary fields, with additional opportunities for minor concentrations and individualized programs. The faculty is composed of scholars, scientists, artists and members of the learned professions. They serve society by teaching; by adding to the store of human art, creativity, understanding, and wisdom; and by providing direct services, such as health care.