Data Warehouse Systems Analyst

About the Employer

The Alameda County Office of Education (ACOE) supports students through our mission to provide, promote, and support leadership and service for the success of every child, in every school, every day.

View Job Description

Requirements / Qualifications

THE POSITION: The Data Warehouse Systems Analyst supports the implementation of a countywide database warehouse system and manages the development of data solutions for school districts.

This job reports to the assigned -administrator. LOCATION: 313 W. Winton Ave. Hayward, CA 94544

TYPICAL DUTIES: Leads the development and implementation of ACOE's data governance policies and procedures, communicates best practices with internal and external partners.

Ensures that all ACOE data systems comply with data security guidelines as defined by the organization's data governance policies; establishes a framework for compliance of ACOE data systems with laws, codes, regulations, policies and procedures related to data privacy, protection, and security, including those found in FERPA, HIPAA, and the California Education Code. Designs data concept architecture mapping for the county's districts for integration into the data warehouse. Develops technical policies and specifications for data importing and exporting, database system development, maintenance, backup and recovery.

Research, review, and provide consultation on software to determine feasibility of use. Assure data integrity, referential constraints and procedures for database systems to assure proper operation. Analyze and diagnose database system problems and take appropriate corrective action for resolution.

Maintain network system standards in database system development that optimize system integration and functionality, oversee the daily operation of backups. Interface with system administration and operations staff at all levels to ensure efficient use of database systems. Manages all regular security audits, risk assessments and analyses of ACOE's data systems, researches and responds to suspected and real data security breaches.

In collaboration with other partners, designs and manages complex projects to ensure successful and timely delivery of milestones. Trains selected personnel for the purpose of ensuring their ability to use new and/or existing databases and related software. SEE FULL JOB DESCRIPTION FOR MORE INFORMATION

Comments and Other Information

MINIMUM QUALIFICATIONS: Education: Bachelor's Degree in Computer Science, Information Systems, Data Systems Administration/ or related field, Master's Degree preferred Experience:

Four years of directly related experience in database system administration and design, programming development in a client server environment specializing in data modeling and normalization as well as data warehouse schema design, school district experience strongly preferred Equivalency: Equivalent combination of education and experience. APPLICATION DEADLINE:

Friday, May 31st, 2024 at 11:59 p.m. APPLICATION REQUIREMENTS: The EdJoin Online Application and materials must be received by the final application filling date.

Incomplete or late EdJoin Online Applications will not be accepted. THE FOLLOWING APPLICATION MATERIALS ARE DESIRED: 1. Completed EdJoin Online Application 2.

Resume 3. Cover Letter APPLICATION SCREENING & EXAMINATION PROCESS: A review of the candidates' EdJoin Online Applications to verify possession of minimum qualifications.

Those candidates who complete the EdJoin Online Application and who possess the minimum qualifications for the class will move on to the next step in the examination process. Those invited to participate will be notified via email of the date, time, and place of the examinations. We reserve the right to make changes to the announced examination components.

THE PROCESS IS AS FOLLOWS: 1. Application Review……………………….............................................................................................PASS/FAIL 2. Written Examination*…………………....................................................Weighted 50% (Monday, June 10th, 2024) 3.

Technical Oral Interview*……..............................…................…Weighted 50% (Friday, June 14th, 2024) 4. Final Interview...........................................................................................................(Monday, June 17th, 2024) * Candidates must attain a minimum score of 70% on all scored examinations and this eligibility list is valid for 6 months.

For more information about this position, go to the pdf file here https://edjoinprodstoragewest.blob.core.windows.net/jobdescriptions/33/jobDescription133596742673320524.pdf