Senior Analytics and Data Services Coordinator

Yale University; New Haven (CT); Híbrido; USD 41 000 - 58 000; Tempo integral

Resumo da oferta

Yale University is seeking a Senior Analytics and Data Services Coordinator to provide high‑level reporting and analysis for Alumni Affairs and Development. You will extract data, create complex reports, and deliver executive summaries to senior leadership.

You will coordinate with Advancement Systems and Technology, perform data reconciliation, and maintain documentation. The role requires strong Excel skills, attention to detail, and an ability to work with diverse stakeholders in a hybrid

Qualificações

• Exceptional reporting skills, including extracting and summarizing large quantities of data from database systems.
• Demonstrated organizational abilities with strong attention to detail and communication skills.
• Advanced proficiency with Excel and MS Office; willingness to learn new tools.
• Commitment to an inclusive workplace and ability to handle confidential information.

Responsabilidades

• Extracts, reports and creates executive summaries from multiple data sources.
• Designs complex tables, macros, forms, queries and reports.
• Develops advanced reporting and analysis on constituent and revenue data from primary databases.
• Ensures data quality through cleansing and reconciliation across sources.

Conhecimentos

Reporting skills

Data reconciliation

Organizational skills

Excel proficiency

Confidentiality

Communication

Tech adaptability

Formação académica

High school diploma

Associate's degree

Bachelor's degree

Ferramentas

Blackbaud CRM

Descrição da oferta de emprego

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

• 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

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 basedon 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 throughtheir 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.