San Mateo County

Departmental Systems Analyst - Data Cleansing and Migration (20027219)

Information Technology
San Francisco/Peninsula
8/12/2020 at 11:59pm
$101,296.00-$126,630.00 Annually

Please review the special instructions before applying for this job opportunity.


The Office of the Assessor-County Clerk-Recorder and Chief Elections Officer is seeking highly qualified candidates for the position of Departmental Systems Analyst

In general, the Departmental Systems Analyst:

  • Provides subject matter expertise on legacy data conversion and migration of data from various sources like AS/400, MS Access, MySQL, Excel sheets etc.
  • Provides complex analytical support to the maintenance and/or modification of existing systems and development of new systems. 
  • Serves as liaison between business users and information technology staff, vendors and service providers.
  • Performs other related duties as required and/or assigned.

Incumbents in the position of Departmental Systems Analyst (DSA) will have: a general knowledge of both departmental and program operations and information system capabilities, which will enable effective interactions between technical and non-technical staff; the ability to explain and document the needs and requirements of each to the other; and the ability to participate in the development of systems that effectively support department and program operations.

The Office of the Assessor-County Clerk-Recorder and Chief Elections Officer (ACRE) is involved in multiple technology initiatives aimed at replacing legacy systems, upgrading applications, and implementing new technologies.  A major project undertaken by ACRE is the development of a new Assessor Property Assessment System (APAS) based on the Salesforce platform. A second major effort is the cleansing and migrating of legacy data. 

Below are the specific requirements for this DSA position:
Data Cleansing and Migration Project
The DSA will:

  • Work closely with business subject matter experts (SMEs) to analyze the legacy data from various sources and translate/interpret the data to the Vendor team. Legacy data resides in AS/400, MS Access, MS Excel and MySQL.
  • Have a strong understanding of the legacy data and the target data model in order to create data mapping in collaboration with the SMEs and the Vendor.
  • Perform various types of analysis for data extraction and data profiling such as uniqueness analysis, range analysis, etc.
  • Document the detailed Data Cleansing Requirements, Business Rules, Data Rules, and list of standard data values based on the findings from Data Profiling.
  • Devise data cleansing strategies and procedures.
  • Oversee both manual and automated cleansing activities.
  • Test the data extraction, data profiling, and data cleansing process standardization and load process thoroughly to make sure requirements are met.
  • Produce data cleansing results reports and error/exception reports for the business SMEs.
  • Review the error/exception reports and take any necessary actions to correct the data and improve data quality.
  • Develop and implement data migration strategies and processes.
  • Implement Data Governance by incorporating processes, policies, guidelines, and responsibilities for administering Assessor's entire data in compliance with policy and/or regulatory obligations.

The ideal candidate for this position will have:

  • Worked as a Lead Data Analyst and completed at least two (2) medium to large legacy data cleansing and conversion projects.
  • Extensive experience in Data Mapping, Data Cleansing, Data Analysis, Data Testing, Data Validation, Data Flow, Reporting, and Presentation.
  • Technical expertise with data models, database design development, and data profiling techniques.
  • Project management, leadership, initiative, and technical skills including data modelling/analysis/migration experience.
  • A data-oriented personality and an excellent eye for details.
  • Knowledge of data governance standards and principles.

This position is a full-time position, which includes medical, dental, vision, vacation, and holiday benefits and a retirement plan.  



Education and Experience: Any combination of education and experience that would likely provide the required knowledge, skills and abilities is qualifying. A typical way to qualify is: 

  • Education: Equivalent to graduation from a four-year college with major coursework in public administration, business administration, information systems, or a closely related field.
  • Experience: The ideal candidate will have eight (8) to ten (10) years of responsible experience in a position that would provide knowledge of department-specific programs, processes and/or operations, including at least three years of experience in data analysis, modeling, design, and legacy data conversion/migration from various sources.

Knowledge of:

  • Data Architecture and database design.
  • Data Conversion Methodology.
  • Talend Data Management Platform, Microsoft SQL, Microsoft Access, Microsoft Excel, and other MS office products (advanced level).

Special Instructions

Open & Promotional. Anyone may apply.  Current County of San Mateo and County of San Mateo Superior Court of California employees with at least six months (1040 hours) of continuous service in a classified regular, probationary, SEIU or AFSCME represented extra-help, or term position prior to the final filing date will receive five points added to their final passing score on this examination. 

Both the County employment application form and the attached supplemental questionnaire must be completed and submitted for you to be considered for this position.

The examination process will consist of an application screening (weight: pass/fail) based on the candidates' application and responses to the supplemental questions. Candidates who pass the application screening will be invited to a panel interview (weight: 100%).

Application Screening
The application screening will include a careful review of each candidate's employment application. The responses to the supplemental questions will be heavily considered in the screening process. Please provide detailed information, answer the questions completely using proper grammar and English language usage, and communicate clearly and concisely. Those applicants who receive a passing score on the rating of the application materials will be invited to the panel interview.

Panel Interview
The panel interview is a standard component of most Civil Service selection processes. Each candidate will be interviewed individually by a panel of three (or more) subject matter experts. All candidates will be asked the same questions, in the same order, for approximately the same amount of time. Responses to each question will be scored based on pre-determined scoring criteria. Each candidate will receive an overall interview score which will determine that candidate's ranking or placement on the eligible list.

Depending on the number of applicants, an application appraisal of education and experience may be used in place of other examinations, or further evaluation of work experience may be conducted to group applicants by level of qualification. All applicants who meet the minimum qualifications are not guaranteed advancement through any subsequent phase of the examination. All examinations will be given in San Mateo County, California, and applicants must participate at their own expense.

IMPORTANT: Applications for this position will only be accepted online. If you are currently on the County's website, you may click the 'Apply' button. If you are not on the County's website, please go to to apply.

~ Recruitment Schedule ~
Final Filing Date: 
August 12, 2020
Application Screening (tentative): August 12, 2020
Panel Interview (tentative): August 24 and/or 25, 2020

The County of San Mateo is a diverse, inclusive workplace, where employees are valued and respected for their different perspectives, experiences, backgrounds, and contributions. 
We are proud to be an Equal Employment Opportunity Employer.

Analyst: Chet Overstreet (07302020) (Departmental Systems Analyst - V233)

Recruitment Contact

Contact phone: 
Contact email: