Working Title: Business Intelligence Analyst / Developer
Classification Title: Analyst/Programmer - Career
As of Thursday, April 28th, this position has been reposted and is still actively accepting applications. Prior applicants need not reapply.
Priority Application Date (Posting will remain open until filled): Thursday, April 21st @ 11:55pm
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.
This Data Warehouse Developer 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. This position reports to the Director of University Reporting and Data Services in the Information Resources and Technology (IRT) division. The University Reporting and Data Services team designs, 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.
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 objectives including student success initiatives. In addition, the incumbent will maintain existing data models and ETL code in support of operational reporting. The incumbent will support data governance initiatives and align data models, ETL code, and data access with data governance policies and guidelines. In addition, the incumbent will participate in the overall data warehouse and analytics application configuration and maintenance, as needed, to ensure a reliable, secure, supportable environment.
Duties may include documentation, development, production support, system administration, user support and other in-depth customer relations activity to support the analytic reporting environment. Duties may also include working as a team member on issues related to the definition, design and implementation of data marts making up the University Data Warehouse. The incumbent may act as lead or secondary lead on one or more systems relating to the business intelligence environment, and cross-train to support systems. Assignments will be dependent on skill level, proficiency, and experience.
CSU Classification Salary Range: $4,372 - $10,792 per month
Hiring Range: Anticipated hiring range is $7,536 - $9,000 per month, commensurate with candidate's education, experience, skills, and training.
Salary Grade/Range: 2
Recruitment Type: Regular
Time Base: Full-Time
Pay Plan: 12 months
Work Hours: Monday-Friday, 8am-5pm; other hours as required.
Full telecommuting (remote work) is available after successful completion of a hybrid onboarding period (remote and in-person work), on an opt-in basis.
Please visit the following webpage for more information on the CSU Telecommuting Program: https://www.csus.edu/administration-business-affairs/internal/your-hr/telecommuting-program.html.
Per our Out of State Employment Policy (see below), a successful candidate must reside within the State of California upon time of hire.
Who is IRT?
Information Resources & Technology (IRT) partners with faculty, staff, and students to provide essential information technology services that support mission critical activities and innovative technology solutions that facilitate the accomplishment of strategic campus goals at Sacramento State.
For more information, please visit: www.csus.edu/irt
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 Management Information Systems (MIS), 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.
- Bachelor’s degree from an accredited university, preferably in Computer Science, Management Information Systems (MIS), or another relevant field.
- 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 ability to analyze user needs, determine and evaluate alternative solutions and approaches to meeting those needs, and select the optimal solution.
- Demonstrated skill to develop user-friendly solutions such as Cognos reports and dashboards data visualizations that meet business intelligence requirements.
- Demonstrated ability to work with the users to monitor, analyze, model, create, and verify data to ensure integrity of reports and dashboards.
- Demonstrated ability to develop, troubleshoot and maintain Extract, Transform, and Load (ETL) code to load a data warehouse repository, including code to handle incremental data loads and slowly change dimensions.
- Demonstrated ability to write complex SQL queries.
- Demonstrated knowledge and skill providing training and communication materials to users that maximize their ability to utilize system capabilities, features, and other resources as related to database management, reporting packages/systems, and business intelligence analysis techniques.
- Demonstrated ability to balance multiple work load responsibilities and meet deadlines.
- Demonstrated ability to collaborate at all levels of the organization and apply effective project management skills.
- Demonstrated ability to communicate effectively with both technical and non-technical staff.
- Demonstrated ability to clearly and effectively write documentation for technical requirements and procedures.
Conditions of Employment
- Ability to pass background check.
- 5 years or greater experience in an ETL Developer role
- Demonstrated ability to conduct thorough data analysis to ensure completeness and accuracy of both data models and data content.
- Demonstrated ability to maintain the data warehouse application platform including application installation, patching, and configuration.
- Demonstrated knowledge of data warehousing data models using the Kimball Data Modeling methodology, or similar.
- Demonstrated knowledge of formal data flow analysis methodologies and ability to design data warehouse data models.
- Demonstrated ability to implement dimensional data models, star schemas, across multiple data marts/subject areas.
- Experience with the following:
- OLAP reporting tools and data cube technology
- Oracle data development tools
- Informatica PowerCenter and Metadata Manager/Enterprise Data Catalog
- Cognos Business Intelligence and Framework Manager tools
- Tableau Desktop and Tableau Server development tools
- ServiceNow or similar application to track incident and work assignments
- Data structures of PeopleSoft Campus Solutions, HR and Finance tables
- Developing data definitions and tracking data lineage as part of an enterprise data governance program
- Agile software development methodology
- Relational and Multi-dimensional database concepts
- Business process analysis and workflow improvement
- Data reporting and analysis from student information systems, financial systems, HR systems, and other data warehouse related information
- Understanding of Information Security and FERPA regulations as they relate to data warehousing and reporting/dashboards.
- Applicable experience within higher education
Documents Needed to Apply
Resume, cover letter. Failure to upload required documentation may result in disqualification.
About Sac State
Sacramento State is located in the heart of California’s capital city, five miles from State Capitol. The lush, 300-acre campus is situated along the American River, close to numerous bike trails and other recreational areas. Sacramento, also known as the “Farm-to-Fork Capital,” is one of the most ethnically diverse and livable cities in the country, with a population of half of a million. Sacramento State’s 31,000 students come not only from the Greater Sacramento Region, but also from across the state, country, and world. Our 1800 faculty and 1,500 staff are committed to meeting our mission: “As California’s capital university, we transform lives by preparing students for leadership, service, and success. Sacramento State will be a recognized leader in education, innovation, and engagement.” As the regional hub of higher education, Sac State is dedicated to student success, diversity, equity and inclusion, community engagement, philanthropy, and campus safety.
As evidenced by the values embedded in our Hornet Honor Code, Sacramento State is committed to creating an inclusive environment where all faculty, staff, students, and guests are welcome and valued. Our commitment is more than simply ensuring that our campus is free from bias and discrimination, but is one devoted to celebrating many diverse identities, life experiences, and perspectives that enrich our community, teaching and learning.
To learn more about why you should join the Hornet Family, please visit the Why Sac State? page.
Background Check Disclaimer
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.
COVID-19 Vaccine Certification Information:
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 https://calstate.policystat.com/policy/9779821/latest/ and questions may be sent to firstname.lastname@example.org
Out of State Employment Policy
Sacramento State University, as part of the CSU system, is a State of California Employer. As such, the University requires all employees (up)on date of hire to reside in the State of California.
As of January 1, 2022 the CSU Out-of-State Employment Policy prohibits the hiring of employees to perform CSU-related work outside the state of California.
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, sex, gender identity/expression, sexual orientation, pregnancy, 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 https://www.csus.edu/administration-business-affairs/internal/your-hr/benefits/reasonable-accomodation.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 https://www.csus.edu/compliance/hr-compliance/mandatory-dhr-training.html .
Jeanne Clery Disclosure of Campus Security Policy and Crime Statistics Act and Campus Fire Safety Right-To-know Act Notification:
Pursuant to the Jeanne Clery Disclosure of Campus Security Policy and Campus Crime Statistics Act, the current Annual Security Report (ASR) is available for viewing at https://www.csus.edu/clery .
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 Sacramento State for the last three (3) calendar years. Paper copies are available upon request at the Police Service Center located in the University Union.
Selected candidate must furnish proof of eligibility to work in the U.S.. California State University, Sacramento is a sponsoring agency (i.e. H-1-B Visa).
Note to Applicants:
Possession of the minimum qualifications does not guarantee an interview unless required by collective bargaining agreement.