Scheduled Hours

40

Position Summary

The Senior Data and Reporting Analyst supports University Advancement (UA) at Washington University in St. Louis in the design and use of constituent data. Produces timely and accurate reports, queries and other desired outputs to support fundraising efforts for the University. Works with UA staff including ARCH team to coordinate data projects and deliverables related to data analysis, reporting and dashboard development using SQL, and data migration. Proficient knowledge of advancement data and how it can support University fundraising efforts. This position reports to the Manager of Data and Reporting, Advancement Services.

Job Description

Primary Duties and Responsibilities

Produce accurate data outputs from University Advancementâ™s CRM. 

• Review and evaluate user requirements to produce and create ad-hoc standardized outputs as requested and approved by the Associate Vice Chancellor of Advancement Services and Administration, Executive Director of Advancement Services or Manager of Data and Reporting.
• Conduct analysis on data and assist in the development of reports and dashboards for University Advancement.
• Design and develop data delivery solutions including:
  • Standardized query reports and outputs
  • Ad-hoc development of query reports and outputs
  • Query templates
  • Dashboard and data visualizations

Supports ongoing data management and data hygiene of the University Advancement CRM. 

• Assist with data audit of CRM tables to document database objects and field properties plus identify data cleanup needed.
• Map, cleanse and validate data migrations.
• Contribute to data governance and data quality improvement initiatives.
• Participate in other University and department-wide IT and data related projects as needed.

Provide support for planning, design and implementation of an Advancement data warehouse and operational reporting environment.

Perform other duties as assigned. 

Preferred Qualifications

• Two to three years of programming and business analysis experience including two years of experience with SQL.
• Deep understanding of Salesforce or other fundraising and relationship management platforms.
• Prior experience working in a nonprofit environment and/or higher education technology environment.
• Experience manipulating and analyzing large, complex data sets related to advancement/development programs.
• Prior experience with data migration and data quality efforts.
• Experience with reporting services including Cognos and/or Tableau.
• Familiarity with MS SharePoint.
• Proficient in Microsoft Office (Excel, Word, etc.).
• Able to think strategically, set priorities, plan and implement effectively in a deadline-driven environment.
• Highly-motivated, organized, proactive and collaborative.
• Strong analytical skills with the ability to collect, organize and analyze significant amounts of information with excellent attention to detail and accuracy.
• Understanding of data analytics and higher education to support data driven improvement efforts.
• Demonstrated success as a team member able to work effectively within a complex organization across multiple units dealing with diverse constituents toward development objectives.
• Strong verbal and written communication skills with a customer service orientation.
• Ability to learn and grow in the position.
• A commitment to the mission of higher education and Washington University in St. Louis.

Required Qualifications

Bachelorâ™s degree and three years of related experience or equivalent education/work experience to equal seven years.

Grade

G12

Salary Range

$55,600.00 - $94,900.00 / Annually

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

Accommodation

If you are unable to use our online application system and would like an accommodation, please email CandidateQuestions@wustl.edu or call the dedicated accommodation inquiry number at 314-935-1149 and leave a voicemail with the nature of your request.

Pre-Employment Screening

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.

Benefits Statement

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.

EEO/AA Statement

Washington University in St. Louis is committed to the principles and practices of equal employment opportunity and especially encourages applications by those from underrepresented groups. It is the Universityâ™s policy to provide equal opportunity and access to persons in all job titles without regard to race, ethnicity, color, national origin, age, religion, sex, sexual orientation, gender identity or expression, disability, protected veteran status, or genetic information.

Diversity Statement

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.

Applicant Instructions

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.

Return to Search Results