Tech Transfer Central

Job Listings


Data Services ETL Developer at California State University, Monterey Bay

 

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 (http://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.

PURPOSE :

Under the general supervision of the Director of IT Compliance and Planning, the Data Services ETL 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 ETL Developer is expected to work 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 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.
  • SQL Development
    • Write SQL to
      • drive ETL processes
      • perform DML on existing datasets
  • Data Modeling
    • 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
  • Documentation
    • Document all work, knowledge base, activities, requirements, coding, processes, etc.
    • Develop and maintain technical documentation for systems and customizations

Other Functions:

  • 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 bachelor’s 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.

Bachelor’s 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.

Highly desirable:

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 (OBIA SIA ) student data warehouse data model, PeopleSoft Campus Solutions database.

Demonstrated understanding of and commitment to CSUMB ’s https://csumb.edu/about/founding-vision-statement.

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 in http://www.calstate.edu/eo/EO-1083.html 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 http://www.calstate.edu/eo/EO-1095-rev-6-23-15.html.
  • 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 https://csumb.edu/it/information-classification-standard?_search=Information+Security+Data+Classification+Standards.
  • 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.

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.

Compensation and Benefits:

POSITION

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 http://www.calstate.edu/hr/benefits/documents/csueu-unit-2-5-7-9-benefits-summary.pdf. Additionally, University Corporation at CSU Monterey Bay provides access to affordable campus housing based on availability; visit https://csumb.edu/corporation/employee-housing for more information.

How to Apply:

To apply, visit https://apptrkr.com/1696633

APPLICATION PROCEDURE :

For full consideration, applicants must complete the required online application prior to the priority screen date found at http://www.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 https://csumb.edu/library/library-hours (https://csumb.edu/library/maps-directions). 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 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. 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.