Data Analyst/Engineer Programmer Analyst III - Band F Research Administration Information Services (RAIS)
The Research Division, headed by the Office of the Vice Provost for Research (OVPR), enables and advances the university's research priorities as well as research activities of Cornell colleges, schools, and research centers, institutes, and laboratories. From the laboratory bench to the hospital bedside and from cultural evolution to concepts in sustainability, our researchers and scholars are translating discovery into meaningful, measurable impact that is changing the world for the better.
The Research Administration Information Services (RAIS) group within OVPR has a mission to improve the research administration experience at Cornell through easy-to-use software tools and to enable smart decisions for the institution through quality data.
The Data Analyst plays a key role in these efforts, working with RAIS product management staff and other stakeholders to understand and solve business challenges through the exploration of relevant data sources using modern data analysis tools, and to create any required data-centric technical specifications, e.g. those for integrations, reporting products, and data migrations. He/she will be responsible for delivering various reports and compelling data visualizations using a shared set of instrumentation with our development team. Other duties include support for production reporting systems, leading the troubleshooting and resolution of data issues. Training customers on the use of RAIS reporting tools and the underlying research administration data is also expected.
Of utmost importance to this position is a commitment to service excellence; to provide efficient and friendly support to RAIS customers. You are expected to continually seek ways to improve and enhance RAIS services, champion the need for excellence in design, user experience, and data quality, and be a strong partner with the research administration functional staff in providing support to the Cornell research community.
2 or more years working in a data analyst or engineering role
Bachelor's degree or higher
Advanced knowledge of SQL
Thorough understanding of relational database systems and design
Thorough understanding of non-traditional/NoSQL data formats and how to work with them (json, xml, csv)
Thorough understanding of popular data warehouse data structures (e.g., star, snowflake)
Ability to use tools to introspect data sources to understand cardinality, relationships, data quality or potential issues
Meticulous attention to detail and documentation habits
Excellent communication and organization skills
Good team player with an ability to work in a cross-functional team environment
Bachelor's degree or higher with a concentration in a quantitative field such as finance, quantitative marketing, engineering, mathematics/statistics
Experience with Python data science ecosystem (Pandas, Jupyter Notebooks, etc)
Experience with Tableau
Experience in higher education
Experience with research administration
Understanding of finance and accounting concepts and data
When applying through our system, please remember to attach your application materials (Resume/Cover Letter/CV) in either Microsoft Word or PDF format. In the Experience section of your application, use the 'Drop Files Here' box to manually drag document(s) into your application. For a more detailed description and instructions on how to apply online please click here as an external candidate or click here if you are an internal candidate.
Please note: Cornell Employees must apply through the Internal Cornell Career site.
No Visa sponsorship is available for this position.
No relocation assistance is available for this position
University Job Title:
Prog Analyst III
Pay Rate Type:
Number of Openings:
Diversity and Inclusion are a part of Cornell University's heritage. We are a recognized employer and educator valuing AA/EEO, Protected Veterans and Individuals with Disabilities.
In 1865, Ezra Cornell founded an institution "where any person can find instruction in any study." From the beginning, all students were welcome, regardless of race, gender, ideology, or socioeconomic status. Today, we invite you to join our talented and diverse students and accessible faculty who, together, form a living and learning community unmatched in its breadth of opportunities.Cornell Uni...versity's college, schools, and other academic units offer more than 4,000 courses, 70 undergraduate majors, 93 graduate fields of study, undergraduate and advanced degrees, and continuing education and outreach programs.