Position Focus:

Yale is committed to improving the world today and for future generations through outstanding research and scholarship, education, preservation, and practice. Yale educates aspiring leaders worldwide who serve all sectors of society. No matter where you work in Yale University you are making an impact. As an entry level professional you will be taking on a key role with one of our business units to work on the technology that is solving our most challenging problems and changing the way the world thinks.

The IT Associate 1 is an entry level career opportunity that provides the ability to develop and build the technical and professional skills needed to contribute to Yale’s continued dedication to expanding and sharing knowledge, inspiring innovation, and preserving cultural and scientific information for future generations.

This position will focus on development, support, and maintenance of many client facing applications that support the Yale Alumni Association and the Office of Development.

Key Functions:

• Expanding the current CRM application using Microsoft SQL Server and TSQL.
• Creating reports and dashboards using SQL Server Reporting Services.
• Developing Data Warehouse ETLs  and data model designs.
• Integrating with other application and extracting data from APIs.
• Working with a team of Business Analysts to understand business needs, taking valuable input from experts and developing creative solution designs.
• Helping our QA team with functional testing and user acceptance testing.

Transcripts requested at time of interview.

Essential Duties

1. Works closely with experienced staff to acquire the skills and knowledge necessary to become proficient in area(s) of specialization. Takes initiative to increase understanding of all job-related areas.
2. Assists in applying principals and methods of the functional area to problems in technical areas to arrive at viable solutions
3. Perform analysis, design, implementation and maintenance activities within area(s) of focus
4. Troubleshoot processes, issues and errors.
5. Participate in projects that solve business requirements.
6. Explore and propose creative information technology solutions to business problems.
7. Pursues opportunities for efficiencies and/or to achieve cost reduction.
8. Work with business and technical partners to resolve business issues and respond to ad hoc requests.
9. Ensure all work is in compliance with Yale University and Information Technology policies, procedures, guidelines and regulatory requirements.
10. Complete additional assignments as assigned.

Required Education and Experience

Bachelor’s degree and no experience necessary or an equivalent combination of education and experience.

Required Skill/Ability 1:

Passion for a career in information technology.

Required Skill/Ability 2:

Strong technical and analytical abilities.

Required Skill/Ability 3:

Strong in oral and written communications, analytics and problem-solving.

Required Skill/Ability 4:

Ability to define problems, identify solutions and follow through to completion.

Required Skill/Ability 5:

Drive and initiative to go above and beyond to achieve goals while collaborating in a team environment.

Drug Screen

No

Health Screening

No

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 www.yale.edu/hronline/careers/screening/faqs.html 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 TitleIX@yale.edu, 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: ocr.boston@ed.gov.

Note

Yale University is a tobacco-free campus