DATA WAREHOUSE RESEARCH ANALYST

Position Information

In addition to the salary, this position qualifies for the choice of one of the District’s excellent Health Benefits and Welfare plans, which the premium cost is 100% paid by the District for the employee and their eligible dependents, and one health plan costing an estimated $60,000 for the District for fiscal year 2025-2026. We offer two medical plans (Anthem Blue Cross [PPO] and Kaiser Permanente (HMO]); dental (Delta Dental PPO); vision (VSP Choice); life insurance for the employee (The Lincoln); life insurance for eligible dependents (The Lincoln); a long- term disability/income protection plan (The Lincoln); and an employee assistance plan (Anthem EAP).

In addition, the District contributes an additional 26.81% of the employee’s salary towards an eligible employee’s pension (CalPERS).

Employees may also elect to participate in optional plans including purchasing additional life insurance for themselves and their eligible dependent(s); enroll in a medical, transportation, and/or dependent care Flexible Spending Account(s) (with the $4 monthly administrative fee paid by the District); and set pre-taxed dollars aside to supplement their pension in a 403b (tax shelter annuity) and/or a 457 (deferred compensation) plan(s).

Classified employees also earn 10 to 22 days per year of vacation (based on years of service), and up to 12 sick leave days (pro-rated for less than full-time positions). There are currently 20 paid holidays.

POSITION SUMMARY

The Data Warehouse Research Analyst reports to the Executive Director, Institutional Effectiveness and Education Services at the District Office. The work schedule is 12 months per year; Monday – Friday; 8:00 a.m. to 5:00 p.m.

This position is represented by the California School Employees Association (CSEA), Chapter 363.

POSITION PURPOSE

Under the direction of an assigned administrator, the Data Warehouse Research Analyst is responsible for organizing, designing and assisting in the coordination and implementation of a comprehensive institutional research program with the emphasis of providing support for its data management and quality assurance programs. The Data Warehouse Research Analyst leads and creates comprehensive sets of data reports to be used by district staff for self-service or customized reporting; supports the development and maintenance of the data warehouse and strategic district planning process; and conducts complex data warehouse queries, analysis and research to support decision-making, budgeting, enrollment management and program reviews. This position works as a lead in planning, implementation and maintenance of comprehensive data warehouse/data quality assurance programs, as well as vendor management and user support.

KEY DUTIES AND RESPONSIBILITIES

1. Work as Subject Matter Expert in the design, development and maintenance of a comprehensive institutional research data warehouse for research, decision-making, assessment, reporting and planning purposes.

2. Serve in a lead role in data warehouse planning: work with users to gather requirements, apply data regulations as determined by governmental/agency data definitions and requirements, collaborate with data stewards and other data sources to validate data elements and performance, and coordinate with ITSS, stakeholders, users, and vendors to maintain quality data warehouse.

3. Develop, maintain, and publish data protocols, procedures, standards and definitions for data warehouse elements; facilitate review and definition of student data warehouse functional areas, business and data process, flow of data between systems.

4. Develop and implement quality assurance protocols, procedures and practices for ensuring the accuracy of all district data and reports related to the test and production databases; provide user-friendly data glossaries, data definition and user support/training.

5. Support efforts to ensure accuracy and integrity of data and systems; monitor data for compliance with deferral and state r