|Classification Title||Analyst Programmer – Career Level|
|Collective Bargaining Unit||CSUEU/Bargaining Unit 9|
|College/Department||I&IT Central Applications|
|Type of Appointment||Probationary|
|Application Materials Required||University Application and Resume|
|Classification Salary Range||$4,314 - $8,831|
|Anticipated Hiring Range||$4,314 – $5,820|
|Recruitment Closing Date||This position is subject to close at anytime.|
The Instruction & Information Technology Division’s goal is to provide an environment that encourages and enables all members of the campus community to reach and maintain a level of technological competence and comfort that facilitates their access to the information and services appropriate to their role on campus and form a basis for professional and personal growth.
The Business Intelligence Programmer/Analyst will work with campus data owners to develop and maintain existing and new dimensional models for campus-wide reporting. The incumbent will create and maintain Extract, Transfer, and Load (ETL) scripts to move data from source systems into the Business Intelligence reporting database; develop and maintain appropriate processing schedules. The incumbent will need to stay current on the future direction of this technology and develop new strategies to stay aligned with the industry; assist in the analysis for planning and execution of application upgrades; work closely with the Business Intelligence Administrator and Department Director to research and develop solutions to leverage and integrate existing campus technology into the campus-wide, comprehensive reporting solution; gather user requirements and develop solutions for campus-wide dashboards and reports based on reporting standards. The dashboards are critical in providing campus decision makers with the correct information to make informed decisions and business operations of the campus; develop campus-wide reports using the current reporting technology. The incumbent will develop standards and processes behind the migration of reports/dashboards from development to production environments; processes include, but are not limited to, code review for adherence to standards, impact on performance, and the administration of security related to dashboards/reports and data. The incumbent will implement campus-wide reporting standards; collaborate with the Business Intelligence Administrator in the development of user training and documentation as assigned, provide end users with guidance and training as needed; respond to and troubleshoot end user help desk or phone call inquiries as well as perform other duties as assigned.
A bachelors degree in Computer Science, Computer Information Systems, Information Systems, Engineering or a related field with relevant experience totaling two years full-time or the equivalent part-time OR eight years of relevant full-time experience. (Associate degree does not substitute for experience in this classification).
Finalists for this position may be required to submit to and successfully pass a background check prior to being hired.
Experience with PeopleSoft application designer; experience with business Analytics and Business Intelligence tools; experience with dashboard development; 5 years full-time experience in report development and data modeling in higher education environment; experience in dimensional data modeling; working knowledge of Oracle RDBMS; software release and system change management experience.
Cal Poly Pomona is an Equal Opportunity, Affirmative Action Employer. The university subscribes to all state and federal regulations and prohibits discrimination based on race, color, religion, national origin, sex, gender identity/gender expression, sexual orientation, marital status, pregnancy, age, disability, genetic information, medical condition, and covered veteran status.
Cal Poly Pomona hires only individuals lawfully authorized to work in the United States.
In compliance with state and federal crime awareness and campus security legislation, including The Jeanne Clery Disclosure of Campus Security Policy and Crime Statistics Act, California Education Code section 67380, and the Higher Education Opportunity Act (HEOA), the Cal Poly Pomona Annual Security and Fire Safety Report is available at: http://dsa.csupomona.edu/police/securityreport.asp
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. http://www.calstate.edu/eo/EO-1083.html
Achieving Excellence as a Learning-Centered University