27 applicants

Company

Cornell University · 8 hours ago

Data Engineer

Ithaca, NY

Full-time

Remote

Mid Level

$85K/yr - $99K/yr

3+ years exp

Maximize your interview chances

BiotechnologyHigher Education

Growth Opportunities

No H1B

Insider Connection @Cornell University

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

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

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

SQLRelational DatabaseData TransformationData Lake/Warehouse DesignETL ProductsPythonCloud ServicesTechnical Communication

Required

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 programming 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

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)

Benefits

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

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.