The Office of Institutional Research and Effectiveness invites applications for a Data Warehouse Developer (ETL) UCP 5. Founded in 1881, the University of Connecticut serves as the flagship for public higher education and the primary doctoral degree granting public institution in the state and includes a main campus in Storrs, CT, four regional campuses throughout the State, a Law School, and Medical and Dental Schools at its Health Center. The University, a Land Grant and Sea Grant college and Space Grant consortium institution, is consistently ranked the number one public university in New England and among the top 20 publics in the nation. The University has approximately 10,000 faculty and staff and 32,000 students, including almost 24,000 undergraduates and 8,000 graduate/professional students. More information regarding the University of Connecticut and the Office of Institutional Research and Effectiveness (OIRE) can be found at: http://oire.uconn.edu.
DUTIES AND RESPONSIBILITES
Under the general guidance of the Assistant Director, the Data Warehouse 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. Specifically, the successful candidate will collaborate with OIRE business experts to establish a core group of data elements necessary for decision support; assist with creating warehouse designs/structure 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 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; manage capacity and monitor data warehouse growth; and other duties as assigned.
The ideal candidate must have a Bachelor's degree in Computer Science, Information Systems, Engineering, or a related discipline; experience using SAS to program ETL processes; strong SQL programming skills and related database experience; strong written and verbal communication skills with various technical and non-technical audiences, including information technology groups; and knowledge and understanding of DBMS technology and ETL processes.
Master’s degree in Computer Science, Engineering, Business, or a related discipline; experience using business intelligence and reporting tools such as SAS Visual Analytics or Tableau; ability to extract and merge data from multiple platforms; knowledge of data mining techniques; experience using SAS Enterprise Guide. Experience with, or knowledge of institutional research data.
This is a full-time position. Salary will be commensurate with background and experience and includes a full benefits package.
Interested applications should apply online at UConn Jobs, http://www.jobs.uconn.edu, Staff Positions, and upload a cover letter, resume, and names and contact information of three professional references. Employment of the successful candidate will be contingent upon the successful completion of a pre-employment criminal background check. (Search # 2018290)
This job posting is scheduled to be removed at 11:59 p.m. Eastern time on January 29, 2018.
The University of Connecticut is committed to building and supporting a multicultural and diverse community of students, faculty and staff. The diversity of students, faculty and staff continues to increase, as does the number of honors students, valedictorians and salutatorians who consistently make UConn their top choice. More than 100 research centers and institutes serve the University’s teaching, research, diversity, and outreach missions, leading to UConn’s ranking as one of the nation’s top research universities. UConn’s faculty and staff are the critical link to fostering and expanding our vibrant, multicultural and diverse University community. As an Affirmative Action/Equal Employment Opportunity employer, UConn encourages applications from women, veterans, people with disabilities and members of traditionally underrepresented populations.
The University of Connecticut is one of the nation's leading public research universities. UConn's main campus in Storrs is admitting the highest-achieving freshmen in University history. Student diversity continues to increase, as does the number of honors students, valedictorians and salutatorians who consistently make UConn their top choice.