Lead Data Engineer

Lead Data Engineer
Prog Analyst Spec
Research Administration Information Services (RAIS)

Lead Data Engineer

Cornell University is one of the leading research universities in the world. Established in 1865 as an "institution where any person can find instruction in any study", we pride ourselves on the diversity of our student body, our faculty and staff, and our academic disciplines. The Research Division at Cornell plays an important role in making our diverse and groundbreaking research programs come to life. We help our world class research community to find funding, navigate complex regulations, and bring new inventions to the market. Our Information Services team makes this possible by providing research management systems that are easy for the research community to use based on excellent user-experience research and design. They also build the data infrastructure necessary to bring together all of the data needed for reporting on the success of our research efforts.

Cornell University embraces diversity and seeks candidates who will contribute to a climate that supports students, faculty and staff of all identities and backgrounds. We strongly encourage individuals from underrepresented and/or marginalized identities to apply.

The Information Services team is looking for talented and creative individuals to join us in our quest to make it easier for the Cornell research community to manage their research. We consider our environment to be its own research laboratory where team members are encouraged to voice new ideas and try new approaches. We're early adopters in the use of new technologies that can help us to automate development and deployment of the application and data products we build or integrate with. There's no doubt that you'll be able to learn and grow as part of our team. We have opportunities for advancement in our group and within the university. The ability to take classes or pursue a degree through our employee degree program is also available and encouraged. Cornell benefits are hard to beat, including a contribution of 10% of your salary to your retirement plan pre-tax.

The Lead Data Engineer position is a senior member of the Information Services team, responsible for all of our technical decisions, including our technology stack and data architecture. The position reports to the Director of Information services and provides day-to-day technical leadership for the data team.

What You Will Do:

• Design and maintain our data infrastructure that gets data to and from the data products we create and the applications and data sources we integrate with
• Review our tool chain to make sure we're using the best apps and practices
• Help build and lead our data team; implement procedures and work instructions
• Work on new data projects - help the project and product management teams understand what's possible and figure out the best way to deliver; break down tasks for the data team
• Write code, e.g. Python for data, Terraform for DevOps
• Prioritize the development backlog with the product team - tell them when you need time to refactor or prioritize "technical debt" items that pose a risk
• Infrastructure design, automation, and maintenance in cloud and on-premises hosting environments (current setup - Terraform: Infrastructure-as-code, CodeBuild: Build tools, Docker/ECS/ECR: containerization, Fargate: Serverless tasks, CloudWatch/Prometheus: Monitor/Log/Trigger, S3/RDS: Storage).
• Troubleshoot potential data issues reported with production reporting systems and integrations
• Create and test data visualizations to aid understanding of research administration data

What You Will Need:

• 5 or more years working in a data analyst, data engineer, or other data science role
• Bachelor's degree or higher
• Advanced knowledge of SQL
• Experience with Python data science ecosystem (Pandas, Jupyter Notebooks, etc.)
• Experience with DevOps, specifically AWS, Terraform, and Docker
• 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

What We Prefer:

• Bachelor's degree or higher with a concentration in a quantitative field such as finance, quantitative marketing, engineering, mathematics/statistics
• Experience with Tableau
• Experience with Salesforce
• Understanding of finance and accounting concepts and data

What we offer:

• The opportunity to work with a dynamic group of people in a stable organization where employee development is promoted.
• A broad set of competitive benefits under the Cornell Endowed program, including educational opportunities, access to virtual wellness programs, health care options, 3 weeks of paid vacation, 13 paid holidays, and superior retirement contributions. https://hr.cornell.edu/benefits-pay
• The potential to work in Ithaca (with affordable housing and highly ranked public schools).
• The position will allow for the flexibility to work a hybrid schedule for those applicants who live within a commutable distance and are willing to come to Ithaca frequently.
• The New York Convenience of Employer guidelines require New York State individual tax reporting and withholdings for this position. Additional individual state income tax filings may also be required if working temporarily outside New York State.

For full consideration, please attach a cover letter and resume with your application.

Visa sponsorship not available for this position.

Familiarize yourself with Cornell's COVID-19 workplace guidance as well as the university's COVID-19 services and information.

University Job Title:

Job Family:

Level:

Pay Rate Type:

Pay Range:

Remote Option Availability:

Company:

Contact Name:

Job Titles and Pay Ranges:

Non-Union Positions

Noted pay ranges reflect the potential pay opportunity for each job profile. The hiring rate of pay for the successful candidate will be determined considering the following criteria:

• Prior relevant work or industry experience

• Education level to the extent education is relevant to the position

• Unique applicable skills

• Academic Discipline (faculty pay ranges reflects 9-month annual salary)

To learn more about Cornell's non-union staff job titles and pay ranges, see Career Navigator.

Union Positions

The hiring rate of pay for the successful candidate will be determined in accordance with the rates in the respective collective bargaining agreement. To learn more about Cornell's union wages, see Union Pay Rates.

Current Employees:

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.

Employment Assistance:

For general questions about the position or the application process, please contact the Recruiter listed in the job posting or email mycareer@cornell.edu.

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 Institutional Equity and Title IX at voice (607) 255-2242, or email atequity@cornell.edu.

Applicants that do not have internet access are encouraged to visit your local library, or local Department of Labor. You may also request an appointment to use a dedicated workstation in the Office of Talent Attraction and Recruitment, at the Ithaca campus, by emailing mycareer@cornell.edu.

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.

EEO Statement:

Diversity and Inclusion are a part of Cornell University's heritage. We are a recognized employer and educator valuing AA/EEO, and we do not tolerate discrimination based on any protected characteristic, including race, ethnic or national origin, citizenship and immigration status, color, sex/gender, pregnancy or pregnancy-related conditions, age, creed, religion, actual or perceived disability (including persons associated with such a person), arrest and/or conviction record, military or veteran status, sexual orientation, gender expression and/or identity, an individual's genetic information, domestic violence victim status, familial status, marital status, or any other characteristic protected by applicable federal, state, or local law. We also recognize a lawful preference in employment practices for Native Americans living on or near Indian reservations in accordance with applicable law.

Cornell University embraces diversity and seeks candidates who will contribute to a climate that supports students, faculty, and staff to all identities and backgrounds. We encourage individuals from underrepresented and/or marginalized identities to apply.

EEO Statement: 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.

Minimum Salary: 31200.00 Maximum Salary: 31200.00 Salary Unit: Yearly