1054 IS Business Analyst-Principal

Data Migration and Integration Team Lead

Recruitment #PEX-1054-091153



Permanent Exempt (PEX) Appointment

This position is excluded by the Charter from the competitive civil service examination process and shall serve at the discretion of the appointing officer, pursuant to the City & County of San Francisco Charter, Section 10.104.13. Any person occupying a position under exempt appointment shall not be subject to civil service selection, appointment and removal procedures.  This project has an anticipated duration of up to three (3) years. 

The Office of the Assessor-Recorder will be screening applications as they are submitted. This announcement will remain live until the Department determines that a suitable number of applicants have applied. This announcement may close at anytime, but not before Friday, November 2, 2018, at 5pm.

Who We Are

The Office of the Assessor-Recorder is responsible for carrying out property tax-related functions governed by the State Constitution and State and local laws. Our core responsibilities include locating all taxable property in the City and County of San Francisco, identifying ownership, establishing a taxable value, and applying all legal exemptions. Property broadly includes both real property and personal property owned by businesses. The Office of the Assessor-Recorder is also responsible for recording documents and maintaining those public records. Over 400 different types of documents are recorded annually, including deeds of trust, reconveyances, liens, and public marriage licenses. The Office is also responsible for collecting any transfer tax due upon a change in property ownership. The Office of the Assessor-Recorder strives to conduct our work with the core principals of professionalism and integrity. 

What We Do

Heightened activity in the real estate and business markets means increased demand for the work of our office. Every year, property tax revenue remains the largest single source of funding for the City’s General Fund revenue, representing close to $2 Billion in Fiscal Year 2017-18. This revenue funds crucial services like public safety, education, neighborhood improvements, and health and family support services. Through the dedicated work of the Assessor-Recorder staff, the City experienced an 11% increase in the local assessment roll compared to the previous year, representing a cumulative value of over $256 Billion and generating over $3 billion dollars in local revenues. This is due in part to strong growth in the real estate market, additional construction across San Francisco, and our office’s efforts in increasing efficiency. In recent years, we have taken significant steps toward modernizing our operations, including launching a new information management system to create a better, more convenient way of managing our close to 300,000 property files and documents and to safeguard our information. We have also started a multi-year, multi-organization effort aimed at modernizing City-wide property tax systems. Meanwhile, our core values continue to drive our efforts to improve customer service. 

What We Are Looking For

The Office of the Assessor-Recorder currently has one (1) permanent, exempt from civil service position available in class 1054 IS Business Analyst-Principal. This position is a long-term position as the Data Migration and Integration Team Lead assigned to work on the Property Assessment Tax System project, a multi-year project to upgrade our assessment systems and integrate them with the Office of the Treasurer & Tax Collector and City Controller's Office.

About the Position

Recently, the Office of the Assessor-Recorder started a multi-year project to replace our legacy Property Assessment System that manages the City’s $237 billion in assessed property value. The new system will handle all aspects of assessment functions and will be able to integrate with other City systems. As part of the system implementation, the department initiated a Data Cleansing Project to ensure that legacy data will be ready for data migration to the new system and to improve overall data quality that is ultimately used for Property Assessment business functions and operations.

The department is looking for a talented Data Migration and Integration Team Leader to play a key role on leading the data migration and integration effort from our legacy environments/processes to our new system.  This will involve developing plans, analyzing our data challenges and developing and documenting the data cleanup process and potentially executing portions of the data cleanup process.  In addition, you will be responsible for developing plans and specifications for integration with other systems.  You will be working closely with our Subject Matter Experts to understand their business needs and translating their business needs into business and technical specifications to accomplish both the data cleanup and integration process.  You will be responsible for ensuring both the data migration and system integration project milestones task are completed in a timely fashion.  In addition, you will develop strategies to reconcile the data from source to targeted systems.  

The ideal candidate will have prior experience with system migrations and integration, is detail-oriented, methodical, has the technical aptitude to manage large data sets and has experience with reconciling data between systems.  They will look for opportunities to create win/win scenarios and remove potential roadblocks. 

The Job

Under the direction of the Property Assessment Tax System Project Manager, this position will serve as the Data Migration and Integration Team Lead.  This role will drive the new system’s business requirements as well as the department’s business goals to help prioritize and lead the data cleanup, data migration and integration efforts. This role will work alongside the project’s Business Analysts and Subject Matter Expert to assist in the analysis, scoping, testing and implementation of all data cleanup, migration and integration processes.   

The essential functions of this position may include but are not limited to:

1.  Manage and lead the data migration and integration process from our legacy environments/processes to our new system.  This includes overseeing and ensuring delivery of all aspects of data analysis, mapping, migration and integration.

2.  Responsible for ensuring the quality of the migrated data and validity of the migration processes and operation.

3. Responsible for ensuring the quality of the integrated data with other systems.

4. Work with customers in gathering business requirements for data migration and integration needs.

5. Work across multiple functional projects to understand data usage and implications for data migration and integration.

6. Lead the designing, planning and managing the data migration/integration process.

7. Work with Subject Matter Experts and project team to identify, define, collate, document and communicate the data migration and integration requirements.

8. Lead and prepare data migration and integration plans including migration risk, milestones, quality and business sign-off details.

9. Lead and manage assigned risks and monitor potential impacts as part of the data migration and integration plan.

10. Develop best practice, processes, and standards for effectively carrying out data migration and integration activities.

11. Lead the source system data analysis to manage source to target data mapping.

12. Lead and perform migration and testing of static data and transaction data from one core system to another.

13. Manage cross-program data assurance for physical data items in source and target systems.

14. Collect and document data quality requirements and review the data validation metrics.

15. Lead and perform quality assurance review, data migration/integration audit, reconciliation and exception reporting.

16. Perform related duties and responsibilities as assigned.

Minimum Qualifications

These minimum qualifications establish the education, training, experience, special skills and/or license(s) which are required for employment in the classification.  Please note, additional qualifications (i.e., special conditions) may apply to a particular position and will be stated on the exam/job announcement.

An associate degree in computer science or a closely related field from an accredited college or university OR its equivalent in terms of total course credits/units [i.e., at least sixty (60) semester or ninety (90) quarter credits/units with a minimum of twenty (20) semester or thirty (30) quarter credits/units in computer science or a closely-related field].

Five (5) years of experience in the information systems field, including system analysis, business process design, development and implementation of business application solutions or IT project management.

License and Certification:


Additional experience as described above may be substituted for the required degree on a year-for-year basis (up to a maximum of two (2) years). One (1) year is equivalent to thirty (30) semester units / forty-five (45) quarter units with a minimum of 10 semester / 15 quarter units in computer science or a closely related field.

Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. If education verification is required, information on how to verify education requirements, including verifying foreign education credits or degree equivalency, can be found at

Note: Falsifying one’s education, training, or work experience or attempted deception on the application may result in disqualification for this and future job opportunities with the City and County of San Francisco.

How To Apply

Applications for City and County of San Francisco jobs are only accepted through an online process. Visit www.jobaps.com/sf to register an account (if you have not already done so) and begin the application process.

  • Select the desired job announcement
  • Select “Apply” and read and acknowledge the information
  • Select either “I am a New User” if you have not previously registered, or “I have Registered Previously”
  • Follow instructions on the screen

Computers are available for the public (from 8:00 a.m. to 5:00 p.m. Monday through Friday) to file online applications in the lobby of the Dept. of Human Resources at 1 South Van Ness Avenue, 4th Floor, San Francisco.

Applicants may be contacted by email about this announcement and, therefore, it is their responsibility to ensure that their registered email address is accurate and kept up-to-date.  Also, applicants must ensure that email from CCSF is not blocked on their computer by a spam filter.  To prevent blocking, applicants should set up their email to accept CCSF mail from the following addresses (@sfgov.org, @sfdpw.org, @sfport.com, @flysfo.com, @sfwater.org, @sfdph.org, @asianart.org, @sfmta.com, @sfpl.org, @dcyf.org, @first5sf.org, @famsf.org, @ccsf.edu).

Applicants will receive a confirmation email that their online application has been received in response to every announcement for which they file.  Applicants should retain this confirmation email for their records.  Failure to receive this email means that the online application was not submitted or received.

All work experience, education, training and other information substantiating how you meet the minimum qualifications must be included on your application by the filing deadline.  Information submitted after the filing deadline will not be considered in determining whether you meet the minimum qualifications.

Applications completed improperly may be cause for ineligibility, disqualification or may lead to lower scores.

If you have any questions regarding this recruitment or application process, please contact the exam analyst, Gerald Buss, by telephone at 415.554.5213, or by email at Gerald.buss@sfgov.org.


Selection Procedures

Selection Procedures

Applications will be screened for relevant qualifying experience. Additional screening mechanisms may be implemented in order to determine candidates’ qualifications. Only those applicants who most closely meet the needs of the Office of the Assessor-Recorder will be invited to participate in the selection process. Applicants meeting the minimum qualifications are not guaranteed advancement to the interview.

Conviction History

As a finalist for a job, you will be fingerprinted, and your fingerprints will be sent to the California Department of Justice (DOJ) and the Federal Bureau of Investigation (FBI). The resulting report of your conviction history (if any) will be used to determine whether the nature of your conviction (or arrest, in limited circumstances) conflicts with the specific duties and responsibilities of the job for which you are a finalist. If a conflict exists, you will be asked to present any evidence of rehabilitation that may mitigate the conflict, except when federal or state regulations bar employment in specific circumstances, such as:

  • Candidates for positions with the Unified School District and the Community College District may be disqualified from consideration should their conviction history not meet the standards established under the California Education Code.
  • Candidates for positions with the Recreation and Park Department may be disqualified from consideration should their conviction history not meet the standards established under California Public Resources Code 5164.

Having a conviction history does not automatically preclude you from a job with the City.

If you are selected as a finalist, the hiring department will contact you to schedule a fingerprinting appointment.

Disaster Service Workers

All City and County of San Francisco employees are designated Disaster Service Workers through state and local law (California Government Code Section 3100-3109). Employment with the City requires the affirmation of a loyalty oath to this effect. Employees are required to complete all Disaster Service Worker-related training as assigned, and to return to work as ordered in the event of an emergency.


General Information concerning City and County of San Francisco Employment Policies and Procedures:
Important Employment Information for the City and County of San Francisco can be obtained at http://sfdhr.org/information-about-hiring-process or hard copy at 1 South Van Ness Avenue, 4th Floor.

Copies of Application Documents:
Applicants should keep copies of all documents submitted, as these will not be returned.

Right to Work:
All persons entering the City and County of San Francisco workforce are required to provide verification of authorization to work in the United States.

Applicants with disabilities who meet the minimum eligibility requirements for this job announcement can find information on requesting a reasonable ADA Accommodation at: 

Exam Type:  Exempt
Issued:  October 18, 2018
Micki  Callahan
Human Resources Director
Department of Human Resources
Recruitment ID Number: PEX-1054-091153


All employees hired on or after January 10, 2009 will be required (pursuant to San Francisco Charter Section A8.432) to contribute 2% of pre-tax compensation to fund retiree healthcare. In addition, most employees are required to make a member contribution towards retirement, ranging from 7.5%-13.25% of compensation. For more information on these provisions, please contact the personnel office of the hiring agency.

For more information about benefits, please click here.


Powered by JobAps