Professional Analyst / Programmer
Job no: 510652
Department: Strat Plan,Enroll,Mgmt,Innovat
Work type: Staff
Location: Stanislaus – Turlock
Categories: Unit 9 – CSUEU – Technical Support Services, Probationary, Full Time, Information Systems & Technology
(Classified as: Analyst/Programmer, Career)
Full-time position available on or after May 2, 2022 in the Office of Institutional Effectiveness and Analytics.
Under general supervision of the Director of Institutional Effectiveness & Analytics, the Business Intelligence Analyst/Programmer works as a seasoned data/information management professional with a full understanding of data warehouse methodologies, reviews and resolves complex data issues, and provisions data in the ways that enable other analysts of Institutional Effectiveness and Analytics (IEA) and modern end users to practice such as visualization, advanced analytics, data prep, and self-service data access. This incumbent, along with other analysts of IEA, will interact directly with decision-makers across the University to streamline the decision-making process.
Duties include but are not limited to:
- Independently research, design, and develop logical data models for data analysis.
- Keep up-to-date with latest technology trends.
- Drive the design and development of a business intelligence platform.
- Use SQL and other Business Intelligence tools to analyze data and assist business leaders in their decision-making.
- Meet with key stakeholders from all University divisions and departments to gather, analyze and determine data and information requirements in support of the Data and Analytics roadmap, as well as business-as-usual requests.
- Assist business units with information in various delivery methods (e.g. canned reports, dashboards, self-service analytics tools, and data extracts).
- Provide security, integrity and validity to all data and reports
- Accountable for creating and maintaining information requirement repository, including all associated metadata.
- Create reports, dashboards, and documents to fulfill requirement repository, including all associated metadata.
- Create reports, dashboards, and documents to fulfill information requests.
- Document specifications for business intelligence reports, dashboards or other outputs.
- Other duties as assigned.
Education: A bachelor’s degree in computer science, computer information systems, or a related field, or equivalent training and applied experience.
Experience: Three years of experience in business applications analysis, design, and programming for medium or large scale, multi-programmed computers.
- Three to five years of experience as a data analyst or programmer analyst with SQL proficiency and understanding of database and information models.
- Experience in data mining.
- Experience using business intelligence tools.
- Experience with relational database design, development & documentation.
- Experience with Excel and Power BI Stack.
- Experience with Data Visualization.
- Advanced in SQL and other programming languages.
- Demonstrated experience of understanding mid-level database, including proprietary and/or structured or open relational databases such as MS SQL.
- Design database systems and programs, which include access methods, access time file structures. Device allocation. validation checks, statistical methods, and security.
- Ability to ensure the integration of systems through the database structure.
- Ability to troubleshoot and resolve database and data problems.
- Ability to assist in data transfers or sharing of files.
- General knowledge of network configuration, programming, and protocols.
- Ability to provide database support in multiple hardware platforms and operating system environments.
Knowledge, Skills, Abilities
- Ability to use systems work flow and logic flowchart techniques.
- Knowledge of formal data flow analysis methodologies.
- Ability to apply and use operations analysis and structured design analysis techniques.
- Knowledge of campus-defined systems, applications, and standards.
- Ability to identify hardware/software interface problems.
- Knowledge of system/equipment capability, design restrictions, and security requirements.
- General knowledge of network connectivity, integration, configuration, and protocols.
- Understanding of and ability to integrate all systems including operating systems, applications, network, and databases, as well as knowledge of distributed processing technology.
- Knowledge of client/server technologies.
- Ability to communicate effectively.
- Ability to apply consultative skills to assess user needs and communicate technology systems and solutions.
- Ability to use one or more industry standard programming languages and various report/screen generators as required by the position.
- Ability to use applications software, data structures and utilities, operating systems, and communication interfaces within the computing environment.
- Ability to perform interactive debugging and to test and analyze program failures.
- Knowledge of structured programming techniques and the ability to use appropriate productivity tools to provide for more rapid development of applications.
- Ability to write/modify programs using multiple applications and databases.
- Knowledge of formal data structure design, relational database design, and file structure.
- Ability to design data structures to maximize efficiency and flexibility.
- Ability to perform database maintenance tasks, develop access routines, and maintain dictionary.
- Knowledge of data administration principles and data modeling concepts.
- Ability to identify and resolve software/hardware interface problems, data requirements, and access methods.
- Ability to establish and execute data security standards and procedures and disaster recovery plans.
- Knowledge of distributed processing and client/server technologies.
- Ability to perform database backup and recovery procedures as part of database management system utilities.
- Ability to use data resource and productivity tools applicable to the database management system.
- General knowledge of network configuration, programming, and protocols.
CSU requires faculty, staff, and students who are accessing campus facilities to be immunized against COVID-19 or declare a medical or religious exemption from doing so. Any candidates advanced in a currently open search process should be prepared to comply with this requirement. The systemwide policy can be found at:
Anticipated salary will be $4,372 – $5,684 per month plus excellent paid benefits. Salary will depend on the qualifications of the successful finalist. (Full Analyst/Programmer, Career range: $4,372 – $10,792 per month)
Compensation & Benefits
Commensurate with qualifications and experience. As a member of the 23-campus CSU System, we offer an extremely competitive benefits package that includes, but is not limited to, outstanding vacation, health, dental, and vision plans; a fee waiver education program; membership in the California Public Employees Retirement System (PERS); and 14 paid holidays a year. Link to (Bargaining Unit: 9) Benefits Summary: CSU Employee Benefit Summary
How to Apply
To be considered, qualified candidates must submit a completed Stanislaus State online employment application, cover letter, and resume. Applications are accepted electronically only. Please note that failure to completely fill out each section of the online application may result in your application not receiving consideration. To apply online, please click the “Apply Now” button on this page.
Applications will be processed in accordance with Article 9.3 of the CSU/CSUEU Memorandum of Understanding. Preference will be given to qualified individuals currently employed at CSU Stanislaus in bargaining units 2, 5, 7, and 9 except when it is determined that it is necessary to appoint outside applicants to meet the best interest of the campus by obtaining specialized skills and abilities not available from current employees.
OPEN UNTIL FILLED; SCREENING TO BEGIN ON OR AFTER APRIL 6, 2022 (Applications received after the screening date will be considered at the discretion of the university.)
Criminal Background Clearance Notice
Satisfactory completion of a background check (which includes checks of employment records, education records, criminal records, civil records; and may include motor vehicle records, professional licenses, and sex offender registries, as position requires) is required for employment. CSU will make a conditional offer of employment, which may be rescinded if the background check reveals disqualifying information, and/or it is discovered that the candidate knowingly withheld or falsified information. Failure to satisfactorily complete the background check may affect the continued employment of a current CSU employee who was conditionally offered the position.
Campus & Area
California State University, Stanislaus serves the San Joaquin Valley and is a critical educational resource for a six-county region of approximately 1.5 million people. The University is fully committed to creating a culture of diversity and inclusion – one in which every person in the University community feels safe to express their views without fear of reprisal. Widely recognized for its quality academic programs, the University has 10 nationally accredited programs and 662 faculty members. 94 percent of full-time faculty holds doctorates or terminal degrees in their fields. The University offers 43 undergraduate majors, 16 master’s programs, 7 post-graduate credentials, a doctorate in education and serves more than 10,000 students. New instructional facilities have been built for the unique pedagogy of professional programs, laboratory sciences and performing arts.
Stanislaus State continues to receive national recognition with its ranking as one of the best 384 colleges in the nation by The Princeton Review. The University was one of 12 public universities in the nation to be recognized by the American Association of State Colleges and Universities for demonstrating exceptional performance in retention and graduation rates. In addition, U.S. News and World Report ranks Stanislaus State in its top 10 among public universities in the West, while Washington Monthly honored Stanislaus State as the West’s No. 1 university for the money. Stanislaus State also is recognized as a Hispanic-Serving Institution (HSI) by the U.S. Department of Education.
Clery Act Disclosure
Pursuant to the Jeanne Clery Disclosure of Campus Security Policy and Campus Crime Statistics Act, the annual security report (ASR), is now available for viewing at https://www.csustan.edu/annual-campus-security-report. The ASR contains the current security and safety-related policy statements, emergency preparedness and evacuation information, crime prevention and sexual assault prevention information, and drug and alcohol prevention programming. The ASR also contains statistics of Clery Act crimes for Stanislaus State for the previous three years. A paper copy of the ASR is available upon request by contacting the office of the Clery Director located at One University Circle, Turlock, CA 95382.
Equal Employment Opportunity
The university is an Equal Opportunity Employer and does not discriminate against persons on the basis of race, religion, color, ancestry, age, disability, genetic information, gender, gender identity, gender expression, marital status, medical condition, national origin, sex, sexual orientation, covered veteran status, or any other protected status. All qualified individuals are encouraged to apply. 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, revised 7/21/17, as a condition of employment.
Applicants requiring necessary accommodations to the application process may contact the Human Resources Department at (209) 667-3351. California Relay Service is available at (800) 735-2922 voice and (800) 735-2929 TDD. As a federal contractor, we are committed to attracting a diverse applicant pool. Please consider completing the Voluntary Self-Identification of Disability form (your response will not be shared with the search committee) at: Voluntary Self-Identification of Disability PDF Form.
CSU Stanislaus hires only individuals lawfully authorized to work in the United States. In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire.
The individuals who appear to be the best qualified for this position will be contacted by telephone or email for an interview.
INFORMATION CONTAINED IN THIS ANNOUNCEMENT MAY BE SUBJECT TO CHANGE WITHOUT NOTICE