Data Warehouse Developer

Search #: 499447
Work type: Full-time
Location: Storrs Campus
Categories: Information Technology

Working under the general guidance of the Institutional Research Director and Data Warehouse Lead, the Data Warehouse Developer plays a critical role in ongoing 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 environment alongside financial 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 BPIR 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.

This is a full‑time, permanent position. The University offers a competitive salary, and outstanding benefits, including employee and dependent tuition waivers at UConn, and a highly desirable work environment. Salary is commensurate with qualifications and experience. For additional information regarding benefits, please visit (Use the "Apply for this Job" box below). and explore the sections under the Benefits & Leaves and Engagement & Learning headers. Other rights, terms, and conditions of employment are contained in the collective bargaining agreement between the University of Connecticut and the University of Connecticut Professional Employees Association (UCPEA).

Employment of the…