Senior Associate Director, Reporting

Job Overview

The Senior Associate Director, Reporting, is a key member of the Advancement team at Swarthmore College. This role is responsible for producing strategic, value-added technology solutions for end-users to meet organizational challenges. The incumbent collaborates with Advancement and campus colleagues to identify technological opportunities and guide operational decision making through data-driven analytics to increase philanthropic goals and constituent engagement.

Key Responsibilities

• Collaborate with the Director of Data & Technology Services and the Executive Director of Operations to build and maintain a culture of data-informed decision making within Advancement.
• Lead collaboration with other team leaders, primarily the Director of Prospect Discovery & Development and Assistant and Associate Vice Presidents across Advancement, to provide analysis and recommend strategies that guide and enhance our fundraising and engagement programs.
• Facilitate discussions between leadership, fundraisers, and technical resources to ensure a complete understanding of project needs and to develop new policies and procedures.
• Proactively develop relationships with staff and departments across the College, especially communications, admissions, Lang Center for Civic and Social Responsibility, Chester Children's Chorus, Center for Innovation & Leadership, and career services to support their work with constituent engagement and to acquire and understand available relevant data.
• Manage and collaborate in cross-campus projects on such topics as data sharing, learning, and training. The Slate Advancement CRM replaces the previous system of over 25 years, and all cross-campus access needs re-evaluated, established, and maintained with all campus departments. Oversee the planning, implementation, and successful delivery of each project.
• Ensure the successful implementation and continued infrastructure development of new technologies, including the Slate CRM and related systems. Work strategically with colleagues to design, test, create, and implement new reporting and dashboard solutions.
• Test, deploy, and validate regular updates, feeds, and/or new functionality delivered by Technolutions.
• Develop new views, tabs, prompts, rules, and more to meet the needs of the division, evolving the product continuously. This involves the technical programming needs and the oversight and partnership required with colleagues to plan and implement policy and procedure change.
• Write and execute queries and API calls against the College databases using SQL Server; data systems include Slate and Banner. Working knowledge of SQL, HTML, and CSS to create queries, reports, forms, portals, and dashboards in Slate and a desire to increase proficiency.

Requirements

• Strong organizational skills, demonstrated experience in project management, and the ability to respond to multiple priorities. Extreme accuracy and attention to detail with the ability to handle multiple and varied tasks both independently and collaboratively. Data management skills demonstrating the ability to manage large amounts of data and organize it into meaningful reports.
• Excellent analytical, communication, and interpersonal skills. A talent for listening, interpreting, and synthesizing information. Ability to effectively bridge communications between non-technical software end-users and the technical team.
• Strong sense of collegiality and the ability to establish collaborative professional relationships using tact and diplomacy, and the ability to maintain a high level of confidentiality. Strong customer service skills.
• Ability to travel locally or nationally for professional development.
• Appreciation for the value of higher education.
• Ability to synthesize information and suggest recommendations.
• Exceptional ability to analyze data, clearly articulate findings, and translate that to a strategy for expert and non-expert audiences.

What You Bring

• Bachelor's Degree with five years of job-related experience or an equivalent combination of education and experience.
• Experience working in institutional advancement with complex relational databases, reporting, and development software.
• Experience with a fundraising database and an excellent understanding of the general underlying database structures and rules to support fundraising efforts.
• Well-versed in configurable joins and database querying.
• Expertise in working with databases and building reports.
• Exceptional computer skills with experience evaluating, mastering, and implementing peripheral software applications, and training colleagues in various applications.
• Highly proficient in Windows operating system, Microsoft Suite, Google Suite, HTML, and Transact SQL (Structured Query Language).
• Demonstrated experience in the design, deployment, maintenance, and documentation of large-scale software applications and databases.
• Ability to work evenings, weekends, or as needed to complete projects or meet heavy demand.