ETL Developer/Data Modeler (Analyst/Programmer Career) (2 Positions)
ETL Developer/Data Modeler (Analyst/Programmer Career) (2 Positions)
Job ID: 101967
Full/Part Time: Full-Time
Job Code: 0400
Job Grade: Career
Salary and Hours WORK SCHEDULE: Monday - Friday 8:00AM-5:00PM with occasional need for work outside of these hours.
Recruitment Salary Range: $4,372 - $7,300
Classification Salary Range: $4,372 - 9,683 Job Summary This Analyst/Programmer Career position will focus on developing and maintaining innovative Data Models and ETL code for the campus data warehouse to run, grow, and transform the way the university uses data to drive decision making.
The incumbent will assist in the transformation of the data warehouse to a dimensional data model that is optimized for analytics in support of key university strategic objective including student success initiatives. In addition, the incumbent will maintain existing data models and ETLs in support of operational reporting including the conversion of existing ETL code to a new ETL development platform.
The incumbent will support data governance initiatives and align data models, ETL code, and data access with data governance policies and guidelines.
The incumbent will work closely with IRT colleagues and key campus data analysts to thoroughly understand reporting and analytics requirements and use those as the basis for development efforts.
In addition, the incumbent will continue to the overall data warehouse and analytics application configuration and application update maintenance as needed to ensure a reliable, secure, supportable environment.
This position reports to the Senior Director of Data Services and Business Intelligence (BI) in the Information Resources and Technology (IR&T) Division. The Data Services and BI team architects, develops enhances, and supports the campus-wide business intelligence and data warehouse solution used by faculty, staff, and senior-level administrators for data-driven decision making.
For more information on IRT, please visit: http://www.csus.edu/irt/index.html Benefits/FLSA This position is covered by health benefits, and is exempt, (not eligible for overtime compensation) according to the Fair Labor Standards Act.
For more information on the comprehensive benefits package offered by the University visit:
http://www.csus.edu/hr/departments/benefits/benefitsprograms.html Minimum Qualifications To enter this classification, a basic 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. Foundation knowledge and skills for the Analyst/Programmer, depending on the position assignment, may include working knowledge of a specific industry standard applications programming language and knowledge of standard systems analysis techniques. Required Qualifications Experience:
1. Demonstrated ability to function at the Analyst/Programmer Career skill level
2. 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
3. Ability to independently consult with users to identify requirements, and use effective communication and listening skills
Demonstrated ability to perform the following Essential Functions of the classification at the career level:
Systems Analysis and Development
4. Knowledge of formal data flow analysis methodologies
5. Demonstrated ability to design data warehouse data models
6. Demonstrated ability to implement dimensional data models, star schemas, and slowly changing dimensions.
7. Ability to design data structures to maximize efficiency and flexibility
8. Demonstrated ability to develop and maintain Extract, Transform, and Load (ETL) code including ETL code to handle incremental data loads and slowly changing dimensions.
9. Ability to write complex SQL scripts
10. Demonstrated ability to support and troubleshoot production ETL code
11. Demonstrated ability to maintain the data warehouse application platform including application patching configuration
General Class Skills
12. Demonstrated ability to communicate effectively with both technical and non-technical staff
13. Demonstrated ability to clearly and effectively write documentation for technical requirements and procedures Preferred Qualifications 1. Demonstrated understanding of complex data models and data relationships for reporting, analytics, and data mining.
2. Demonstrated ability and skills monitoring, analyzing, and verifying data to ensure data integrity including troubleshooting and resolving data problems.
3. Ability to analyze user needs, determine and evaluate alternative solutions and approaches to meeting those needs, and select optimal solution.
4. Understanding of technical and vendor documentation and ability to maintain internal documentation.
5. Three or more years of experience in building data models and supporting a data warehouse implemented on an Oracle database platform.
6. Three or more years of experience in developing ETL code using data integration tools such as DataStage, Informatica, SSIS, ODI, or other similar tools.
7. Three or more years of experience developing ETL code and data models to populate a data warehouse from PeopleSoft Student, HR, and finance related transactional source data.
8. Understanding of functional processes used at a Higher Ed institution.
9. Experience developing Tableau Data Extracts
10. Experience building data relationships and surfacing data in IBM Cognos Framework Manager
11. Experience in identifying use cases for data virtualization and implementing and maintaining data virtualization solutions.
12. Experience in managing meta-data, data definitions, and data use policies. Eligibility Verification -Candidate selected will be required to provide proof of eligibility to work in the U.S. Background Check A background check (including a criminal records check) must be completed satisfactorily before any candidate can be offered a position with California State University, Sacramento. Failure to satisfactorily complete the background check may affect the application status of applicants or continued employment of current California State University, Sacramento employees who apply for the position. Child Abuse and Neglect Report 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 the California State University Executive Order 1083 as a condition of employment. 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. We consider qualified applicants for employment without regard to race, color, religion, national origin, age, gender, gender identity/expression, sexual orientation, genetic information, medical condition, marital status, veteran status, or disability. Sacramento State hires only those individuals who are lawfully authorized to accept employment in the United States.
It is the policy of California State University, Sacramento to provide reasonable accommodations for qualified persons with disabilities who are employees or applicants for employment. If you need a disability related reasonable accommodation as part of the application and/or interviewing process, visit http://www.csus.edu/hr/departments/equal-opportunity/index.html
The University is committed to creating an education and working environment free from discrimination, sexual harassment, sexual violence, domestic violence, dating violence, and stalking. For more information on mandatory training for new employees, visit http://www.csus.edu/hr/departments/equal-opportunity/Information%20for%20Job%20Applicants.html
Jeanne Clery Disclosure of Campus Security Policy and Crime Statistics Act and Campus Fire Safety Right-To-know Act Notification. For additional information, visit http://www.csus.edu/aba/police/ Hiring Preference Eligible on-campus applicants in California State University Employees Union (CSUEU) Bargaining Units 2, 5, 7, and 9 will be given first consideration in the recruitment. Application Deadline OPEN UNTIL FILLED ¿ Applications received by 11:59p.m. Wednesday, March 29, 2017 will be given priority review. How To Apply Applications are only accepted through the Sacramento State jobs webpage located at http://www.csus.edu/about/employment/. Once there, applicants can also click on the instructions link to see how to apply. External applicants can apply by clicking on the Staff and Management Opportunities at Sacramento State link. Internal applicants can apply by logging on My Sac State.
NOTE: This position will be located in the Center¿s Sacramento Office or other major metropolitan area in the state, depending on the Center¿s needs.
Please note: Resumes will not be accepted in lieu of application.
Candidate must attach the following materials to the on-line application:
1. Letter of interest (Cover letter).
2. Current curriculum vitae/resume.
3. Three (3) references who can speak to a broad range of candidates professional qualifications (including name, title, and telephone number).
For questions regarding this search, contact:
Baron Siegfried Marsh
To apply, visit: http://www.csus.edu/about/employment/