Classification: Analyst/Programmer - Career Department Name: IT Planning & Compliance Job Number: MB2019-PD2572 Status: Extended Priority Screening Date: Recruitment Status: Open until filled. 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 (www.csumb.edu) is a comprehensive, mid-sized four-year university whose staff and faculty help transform student lives by emphasizing project-based learning, requiring service learning, and promoting multicultural and global perspectives on and beyond the campus community. CSUMB is both an MSI and HSI and has a vibrant, diverse student body of nearly 7,000 students and growing. Our faculty and staff, many of whom live in campus housing, appreciate living and working about one mile from the shores of the beautiful Monterey Bay.
As one of the 23 campuses in the California State University (CSU) system, we offer excellent benefits, including housing, and competitive salaries for our faculty and staff. During our 25th Silver Anniversary Celebration in 2019-20, we will complete two major building projects: the College of Arts, Humanities and Social Sciences and the Student Union. By 2030, CSUMB's sustainability initiative is to be carbon neutral.
Under the general supervision of the Director of IT Compliance and Planning, the SQL Developer will work closely with the Data Modeler, DBAs, other Data Services Developers, and campus staff to build processes that move data to populate the student data warehouse, other campus, third party, or cloud systems. The Data Services developer designs, tests and develops using ETL tools (such as Oracle Data Integrator (ODI) and/or Dell Boomi), documents ETL processes, and helps develop and maintain the campus business and data models. The SQL Developer is expected to work independently on assigned tasks in close collaboration with other technical and functional members of the Data Services team.
ESSENTIALDUTIESANDRESPONSIBILITIES include, but are not limited to, the following:
ETL Process Development
Design and develop new ETL code or modify existing ETL to meet user requirements using campus ETL tools (such as ODI and Dell Boomi)
Translate specifications into ETL to extract the appropriate data from the source systems into the data warehouse physical model
Participate in all aspects of system upgrades and test for ETL related tools and applications.
Write SQL to
drive ETL processes
perform DML on existing datasets
Consult with the data modeler and users on the model design specifications and underlying business requirements
Support the principal data modeler using data modeling tools (erwin, Visio) to develop visual diagrams depicting project requirement
Document all work, knowledge base, activities, requirements, coding, processes, etc.
Develop and maintain technical documentation for systems and customizations
Collaborate with other campus technical staff and developers as needed.
Perform other job-related duties and special projects as assigned.
Knowledge, Skills and Abilities: Knowledge of system development life cycle and structured systems development concepts; formal data flow analysis methodologies; campus-defined systems, applications, and standards; system capability, design restrictions, and security requirements. Familiarity with client/server technologies, network connectivity, integration, configuration, and protocols. Understanding of Data Warehouse systems, applications, and technical standards; and the ETL processes and relational databases.
Abilities: Consult with both technical and non-technical users to identify and document software/system purpose, work flow issues, output needs and to determine overall functional and technical system requirements and specifications; use systems work flow and logic flowchart techniques; apply and use operations analysis and structured design analysis techniques; identify hardware/software interface problems; to communicate effectively; prepare requests for proposals, and conduct feasibility studies; use project management tools; work with users to test and debug programs, to write documentation to provide user support for new or modified programs and production/operation procedures.
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 bachelors degree, preferably in computer science or business, or equivalent training and applied experience. Foundation knowledge and skills for the Analyst/ Programmer may include working knowledge of a specific industry standard applications programming language and knowledge of standard systems analysis techniques.
Specialized Skills: Proficiency with SQL. ETL training, and hands-on experience with at least one ETL tool (such as ODI and/or Dell Boomi). Familiarity with entity relationship diagrams and star schemas such as used for data warehousing data modeling. Experience with at least one industry standard object-oriented programming language. Experience with technical and vendor documentation and ability to maintain internal documentation.
Ability to work within a team or independently, demonstrating strong personal initiative and ability to work reliably with minimal supervision and to communicate and collaborate with faculty, staff, administrators, students, and members of the community in one-on-one or group settings.
Excellent documentation skills. Highly organized. Detail oriented.Self-motivated and able to work independently. Willing to accept responsibility and take a lead role in assigned projects and tasks.
Preferred Qualifications: Experience with OLAP tools, ETL tools and strategies, data warehouse and data marts as they pertain to business intelligence. Knowledge of Oracle Business Intelligence Applications and middleware technologies. Experience with Oracle/PeopleSoft tools, technology and architecture.
Experience working with DBAs and Data Modelers as part of a team. Experience working with large data models or data sets for the purposes of data manipulation, restructuring, cleansing, etc. Data Warehousing knowledge, training, and experience.
Experience with university business and IT functions handling enterprise data (student data focus). Experience with Microsoft Office Professional Suite, and Google mail and calendaring programs. Familiarity with Salesforce.
Bachelors degree in educational technology, computer science, information systems, education (or related field) AND three years of experience in systems analysis and application development. Experience working in higher education.
Experience with the following Tools: Dell Boomi and Salesforce, Oracle Data Integrator (ODI), Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Business Intelligence Applications Student Information Analytics (OBIASIA) student data warehouse data model, PeopleSoft Campus Solutions database.
Special Conditions of Employment: SPECIALCONDITIONS OF EMPLOYMENT & POSITIONDESIGNATIONS:
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 in CSU 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 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.
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.
Must possess and maintain a valid license to drive in the State of California, pass the Defensive Training Class, and be insurable under the Universitys liability coverage.
Office environment with standard equipment and tasks. Position requires working at a computer and desk for extended periods of time. May require travel between campus offices and off-campus locations.
Compensation and Benefits: POSITION
Type of Appointment: Full-time, probationary
Collective Bargaining Unit: Technical & Support Services (CSUEU)
Anticipated Campus Hiring Salary: Mid- to high-$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 CSU Benefits R09. Additionally, University Corporation at CSU Monterey Bay provides access to affordable campus housing based on availability; visit Employee Housing for more information.
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 is a smoke and tobacco-free campus.
CSUMB is an Equal Opportunity Affirmative Action employer. We consider qualified applicants for employment 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 2017 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.
University Home Page
Employment Opportunities Web Page
See how we're Doing What Matters! at Cal State Monterey Bay!