Classification: Analyst Programmer - Career Department Name: Enterprise Data Mgmt & Info Security Job Number: MB2021-PD2733 Status: Extended.Apply Today! Applications will be reviewed on a rolling basis until the position is filled. Priority Screening Date: Recruitment Status:Apply Today! Applications will be reviewed on a rolling basis until the position is filled.
Position Description: Powered by an inspiring Founding Vision Statement, California State University, Monterey Bay (CSUMB) is a mid-sized comprehensive baccalaureate and masters granting university whose staff and faculty help transform student lives through a focus on student success and engagement through project-based learning, service learning in its regional community, and the promotion of multicultural and global perspectives on and beyond campus. CSUMB is both a Minority Serving Institution (MSI) and an Hispanic Serving Institution (HSI) and has a vibrant, diverse student body of over 7,600 students. The university's Strategic Plan prioritizes inclusive excellence through recruiting and investing in the development of a diverse body of faculty, staff, and administrators. CSUMB's sustainability initiative is to be carbon neutral by 2030. The university's faculty and staff, many of whom live in the East Campus housing development, appreciate living and working so close to the shores of the beautiful Monterey Bay. As one of the 23 campuses in the California State University (CSU) system, CSUMB offers excellent benefits, including access to below market rate campus housing and competitive salaries for faculty and staff. PURPOSE: Under the general supervision of the Senior Director of Enterprise Data Management, the Data Services Developer will work closely with other Data Services Developers, the Data Modeler, DBAs, and campus staff to build processes that move data to populate the campus data warehouse, and other campus, third party, or cloud systems. The Data Services developer designs, tests and documents ETL processes (extract, transform, load), and assists with development of campus business and data models. The Data Services Developer works independently on assigned tasks in close collaboration with other technical and functional members of the Data Services team. ESSENTIAL DUTIES AND RESPONSIBILITIES include, but are not limited to, the following:
ETL Process Development
Design and develop new ETL processes using campus ETL tools, or modify existing ETL to meet user requirements
Translate development specifications into ETL to extract the appropriate data from source to target systems
Participate in all aspects of system upgrade/test for ETL related tools and processes
Write SQL to achieve objectives (including but not limited to)
drive ETL processes
populate existing datasets
support data validation
Consult with the data modeler and users on the model design specifications and underlying business requirements
Use data modeling tools to develop visual diagrams depicting business process and project requirements
Participate in project plan development and updates
Develop and maintain technical documentation for processes, systems and customizations
Other Functions: Perform other job-related duties and special projects as assigned.
Knowledge, Skills and Abilities: Knowledge of: Enterprise systems, applications, and technical standards; Linux/UNIX operating systems, database productivity tools similar to Oracle Enterprise Manager, SQL, SQL*Plus, PL/SQL, and SQL*Loader; data administration principles and data modeling concepts; technical and vendor documentation and ability to maintain internal documentation; system development life cycle and structured systems development concepts; system capability, design restrictions, and security requirements; client/server technologies, network connectivity, integration, configuration, and protocols. Ability to: apply consultative skills to assess user needs and communicate technology systems and solutions; maintain databases and middleware applications through performance tuning and applying patches/fixes/upgrades; develop program implementation plans, install software, and apply fixes; identify hardware/software interface problems; perform interactive debugging and to test and analyze program failures; use systems work flow and logic flowchart techniques; use project management tools.
Minimum Qualifications: A basic foundation of knowledge and skills in database management, applications packages and programming, systems analysis and related programming support functions is a prerequisite. This foundation would normally be obtained through a bachelors degree, preferably in computer science or business, or equivalent training and applied experience. Working knowledge of industry standard applications programming languages and knowledge of standard systems analysis techniques.
Specialized Skills: Equivalent to a bachelors degree from an accredited college or university in Computer Science or related technical field AND two (2) years experience with integration services are required. Working knowledge and skills in SQL, ETL programming and systems analysis and related programming support functions. Working knowledge of data integration operations support/programming or demonstrated project management in data integration support operations. Additional experience, which has demonstrated the requisite skills/abilities, may be substituted for required education on a year-for-year basis.
Knowledge of ETL programming languages and protocols. Experience creating data sources from enterprise systems and/or other applications. Demonstrated ability to address the essential functions associated with this position including the knowledge and abilities identified above. Exceptional demonstrated working knowledge of SQL, and technical literacy in ETL concepts and processes. Exceptional ability to communicate verbally and in writing in a professional, persuasive, and tactful manner, and establish and maintain cooperative and effective working relationships within a diverse, academic environment.
Preferred Qualifications: Experience working in higher education. Working knowledge of enterprise systems, i.e. Student Administration, Financials, Human Resource, Extended Ed, and/or Data Warehouse systems and development. Additional technical skills including experience with Oracle/PeopleSoft tools, technology and architecture, Experience with ETL tools, data warehouse and data marts as they pertain to business intelligence, knowledge of Oracle Business Intelligence Applications and middleware technologies. Highly desirable: Demonstrated understanding of and commitment to CSUMBsVision.
Special Conditions of Employment: SPECIAL CONDITIONS OF EMPLOYMENT & POSITION DESIGNATIONS:
All offers of employment are contingent upon the successful completion of a background check (including a criminal records check).
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 inCSU Executive Order 1083 as a condition of employment.
This position will have a duty to report to the Campus Title IX Officer information pertaining to victims of sex discrimination, sexual harassment, sexual misconduct, dating/domestic violence, and stalking as required by CSU Executive Order 1095.
This position is required to comply with confidentiality requirements outlined in the Department of Educations Family Educational Rights and Privacy and Californias Educational Code Chapter 13 regarding sensitive student issues.
This position has been designated as a sensitive position with access to and responsibility for detailed personally identifiable Level 1 confidential information about students, faculty, staff or alumni that is protected, personal or sensitive as defined in the CSU Information Security Data Classification Standards
Office environment with standard equipment and tasks. The position requires working at a computer and desk for extended periods of time.
May require travel between campus offices and off-campus locations.
This position has been approved to work remotely and will require execution of CSUMBs current Temporary Remote Agreement, as well as the CSUMB Voluntary Remote Work Agreement when finalized by the campus.
The health and safety of our students, faculty, and staff remain our highest priority. In the fall, students, faculty, staff, and the community can expect that masks will be required and that the appropriate degree of social distancing will be in place in all areas based on evolving guidance. Additionally, all students, faculty, and staff are encouraged to be vaccinated before coming to campus. All community members who work or attend class on campus should expect to participate in a random or periodic testing system. CSUMB will communicate more information about vaccination requirements and testing protocols when the details become available.
Compensation and Benefits: POSITION INFORMATION:
Type of Appointment: Full-Time, Probationary
Collective Bargaining Unit: Clerical & Administrative Support Services (CSUEU)
Anticipated Campus Hiring Salary: Low to mid $6,000s/month
CSUMB offers a premium benefit package that includes outstanding vacation, health, dental & vision plans; a fee waiver education program; membership in the California Public Employees Retirement System (CalPERS); and 14 paid holidays a year. For more information, visit Benefits Summary. Additionally, University Corporation at CSU Monterey Bay provides access to affordable campus housing based on availability, visit: Employee Housing.
For full consideration, applicants must complete the required online application prior to the priority screen date found at csumb.edu/jobs. Application submissions received after the application screening date will be reviewed at the discretion of the University. Materials submitted become the property of CSUMB and will not be returned.
CSUMB is not a sponsoring agency for staff or management positions.
Reasonable accommodations will be provided for qualified applicants with disabilities who self-disclose by contacting University Personnel at (831) 582-3389. For computer/online access you may visit the Tanimura and Antle Family Memorial Library (map). All employees must be eligible for employment in the U.S.
CSUMB hires only individuals lawfully authorized to work in the United States and is an E-Verify employer. 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 State University, Monterey Bay Annual Security and Fire Safety Report is available at: https://csumb.edu/clery
CSUMB 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 email@example.com. CSUMB is a smoke and tobacco-free campus.
AFFIRMATIVE ACTION/EQUAL OPPORTUNITY EMPLOYER:
CSUMB is an Equal Opportunity Affirmative Action employer seeking to recruit and support a broadly diverse community of faculty and staff. We value and celebrate diversity in all its forms and strive to foster an inclusive culture built on respect that affirms inter-group relations and builds cohesion. We consider qualified applicants for employment for their anticipated contributions and without regard to race, color, religion, national origin, age, gender, gender identity or expression, sexual orientation, genetic information, medical condition, pregnancy, marital status, veteran status, or disability.
Copyright 2021 Jobelephant.com Inc. All rights reserved.
California State University Monterey Bay (CSUMB), is a comprehensive public university committed to serving the diverse people of California, especially the working class, historically under-served, and low income populations. The university values an educational environment of cultural and linguistic diversity and gender equity; ethical reflection and practice; effective and experimental use of technologies as resources to people and catalysts for learning; and the integration of cross-disciplinary models enabling students, faculty and staff to engage in innovative instruction and coordinated service learning. The curriculum is organized around student learning outcomes. It is global in perspective, and of sufficient breadth and depth to meet local, regional, and statewide needs, specifically those of both isolated rural communities and inner-city populations. The identity of the University is framed by substantive commitment to a multilingual, multicultural, intellectual community which enables students, faculty and staff to cross institutional boundaries for innovative instruction, broadly defined scholarly and creative activity, and coordinated community service. The campus is located on Monterey Bay, 100 miles south of San Francisco.