Data and Reporting Business Analyst

Yale University - New Haven, CT4.3

Full-timeEstimated: $82,000 - $110,000 a year
Position Focus:
This position’s principal focus will be the data model activities as it pertains to IRES systems. They will provide analytical expertise in a variety of data driven operational projects in the areas of domain data governance, quality control identification/monitoring, and data integrations (ETL processing). This position will also have a role in supporting the IRES reporting portal, acting as an escalation point for data issues/problems.

The ability to clearly translate functional reporting needs into technical specifications and work with technical colleagues for problem resolution is a key skill in this role. Creativity, the ability to multitask and, the capacity to balance operational tasks with project work are required for this position. The person in this position must have a thorough working knowledge of data model concepts but be able to communicate in a non-technical manner with functional users.

Essential Duties

1. Maintain a master list of domain data elements and participate in batch data conversion activities that will align and standardize key data elements across all RE systems where appropriate. Work with business owners to correct synthetic key discrepancies for the RE DataMart load process. Play a significant role in the standardization of domain data across primary and secondary systems across the university. 2. Partner with management and staff of Research Administration to identify and manage QC processes which includes monitoring data for completeness, accuracy and timeliness. Identify opportunities for automated solutions to increase efficiency and strengthen data quality. i.e. define business rules for automating high-volume/prone to error manual tasks to reduce overall data entry burden on the business while increasing data quality. 3. Maintain the RE data vault data dictionary while adhering to precise governance rules around domain data. 4. Document requirements for RE data vault expansion. Develop/execute functional test plans for data integration projects 5. Develop/maintain functional requirements, business justifications, and data mapping documentation for data transformation processes such as data integrations and data set creation consumed by external partners inside/outside the university. 6. Support/maintain scheduled events that provide predefined datasets to internal/external data partners for sanctioned business functions. Provide support to end-users to document enhancement or data change requests as needed. 7. Provide analytical support for gap analyses, cost/benefit analyses, and risk assessments as it relates to new technology or business process redesign. 8. Participate in early-adoption and proof of concept activities as it relates to next generation technologies when appropriate.

Required Education and Experience

Bachelor’s degree in business, technology or related field. Four years of related experience or an equivalent combination of education and experience.

Required Skill/Ability 1:
Demonstrated expertise in data analysis. Proficiency with data models and business architecture concepts. Working knowledge of report development and business intelligence (BI) tools.

Required Skill/Ability 2:
Ability to work with functional resources to translate business needs into process and technical requirements. Ability to work effectively in a deadline-driven environment.

Required Skill/Ability 3:
Detailed oriented with focus on precision. Well-developed organizational, analytical and problem-solving skills.

Required Skill/Ability 4:
Superior analytical skills and ability to work with a wide variety of stakeholders, from senior leadership to transactional staff.

Required Skill/Ability 5:
Clear understanding of data migration strategies.

Preferred Education, Experience and Skills:
Experience with research administration business processes and systems. Knowledge of InfoEd or other proposal development software is highly desired. Experience with regulatory concepts in research administration including Conflict of Interest requirements.

Drug ScreenNo
Health Screening


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. Please visit for additional information on the background check requirements and process.

Posting Disclaimer

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 particular position. Employees will be assigned specific job-related duties through their hiring departments.

Affirmative Action Statement:
Yale University considers applicants for employment without regard to, and does not discriminate on the basis of, an individual’s sex, race, color, religion, age, disability, status as a veteran, or national or ethnic origin; nor does Yale discriminate on the basis of sexual orientation or gender identity or expression. Title IX of the Education Amendments of 1972 protects people from sex discrimination in educational programs and activities at institutions that receive federal financial assistance. Questions regarding Title IX may be referred to the University’s Title IX Coordinator, at, or to the U.S. Department of Education, Office for Civil Rights, 8th Floor, Five Post Office Square, Boston MA 02109-3921. Telephone: 617.289.0111, Fax: 617.289.0150, TDD: 800.877.8339, or Email:

NoteYale University is a tobacco-free campus