Research Associate/Programmer Analyst (2 Positions) (500746)

  • Cal State University (CSU) San Jose
  • San Jose, California
  • Sep 28, 2021
Full Time Administrative Analysis and Research Information Technology and Communication Services

Job Description


Job Summary

The Research Associate/Programmer Analyst supports a wide variety of data management and analytics and evaluation projects in the Office of Institutional Research. The position develops data governance policies and analytical support to campus constituents for institutional reporting, ad hoc and ongoing studies, and requests for complex research projects. This position also collaborates with IT and other internal partners for data migration, integration, and governance across multiple data sources. The incumbent manages projects largely independently and may help coordinate the efforts of the Institutional Effectiveness and Strategic Analytics Unit including IR support staff such as programmers, institutional research technicians, and student assistants. The position is responsible for maintaining the accuracy and usability of data delivered to stakeholders including evaluative reports to inform decision-making.

Key Responsibilities
  • Communicate with IR and campus stakeholders making data requests and advise them about available data and the best uses of the data to meet their needs
  • Learn about IR data sources (e.g. ERS, APDB), operations, and processes.
  • Effectively use IR data sources to perform data operations on ERS and APDB for Chancellor's Office and university-wide reporting as needed
  • Write queries, develop data management logic, integrate data sources, and build cleaned, standardized data sets for use in analyses and reports
  • As needed, analyze data for outcomes and conclusions related to the data request including conducting evaluation studies as deemed appropriate
  • On request, run relevant general statistical analyses related to the data request
  • Perform quality checks on own work and the work of other contributors when applicable
  • Leverage data visualization skills to develop user-friendly reports to communicate key trends related to business questions and strategic initiatives
  • Develop systematic reporting capabilities, documentation, and web-based sites related to institutional effectiveness
  • Coordinate special studies assigned by the Vice Provost for Institutional Effectiveness and Strategic Analytics or designate
  • Responsible for data processes including data definitions, operations, tools, strategy, etc. that ensure data usability, integrity, and consistency across different content areas
  • Manage the accessibility of institutional data in the IR databases
  • Create and make accessible relevant dictionaries and specifications of institutional data to be collected and maintained
  • Contribute relevant information to the data governance policies to ensure appropriate access and use of data
  • Provide documentation, user supports, and technical manuals for data access
  • Update or create new data elements to meet on-going reporting needs.
  • Monitor data quality and ensure data validity
  • Troubleshoot data issues, identify solutions, fix errors, and reconcile discrepancies across different data sources
  • Cross-functional collaborations with IT and internal partners for data migration, integration, and developing as well as implementing data governance policies of the Campus Data Warehouse (CDW)
  • Engage in complex data compilation, predictive modeling, statistics, and trend analysis activities in support of Institutional Research project goals and constituent functional needs
  • Proficient understanding of qualitative research design to support various studies that generate appropriate outcomes and produce meaningful reports to share
  • Conduct, coordinate research activities that may require analysis of multiple factors or data sources
  • Prepare oral and written informative, comprehensible, and formatted reports of research findings and make presentations to facilitate the interpretation of data to key campus constituencies, on request and proactively

Knowledge, Skills & Abilities
  • Comprehensive knowledge of database management systems and skilled programming abilities in SQL or other data query languages
  • Proficient with Tableau and other BI tools. Experience with writing scripts to create reports with a detail-oriented approach to data visualization
  • Comprehensive knowledge of and demonstrated technical proficiency in online reporting, web development, and content management
  • Comprehensive knowledge of and demonstrated technical proficiency in client-server management and general knowledge of network operating system and network architectures, configuration, and protocols in both hardware and software applications
  • Ability to design, develop and maintain online reporting applications and unit-level and department-level websites in order to provide statistical and analytical reports to support internal management needs as well as for Federal and State reporting requirements
  • Detailed knowledge of campus data sources and definitions, including ERS census extracts and PeopleSoft sources
  • Ability to apply general statistical techniques, such as tests of difference and association (e.g., t-tests, ANOVA, correlation, regression)
  • General knowledge of SPSS, SAS, Stata, and/or R to perform basic statistical analyses
  • Thorough knowledge of the techniques and treatment of data such as simple correlation methods, trend analysis, frequency distribution analysis, sampling techniques, hypothesis testing, and methods of interval estimation familiarity with the principles of personnel management and effective supervision and ability to direct the work of others
  • Capable of working independently on complex assignments, collaborating with others, and making judgments about priorities
  • Ability to perform data management and stewardship to obtain desired results
  • Demonstrated ability to design application programs to meet user requirements optimizing the use of available resources
  • Demonstrated ability to determine overall functional and technical system requirements and specifications using structured design analysis techniques
  • Demonstrated ability to plan, organize, and direct the work of assigned projects, and manage multiple projects simultaneously
  • Ability to plan, organize and conduct system studies, prepare clear and concise reports
  • Ability to exercise initiative, flexibility, good judgment and discretion, and work well independently and as part of a team
  • Ability to maintain confidentiality and appropriately handle sensitive communications with employees and external agencies
  • Strong oral and written communication skills
  • Excellent customer service and public relations skills
  • Ability to manage concurrent projects and activities with a high degree of quality and data accuracy
  • Thorough knowledge of quantitative and qualitative research techniques, including the planning of studies and investigations, the determining of variables, and the developing of reference materials
  • Thorough knowledge of research methodologies and designs
  • General knowledge of machine tabulation techniques and the programming of data
  • Ability to produce tables and graphical analytic outcomes in Tableau or other visualization tools
  • Ability to accurately compile custom data sets
  • Ability to produce qualitative data that is digestible and consumable to the client
  • Ability to document and replicate data processes
  • Ability to produce well-formatted, easy-to-read data reports and extracts
  • Knowledge of FERPA and other relevant data privacy policies and practices
  • Knowledge of relevant human subjects research standards, including when the SJSU IRB should be involved
  • Organizational and planning skills with attention to detail and follow-through
  • Ability to reason logically and capacity for independent and creative thinking on research problems
  • Ability to develop techniques for handling a large variety of detailed data and ability to analyze these data
  • Ability to analyze situations accurately and to adopt an effective course of action

Required Qualifications
  • Equivalent to graduation from a four-year college or university. Additional qualifying professional experience may be substituted for the required education on a year-for-year basis.
  • Three years of progressively responsible technical research or statistical experience including or supplemented by one year in the interpretation and graphic presentation of data. Graduate study in the social sciences, economics, mathematics, statistics, public or business administration or engineering may be substituted for the required experience on a year-for-year basis.

Preferred Qualifications
  • Master's Degree in education, social sciences, economics, mathematics, statistics, public or business administration, computer or data science, or other related fields
  • Five or more years of experience in applying research design and data analytics or business intelligence models
  • Experience in understanding, manipulating, and querying large quantitative and qualitative data sets with complex file structure, and explaining complex data and research issues to technical and non-technical audiences
  • Advanced experience with SQL, Python, R, SAS, Stata, or SPSS
  • Expert experience in Tableau and qualitative software such as NVivo or the like


Classification: Research Technician III
Anticipated Hiring Range: $4,476/month - $5,400/month
Salary Range: $4,476/month - $8,097/month

San José State University offers employees a comprehensive benefits package typically worth 30-35% of your base salary. For more information on programs available, please see the Employee Benefits Summary.

Application Procedure

Click Apply Now to complete the SJSU Online Employment Application and attach the following documents:
  • Resume
  • Letter of Interest

All applicants must apply within the specified application period: May 25, 2021 through June 15, 2021. Application Screening Date Extended to August 1, 2021. This position is open until filled; however, applications received after screening has begun will be considered at the discretion of the university.

Contact Information

University Personnel

Additional Information

Satisfactory completion of a background check (including a criminal records check) is required for employment. SJSU will issue a contingent offer of employment to the selected candidate, 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 offered the position on a contingent basis.

The standard background check includes: criminal check, employment and education verification. Depending on the position, a motor vehicle and/or credit check may be required. All background checks are conducted through the university's third party vendor, Accurate Background. Some positions may also require fingerprinting. SJSU will pay all costs associated with this procedure. Evidence of required degree(s) or certification(s) will be required at time of hire.


All San José State University employees are considered mandated reporters under the California Child Abuse and Neglect Reporting Act and are required to comply with the requirements set forth in CSU Executive Order 1083 as a condition of employment.

Equal Employment Statement

San José State University (SJSU) is an Equal Opportunity/Affirmative Action employer committed to nondiscrimination on the basis of age, ancestry, citizenship status, color, creed, disability, ethnicity, gender, genetic information, marital status, medical condition, national origin, race, religion or lack thereof, sex, sexual orientation, transgender, or protected veteran status consistent with applicable federal and state laws. This policy applies to all SJSU students, faculty and staff programs and activities. Title IX of the Education Amendments of 1972, and certain other federal and state laws, prohibit discrimination on the basis of sex in all education programs and activities operated by the university (both on and off campus).

Closing Date/Time: Open until filled

Job Address

San Jose, California United States View Map