Description

Spends the majority of time (50% or more) achieving organizational objectives through the coordinated achievements of subordinate staff. Manages experienced professionals who exercise latitude and independence in assignments. Establishes departmental goals and objectives, functions with autonomy. Manages the accountability and stewardship of human, financial, and often physical resources in compliance with departmental and campus wide goals and objectives. Ensures subordinate supervisors and professionals adhere to defined internal controls with a focus on policy and strategy implementation. Manages systems and procedures to protect departmental assets and requires practical knowledge in leading and managing the execution of processes, projects and tactics within one area. May report to a Chair, Unit Director, or equivalent administrative management.

Requirements

Bachelor’s degree and five years’ relevant experience, or an equivalent combination of education and experience, including 1 year of managerial experience.

• Develop annual program plans and provide strategic direction and oversight for the Advancement Systems & Information Delivery team.
• Gather and prepare documentation outlining the specifications and requirements for reports and business processes using interviews, document analysis, requirement workshops, surveys, business process descriptions, use cases, scenarios, business analysis, as well as task and workflow analysis.
• Develop requirement specifications according to standard templates, using natural language and Structured Query Language (SQL). Oversee the team providing design, query, and presentation aspects of reports, from conception to delivery.
• Translate requests into accurate reflections of requirements, provide recommendations for solutions, document processes, anticipate needs, work with Data
• Analysts and Developers to create accurate and detailed reports.
• Develop data workflow processes and documentation across the Foundation's operations.
• Conduct systematic reviews of reports/queries performed by Data Analysts and Developers. Testing for accuracy, evaluating quality, and accounting for variation in findings between expected and actual outputs.
• Facilitate business side end-user requirements gathering and translation for technical resources to ensure a complete understanding of reporting needs and use cases to ensure successful solutions.
• Serve as a liaison with stakeholders, Advancement Services colleagues, and the Office of Information Technology (OIT) for the business requirements gathering, design, system definition, testing, conversion planning, and interfaces that are part of the enhancements to the Foundation's technical ecosystem.
• Provide overall subject matter expertise in Advancement Services data operations.
• Build and maintain relationships with Foundation colleagues to improve report service delivery and database functionality. Ensure that challenges, problems, or potential problems with data or systems are communicated quickly and clearly to other team members.
• Plan, organize, design, and oversee implementation of data acquisition, harvesting, and hygiene practices and projects.
• Plan, organize, design, oversee implementation of, and evaluate reporting processes and efforts. Work with all staff on reporting needs and ensure availability of a library of reports, queries, dashboards, and other information resources.
• Strong problem-solving abilities and be able to exercise independent initiative as appropriate. Attention to detail is critical.
• Well organized, self-motivated; able to work on multiple tasks simultaneously.
• Strong interpersonal communication skills and the ability to communicate effectively and efficiently with co-workers and constituents, in a highly professional manner.
• Results-oriented and goal driven.
• Supervisory experience
• Broad knowledge of relational databases and how they function within an advancement/ fundraising office environment.
• Strong knowledge of data structures and experience administering relational databases.
• Familiarity with the technology marketplace, specifically catering to non-profit advancement and alumni relations activities.
• Working knowledge and experience using natural language and Structure, Query Language (SQL), and tools similar to SQL Developer, SQL Management
• Studio, MS Analysis Services, Integration Services, Reporting Services.