Administrative and Professional Staff (APSA)
$65,871 To $78,658 Annually
# of openings:
The Manager, Records provides team direction and completes requests for strategic data analysis reports on alumni and donors which are utilized by the VP, Advancement and Alumni Engagement, its departments, and the University President to further major gift fundraising programs which raise $30 million annually and support community and alumni engagement priorities. This position maintains the University's advancement and alumni databases, which includes inspecting, cleansing, analysis, transforming, modelling and extracting constituent data to provide decision-ready intelligence to support the initiatives of the office of the VP, AAE, the University President, and the offices of VP, External Relations and faculties under VP, Academic. Designs complex database queries, data exports, and imports for key fundraising metrics and statistics in coordination with the Records team. Liaises with the executives in VP, AAE to provide guidance and advice, and manages the expectations of all end-users in AAE and other VP portfolios.
Bachelor's degree and three years of relational database experience (report writing, data analytics, visualization, hygiene, and/or database management), or an equivalent combination of education, training and experience.
Demonstrated proficiency in managing the accuracy, completeness and consistency of data within a database.
Ability to use and navigate a customer relationship management software application (e.g. Blackbaud Raiser's Edge, PeopleSoft) at an advanced level.
Ability to use word processing and spreadsheet applications (e.g. Microsoft Word, Microsoft Excel) at an advanced skill level; as well as coalesce information from a relational database at an advanced skill level using either SQL, Crystal Reports, Microsoft Access, or other relational database querying tool to provide intelligible reporting.
Advanced skill in MS Excel to transform and manipulate data and joining different sources of data using custom formulas and lookups.
Proficiency with statistics, data mining, business process design and modelling preferred.
Excellent knowledge of data structures and data relationships of systems, and use of query tools to quickly obtain accurate and relevant information.
Excellent knowledge of enterprise level student information system and student services business functions.
Excellent interpersonal skills and ability to work effectively on own and with others in a team, and customer service skills.
Excellent verbal and written communication skills, and presentation skills.
Excellent training skills and ability to prepare user manuals and technical documentation for users.
Strong analytical reasoning, problem solving and organizational skills.
Ability to maintain confidentiality of alumni and donor information and knowledge of FOIPPA regulations.
Ability to maintain high performance in a fast-paced environment and meet firm deadlines.
Knowledge of manual to automated business process and workflow design.
Ability to use query languages, relational databases, and business intelligence tools (e.g. T-SQL, Crystal Reports, Tableau).
Please note: Expected Start Date: February 3, 2020. Review of applications will begin on December 16, 2019.
Please include your cover letter and resume in one attachment.