ETL Developer (CEMI)

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 day‑to‑day 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, 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.   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,…