Data and Reporting Coordinator, SEUC - University Advancement

Scheduled Hours
37.5

Position Summary
The University Advancement systems are designed to improve Wash U's operational excellence and ability to make insight-driven decisions focused on University Advancement activity. ARCH is the system of record for Washington University alumni and donors, and stores biographical, relationship, transactional, research, and activity data for constituents. Marketing Cloud is the system of record to manage our event communications. Critical system functionality of ARCH and accurate data for invitations and communications directly support fundraising and engagement efforts across UA.

This position focuses on data; research, analysis, reporting needs, survey work, invitation list formatting/extensions for Marketing Cloud and data projects that improve data quality within Advancement Services. Supports Special Events and University Ceremonies (SEUC) related to data quality, research, and analytics. Utilizes judgment and resourcefulness to research, analyze, and maintain accurate data on alumni and donors in the University's complex and comprehensive information system, ARCH. Assists in preparing and distributing reports, in gathering data for various projects and surveys, and assists as a liaison on ARCH operation tickets. Identifies and implements new techniques that will considerably improve the data quality of alumni and donors. Reports to the Director in SEUC. The position requires excellent verbal and written communication skills, strong analytical skills, critical thinking, attention to detail, and the ability to prioritize, follow through, and take initiative.

Job Description

Primary Duties & Responsibilities:

Project management and support for data-focused projects for the SEUC department and special data and invitation projects as directed.

• Manage or support special projects focused on data quality as part of the greater Advancement systems replacement planning and/or that will directly impact university fundraising efforts. Including data requests, QC-ing data requests, formatting data extensions for Marketing Cloud.
  
• Work with WashU IT and Advancement Services management to prioritize, analyze, and test WashU IT projects related to SEUC data.
  
• Perform analysis of data definitions and existing reports and suggest data correction, report improvements, and new/improved documentation.
  
• Subject Matter Expert (SME) for SEUC for all UA-approved software that partners with ARCH, Marketing Cloud, and Advancement Form.
  
• Support SEUC coordinators and administrations as the liaison and SME for data requests, constituency query needs, and data extension best practices.
  
• Support SEUC management with actionable data insights documentation, as directed by audience needs, PowerPoint presentation support.
  
• Complex invitation (tier), data extensions formatting and upload into Marketing Cloud.
  

Reporting and Surveys:

• Assist with weekly, monthly, and quarterly reporting.
  
• Assist with gathering and analyzing data surveys.
  
• Assist with the implementation and maintenance of the set of data integrity audit reports for ARCH and Marketing Cloud data.
  
• Submit ARCH Cases as part of data clean/accurate data efforts.
  

Perform other duties as assigned.

Working Conditions:
Job Location/Working Conditions

• Normal office environment
  
• Ability to travel to various on- and off-campus locations
  
• Available to work evenings and weekends, as necessary
  

Physical Effort

• Typically sitting at desk or table
  
• Repetitive wrist, hand or finger movement
  

Equipment

• Office equipment
  

The above statements are intended to describe the general nature and level of work performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all job duties performed by the personnel so classified. Management reserves the right to revise or amend duties at any time.

Required Qualifications

Education:
High school diploma or equivalent high school certification or combination of education and/or experience.

Certifications /Professional Licenses :
No specific certification/professional license is required for this position.

Work Experience:
Relevant Experience (3 Years)

Skills:
Not Applicable

Driver's License:
A driver's license is not required for this position.

More About This Job

Preferred Qualifications:

• Experience with ARCH system.
• Advanced Knowledge or certification in Microsoft Excel

This position is located in St. Louis, MO and the targeted hiring range for this position is $21.17 - $24.50 per hour.

This is a time limited position, anticipated to last one year and is full time benefits eligible.

Preferred Qualifications

Education:
Bachelor's degree or combination of education and/or experience may substitute for minimum education.

Certifications /Professional Licenses :
No additional certification/professional licenses unless stated elsewhere in the job posting.

Work Experience:
No additional work experience unless stated elsewhere in the job posting.

Skills:
Adaptability, Communication, Confidential Data Handling, Data Analysis, Data Entry, Data Verification, Detail-Oriented, Information Systems, Learning New Technologies, Microsoft Office, Multitasking, Organizational Commitment, Organizing, Prioritization, Project Management, Reporting and Analysis, Research Tools, Work Coordination, Working Independently

Grade
G08-H

Salary Range
$21.17 - $32.85 / Hourly

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.

Questions

For frequently asked questions about the application process, please refer to our External Applicant FAQ.

Accommodation

If you are unable to use our online application system and would like an accommodation, please email View email address on click.appcast.io or call the dedicated accommodation inquiry number at View phone number on click.appcast.io and leave a voicemail with the nature of your request.

All qualified individuals must be able to perform the essential functions of the position satisfactorily and, if requested, reasonable accommodations will be made to enable employees with disabilities to perform the essential functions of their job, absent undue hardship.

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

Personal

• Up to 22 days of vacation, 10 recognized holidays, and sick time.
  
• Competitive health insurance packages with priority appointments and lower copays/coinsurance.
  
• Take advantage of our free Metro transit U-Pass for eligible employees.
  
• WashU provides eligible employees with a defined contribution (403(b)) Retirement Savings Plan, which combines employee contributions and university contributions starting at 7%.
  

Wellness

• Wellness challenges, annual health screenings, mental health resources, mindfulness programs and courses, employee assistance program (EAP), financial resources, access to dietitians, and more!
  

Family

• We offer 4 weeks of caregiver leave to bond with your new child. Family care resources are also available for your continued childcare needs. Need adult care? We've got you covered.
  
• WashU covers the cost of tuition for you and your family, including dependent undergraduate-level college tuition up to 100% at WashU and 40% elsewhere after seven years with us.
  

For policies, detailed benefits, and eligibility, please visit:

EEO Statement
Washington University in St. Louis is committed to the principles and practices of equal employment opportunity. 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, citizenship (where prohibited by federal law), age, religion, sex, sexual orientation, gender identity or expression, disability, protected veteran status, or genetic information.