Research Administration Information Services (RAIS)
Research Administration Information Services (RAIS) provides research administration software tools, including applications and reporting products, for Cornell faculty, other researchers, and research administration staff. RAIS builds its expertise in researcher needs and challenges, research administration, and user experience design to achieve its goal of providing relevant and easy-to-use software tools.
We have an immediate opening for a Data Analyst/Engineer.
What you will do:
The Data Analyst works with product management staff and other stakeholders to understand and solve business challenges through the exploration of relevant business systems and 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. The Data Analyst is also responsible for delivering various data products, including backend work, customer facing reports, and the creation of clean and compelling data visualizations. Other duties include support for production reporting systems and 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.
The position is charged with becoming an expert in research administration data and working with customers, product management staff, and development team members to continually improve RAIS reporting offerings, while maintaining a well-documented and organized library of code, and using a shared set of instrumentation with the development team. Maintenance of appropriate security models and data stewardship is critical.
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)
Understanding of popular data warehouse data structures (e.g., relational data mart, star, snowflake) and data lake concepts
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 working with modern code management and deployment tool (Git, Containerization, etc.)
Education and/or experience in machine learning techniques
Experience in higher education
Experience with research administration
Understanding of finance and accounting concepts and data
Visa sponsorship is not available for this position.
University Job Title:
Prog Analyst III
Pay Rate Type:
Number of Openings:
If you currently work at Cornell University, please exit this website and log in to Workday using your Net ID and password. Select the Career icon on your Home dashboard to view jobs at Cornell.
Online Submission Guidelines:
Most positions at Cornell will require you to apply online and submit both a resume/CV and cover letter. You can upload documents either by ‘dragging and dropping’ them into the dropbox or by using the ‘upload’ icon on the application page. For more detailed instructions on how to apply to a job at Cornell, visit How We Hire on the HR website.
If you require an accommodation for a disability in order to complete an employment application or to participate in the recruiting process, you are encouraged to contact Cornell University's Office of Workforce Policy and Labor Relations at voice (607) 255-6866, fax (607) 255-0298, or email at email@example.com.
Applicants that do not have internet access are encouraged to visit your local library, or local Department of Labor. You may also visit the office of Workforce Recruitment and Retention Monday - Friday between the hours of 8:30 a.m. – 4:30 p.m. to use a dedicated workstation to complete an online application.
Notice to Applicants:
Please read the required Notice to Applicants statement by clicking here. This notice contains important information about applying for a position at Cornell as well as some of your rights and responsibilities as an applicant.
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. Cornell University is an innovative Ivy League university and a great place to work. Our inclusive community of scholars, students, and staff impart an uncommon sense of larger purpose, and contribute creative ideas to further the university's mission of teaching, discovery, and engagement.
Internal Number: WDR-00018186
About Cornell University
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 University'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.