Senior Data and Reporting Analyst - Advancement Systems Replacement Project - University Advancement
Washington University in St. Louis
Location: Clayton, Missouri
Internal Number: JR48037
The University Advancement systems replacement program is a multi-year program designed to improve Wash U's operational excellence and ability to make insight driven decisions focused on University Advancement activity. ADIS is the system of record for Washington University alumni and donors, and stores biographical, relationship, transactional, research and activity data for constituents. Critical system functionality supports fundraising and engagement efforts. The University Advancement systems replacement program includes replacing ADIS with a vended, cloud solution, in addition to other identified related systems.
Support University Advancement in the design and use of alumni, friend, and donor data. Work with the Advancement Systems Replacement team and other Advancement staff to coordinate data projects and deliverables related to data migration, report development, dashboard development, and data analysis. Design and produce reports and dashboards in the new advancement CRM system and extended tools to support future fundraising efforts of the University. Expert-level knowledge of advancement data and how it can support WU activities. This position reports to the Data Analyst Lead.
Primary Duties and Responsibilities:â‹
Design and develop of new system-hosted reporting and data delivery solutions, including:
Standard system-hosted reports.
Dashboards and data visualizations.
Support the execution of data migration, including:
Assisting with data audit of ADIS tables to document tables and fields and to identify data cleanup.
Mapping, cleansing and validating data migrations.
Contributing to data governance and data quality improvement initiatives.
Provide support for planning, design, and implementation of an Advancement data warehouse and operational reporting environment.
Perform other duties as assigned.
Strong working knowledge of Microsoft SQL Server Management Studio, experience with Reporting Services software, including Cognos and/or Tableau.
Prior experience in a higher education technology environment, particularly experience with Blackbaud, Ellucian, or Salesforce products.
Familiarity with University Advancement.
Prior experience with data migration and data quality efforts.
Must be able to set priorities and 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 advancement objectives and building effective working relationships.
Superior verbal and written communication skills.
Excellent project management skills and ability to handle multiple projects effectively; a highly organized work style is essential.
Attention to detail, highly-motivated, organized and energetic.
Demonstrated ability to learn.
A commitment to the mission of higher education.
Strong interpersonal, teamwork, and follow-up skills with the ability to develop rapport with others and recognize their concerns.
Bachelor's degree or equivalent work experience.
Three or more years of experience in business analysis, including two years of experience with common programming languages.
Prior use and familiarity with Microsoft Office, with advanced proficiency in Excel and Word.
$53,900.00 - $92,200.00 / AnnuallyThe salary range reflects base salaries paid for positions in a given job grade across the University. Individual rates within the range will be determined by factors including one's qualifications and performance, equity with others in the department, market rates for positions within the same grade and department budget.
All external candidates receiving an offer for employment will be required to submit to pre-employment screening for this position. The screenings will include criminal background check and, as applicable for the position, other background checks, drug screen, an 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.
Washington University in St. Louis is committed to providing a comprehensive and competitive benefits package to our employees. Benefits eligibility is subject to employment status, full-time equivalent (FTE) workload, and weekly standard hours. Please visit our website at https://hr.wustl.edu/benefits/ to view a summary of benefits.
Washington University is an equal opportunity and affirmative action employer. All qualified applicants will receive consideration without regard to an individualâ™s sex, race, color, religion, age, disability status, protected veteran status, national or ethnic origin, gender identity or expression, sexual orientation. Women, minorities, protected veterans and the disabled are strongly encouraged to apply.
Washington University is dedicated to building a diverse community of individuals who are committed to contributing to an inclusive environment â“ fostering respect for all and welcoming individuals from diverse backgrounds, experiences and perspectives. Individuals with a commitment to these values are encouraged to apply.
When you are ready to apply, creating an account only takes a minute. Your account creates a candidate home page which we will use to communicate with you and allows you to apply for jobs and view your application statuses. The first page of the application offers two âœQuick Applyâ options. Quick Apply allows you to either use a previous application or create a new application using a resume to populate the work experience and education sections of your job application. If using a resume to populate your application, check to ensure the application fields populated accurately. You may skip the âœQuick Applyâ page by clicking âœNextâ at the bottom of the page. Documents may be uploaded in the My Experience section of the application. You also have the option to apply with a Linkedin feature, which allows you to apply by using your Linkedin profile to populate some of the job application fields.
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.