Data Engineer

This position is located in Ithaca, New York. The successful candidate will have the option to perform this role remotely at a locationof their choosing within the United States.

The NewYork Convenience of employer guidelines require New York State individual tax reporting andwithholdings for this position. Additional individual state income tax filings may also be required if workingoutside New York State.

No Visa sponsorship is available for this position.

What is Cornell University and what is Information Technology @ Cornell?
Cornell University, unique among peers, is the federal land-grant institution of New York State, a private endowed university, and a member of the Ivy League. Information technologies (IT) is a strategic enabler for many functions at Cornell. Staff working in IT are found in most colleges and units across Cornell. We are comprised of many organizations, but we work as one. By being where Cornell faculty, staff, and students are, we are better able to offer support-whether needed at your desktop or to solve a major business, academic or research objective-to everyone at Cornell. Check out this link to find out more about IT@Cornell.

What you will do:

As an individual contributor you will model and support a culture of diversity, equity, inclusion, and wellbeing and continually seek to understand how your role, behaviors, and actions impact the success of this culture.

As a member of Cornell Information Technologies' Data Warehousing and Integrations team, the Data Engineer is a member of a team who develops and supports robust, reliable, and standardized data solutions in support of Cornell's data analytic, data warehousing and data lake ecosystem. This is an area of rapid change where the Data Engineer is expected to learn and apply new technical skills on an ongoing basis. The Data Engineer will work daily with customers and colleagues to develop and support a vast data environment.

Primary responsibilities include:

• Work collaboratively with customers and IT team members to develop new data lake/data warehouse content that is enterprise grade and supportable
• Proactively support the many data feeds, transformations, and updates which make up Cornell' DL/DW echo system
• Act as a DL/DW liaison, and subject matter expert, to project teams requesting DL/DW resources
• Research and conduct impact analysis of changing schema and data model requirements
• Develop and maintain documentation and standard operating procedures
• Support the migration of ETL code and database objects
• Learn new tools and environments quickly as the data analytics space evolves
• Participate in the 24X7 DL/DW On Call support rotation

Position requirements:

• Bachelor's degree with 3-5 years of experience or equivalent combination of education and experience
• Experience with SQL (DDL and DML)
• Development experience within a Relational Database such as: Postgres, Oracle, MS SQL Developer
• Proven experience developing data transformation solutions in one or more programing languages

• One to two years of related experience in at least 2 of the following: data analysis, data lake/data warehouse design/construction, or report/dashboard development
• Strong desire to become highly proficient in a new and rapidly evolving technical space
• Strong development skills (e.g. ability to quickly learn specific functional need and effectively and efficiently apply solutions to desired outcome)
• Must enjoy and have demonstrated successful experience in a rapidly changing, continual learning IT/Business environment
• Demonstrated proficiency developing technical skills and performing problem solving
• Demonstration of excellent technical, verbal and written communications skills and ability to multi-task within a team-oriented environment

• Experience in and/or demonstrated commitment to supporting diversity, equity, access, inclusion, and wellbeing.
• Ability to cultivate and develop inclusive and equitable working relationships with students, faculty, staff, and community members.

Preferred qualifications (but not required) include:

• Experience developing and supporting data transformations using an ETL product such as: Informatica, Data Stage, WhereScape, Talend, etc.
• Experience with a database procedural language
• Experience with Python
• Understanding of dimensional data modeling concepts
• Experience with cloud services, such as AWS (S3, Redshift, Glue, Athena, RDS, EMR)

While position responsibilities vary, every member of our community is expected to foster a culture of belonging and a psychologically healthy work environment by communicating across differences; being cooperative, collaborative, open, and welcoming; showing respect, compassion, and empathy; engaging and supporting others regardless of background or perspective; speaking up when others are being excluded or treated inappropriately; and supporting work/life integration of oneself and others.

What we offer:

Great benefits that include an active and diverse community to work and thrive in, educational benefits, access to a plethora of wellness programs, employee discounts with local and national retail brands, health care options to choose from, and generous paid leave provisions: Paid vacation and health/personal time, 12 university paid holidays (including end of year winter break through New Year's Day) and superior retirement contributions.

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

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.