Institutional Research ETL Developer
Application Procedure:
Please apply online at https://hr.uconn.edu/jobs, Staff Positions, Search # 499447 to upload a resume, cover letter, and contact information for three (3) professional references. The department is unable to sponsor an international candidate for this position. Applicants should have U.S. work authorization.
This job posting is scheduled to be removed at 11:55 p.m. Eastern time on March 22, 2026.
All employees are subject to adherence to the State Code of Ethics which may be found at https://portal.ct.gov/Ethics/Statutes-and-Regulations.
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, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.
The University of Connecticut is an AA/EEO Employer.
Job Duties
Institutional Research (IR) invites applications for Institutional Research (IR) ETL Developer (Data Analyst 1). Under the general guidance of the Institutional Research Director and IR ETL Developer Lead, the IR ETL Developer plays a critical role in on-going efforts to build data integration and warehousing solutions to support both business intelligence and analytical applications for decision making at the University.
This position has a critical role in coordinating and confidentially managing the administrative and technical support for the online Student Evaluation of Teaching system, including providing support to instructors, departments, and senior leadership.
The person in this position will work in a collaborative, dynamic team and research analysts. A successful candidate will provide support to IR and various other departments with outstanding organizational, communication, and problem-solving skills.
Include, but are not limited to:
- Collaborate with IR business experts to establish a core group of data elements necessary for decision support using SAS Enterprise Guide.
- Assist with creating warehouse designs/structures that enable easy, natural end-user access with selected business intelligence platform(s).
- Design, automate, schedule and load jobs necessary to extract core data from multiple data sources and environments into a local data warehouse.
- Provide recommendations in the selection of DBMS, ETL and associated tools appropriate for the current and future needs of the decision support system.
- Ensure efficient processing on an ongoing basis, including data consistency of data attributes, naming conventions and element value types.
- Report data to various internal and external audiences, such as ad hoc reporting, mandated reporting, and reporting for leadership decision-making.
- Possess knowledge regarding data content/definitions and the use of business intelligence tools such as Microsoft Power BI.
- Manage the administrative and technical support for the online Student Evaluation of Teaching system including providing support to instructors, departments, and senior leadership.
- Complete other duties as assigned.
Job Qualifications
MINIMUM QUALIFICATIONS
- Experience in Computer Science, Information Systems, Engineering, or Related Fields with a Bachelor’s Degree and 2 years of experience OR Associates Degree and 4 years of experience OR 6 Years of related experience.
- Strong SQL programming skills and related database experience.
- Excellent oral and written communication skills with various technical and non-technical audiences, including information technology groups.
- Knowledge and understanding of DBMS technology and ETL processes.
PREFERRED QUALIFICATIONS
- Bachelor’s degree in Computer Science, Engineering, Business, or a related discipline; minimum of six years of prior data programming experience.
- Hands-on development experience in ETL (Extract, Transform & Load), using tools such as SAS Enterprise Guide, Informatica or DataStage.
- Experience programming in SAS or SPSS.
- General knowledge of business intelligence and reporting tools such as Microsoft Power BI, Tableau, or WebFOCUS.
- 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.
- Knowledge of PeopleSoft Campus Solutions and Institutional Research data.
Institution Description
Established as an agricultural school in 1881, the University of Connecticut (UConn) has since grown into one of the nation’s top-tier public research institutions. By 1939, it had evolved into a major PhD granting university. Today—with over 34,000 students, 11,000 faculty and staff members, and more than 299,000 alumni—it is recognized for its diverse research portfolio and key areas of strength including healthcare, additive manufacturing, education, environmental sciences, human rights, linguistics, psychology and visual arts.
The University has 14 schools and colleges, awards 8 undergraduate degrees in 128 majors, 17 graduate degrees and 6 professional degrees. The University is composed of the main campus in Storrs; four regional campuses in Avery Point, Hartford, Stamford, and Waterbury; UConn Health in Farmington; and the Graduate Business Learning Center, School of Law, and School of Social Work in Hartford.
Benefits
Search for openings in IR, effectiveness, assessment, planning, and related fields at higher education institutions in the U.S. and abroad.
