ETL Developer (CEMI)

Cornell University; Town of Ithaca (NY); Remote; USD 88,000 - 103,000; Full time

Benefits offered by this job

Health benefits

Retirement contributions

Wellness programs

Employee discounts

Job summary

Cornell University is seeking an ETL Developer (CEMI) on a 2-year term with remote work eligibility across the United States. The role sits in Cornell Information Technologies' Data Warehousing and Integrations team and partners with customers to deliver enterprise-grade data solutions.

You will develop and support ETL processes, collaborate on data lake/warehouse content, and participate in on-call rotations while learning evolving technologies in a fast-paced environment.

Qualifications

• Bachelor's degree with 3–5 years of relevant experience, or an equivalent combination of education and experience.
• Demonstrated experience using SQL, including DDL and DML.
• Development experience with relational database platforms (PostgreSQL, Oracle, MS SQL Server).
• Proven experience developing data transformation solutions using one or more programming languages.
• 1–2 years of related experience in at least two of: Data analysis, data warehouse/data lake design, ETL development.
• Strong interest and aptitude for learning in a rapidly evolving technical/analytical environment.
• Strong development skills and ability to translate requirements into technical solutions.
• Proven ability to work in fast-paced IT or business environments with ongoing learning.
• Proven problem-solving skills and ability to develop technical expertise.
• Excellent verbal and written communication, with ability to multitask and collaborate.
• Ability to cultivate inclusive working relationships with students, faculty, staff, and community members.

Responsibilities

• Collaborate with customers and IT to develop enterprise-grade data lake/warehouse content.
• Support data feeds, transformations, and updates across the DL/DW ecosystem.
• Serve as DL/DW liaison to project teams requesting DL/DW resources.
• Research and analyze impact of schema and data model changes.
• Develop and maintain documentation and SOPs.
• Support migration of ETL code and database objects.
• Learn new tools and environments as the data analytics space evolves.
• Participate in the 24x7 DL/DW On Call rotation.

Skills

SQL

DDL

DML

Relational databases

PostgreSQL

Oracle

MS SQL Server

ETL development

Python

Data analysis

Data warehouse

Data lake

Communication

Problem solving

Education

Bachelor's degree

Tools

Informatica

Data Stage

WhereScape

Talend

Job description

Working Title: ETL Developer (CEMI)[Remote] [2 Year Term]

No Visa Sponsorship is available for this position.

This position will require occasional off-hours support.

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

This position is eligible for remote work within the United States, subject to Cornell University's approval process for out-of-state work arrangements and all applicable legal and operational requirements. Candidates must be able to travel to Cornell's Ithaca campus periodically for meetings, training, and other business needs. The university reserves the right to modify or discontinue remote work arrangements as business needs require.

About Information Technology

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 daytoday needs to large, complex initiatives that advance major academic, research, and operational objectives across the university. Check out this link to find out more about IT@Cornell

What will you do:

As a member of Cornell Information Technologies' Data Warehousing and Integrations team, theETL 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.

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

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
  • 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 fastpaced IT or business environment that requires continual learning and adaptation.
• Proven problemsolving skills and ability to independently develop technical expertise.
• Excellent verbal and written communication skills, with the ability to multitask and work collaboratively in a teamoriented 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)

Rewards and Benefits

• This position is based in Ithaca, New York, however, the successful applicant may perform this role remotely anywhere within the United States. Employees who work remotely may receive multiple W-2 Forms depending on their work location. The New York Convenience of employer guidelines require New York State individual tax reporting and withholding for this position. Additional individual state income tax filings may also be required if working temporarily outside of New York State. The university reserves the right to modify, suspend, or terminate the remote or hybrid work arrangement at any time.
• Cornell receives national recognition as an award-winning workplace for our health, wellbeing, and sustainability. Our benefits programs include comprehensive health care options, generous retirement contributions, access to wellness programs, and employee discounts with local and national retail brands. We invite you to follow this link to get more information about our benefits: Understand Your Benefits | Working at Cornell
• Our leave provisions include health and personal leave, three weeks of vacation and 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. To offer greater flexibility for observing faiths and traditions we also offer two additional floating holidays. Learn more about our generous leave provisions: Holiday and Accrued Time Off | Working at Cornell
• Cornell's impressive educational benefits include tuition-free Extramural Study and Employee Degree Program, tuition aid for external education, and Cornell Children's Tuition Assistance Program. Learn more about our extensive educational benefits: Education Benefits | Working at Cornell
• Follow this link to learn more about the Total Rewards of Working at Cornell: Total Rewards | Working at Cornell

University Job Title:

Business Intelligence Eng III

Job Family:

Information Technology

Level:

F

Pay Rate Type:

Salary

Pay Range:

$88,337.00 - $102,662.00

Remote Option Availability:

Remote

Contact Name:

Maria Avila

Contact Email:

[e-mail]

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.

EEO Statement:

Cornellwelcomes 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 seeksjob candidates who will contribute to a climate that supports students, faculty, and staff of all identities and backgrounds. Wehire based on merit, andencourage 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.