Data Integration Developer

Posted on6/25/2018
Job typeFull-time
Reports toDirector of Institutional Data Management
Reports in officeData & Analytcics Rept Tech Svs
Application due dateFirst review July 2, 2018
Job start dateThe position is open until filled.
CityOrono
State/ProvinceMaine
InstitutionUniversity of Maine System
Institution descriptionEstablished in 1968, the University of Maine System (UMS) unites seven distinctive public universities, comprising 10 campuses and numerous centers, in the common purposes of providing quality higher education while delivering on its traditional tripartite mission of teaching, research, and public service.
Maine’s largest educational enterprise, the University extends its mission as a major resource for the state, linking economic growth, the education of its people, and the application of research and scholarship.
A comprehensive public institution of higher education, UMS serves nearly 30,000 students annually and is supported by the efforts of more than 2,000 full-time and part-time faculty, more than 3,000 regular full-time and part-time staff, and a complement of part-time temporary (adjunct) faculty.
Reaching more than 500,000 people annually through educational and cultural offerings, the University of Maine System also benefits from more than two-thirds of its alumni population residing within the state; more than 123,000 individuals.
The System consists of the following seven universities: University of Maine (UM); University of Maine at Machias (UMM); University of Maine at Augusta (UMA); University of Maine at Presque Isle (UMPI); University of Maine at Farmington (UMF); University of Southern Maine (USM); and, University of Maine at Fort Kent (UMFK).
Job dutiesEssential Duties:

•Write & modify ETL (ELT) as required to assemble functional data warehouse/data marts
•Participate in the development of star schemas & dimensional data models for data warehouse
•Coordinate with DARTS team members to ascertain data modeling and ETL (ELT) requirements
•Develop and maintain data models of operational and analytical environments
•Assist in the creation and maintenance of documentation related to operational and analytical reporting tools, and the reports and dashboards executed therein, for various groups of end users
QualificationsRequired:
•Bachelor’s degree or combination of equivalent relevant experience and education
•Understanding of data warehousing & data integration methodologies
•Experience writing data integration procedures
•Ability to create ETL/ELT procedures leveraging Change Data Capture, Slowly Changing Dimensions, and error handling
•Ability to troubleshoot a wide variety of complex data system problems
•Extensive prior experience writing SQL
•Prior experience with database administration

Preferred:
•Experience with relational & dimensional data modeling
•Experience tuning ETL performance
•Experience in a higher education setting, especially with higher education data
Salary range$60,000 - $80,000
Salary benefits10% employer contribution to the UMS retirement plan. Additional benefits include medical, dental, vision, and tuition waiver programs for employees and dependents. The UMS is a recipient of the Wellness Councils of America’s Well Workplace Award and offers wellness programs.
Application procedureTo learn more and to apply please visit our website.