Institutional Research (IR) ETL Developer

Apply now Search #: 499447
Work type: Full-time
Location: UConn Storrs
Categories: Research

JOB SUMMARY

Institutional Research (IR) invites qualified applicants to apply for the ETL (Extract, Transform, & Load) Developer position. Under the direction of the ETL Team Lead, the successful candidate will play a critical role in on-going efforts to build data integration and warehousing solutions to support business intelligence, analytical applications, mandated reporting, and internal decision-making at UConn.

A successful candidate will work in a dynamic, collaborative, and innovative environment, providing support to IR and partner units while producing data, visualizations, and productivity reports for internal and external stakeholders. The candidate will demonstrate strong organizational, communication, and problem-solving skills.

DUTIES AND RESPONSIBILITIES

Include, but are not limited to:

  • Design data warehouse structures that support decision making and enable intuitive end-user access through selected business intelligence platforms.
  • Design, automate, schedule, and monitor extract, transform, and load processes that move core data from multiple source systems and environments into the local data warehouse.
  • Define and maintain the core data elements required for institutional decision support and reporting.
  • Maintain, update, and modernize SAS and SQL code to reflect emerging technologies, evolving business needs, and changes in source data structures.
  • Assist team members with data management, ETL, and business intelligence tools that support decision-making needs.
  • Develop and deliver ad hoc, mandated, and leadership-focused reports for internal and external audiences.
  • Maintain strong knowledge of institutional data content, definitions, and business intelligence tools.
  • Perform other duties as required.

MINIMUM QUALIFICATIONS

  1. Experience in Data Infrastructure and Design, Database Management, Analysis, or Related Fields with a Bachelor’s Degree and 2 years of related professional experience OR Associates Degree and 4 years of related professional experience OR 6 Years of related professional experience.
  2. Strong SQL programming skills and related database experience.
  3. Strong organizational and problem-solving skills.
  4. Excellent oral and written communication skills with various technical and non-technical audiences, including information technology groups.
  5. Experience with data validation techniques.
  6. Knowledge and understanding of DBMS technology and ETL processes.
  7. Knowledge of data warehousing structures and maintenance.
  8. General knowledge of business intelligence and reporting tools such as Microsoft Power BI, Tableau, or WebFOCUS.
  9. This position is not eligible for employer-sponsored visas. Candidates must be available for work by the start date of employment.

PREFERRED QUALIFICATIONS

  1. Bachelor’s degree in Data Science, Computer Science, Engineering, Business, or a related discipline.
  2. Minimum of six years of prior data programming experience.
  3. Hands-on development experience in ETL using tools such as SAS Enterprise Guide, Python, R, or Microsoft Fabric.
  4. Ability to extract and merge data from multiple platforms.
  5. Experience with creating a data warehouse, including the steps involved in the “lifecycle” of its development.
  6. Experience with higher education systems and data.
  7. Experience with quality assurance testing.

COMPENSATION AND BENEFITS

The hiring range for this position is $75,000 to $85,000. An offer of employment, if made, will be commensurate with the successful candidate’s skill and experience, as determined by the University. 

For more information about benefits and other offerings available to University employees, we encourage you to review the Human Resources website and explore the sections under the Benefits & Leaves header at the top of the page. Under Benefits & Leaves, select Benefits to access an overview as well as additional information on topics such as paid time off, benefits, retirement, and other resources.  As you explore these pages, please note that this position is covered by the University of Connecticut Professional Employees Association (UCPEA) and look for information specifically identified for UCPEA, as provisions may vary by employee group. 

APPOINTMENT TERMS

This is a full-time, permanent position located at the Storrs campus. This position is in a hybrid office environment which is subject to approval and may change. Staff are expected to work a certain number of days in-person on campus each week. The campus is located in Storrs, Connecticut.

TERMS AND CONDITIONS OF EMPLOYMENT

Employment of the successful candidate is contingent upon the successful completion of a pre-employment criminal background check.

The department is unable to sponsor an international candidate for this position. Applicants must have permanent U.S. work authorization.

TO APPLY

Please apply online at Faculty and Staff Positions, Search #499447 to upload a resume, cover letter, and contact information for three (3) professional references. Applicants must clearly demonstrate how they meet the stated minimum qualifications, and any preferred qualifications they may possess, in their application materials.

This job posting is scheduled to be removed at 11:55 p.m. EST on December 7, 2026. 

All employees are subject to adherence to the State Code of Ethics.

All members of the University of Connecticut are expected to exhibit appreciation of, and contribute to, an inclusive, respectful, and diverse environment for the University community.

The University of Connecticut aspires to create a community built on collaboration and belonging and has actively sought to create an inclusive culture within the workforce. The success of the University is dependent on the willingness of our diverse employee and student populations to share their rich perspectives and backgrounds in a respectful manner. This makes it essential for each member of our community to feel secure and welcomed and to thoroughly understand and believe that their ideas are respected by all. We strongly respect each individual employee’s unique experiences and perspectives and encourage all members of the community to do the same. All applicants will receive consideration for employment without regard to race, color, ethnicity, religion, age, sex, marital status, national origin, ancestry, sexual orientation, genetic information, physical or mental disabilities, veteran’s status, status as a victim of domestic violence and/or sexual assault and/or trafficking in persons as defined by Connecticut law, prior conviction of a crime, workplace hazards to the reproductive systems, or gender identity or expression.

The University of Connecticut is an AA/EEO employer including for Disability and Veteran status.

Advertised: Eastern Standard Time
Applications close: Eastern Standard Time

Back to search results Apply now Refer a friend