Job No 523808 Enterprise Data Engineer (523808)

  • California State University (CSU) Bakersfield
  • Bakersfield, California
  • Jan 25, 2023
Full Time Information Technology and Communication Services

Job Description

Description:

CLASSIFICATION TITLE: Analyst/Programmer - Career

UNION CODE: R09

FT/PT: Full-time

PAY PLAN: 12-month

WORKPLACE TYPE: On-site (work in-person at business location)

CSU CLASSIFICATION SALARY RANGE: $4,678 - $11,547

PAY BASIS: Monthly

BENEFITS: CSUB offers a best-in-class benefit package for eligible employees that includes an array of medical plans, choice of dental plans, vision coverage, retirement participation in CalPERS, CSU tuition waiver, up to 24 vacation days per year, sick leave with unlimited accrual, 14 paid holidays per year and more! See our benefits website for additional information.

CANDIDATES ELIGIBLE TO APPLY: Open to all qualified applicants

SPECIAL INSTRUCTIONS TO APPLICANT:

FOR PRIORITY CONSIDERATION, applications must be received by February 7, 2023; however, the position will remain open until filled.

CSU 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 CSU Vaccination Policy [calstate.policystat.com] and questions may be sent to hr@campus.edu .

POSITION PURPOSE: Under the general supervision of the Director of Enterprise Applications, the Enterprise Data Engineer is responsible for developing data management and storage solutions to ensure CSUB data is stored effectively and securely. The duties include building, maintaining, and expanding the campus’ data ecosystem and performing functions around loading, extracting, and transforming data from a myriad of systems to the campus data environments. Additionally, the duties include working with subject matter experts to identify data sources, collaborating with stakeholders to determine their data storage and organizational needs, and using the information to create and maintain data infrastructure to support campus missions.

DUTIES & RESPONSIBILITIES:

Develop and Maintain Data Management and Storage Solutions
  • Act as subject matter expert/specialist in designing, building, and maintaining data warehouse architecture for the
  • University. Stakeholders and report writers rely on incumbent’s expertise in curating data from multiple data sources
  • in order to support the campus’ goals of data driven decision-making.
  • Work with our committees and ITS to develop standards and our metadata for the data ecosystem.
  • Collaborate with campus stakeholders to identify data sources, data definitions, and frequency of updates.
  • Work with campus stakeholders to identify future reporting needs and requirements.
  • Partner with analysts to design optimized SQL queries, enabling scalable reporting with a growing data volume.
  • Partner with data scientists and analysts to design effective data pipelines required for data modeling.
  • Develop solutions to store and retrieve information.
  • Develop integrations to extract, transform, and load data into other storage systems.
  • Design conceptual and logical data models and flowcharts.
  • Provide continual assessment of data systems performance and identification and tuning of problem areas.
  • Monitor applications and make recommendations on upgrades or new functionality.
  • Migrate data from legacy systems to new data store solutions.
  • Leverage CSU provided data lake to augment campus data ecosystem.
  • Research and properly evaluate sources of information to determine possible limitations in reliability or usability.
  • Document current state, future state, and provide recommendations for improvement.

Database Admin & Support
  • Install and configure data storage solutions to ensure functionality.
  • Improve system performance by conducting tests, troubleshooting, and integrating new elements.
  • Define backup procedures and data restoration procedures.

REQUIRED QUALIFICATIONS:

EDUCATION & EXPERIENCE - Bachelor’s degree in computer science, computer information systems, or a related degree. Additional qualifying experience may be substituted for the required education on year-for-year basis. Minimum of 2 years of recent (within 5 years) full-time experience in developing and supporting a data warehouse or other experience directly related to the position.

SKILLS, KNOWLEDGE & ABILITIES (SKA’s) -
  • Regular and reliable attendance is required.
  • Ability to be proactive and understand problems from broad, interactive perspective and can develop solutions that combine information and ideas in new, unprecedented ways.
  • In-depth understanding of data storage structure principles to maximize efficiency and flexibility.
  • Ability to use data resource and productivity tools applicable to the database management system.
  • Ability to work and communicate with users to define and meet data warehousing needs and requirements.
  • Knowledge gathering and analyzing system requirements.
  • Knowledge of data mining and segmentation techniques.
  • Knowledge of RDBMS and cloud-based storage solutions.
  • Knowledge of Azure and/or Amazon data environments (warehousing, storage, reporting).
  • Familiarity with data visualization tools (Amazon, Azure, Tableau, Pyramid Analytics).
  • Proven analytical skills and a problem-solving attitude.
  • Strong math and analytical skills are essential to complete job requirements successfully.
  • Able to compile and organize statistical information retrieved and present findings to management.
  • Experience working with private and sensitive personal information.
  • Confident in decision making and the ability to explain processes or choices as needed.
  • Demonstrated customer service experience requiring a very high level of diplomacy and professionalism.
  • Ability to use tact and diplomacy to effectively handle a broad range of high level and sensitive interpersonal situations with diverse personalities, and to respond appropriately to conflicts and problems.
  • Ability to initiate, establish, and foster communication and teamwork by maintaining a positive, cooperative, productive work atmosphere in the University
  • Ability to establish and maintain effective working relationships within a diverse population and with those from various cultural backgrounds.
  • Excellent communication skills. ability to effectively communicate information in a clear and understandable manner, both verbally and in writing.
  • Thorough knowledge of English grammar, spelling and punctuation.
  • Demonstrated ability to maintain a high degree of confidentiality.
  • Excellent organizational and time management skills with the ability to set own priorities to coordinate multiple assignments with fluctuating and time-sensitive deadlines.
  • Excellent computer skills and competence with a variety of computer applications including word-processing, spreadsheets, databases, on-line systems, Internet as well as online calendaring and email.
  • Working knowledge of or ability to quickly learn University infrastructure, policies, and procedures.

PREFERRED QUALIFICATIONS:
  • Prior work experience with PeopleSoft Campus Solution Applications or data structures.
  • Prior work experience with enterprise level systems.
  • Proven work experience as a Data Engineer.
  • Demonstrated skills in an institutional/educational environment utilizing a customer-oriented and service-centered attitude.

PHYSICAL DEMANDS: SEDENTARY WORK - involves mainly sitting; minimal walking and standing; lifting light weight objects limited to 15 pounds.

ENVIRONMENTAL FACTORS: N/A

SPECIAL CONDITIONS:

SCREENING: Only those applicants possessing experience most directly related to the immediate needs of the office will be invited to appear before a Qualifications Appraisal Board for the purpose of appraising training, experience, and interest in the position.

CALIFORNIA STATE UNIVERSITY EMPLOYEES UNION: It shall be the policy of the CSU in filling vacant CSUEU bargaining Units 2, 5, 7 & 9 positions to fill such vacancies from among qualified individuals currently employed on-campus except when it is determined that it is necessary to appoint outside applicants to meet campus workforce diversity goals or to provide specialized skills and abilities that are not available from current employees.

BACKGROUND CHECK: Satisfactory completion of a background check (including a criminal records check) is required for employment. CSU will make a conditional offer of employment, which may be rescinded if the background check reveals disqualifying information, and/or it is discovered that the candidate knowingly withheld or falsified information. Failure to satisfactorily complete the background check may affect the continued employment of a current CSU employee who was conditionally offered the position.

SENSITIVE POSITION: Sensitive positions are designated by the CSU as requiring heightened scrutiny of individuals holding the position, based on potential for harm to children, concerns for the safety and security of the people, animals, or property, or heightened risk of financial loss to the CSU or individuals in the university community.

MANDATED REPORTER: Not Mandated

GENERAL INFORMATION: It is the policy of California State University, Bakersfield to hire only United States citizens and aliens lawfully authorized to work in the United States. All new employees will be required to present documentation verifying their right to accept employment. You will also be requested to present a social security card at the time of initial appointment in compliance with state payroll regulations. State regulations require that every state employee sign the Oath of Allegiance prior to commencing the duties of his/her State employment, except legally employed non-citizens. These individuals are required to sign the Declaration of Permission to Work.

EEO STATEMENT: California State University, Bakersfield is committed to Equal Employment Opportunity. Applicants will be considered without regard to gender, race, age, color, religion, national origin, sexual orientation, genetic information, marital status, disability or covered veteran status.
Closing Date/Time: Open until filled

Job Address

Bakersfield, California 93311 United States View Map