Filter Your Search

Work type

Locations

Central California

Categories

Appointment Type
Bargaining Unit
Job Search Category/Discipline
Time Basis

Current Listings

SQL/Data Integration Developer

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

Classification:   Analyst/Programmer - Career
Anticipated Hiring Salary:   Low to mid $6,000's/month 
CSU Salary Schedule
Hours:  Full-time / 40 hours per week 
FLSA: Exempt

Priority Screening Date:   January 5, 2022
Recruitment Status:   Open Until Filled

ABOUT CSUMB

Powered by an inspiring Founding Vision StatementCalifornia 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 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, implements, 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:

1)  Data Integration Process Development

  • Design and develop new data integration processes using campus ETL tools, or modify existing data integrations to  meet user requirements.
  • Translate development specifications into executable processes to extract the appropriate data from source to target systems.
  • Participate in all aspects of system upgrade/test for integration related tools and processes.

2)  SQL Development

  • Write SQL to achieve objectives (including but not limited to)
    • drive integration processes
    • populate existing datasets
    • support data validation

3)  Data Modeling

  • 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

4)  Documentation

  • Participate in project plan development and updates
  • Develop and maintain technical documentation for processes, systems, customizations, and change control

Other Functions:

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

KNOWLEDGE, SKILLS AND ABILITIES:

Knowledge of: enterprise systems, applications, and technical standards; database productivity tools; data modeling concepts; structured and semi-structured data design; development life cycle and concepts; data integration concepts; programming with awareness of security policies; distributed processing and client/server technologies.

Ability to: maintain internal documentation; apply consultative skills to assess user needs and communicate technology systems and solutions; monitor hardware/software interface for problems; perform interactive debugging to test and analyze program failures; use systems work flow and logic flowchart techniques; use project management tools; design data structures to maximize efficiency and flexibility; use data resource and productivity 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. Working knowledge and skills in SQL, ETL development and related development life-cycle functions. Working knowledge of data integration operations and support. Additional experience, which has demonstrated the requisite skills/abilities may be substituted for required education on a year-for-year basis.

Knowledge of ETL principles and procedures. Experience working with 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. Ability to communicate verbally and in writing in a professional, persuasive, and tactful manner. Ability to establish and maintain cooperative and effective working relationships within a diverse, academic environment.

PREFERRED QUALIFICATIONS:

Experience working in higher education. Working knowledge of enterprise data systems in a university setting (e.g. PeopleSoft, Salesforce). Additional technical skills including experience with data integration platforms (e.g. ODI, Boomi). Experience with data warehousing concepts. Familiarity with Cloud technologies. Knowledge of Linux shell programming.

Highly desirable: Demonstrated understanding of and commitment to CSUMB’s Vision.

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

PHYSICAL ENVIRONMENT:

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. 

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.

BENEFITS: 

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, University Corporation at CSU Monterey Bay provides access to affordable campus housing based on availability; visit 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 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. 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 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 universitypersonnel@csumb.edu.

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.

Advertised: Pacific Standard Time
Applications close:

Back to search results Apply now Refer a friend

Share this:

| More