ETL Developer (CEMI)

Cornell University•Ithaca, MI

2d•$88,337 - $102,662•Remote

About The Position

As a member of Cornell Information Technologies’ Data Warehousing and Integrations team, the ETL Developer 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 ETL Developer is expected to learn and apply new technical skills on an ongoing basis. The ETL Developer will work daily with customers and colleagues to develop and support a vast data environment.

Requirements

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, ETL 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.

Nice To Haves

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)

Responsibilities

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’s Data Lake / Data Warehouse (DL/DW) ecosystem
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
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.

Benefits

Comprehensive health care options
Generous retirement contributions
Access to wellness programs
Employee discounts with local and national retail brands
Health and personal leave
Three weeks of vacation
13 holidays: Martin Luther King, Jr. Day, Memorial Day, Juneteenth, Independence Day, Labor Day, Thanksgiving and the day after, and an end of the year winter break from December 25-January 1.
Two additional floating holidays
Extramural Study
Employee Degree Program
Tuition aid for external education
Cornell Children's Tuition Assistance Program