University of Connecticut logo

University of Connecticut

Institutional Research (IR) ETL Developer

🇺🇸 Hybrid - Storrs, Connecticut 🕑 Full-Time 💰 $75K - $85K 💻 Data Science 🗓️ November 22nd, 2026
Python Tableau SAS

Edtech.com's Summary

University of Connecticut is hiring an Institutional Research (IR) ETL Developer to build the data pipelines and data warehouse behind the university’s reporting and decision-making. Working under the ETL (extract, transform, and load) team lead, the developer moves data from multiple source systems into a central warehouse that supports business intelligence tools, mandated reports, and analytics. The role also supports partner units across campus with data, visualizations, and reports.

Highlights
  • Design data warehouse structures that give end users intuitive access to data through business intelligence platforms.
  • Design, automate, schedule, and monitor ETL processes that load core data from multiple source systems and environments into the local data warehouse.
  • Define and maintain the core data elements the university relies on for institutional decision support and reporting.
  • Maintain, update, and modernize SAS and SQL code as technologies, business needs, and source data structures change.
  • Develop and deliver ad hoc, mandated, and leadership-focused reports for internal and external audiences.
  • Assist team members with data management, ETL, and business intelligence tools.
  • Bachelor’s degree with 2 years of related professional experience, an associate degree with 4 years, or 6 years of related experience in data infrastructure, database management, or analysis.
  • Strong SQL programming and database skills, plus experience with data validation, DBMS technology, ETL processes, and data warehousing structures.
  • General knowledge of business intelligence tools such as Microsoft Power BI, Tableau, or WebFOCUS.
  • Preferred qualifications include hands-on ETL development with SAS Enterprise Guide, Python, R, or Microsoft Fabric, experience with higher education data, and a degree in data science, computer science, engineering, or business.
  • Hiring range of $75,000 to $85,000, in a hybrid role at the Storrs campus.

Institutional Research (IR) ETL Developer Full Description

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
  • 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.
  • Strong SQL programming skills and related database experience.
  • Strong organizational and problem-solving skills.
  • Excellent oral and written communication skills with various technical and non-technical audiences, including information technology groups.
  • Experience with data validation techniques.
  • Knowledge and understanding of DBMS technology and ETL processes.
  • Knowledge of data warehousing structures and maintenance.
  • General knowledge of business intelligence and reporting tools such as Microsoft Power BI, Tableau, or WebFOCUS.
  • This position is not eligible for employer-sponsored visas. Candidates must be available for work by the start date of employment.

PREFERRED QUALIFICATIONS
  • Bachelor’s degree in Data Science, Computer Science, Engineering, Business, or a related discipline.
  • Minimum of six years of prior data programming experience.
  • Hands-on development experience in ETL using tools such as SAS Enterprise Guide, Python, R, or Microsoft Fabric.
  • Ability to extract and merge data from multiple platforms.
  • Experience with creating a data warehouse, including the steps involved in the “lifecycle” of its development.
  • Experience with higher education systems and data.
  • 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.

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.
All employees are subject to adherence to the State Code of Ethics.
The University of Connecticut is an AA/EEO employer including for Disability and Veteran status.