Senior Analytics and Data Services Coordinator

Affairs and Development through high-level reporting and analysis utilizing database systems and other tools. The Senior Analytics and Data Services Coordinator is responsible for the following: Provide complex report requests, data extractions and other information in support of the business needs of Alumni Affairs and Development. Develop, design and produce complex standard and ad hoc reporting and analysis based on constituent and revenue data extracted from primary databases to support fundraising programs and alumni activities. Perform reconciliation of extracted financial and/or constituent data. Produce high-level analysis and executive summaries for senior leadership. Understand and utilize relevant database systems, and applicable internal reporting structures and guidelines. Coordinate and update database selections for publications, events, mailings and other Alumni Affairs and Development activities. Work closely with staff from Advancement Systems and Advancement Technology, including conducting report testing for standard and ad hoc reports and selections, and communicating findings and/or data integrity issues. Utilize database systems to assist with problem-solving for giving and prospect data integrity and reports. Support revenue and constituent coding structures and hierarchies, through data entry and reporting. Contribute to the establishment of best practices and maintain reporting documentation and guidelines within Analytics and Data Services. Collaborate with the Analytics and Data Services team on reporting and analysis projects, training efforts and other coordination efforts as needed. Collaborate with Alumni Affairs and Development staff as well as other schools and units across the University. Perform other administrative duties as assigned. The following principal responsibilities are generic in nature. Applicants will find the information in this position focus to be most relevant to the needs of the position. Required Skills and Abilities 1. Exceptional reporting skills, including extracting and summarizing large quantities of data from database systems. Experience with manipulating and reconciling data. 2. Demonstrated organizational abilities with strong attention to detail, strong interpersonal skills, and well-developed written and verbal communication skills. Ability to work independently and as part of a team, and to handle multiple projects simultaneously. 3. Advanced proficiency with Excel, and strong knowledge of other Microsoft products, such as Word, PowerPoint, and Outlook. Ability and willingness to learn new online tools. 4. Commitment to an inclusive workplace. Ability to engage with diverse audiences (age, gender, nationality, race/ethnicity, profession, sexual orientation, etc.). 5. Ability to maintain strict confidentiality of information. Preferred Skills and Abilities Familiarity with university and/or development and alumni affairs programs, processes, and practices. Experience in higher education advancement services. Experience with Blackbaud CRM or other fundraising and relationship management systems, including query development and marketing efforts. Principal Responsibilities 1. Extracts, reports and creates executive summaries on data derived from multiple data sources. Serves as a data expert and is the coordinator of day-to-day methods used to retrieve data and generate reports.2. Creates and designs complex tables, macros, forms, queries and reports. 3. Utilizes querying tools and applicable internal reporting structures and guidelines to develop, design and produce complex reporting and analysis based on constituent and revenue data extracted from primary databases.4. Enforces rules and procedures for cleaning, integrating, and reconciling information/data from various sources. Identifies and effectively communicates necessary corrections or enhancements to business data and applications that will facilitate reporting needs.5. Produces high-level analysis and summaries for senior leadership.6. Maintains, updates, and reconciles complex financial and business information in relevant database records as needed.7. Researches and investigates revenue-based information using office files and databases to ensure accuracy. 8. Maintains a thorough knowledge of, and establishes best practices, particularly as they relate to revenue and financial tracking. Participates in the development of processes and practices and serves as expert data analytics and reporting resource within the unit. 9. Builds strategic relationships with staff within and outside the unit and serves as a key contact on questions relating data and reporting needs.10. Interacts with external stakeholders at the request of leadership and/or frontline staff in response to inquiries, often requiring a comprehensive knowledge of business development. Required Education and Experience Eight years of related experience, six of them in the same job family at the next lower level and a high school level education; or six years of related experience and an Associate's Degree; or two years of related work experience and a Bachelor's Degree; or an equivalent combination of experience and education. Job Posting Date 10/29/2026 Job Category Administrative Support Bargaining Unit L34 Compensation Grade Labor Grade E Compensation Grade Profile Hourly Range $35.64 Benefits A general description of the benefits to be offered with this Clerical and Technical position is available at: Yale Benefits Time Type Full time Duration Type Staff Work Model Hybrid Background Check Requirements All candidates for employment will be subject to pre-employment background screening for this position, which may include motor vehicle, DOT certification, drug testing and credit checks based on the position description and job requirements. All offers are contingent upon the successful completion of the background check. For additional information on the background check requirements and process visit "Learn about background checks" under the Applicant Support Resources section of Careers on the It's Your Yale website. Health Requirements Certain positions have associated health requirements based on specific job responsibilities. These may include vaccinations, tests, or examinations, as required by law, regulation, or university policy. Posting Disclaimer The hiring rate of a role is determined in accordance with the provisions outlined in the respective collective bargaining agreement. The intent of this job description is to provide a representative summary of the essential functions that will be required of the position and should not be construed as a declaration of specific duties and responsibilities of the position. Employees will be assigned specific job-related duties through their hiring department. The University is committed to basing judgments concerning the admission, education, and employment of individuals upon their qualifications and abilities and seeks to attract to its faculty, staff, and student body qualified persons from a broad range of backgrounds and perspectives. In accordance with this policy and as delineated by federal and Connecticut law, Yale does not discriminate in admissions, educational programs, or employment against any individual on account of that individual’s sex, sexual orientation, gender identity or expression, race, color, national or ethnic origin, religion, age, disability, status as a special disabled veteran, veteran of the Vietnam era or other covered veteran. Inquiries concerning Yale's Policy Against Discrimination and Harassment may be referred to the Office of Institutional Equity and Accessibility (OIEA). Note Yale University is a tobacco-free campus.