Data Engineer (CEMI)
About The Position
About Information Technology @ Cornell and CEMI Information Technology (IT) is a strategic enabler for many functions at Cornell University, with staff located across colleges, administrative units, and campuses throughout the institution. While comprised of many organizations, IT operates as one partnering closely with faculty, staff, and students to support teaching, research, and business operations. By being embedded where the Cornell community is, IT is well positioned to provide support ranging from day‑to‑day needs to large, complex initiatives that advance major academic, research, and operational objectives across the university. The Cornell Experience Modernization Initiative (CEMI) is a multi-year program designed to improve the experience of students, faculty, staff, alumni, donors, patients, and partners by unifying and enhancing administrative systems and processes across all Cornell University locations. Its name CEMI is said as “See Me” because the focus is on you: the people who use Cornell’s systems and data to accomplish your goals. 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.
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, 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.
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’ 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
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
- tuition-free Extramural Study and Employee Degree Program
- tuition aid for external education
- Cornell Children's Tuition Assistance Program
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
