Data Integration Developer

Data Integration Developer

Job no: 520428
Work type: Staff
Location: Monterey Bay
Categories: Unit 9 - CSUEU - Technical Support Services, Probationary, Full Time, Information Systems & Technology

Classification: Analyst Programmer - Foundation or Career
Anticipated Hiring Salary:

Foundation level Mid to high $4,000's/month

Career level High $6,000's/month

CSU Salary Schedule
Hours: Full-time / 40 hours per week
FLSA: Foundation level - Non Exempt, Career level - Exempt

Priority Screening Date: November 6, 2022
Recruitment Status: Open Until Filled

ABOUT CSUMB

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 a Hispanic Serving Institution (HSI) and has a vibrant, diverse student body of over 7,400 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 Associate Director of Data Integration Services, the incumbent is responsible for data integration development and programmer analyst support, and works in close collaboration with other team members to address the specific needs of the University. The incumbent is responsible for ensuring industry-standards (data modeling, data integrations, programming languages, and architectures) are applied to develop, maintain, and support software and applications. The incumbent will provide application development support for campus solutions and software programs. The incumbent will work closely with project teams during project initiation and planning to determine their needs, define requirements, and understand business processes. The incumbent is expected to ensure that industry-standard methodologies are followed for Software and Systems Development Life Cycles (SDLC) from beginning to end. The incumbent will work closely with project coordinators, managers, and business analysts during project delivery to ensure SDLC efforts follow frameworks such as agile and waterfall. The incumbent is responsible for monitoring engagement applications to ensure operational support is meeting service level objectives, and applies industry-standard approaches in support of IT Service Management (ITSM) for service areas such as but not limited to, incident, problem, change, communication, configuration, and release management.

ESSENTIAL DUTIES AND RESPONSIBILITIES include, but are not limited to, the following:

1. Data Integration

Develops, maintains, and supports data processes and procedures for enterprise systems. This includes all phases of development including analysis, project planning, programming, testing, and documentation. Ensures quality of overall system performance and data quality throughout the initial implementation/integration process. Follows development best practices established by the Enterprise Applications and Data Management groups. Provides analysis and timely support in the resolution of system integration and implementation problems. Assist other IT technical staff and system admins to maintain optimal operation of integration processes and identify/rectify integration processing issues to meet user needs.

Programmer Analyst

Follows and applies administrative and technical design standards for programmer analysts and technical support staff to ensure the optimal performance, reliability, compliance, and maintainability of Engagement Applications. These standards include detailed coding guidelines, style and naming conventions as well as technical policies and procedures. Conducts periodic reviews to verify compliance with standards and addresses any nonconformities. Applies application software and solution updates and patches for standard release management processes for change and configuration management. Oversees change management and code migrations to ensure changes to production environments are tested, documented, reliable, secure, and adhere to both compliance and technical standards. Designs and develops complex reports and custom dashboards to support senior leadership.

Technical Documentation

Develop and maintain documentation which includes (but is not limited to): Technical documentation for integration processes, systems, and customizations. Non-technical documentation for functional stakeholders. Best practices documentation which can help establish development standards.

Application and Software Testing

Coordinate or participate in unit, integration, and end-user testing.

Campus System and Project Support

Collaborates with IT and cross-functional/technical teams in requirements gathering, planning, coordination and implementation of new campus systems and projects.

Other Functions:

Performs other job-related duties and special projects as assigned.

KNOWLEDGE, SKILLS AND ABILITIES:

General knowledge of: Enterprise systems, applications, and standards; structured programming techniques; data administration principles and data modeling concepts; formal data flow analysis methodologies; system/equipment capability, design restrictions, and security requirements; system development life cycle and structured systems development concepts; formal data structure design, relational database design, and file structure; client/server technologies; network configuration, programming, 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; Understanding of technical and vendor documentation and ability to maintain internal documentation. Skill in new systems and programming technologies.

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 workflow 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 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.

SPECIALIZED SKILLS:

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 integration support operations. Additional experience, which has demonstrated the requisite skills/abilities, may be substituted for the required education on a year-for-year basis.

Knowledge of ETL programming languages and protocols. Experience developing integration services, sourcing data 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 Resources, Extended Ed, and/or Data Warehouse systems and development. Additional technical skills including experience with secure server technology and Oracle/PeopleSoft tools, technology and architecture and Salesforce.

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 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 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.
• Must possess and maintain a valid license to drive in the State of California, pass the Defensive Training Class, and be insurable under the University's liability coverage.
• May require occasional evenings and/or weekend work.

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
• control over campus business processes, either through functional roles or system security access

PHYSICAL ENVIRONMENT:

Position requires some travel, mobile work locations, and working at a computer and desk for extended periods of time. This is an exempt position that may require extended or varied hours, including some weekends, and may require travel between campus offices and off-campus locations.

The health and safety of our students, faculty, and staff remain our highest priority. While on campus, students, faculty, staff, and the community will be expected to follow all campus safety mandates.

Per the CSU COVID-19 Vaccination Interim Policy, all students and employees are required to submit their vaccination status to the Otter Vaccination Registry and are encouraged to be vaccinated.

BENEFITS/PERKS:

CSUMB offers a premium benefit package that includes outstanding vacation, health, dental and vision plans; membership in the California Public Employees Retirement System (CalPERS); and 14-paid holidays a year. For more information, visit CSU System Benefits. Additionally, as a perk, the University Corporation at CSU Monterey Bay provides access to affordable campus housing based on availability; visit Schoonover Employee Housing for more information.

APPLICATION PROCEDURE:

For full consideration, applicants must complete the required online application prior to the priority screen date found at Careers at CSUMB. 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 or email universitypersonnel@csumb.edu. All employees must be eligible for employment in the U.S.

GENERAL INFORMATION:

CSUMB hires only individuals lawfully authorized to work in the United States and is an E-Verify employer. In compliance with federal crime awareness and campus security legislation, including the Jeanne Clery Disclosure of Campus Security Policy and Campus Crime Statistics, you can view the notice of availability and access the Cal State University, Monterey Bay annual security and fire safety reports at https://csumb.edu/clery/asr-and-fsr-notices-availability/.

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.



To apply, visit https://careers.csumb.edu/en-us/job/520428/data-integration-developer

jeid-f479d294f85dc944873f44d0506e2ff8