South Midwest HERC

Data Engineer (CEMI)

Working Title: Data Engineer (CEMI) [Remote] [2 Year Term]

No Visa Sponsorship is available for this position.

This is a 2 year term appointment which may be ended or extended based on organizational needs, funding availability, and performance.

About Information Technology @ Cornell and CEMI

What will you do:

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

This is a 2 year term appointment which may be ended or extended based on organizational needs, funding availability, and performance.

While position responsibilities vary, every member of our community is expected to foster a culture of belonging and a 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.

Required Qualifications:

• Bachelor's degree with 3-5 years of relevant experience, or an equivalent combination of education and experience.
• Demonstrated experience using SQL, including Data Definition Language (DDL) and Data Manipulation Language (DML).
• Development experience working with relational database platforms such as PostgreSQL, Oracle, or Microsoft SQL Server.
• Proven experience developing data transformation solutions using one or more programming languages.
• One to two years of related experience in at least two of the following areas:
  • Data analysis
  • Data warehouse or data lake design and construction
  • Report and dashboard development
• Strong interest in and aptitude for becoming highly proficient in a rapidly evolving technical and analytical environment.
• Strong development skills, including the ability to quickly understand functional requirements and efficiently apply technical solutions to achieve desired outcomes.
• Demonstrated success working in a fast-paced IT or business environment that requires continual learning and adaptation.
• Proven problem-solving skills and ability to independently develop technical expertise.
• Excellent verbal and written communication skills, with the ability to multitask and work collaboratively in a team-oriented environment.
• Ability to cultivate and develop inclusive working relationships with students, faculty, staff, and community members.

Preferred Qualifications:

• 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)

Application Information:

• A resume is required for further consideration for this position. A cover letter expressing alignment with Cornell's mission and this role is strongly encouraged. When applying through our system, please remember to attach your application materials (Cover Letter and Resume) in PDF format.
• No Visa Sponsorship of any kind is available for this position.
• No Relocation assistance will be provided for this position.

Rewards and Benefits

University Job Title:

Job Family:

Level:

Pay Rate Type:

Pay Range:

Remote Option Availability:

Company:

Contact Name:

Contact Email:

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:

Cornell welcomes students, faculty, and staff with diverse backgrounds from across the globe to pursue world-class education and career opportunities, to further the founding principle of "... any person ... any study." No person shall be denied employment on the basis of any legally protected status or subjected to prohibited discrimination involving, but not limited to, such factors as race, ethnic or national origin, citizenship and immigration status, color, sex, 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.

Cornell University embraces diversity in its workforce and seeks job candidates who will contribute to a climate that supports students, faculty, and staff of all identities and backgrounds. We hire based on merit, and encourage people from historically underrepresented and/or marginalized identities to apply. Consistent with federal law, Cornell engages in affirmative action in employment for qualified protected veterans as defined in the Vietnam Era Veterans' Readjustment Assistance Act (VEVRAA) and qualified individuals with disabilities under Section 503 of the Rehabilitation Act. We also recognize a lawful preference in employment practices for Native Americans living on or near Indian reservations in accordance with applicable law.