Data Systems Developer
Employer Info:
University of Maine System
http://www.maine.edu/
The University of Maine System (UMS) is a network of public universities in the U.S. state of Maine. Created in 1968 by the Maine State Legislature, the University of Maine System consists of seven universities, each with a distinct mission and regional character. Combined, there are approximately 34,700 students enrolled at these institutions. The University of Maine System is an EEO/AA employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, age, disability, protected veteran status, or any other characteristic protected by law.
University of Maine System
http://www.maine.edu/
The University of Maine System (UMS) is a network of public universities in the U.S. state of Maine. Created in 1968 by the Maine State Legislature, the University of Maine System consists of seven universities, each with a distinct mission and regional character. Combined, there are approximately 34,700 students enrolled at these institutions. The University of Maine System is an EEO/AA employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, age, disability, protected veteran status, or any other characteristic protected by law.
- Job Name
- Data Systems Developer
- Posting Date
- 03/31/2017
- Brief Description
- The University of Maine is seeking to fill the position of Data Systems Developer located on the Orono Campus of the University of Maine.
Primary Purpose of Position:
The Data Systems Developer (DSD) works closely with all members of the Data, Analytics, & Reporting Technology Services team (DARTS), as well as additional personnel within IT, to develop and maintain reporting archives, views, and calculated fields within reporting databases, and to write and maintain the ETL procedures that feed the UMS data warehouse. The DSD works together with the US:IT Database Administration team to ensure that reporting databases are performing and accurate. The DSD also produces reports and dashboards in consultation with colleagues within DARTS, and contributes to DARTS documentation efforts. - Job Category
- Institutional Research
- Job Type
- Full-Time
- Education Level Required
- Bachelors
- Location City
- Orono, ME , United states
- How to Apply
- Review of applications begins immediately. Position open until filled. Materials must be submitted by going to the following link:
https://maine.hiretouch.com/job-details?jobID=39283&job=data-systems-developer&collection=true
You will need to create an applicant profile, complete an application (which includes contact information for three professional references), and upload a cover letter and a resume/curriculum vitae which fully describes your qualifications and experiences with specific reference to the required and preferred qualifications. You will also need to complete the affirmative action survey, the self-identification of disability form, and the self-identification of veteran status form.
The successful applicant is subject to background screening.
All UMS employees are required to comply with applicable policies and procedures, as well as to complete applicable workplace related screenings, and required employee trainings, such as Information Security, Safety Training, Workplace Violence and Sexual Harassment.
The University of Maine System is an EEO/AA employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, age, disability, protected veteran status, or any other characteristic protected by law. - Job Details
-
Essential Duties:
- Design, implement, and maintain reporting archives and views in PeopleSoft
- Write & modify ETL as required to build out data warehouse
- Participate in the development of star schemas & dimensional data models for data warehouse
- Coordinate with DARTS team members to ascertain data modeling and ETL requirements
- Ensure timely update of reporting system tables
- Create and modify SQR reports
- Create and modify UMS data warehouse reports & dashboards
- Assist in the creation and maintenance of documentation related to analytical reporting tools, and the reports and dashboards executed therein, for various groups of end users
Nonessential Duties: None.
Supervisory Responsibilities: None.
Reporting Relationship: Reports to the Director of Institutional Data Management
Knowledge, Skills and Abilities:
Required:
- Excellent analytical, organizational, critical thinking & quantitative skills
- Outstanding problem identification & problem solving skills
- Achieves results through partnership & collaboration in a team work environment
- Self-motivated, resourceful individual who manages time well and follows through
- Excellent communication skills, both verbal & written
- Excellent customer service & interpersonal skills
Required
Bachelor’s degree or combination of equivalent relevant experience and education.
Extensive prior experience writing SQL
Ability to troubleshoot a wide variety of complex data system problems
Preferred :
Experience with BI Publisher and SQR
Experience with data warehousing & data integration methodologies
Experience with relational & dimensional data modeling
Experience tuning ETL performance
Experience in a higher education setting, especially with higher education data
Other Information:The salary range is low $40's to $60,000 based on the qualifications and experience of the successful applicant. Benefits include medical, dental, vision, and tuition waiver programs for employees and dependents. In addition, the UMS retirement program provides a 10% employer contribution. The UMS is a recipient of the Wellness Councils of America’s Well Workplace Award and offers wellness programs.