CSU Job Listing Details

Printable version
E-Mail this listing


Job ID: 101002

Job Title:
Analyst/Programmer - Data Warehouse Developer (Analyst/Programme

Appointment Type:

Time Base:

Date Posted:
February 12, 2014

Closing Date:
Open until filled

Link to Apply Online:

Campus Employment Homepage:


Analyst/Programmer - Data Warehouse Developer (Analyst/Programmer - Career)

Job ID:



Sacramento Campus

Position Information

Eligible on-campus applicants in CSUEU Bargaining Units 2, 5, 7, and 9 will be given first consideration in this recruitment.

This is a full-time, probationary-track position which may become permanent upon successful completion of a probationary period.


Candidate selected will be required to provide proof of eligibility to work in the U.S.

NOTE: The person holding this position is considered a "mandated reporter" under the California Child Abuse and Neglect Reporting Act and is required to comply with the requirements set forth in CSU Executive Order 1083 as a condition of employment.


HOURS: Typically MONDAY - FRIDAY 8:00 A.M. - 5:00 P.M.; Other hours as required.

BENEFITS/FLSA: This position is covered by health benefits, and is exempt, (not eligible for overtime compensation) according to the Fair Labor Standards Act.



SALARY RANGE: $4,314.00 - $8,831.00 PER MONTH.

RECRUITMENT RANGE: Based upon the availability of funds, the anticipated appointment range is $4,314.00 - $7,084.00 PER MONTH. Salary offers within this range are contingent upon the experience and qualifications of each individual applicant. (This does not apply to promotions of on-campus employees which are covered by an MOU.)

NOTE: It is the general practice of Sacramento State to hire at the lower end of the salary range. (This does not apply to promotions of on-campus employees.)

Hiring Dept. Information

Information Resources and Technology

The Data Warehouse Developer designs, develops, maintains, and supports data models and ETLs related to campus reporting and analytics for enrollment, academic, student, budget, finance, HR, advancement, and related functions. The solutions must support critical campus-wide reporting, data modeling, and data analysis outcomes required of the Data Warehouse group.
This position is specifically responsible for the analysis, design, development, implementation, and support of reporting and predictive analytic Data Models and ETLs; development of ETL standards and templates; development and maintenance of the data security and access model; review and maintenance of data integrity; design and development of campus-wide data warehouse reporting and extract solutions; and, maintenance and support of the data warehouse and reporting development tools environment. This position will also contribute to the analysis and development of campus reporting solutions including reports, dashboards, and predictive analytic solutions.
While more than 50% of the duties assigned to the incumbent are programming and analysis, there is also a significant operational and user interaction piece to this position. Also, the work will be closely monitored by an expert-level staff member and management to ensure the work aligns with the data warehouse strategy and architecture.
The incumbent must be able to perform these duties at the career skill level.
This position reports to the Director of Data Services & Business Intelligence in the Division of Information Resources and Technology.

Minimum Qualifications

A basis foundation of knowledge and skills in applications programming and systems analysis and related programming support functions is a prerequisite. This foundation would normally be obtained through a bachelor's degree preferably in computer science or business, or equivalent training and applied experience. Knowledge and skills may include working knowledge of a specific industry standard applications programming language and knowledge of standard systems analysis techniques. Incumbents at the career level work relatively independently and posses the experience to be fully proficient in performing most of all of the work assignments defined by their position. The requisite skills and knowledge is typically obtained through a combination of education, training and progressive work experience to be able to demonstrate competence in independently applying technical judgment to standard and nonstandard applications and systems, solving a wide range of problems and developing practicable and thorough solutions, and using effective communication and listening skills.

Knowledge, Skills & Abilities

Bachelor's degree in computer science, information systems, or equivalent training and applied experience.
Demonstrated ability to function at the Analyst/Programmer Career skill level, including ability to independently apply technical judgment to work assignments to achieve desired outcomes, to both standard and non-standard data applications and systems, solve a wide range of problems, develop practicable and thorough solutions, independently consult with users to identify requirements, and use effective communication and listening skills.
Demonstrated knowledge, skill, and ability to perform the following Core Functions of the Classification:
Demonstrated knowledge and skills in analyzing and defining data requirements.
Demonstrated skills in creating, implementing, and optimizing data warehouse dimensional and relational data models for operational reporting, drill-down dashboards, and analytics.
Ability to write, modify, and support programs using multiple applications and databases. For example, develop, maintain, and support Extract, Transform, and Load (ETL) code to load a data warehouse from multiple source systems.
Demonstrated knowledge and skills in data administration and support including administering data use policies and standards.
Demonstrated ability and skills monitoring, analyzing, and verifying data to ensure data integrity including troubleshooting and resolving data problems.
Demonstrated ability and skills to develop business intelligence and operational reports.
Demonstrated knowledge and ability to use SQL.

Experience using IBM Cognos or similar tools including Data Manager, Framework Manager, SPSS Modeler, Cognos BI, Report Studio, and Query Studio.
Experience with PeopleSoft applications and data structures.
Experience in developing incremental data loads for slowly changing fact dimensions.
Experience tuning data loads and reports in a data warehouse environment.
Experience with master data management (MDM).
Ability to enhance the efficiency of existing ETLs and data models to meet current and future user needs.
Ability to develop program implementation plans, install software, and apply fixes.
Understanding of technical and vendor documentation and ability to maintain internal documentation.
Applicable experience in higher education.

Essential Functions

Data Model: Investigate, design, and develop the appropriate Data Warehouse relational and dimensional data models for operational reporting, drill-down dashboards, and advanced analytics solutions.
ETL: Develop ETL code required to update tables in the Data Warehouse with data from source systems: stage the data and transform the data for operational reporting, business intelligence reporting, and advanced analytics.
Reporting Solutions: Develop report, dashboard, and analytics solutions in support of university and department decision-making requirements.
Analysis: Consult with campus users to determine daily and long-term reporting and analytics requirements. Consult with data warehouse report writers and architect to determine how to model the data and structure the ETLs to streamline report writing.

Assist with ETL job setup and maintenance necessary to execute ETL test and production cycles.
Verify the integrity of all databases in the data warehouse. Install, structure, tune and maintain all system data warehouse instances and software for client use.
Monitor database system usage, researching the cause of and correction for data warehouse and business intelligence reporting issues.
Provide advice to the campus regarding questions and processing problems related to data warehouse related systems.
Assist with the administration of the software security process to ensure proper system access.
Produce and maintain reliable monitoring for all events related to the data warehouse.
Assist with the support, maintenance, testing, and upgrade of new and existing data warehouse related tools, software, and processes.
Monitor and support daily ETL processing.

Perform required research and analysis necessary to develop the data models and ETLs required for generating complex reports.
Learn the use of new hardware, various software packages, development tools and communication protocols.
Assist with the implementation of new technologies.
Identify tools needed to meet user requests.
Establish subject matter expertise in multiple subject matter areas of the data warehouse and a firm knowledge of the data warehouse data marts including the relationships of the data fields residing in them.

Maintain data that supports managing the department's workload.
Consult with department staff to prepare department and individual objectives.
Other tasks related to the department mission that may be assigned by management.

Equal Employment Opportunity

California State University, Sacramento is an Affirmative Action/Equal Opportunity employer, and has a strong institutional commitment to the principle of diversity in all areas. In that spirit, we are particularly interested in receiving applications from a broad spectrum of qualified people who assist the University in meeting its Strategic Plan goal to: "Build and sustain a vibrant learning community derived from the strength and vitality of our diverse campus." Sacramento State hires only those individuals who are lawfully authorized to accept employment in the United States.

It is the policy of CSU Sacramento to provide reasonable accommodations for qualified persons with disabilities who are employees or applicants for employment. If you need assistance or accommodations to interview because of a disability, please contact the department office at (916)278-5770. Employment opportunities will not be denied to anyone because of the need to make reasonable accommodations for a person's disability.

Jeanne Clery

In compliance with the Jeanne Clery Disclosure of Campus Security Policy and Campus Crime Statistics Act, Sacramento State has made crime statistics available on-line at www.csus.edu/police/cleryact.htm. Reported crimes that occurred on campus, in certain off-campus buildings or property owned or controlled by Sacramento State and on public property within, or immediately adjacent to and accessible from the campus, during the last three years are included. The report also includes institutional policies concerning security, alcohol and drug use, crime prevention, the reporting of crimes, sexual assault and other safety matters. Print copies are available in the library, and by request from the Office of Public Safety and the Office of the Vice President for Student Affairs.