Data Services Developer
Data Services Developer
Classification: Analyst Programmer - Career
Department Name: Information Systems
Job Number: MB2021-PD2733
Status: Open Until Filled!Apply Today! Application screening begins on Thursday, July 29, 2021
Priority Screening Date: 07/28/2021
Recruitment Status: Apply Today! Application screening begins on Thursday, July 29, 2021
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.
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 bachelor’s 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.
Equivalent to a bachelor’s 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.
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 CSUMB’sVision.
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 Education’s Family Educational Rights and Privacy and California’s 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.
There are components of this job which are deemed essential on campus. This position will primarily work on the main campus, with occasional work from home. This position requires working on campus with students. 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:
- Type of Appointment: Full-Time, Probationary
- Collective Bargaining Unit: Clerical & Administrative Support Services (CSUEU)
- Anticipated Campus Hiring Salary: Low to mid $6,000’s/month
- CSU Salary Range
- FLSA Status: Exempt
How to Apply:
To apply, visit https://csumb.peopleadmin.com/postings/6466
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.
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.