Senior Analytics and Data Services Coordinator

Yale University; New Haven (CT); Hybrid; USD 41,000 - 58,000; Full time

Benefits offered by this job

Hybrid work model

Yale Benefits

Job summary

Yale University is seeking a Senior Analytics and Data Services Coordinator to support Alumni Affairs and Development through high-level reporting and analysis. The role involves complex data extractions, ad hoc reporting, and executive summaries drawn from multiple databases to support fundraising and alumni activities.

The position requires extensive experience in data reporting, strong Excel skills, and the ability to collaborate across units while maintaining strict data confidentiality.

Qualifications

• Eight years of related experience; six in the same job family at the next lower level, or an equivalent mix of education.
• Strong Excel and Microsoft Office skills; ability to learn new online tools.
• Excellent reporting and data reconciliation capabilities.

Responsibilities

• Extracts, reports and creates executive summaries from multiple data sources.
• Designs complex tables, macros, and queries for reporting.
• Develops reporting based on constituent and revenue data.
• Enforces data-cleaning and reconciliation rules across sources.
• Produces high-level analysis and summaries for senior leadership.
• Maintains financial and business data in databases and reconciles records.
• Investigates revenue-related data to ensure accuracy.
• Keeps best practices and documentation for analytics and reporting.
• Builds cross-team relationships and serves as data reporting resource.
• Interacts with external stakeholders on data requests.

Skills

Advanced reporting

Attention to detail

Excel proficiency

Communication

Confidentiality

Education

Bachelor's Degree

Associate's Degree

High School Diploma

Tools

Excel

Word

PowerPoint

Outlook

Job description

Working at Yale means contributing to a better tomorrow. Whether you are a current resident of our New Haven-based community, eligible for opportunities through the New Haven Hiring Initiative, or a newcomer, interested in exploring all that Yale has to offer, your talents and contributions are welcome. Discover your opportunities at Yale!

Overview

Reporting to the Director, Analytics, Data Services & Compliance, the Senior Analytics and Data Services Coordinator supports the efforts of Alumni 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

• Exceptional reporting skills, including extracting and summarizing large quantities of data from database systems. Experience with manipulating and reconciling data.
• 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.
• 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.
• Commitment to an inclusive workplace. Ability to engage with diverse audiences (age, gender, nationality, race/ethnicity, profession, sexual orientation, etc.).
• 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

• 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

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.