Lead Data Engineer - Military Veterans

Lead Data Engineer

Lead Data Engineer

Prog Analyst Spec

Research Administration Information Services (RAIS)

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 & Innovation organization 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
• Use tools like Tableau or write code to create data visualizations, dashboards, and applications
• Review our tool chain to make sure we're using the best apps and practices
• Help lead our data team; implement procedures and work instructions; break down tasks
• Work on data projects with project and product management teams - help understand what's possible and figure out the best way to deliver; assist with data analysis and discovery
• 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
• Troubleshoot potential data issues reported with production reporting systems and integrations

What You Will Need:

• 5 or more years working in a data analyst, data engineer, or other data science role
• Proven experience in designing and delivering end-to-end data products, including data discovery, cleaning, and integration. Expertise in pipeline creation and automation using various ETL tools, APIs, and hands-on knowledge of front-end data visualization and delivery frameworks
• Bachelor's degree or higher
• Advanced knowledge of SQL and relational database systems and design
• Thorough understanding of popular data warehouse data structures (e.g., star, snowflake)
• Thorough understanding of non-traditional/NoSQL data formats and how to work with them (json, xml, csv)
• Experience with Tableau
• Experience with Python data science ecosystem (Pandas, Jupyter Notebooks, etc.)
• Experience with DevOps
• 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
• Understanding of finance and accounting concepts and data

What we offer:

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.

University Job Title:
Prog Analyst Spec
Job Family:
Information Technology
Level:
G
Pay Rate Type:
Salary
Pay Range:
$108,296.00 - $132,362.00
Remote Option Availability:
Hybrid
Company:
Endowed
Contact Name:
Kristie Devine

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

Union Positions

Current Employees:

Online Submission Guidelines :

Employment Assistance:

Notice to Applicants:

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.
2024-12-11