Data Architect (Analyst/Programmer - Career), Digital Transformation

Data Architect (Analyst/Programmer - Career), Digital Transformation
California State University, San Bernardino


Job No: 524995
Work type: Staff
Categories: Unit 9 - CSUEU - Technical Support Services, Temporary, Full Time, Information Systems & Technology

Job Summary:

Under the indirect supervision of the Digital Transformation Lead and immediate supervision of the Director of Digital Transformation in the Division of Information Technology Services, the Data Architect will assist in the connection to and implementation of API's to access data from multiple campus systems and external sources for use by the Digital Transformation team and other campus entities upon request.

Major duties and responsibilities:

• Assist in the connection to and implementation of API's to access data from multiple campus systems and external sources for use by the Digital Transformation team and other campus entities upon request.
• Assist in the integration of third party systems to function with campus systems.
• Coordinate with programmers to debug, add features, and interact with third-party vendors to implement new changes to university applications including the mobile app.
• Write, design, and implement APIs to pull/push data to other systems on campus, integrate third party systems to function with campus systems, both on premises and cloud-based.
• Work with mySQL, Spring, Java, and related technologies to allow the creation and support of data migrations and transformations.
• Fix bugs, add features and interact with third-party vendors to implement new changes to university web-based applications.
• Design application programs and structures to meet user requirements that optimize the use of available resources.
• Consult with users to identify and document purpose, needs and determine overall functional and technical system requirements and specifications.
• Based on user requirements and needs, select a suitable development methodology and develop succinct, timely programming code, or modify software in a fashion which optimizes programming resources and meets functional user requirements.
• Analyze data requirements, develop and document data dictionaries, and develop data models.
• Design database systems and programs which include access methods, device allocation, validation checks, statistical methods and security.
• Write code and implement functions to meet user specifications, test and debug programs, verify data acquisition, output media, and format.
• Compose documentation, user guides and materials when necessary.
• Perform database, file, and code backup, fine tune application server configurations.
• Structure, implement and maintain database systems to optimize data access and security.
• Maintain and support assigned operating systems and applications to ensure minimal downtime and loss of productivity and service.
• Evaluate and enhance the efficiency of existing programs to meet current and future user needs.
• Upgrades and Training: Implement Application and Support all application upgrades. Train others, troubleshooting and work collaboratively with other divisions at CSUSB.

Minimum Qualifications: Required Education and Experience

• Bachelor's degree, preferably in computer science or business, or equivalent training and applied experience.
• At least 3 years computer programming experience.
• Experience with Java, JSON, XML, mySQL.

Preferred Qualifications:

• Experience with Oracle database and database SQL language.
• Good understanding of version control tools including Bitbucket.
• Experience working in or with higher education.
• Experience developing RESTful API using Java and Spring.
• Familiarity with data format JSON and XML.
• Familiarity with AWS, Docker, Dell Boomi, and Maven.
• Understanding of Intermediate HTML & CSS

Compensation and Benefits:

Anticipated Hiring Range: $4,678 - $5,350 per month

Classification Salary Range: $4,678 - $11,547 per month

The CSU system provides a comprehensive benefit package that includes medical, dental and vision plans, membership in the California Public Employees Retirement System (CalPERS), sick and vacation time, and 14 paid holidays a year. Eligible employees are also able to participate in the fee waiver education program. A summary of benefit information can be found

Job Summary:

Under the indirect supervision of the Digital Transformation Lead and immediate supervision of the Director of Digital Transformation in the Division of Information Technology Services, the Data Architect will assist in the connection to and implementation of API's to access data from multiple campus systems and external sources for use by the Digital Transformation team and other campus entities upon request.

Major duties and responsibilities:

• Assist in the connection to and implementation of API's to access data from multiple campus systems and external sources for use by the Digital Transformation team and other campus entities upon request.
• Assist in the integration of third party systems to function with campus systems.
• Coordinate with programmers to debug, add features, and interact with third-party vendors to implement new changes to university applications including the mobile app.
• Write, design, and implement APIs to pull/push data to other systems on campus, integrate third party systems to function with campus systems, both on premises and cloud-based.
• Work with mySQL, Spring, Java, and related technologies to allow the creation and support of data migrations and transformations.
• Fix bugs, add features and interact with third-party vendors to implement new changes to university web-based applications.
• Design application programs and structures to meet user requirements that optimize the use of available resources.
• Consult with users to identify and document purpose, needs and determine overall functional and technical system requirements and specifications.
• Based on user requirements and needs, select a suitable development methodology and develop succinct, timely programming code, or modify software in a fashion which optimizes programming resources and meets functional user requirements.
• Analyze data requirements, develop and document data dictionaries, and develop data models.
• Design database systems and programs which include access methods, device allocation, validation checks, statistical methods and security.
• Write code and implement functions to meet user specifications, test and debug programs, verify data acquisition, output media, and format.
• Compose documentation, user guides and materials when necessary.
• Perform database, file, and code backup, fine tune application server configurations.
• Structure, implement and maintain database systems to optimize data access and security.
• Maintain and support assigned operating systems and applications to ensure minimal downtime and loss of productivity and service.
• Evaluate and enhance the efficiency of existing programs to meet current and future user needs.
• Upgrades and Training: Implement Application and Support all application upgrades. Train others, troubleshooting and work collaboratively with other divisions at CSUSB.

Minimum Qualifications: Required Education and Experience

• Bachelor's degree, preferably in computer science or business, or equivalent training and applied experience.
• At least 3 years computer programming experience.
• Experience with Java, JSON, XML, mySQL.

Preferred Qualifications:

• Experience with Oracle database and database SQL language.
• Good understanding of version control tools including Bitbucket.
• Experience working in or with higher education.
• Experience developing RESTful API using Java and Spring.
• Familiarity with data format JSON and XML.
• Familiarity with AWS, Docker, Dell Boomi, and Maven.
• Understanding of Intermediate HTML & CSS

Compensation and Benefits:

Anticipated Hiring Range: $4,678 - $5,350 per month

Classification Salary Range: $4,678 - $11,547 per month

The CSU system provides a comprehensive benefit package that includes medical, dental and vision plans, membership in the California Public Employees Retirement System (CalPERS), sick and vacation time, and 14 paid holidays a year. Eligible employees are also able to participate in the fee waiver education program. A summary of benefit information can be found here.

Position Information:

Work status: Full-time/Exempt/Temporary (up to one year with the possibility of further renewal)

Schedule: Monday through Friday from 8:00 am to 5:00 pm, weekends and evenings may be required.

The application deadline is: April 5, 2023

Conditions of Employment

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.

Mandated Reporter

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.

I-9

CSUSB hires only individuals lawfully authorized to work in the United States. In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification form upon hire. See Form I-9 Acceptable Documents at https://www.uscis.gov/i-9-central/form-i-9-acceptable-documents.

COVID-19 Vaccination

CSU requires faculty, staff, and students who physically access campus facilities or programs to be fully vaccinated against COVID-19, which includes obtaining a COVID-19 booster dose, 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. See policy at https://calstate.policystat.com/policy/11030468/latest.

Statement of Commitment to Diversity

In our commitment to the furthering of knowledge and fulfilling our educational mission, California State University, San Bernardino seeks a campus climate that welcomes, celebrates, and promotes respect for the entire variety of human experience. We welcome people from all backgrounds, and we seek to include knowledge and values from many cultures in the curriculum and extra-curricular life of the campus community. We will create, promote, and maintain activities and programs that further our understanding of individual and group diversity. We will also develop and communicate policies and promote values that discourage intolerance and discrimination.

California State University, San Bernardino is proud to be an Affirmative Action/Equal Opportunity Employer. We recruit, hire, train, and administer all personnel actions without regard to race, ethnicity, religion, color, caste, national origin, ancestry, age, sex, gender, gender identity, gender expression, sexual orientation, socioeconomic status, genetic information, medical condition, disability, marital status, protected military or veteran status, or any other status protected by applicable law. This position adheres to CSU policies against Sex Discrimination, Sexual Harassment, and Sexual Violence, including Domestic Violence, Dating Violence, and Stalking. This requires completion of Sexual Violence Prevention Training within 6 months of assuming employment and on a two-year basis thereafter. (Executive Order 1096) For more information about Diversity & Inclusion at CSUSB, please visit https://www.csusb.edu/human-resources/diversity-inclusion

Closing Statement:

Reasonable Accommodation

We provide reasonable accommodations to applicants and employees with disabilities. Applicants with questions about access or requiring a reasonable accommodation for any part of the application or hiring process should contact the Employee & Labor Relations Coordinator by email at KFirstenberg@csusb.edu.

Smoking

CSUSB is a smoke and tobacco-free campus. See policy at https://calstate.policystat.com/policy/6591951/latest/.

Clery Act

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 San Bernardino Annual Security and Fire Safety Report is available at: https://www.csusb.edu/clery-act


To view full description and to apply, visit: https://www.csusb.edu


jeid-2c85457c945bad4eb8e891122b095c04