Job no: 493019 Work type: Staff Full-time Department: Institutional Advancement Location: Wilf Campus, 500 West 185th Street, NY, NY Categories: Information Technology, Philanthropy, Research
Position Summary: The Advancement Data Analyst provides data analysis and reporting needed for the operational success of the Department of Institutional Advancement. The expectation of this position is to provide directive driven reporting analysis in a timely manner. The Analyst will develop quality reporting deliverables, implement effective reporting throughout the department, and will maintain relationships throughout the institution with data stewards of other departments.
This position will be responsible for the completion of weekly assigned reporting projects, while assisting in the migration of reports and data into Evisions Argos and Ellucian CRM Advance Analytics.
Responsible for assisting the Sr. Director of Advancement Information Systems and Analytics in key reporting projects, report migration needs, and servicing existing reports for changes in Oracle Developer via SQL, Evisions Argos, Ellucian CRM Advance Analytics, Microsoft Dynamics CRM and future implemented reporting tools.
Coordinates within the Department of Institutional Advancement, and Information Technology Services for the resolution of data integrity issues, creation of special reports and dashboards, for the design and implementation of scripts used to execute mass record information updates.
Processes reporting requests daily, either requiring the execution of existing reports, or creation of new solutions. At times reports will need to be adjusted or updated to fit the changing needs of the department, while considering for specific requests in data.
Expected, but not limited to reviewing and testing files for software compatibility, working with large data sets. Responsible for interpreting organizational needs and presenting data in a way that will drive successful organizational decisions.
Understanding of and inquisitiveness in technology integration, reporting platforms, individual records management, and overall approaches to information accuracy
Document, design, and deploy data reports, assessments and workflows.
Maintain expectations of reporting needs with the department, communicating status of requests and anticipated changes effecting deadlines.
Unquestionable discretion and ability to process confidential information in a timely, accurate, and professional manner
Other duties as assigned.
Experience & Educational Background:
BA preferred or equivalent education and experience.
4+ years of hands on database reporting experience, preferably Oracle SQL.
4+ years of experience in reporting and analytics.
2+ year reporting project management experience.
Skills & Competencies:
4+ years Oracle SQL, or MySQL experience. Microsoft Office expert with high proficiency in MS Excel.
Experience using Ellucian Banner, or Ellucian CRM Advance.
Ability to communicate effectively and collaboratively with technical and non-technical staff.
Cross-departmental application of reporting tools, specific to Institutional Advancement needs.
Ability to analyze, forecast, and present data in a meaningful way for operational and business planning.
About Us: Founded in 1886, Yeshiva University (YU) has a strong tradition of combining Jewish scholarship with academic excellence and achievement in the liberal arts, sciences, medicine, law, business, social work, Jewish studies, education, psychology, and more.
We are a leading global educational institution that employs 2,000 people across our various campus locations -- Wilf Campus, Beren Campus, Brookdale Center, Resnick Campus in the Bronx, the Gruss Institute in Jerusalem, the Boys High School in Manhattan and the Girls High School in Queens. From the distinguished faculty who teach here, to the dedicated staff, we work to fulfill our mission through all that we teach, by all that we do and for all those we serve. We seek to attract and retain engaged and committed individuals who contribute to an exciting working environment, where there is a sense of community and belonging, balanced with a significant cross section of people from diverse backgrounds working and studying together.
The University offers an excellent compensation package, and a broad range of employee benefit plans, including immediate participation in the University's retirement plan. Staff members are typically eligible for four weeks paid vacation each year and have access to a shuttle to nearby subway locations.
Equal Employment Opportunity: Yeshiva University is an equal opportunity employer committed to hiring minorities, women, individuals with disabilities and protected veterans.