Experience:
1-3 years of experience
Concerned about your lack of experience? Learn More...
Employment Type:
Full time
Posted:
8/31/2015
Job Category:
Information Services
Data Developer (7199U) #19594
(This job is no longer available)
University of California | Berkeley, CA
loading
loading
School
Major
Grad Date
 
 

Not sure what types of jobs you are interested in?


Explore Jobs
Based on Your Education

Follow This Company
Share

Job Description

The University of California, Berkeley, is one of the world's most iconic teaching and research institutions. Since 1868, Berkeley has fueled a perpetual renaissance, generating unparalleled intellectual, economic and social value in California, the United States and the world. Berkeley's culture of openness, freedom and acceptance-academic and artistic, political and cultural-make it a very special place for students, faculty and staff.

Berkeley is committed to hiring and developing staff who want to work in a high performing culture that supports the outstanding work of our faculty and students. In deciding whether to apply for a staff position at Berkeley, candidates are strongly encouraged to consider the alignment of the Berkeley Workplace Culture with their potential for success at http://jobs.berkeley.edu/why-berkeley.html.

Departmental Overview

The Student Information System (SIS) Project is one of the largest and most significant initiatives on campus. This project has strong support from campus executive leadership, faculty, staff and students, and is seen as one of UC Berkeley's highest administrative priorities. To ensure the success of this mission-critical project, UC Berkeley is building a project team whose members will include a blend of campus and external experts to help design, test and implement the new system.

The objective of the SIS Replacement Project is to replace the university's constellation of aging, disparate and internally built and maintained student systems with a modern, nimble and effective vendor-supported system. The new system will include admissions, enrollment, registration, financial aid, student accounts, advising and a student portal.

This two-year contract position, with possibility of extension, will join the Student Information Systems Project as part of the Data Conversion, Data Warehouse and Reporting Team to 1) assist in converting UC Berkeley's student data assets from legacy systems to PeopleSoft Campus Solutions and 2) retrofit and integrate reporting and data warehouse content impacted by the conversion. Key responsibilities include task management; business requirements analysis; the creation of technical specifications; designing, developing, unit testing, deploying and supporting data conversion; coordinating the efforts of ETL and report developers, database administrators, and other technical staff in the course of providing conversion and reporting solutions; performing and documenting impact analysis on existing reporting and data warehouse content; developing and maintaining business and technical metadata; responding to functional questions and issues; and leading efforts to resolve operational data inconsistencies.

Responsibilities

Conversion from Legacy Applications to Campus Solutions
Conduct sessions with subject matter experts to map legacy system data to Campus Solutions tables and fields. Profile legacy data to inform the conversion effort. Make conversion recommendations to functional teams. Translate functional conversion requirements to technical specifications. Troubleshoot and resolve conversion load warnings and errors. Identify data cleanup opportunities and coordinate with functional team members. Extract, transform and integrate legacy data using SQL and ETL tools (Informatica). Create test plans and coordinate converted data validation efforts.

Reporting
Work with functional users to define and prioritize reporting needs, consolidate similar reports and retire deprecated reports. Capture and document functional and technical report specifications. Work with Campus Solutions consultants to identify reporting needs satisfied by the ERP. Identify data source(s), reporting tool and delivery options for each report. Design and implement reports. Gather, specify and enforce data security requirements for each report. Create test plans and coordinate user acceptance testing.

Data Warehouse Retrofit
Inventory Data Warehouse objects and reports impacted by decommission of legacy systems. Evaluate if legacy data warehouse data models support Campus Solutions business processes and data structures. Work with data architect to modify campus data warehouse models, as needed. Propose strategies for data warehouse object retrofit or redesign. Modify impacted source-to-target mapping specifications. Interface with users, project managers, DBA's, and other technical resources as necessary to meet project goals. Adhere to established programming and naming standards. Modify mappings that transform and load data into data warehouse structures utilizing ETL tools (Informatica). Unit test and deploy ETL processes to production. Develop and maintain accurate, clear technical metadata.

Required Qualifications

- Must have successfully completed a system data migration or conversion project.
- Must have experience with solving data quality problems and have an understanding of mapping and cross reference lookups.
- Must have in-depth understanding of ETL tools and processes.
- Requires strong analytical and design skills, including the ability to abstract information requirements from real-world processes to understand information flows in computer systems.
- Must be familiar with logical data design, data mapping and data conversion.
- Requires strong knowledge of data management systems, practices and standards.
- Must have knowledge relating to logical data design, data warehouse design and data integration.
- Must be familiar with data model patterns in one or more common business or academic domains.
- Must be fluent in SQL.
- Must exercise critical thinking skills and attention to detail.
- Must demonstrate good interviewing and listening skills.
- Requires good written and oral communication skills.
- Should be familiar with data quality and governance issues and requirements.

Conversion from Legacy Applications to Campus Solutions:
Conduct sessions with subject matter experts to map legacy system data to Campus Solutions tables and fields. Profile legacy data to inform the conversion effort. Make conversion recommendations to functional teams. Translate functional conversion requirements to technical specifications. Troubleshoot and resolve conversion load warnings and errors. Identify data cleanup opportunities and coordinate with functional team members. Extract, transform and integrate legacy data using SQL and ETL tools (Informatica). Create test plans and coordinate converted data validation efforts.

Reporting:
Work with functional users to define and prioritize reporting needs, consolidate similar reports and retire deprecated reports. Capture and document functional and technical report specifications. Work with Campus Solutions consultants to identify reporting needs satisfied by the ERP. Identify data source(s), reporting tool and delivery options for each report. Design and implement reports. Gather, specify and enforce data security requirements for each report. Create test plans and coordinate user acceptance testing.

Data Warehouse Retrofit:
Inventory Data Warehouse objects and reports impacted by decommission of legacy systems. Evaluate if legacy data warehouse data models support Campus Solutions business processes and data structures. Work with data architect to modify campus data warehouse models, as needed. Propose strategies for data warehouse object retrofit or redesign. Modify impacted source-to-target mapping specifications. Interface with users, project managers, DBA's, and other technical resources as necessary to meet project goals. Adhere to established programming and naming standards. Modify mappings that transform and load data into data warehouse structures utilizing ETL tools (Informatica). Unit test and deploy ETL processes to production. Develop and maintain accurate, clear technical metadata.

Preferred Qualifications

Preferred Work Experience:
- Direct experience with ERP systems and implementation projects strongly desired.
- Experience with higher education information systems strongly preferred.
- Experience with PeopleSoft applications and technology desired.

Preferred Software Experience:
- Oracle 12c Enterprise Edition
- PeopleSoft Campus Solutions 9.x (including PS Query, BI Publisher and PeopleTools 4.8.x)
- Oracle SQL Developer 4.x
- Informatica PowerCenter 9.5.x
- IBM Data Studio 4.1.x

Education/Training:
- Bachelor's degree in related area and/or equivalent experience/training

Salary & Benefits

For information on the comprehensive benefits package offered by the University visit:

http://ucnet.universityofcalifornia.edu/compensation-and-benefits/index.html

How to Apply

Please submit your cover letter and resume as a single attachment when applying.

** This is a 2 year contract position.**

Criminal Background Check

This position has been designated as sensitive and may require a Criminal Background Check. We reserve the right to make employment contingent upon successful completion of a Criminal Background Check.

Equal Employment Opportunity

The University of California is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status. For the complete University of California nondiscrimination and affirmative action policy see:
http://policy.ucop.edu/doc/4000376/NondiscrimAffirmAct

If you'd like more information about your EEO rights as an applicant under the law, please see:
http://www1.eeoc.gov/employers/upload/eeoc_self_print_poster.pdf

About University of California

UCSF is a leading university that consistently defines health care worldwide by conducting advanced biomedical research, educating graduate students in the life sciences, and providing complex patient care.