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.