Job Description
Under general direction, this role serves as an expert for data integration projects and supports the completion of various data initiatives. Key responsibilities include assisting with all phases of data integration projects, optimizing data integration jobs to ensure efficient and reliable data ingestion from various data sources and working collaboratively with architects, business analysts, and data analysts.
ESSENTIAL DUTIES AND FUNCTIONS
According to Civil Service Commission Rule 109, the duties specified below are representative of the range of duties assigned to this job code/class and are not intended to be an inclusive list; this position may include additional duties as assigned.
- Coordinates and conducts end user sessions to understand the business and document business processes.
- Assists in preparing comprehensive data requirements for data warehousing and data integration efforts.
- Design dimensional models for a data warehouse that supports advanced analytics and reporting ensuring data consistency and scalability.
- Supports with building complex ETL/data integration solutions using Microsoft SSIS or Oracle Data Integrator (ODI) to populate the data warehouse.
- Aids in performing unit testing and regression testing of data integration solutions developed in Microsoft SSIS & ODI.
- Collaborates effectively with data scientists, data analysts and stakeholders to design, implement and optimize data models and data flows for different analytics needs.
- Evaluate and optimize database queries and ETL processes for performance, ensuring timely data delivery and improving data latency.
- Analyzes and develops complex ad hoc data extracts, reports to support decision makers.
- Ensures data results are verified and data issues are debugged.
- Maintains thorough documentation of data architecture, data model and data integration processes.
Qualifications:
Qualifications
1. Education :
a) An associate degree in business administration, public administration, information systems, economics, finance, computer science or a closely related field from an accredited college or university
OR
b) 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 one of the fields above or a closely-related field).
AND
2. Experience : Three (3) years in the information systems field, including system analysis, business process design, development and implementation of business application solutions or IT project management.
** Substitution ** : 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 one of the fields above or a closely related field.
Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree.
Supplemental Information:
Essential duties require the following physical skills and work requirements:
- Some positions may require sufficient strength and coordination for lifting, pushing, pulling and/or carrying the weight of computer equipment.
- May require hand/eye coordination for semi-skilled movements, such as taking apart casings, installing parts and reconnecting computers and for performing data entry.
- May involve extensive VDT exposure.
Note: Applicants who meet the minimum qualifications are not guaranteed to advance through all of the steps in the selection process.
** Applicants must meet the Minimum Qualification requirement by the final filing date unless otherwise noted. **
** DESIRABLE QUALIFICATIONS: **
- Three (3) years of experience with Microsoft SSIS or Oracle Data Integrator (ODI)
- Three (3) years of experience with SQL tuning or Query Optimization
The stated desirable qualifications may be used to identify job finalists at the end of the selection process when candidates are referred for hiring.
VERIFICATION OF EXPERIENCE AND/OR EDUCATION :
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.
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.
Resumes will not be accepted in lieu of a completed City and County of San Francisco application.
Applications completed improperly may be cause for ineligibility, disqualification or may lead to lower scores.
Selection Procedures :
Supplemental Questionnaire Examination (Weight: 100%):
Candidates who meet the Minimum Qualifications will be invited to complete the Supplemental Questionnaire Examination. This exam is designed to measure knowledge, skills and/or abilities in job-related areas which may include but not be limited to: problem-solving skills; a deep understanding of data integration, optimizing data feeds; experience with cloud platforms; prepare technical specifications; produce complex reports, coordinate technical procedures and complex reporting requirements; knowledge of information systems; ability to assist with developing and implementing policies, systems and procedures; ability to identify, analyze and report upon activities, issues, and problems and recommend appropriate solutions; ability to establish and maintain effective working relationships.
Candidate scores on this examination may also be applied to other announcements involving other job titles, when directed by the Human Resources Director.
A passing score must be achieved on the Supplemental Questionnaire Examination in order to continue in the selection process.
Candidate exam responses will be vetted as appropriate using AI use detection software. Evidence of use of AI, plagiarized answers, or falsified information in exam responses will be addressed in accordance with Civil Service Rules related to fraud and cheating.
The above test components are considered standardized and, therefore, test questions and answers are not available for public inspection or review.
After application submission, candidates deemed qualified must complete all subsequent steps to advance in this selection process, which includes the following:
Minimum Qualification Supplemental Questionnaire (MQSQ): Candidates will be required to complete a MQSQ as part of the employment application. This MQSQ is designed to obtain specific information regarding an applicant's experience in relation to the Minimum Qualifications (MQ) for this position. The MQSQ will be used to evaluate if the applicant possesses the required minimum qualifications.
Additional Information
Eligible List/Score Report: A confidential eligible list of applicant names that have passed the civil service examination process will be created, and used for certification purposes only. An examination score report will be established, so applicants can view the ranks, final scores and number of eligible candidates. Applicant information, including names of applicants on the eligible list, shall not be made public unless required by law. However, an eligible list shall be made available for public inspection, upon request, once the eligible list is exhausted or expired and referrals resolved. The eligible list/score report resulting from this civil service examination process is subject to change after adoption (e.g., as a result of appeals), as directed by the Human Resources Director or the Civil Service Commission.
The duration of the eligible list resulting from this examination process will be of six (6) months , and may be extended with the approval of the Human Resources Director.
To find Departments which use this classification, please see
Terms of Announcement and Appeal Rights:
Applicants must be guided solely by the provisions of this announcement, including requirements, time periods and other particulars, except when superseded by federal, state or local laws, rules or regulations. Clerical errors may be corrected by the posting the correction on the Department of Human Resources website at
The terms of this announcement may be appealed under Civil Service Rule 111A.35.1. The standard for the review of such appeals is ‘abuse of discretion’ or ‘no rational basis’ for establishing the position description, the minimum qualifications and/or the certification rule. Appeals must include a written statement of the item(s) being contested and the specific reason(s) why the cited item(s) constitute(s) abuse of discretion by the Human Resources Director. Appeals must be submitted directly to the Executive Officer of the Civil Service Commission within five business days of the announcement issuance date.
Additional Information Regarding Employment with the City and County of San Francisco
- Information About The Hiring Process
- Conviction History
- Employee Benefits Overview
- Equal Employment Opportunity
- Disaster Service Worker
- ADA Accommodation
- Veterans Preference
- Seniority Credit In Promotional Exams
- Right to Work
- Copies of Application Documents
- Diversity Statement
How to Apply
Applications for City and County of San Francisco jobs are only accepted through an online process. Visit and begin the application process.
• Select the “I’m Interested” button and follow instructions on the screen
Applicants may be contacted by email about this recruitment 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, @smartalerts.info, and @smartrecruiters.com).
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.
If you have any questions regarding this recruitment or application process, please contact the exam analyst, Valerie Tieu, by telephone at (415) 557-5031 or by email at
All of your information will be kept confidential according to EEO guidelines.
The City and County of San Francisco encourages women, minorities and persons with disabilities to apply. Applicants will be considered regardless of their sex, race, age, religion, color, national origin, ancestry, physical disability, mental disability, medical condition (associated with cancer, a history of cancer, or genetic characteristics), HIV/AIDS status, genetic information, marital status, sexual orientation, gender, gender identity, gender expression, military and veteran status, or other protected category under the law.
Qualifications 1\. **_Education_** **:** a) An associate degree in business administration, public administration, information systems, economics, finance, computer science or a closely related field from an accredited college or university **OR** b) 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 one of the fields above or a closely-related field). **AND**2\. **_Experience_** **:** Three (3) years in the information systems field, including system analysis, business process design, development and implementation of business application solutions or IT project management. ** _Substitution_** **:** 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 one of the fields above or a closely related field.Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree. **Supplemental Information:** Essential duties require the following physical skills and work requirements: * Some positions may require sufficient strength and coordination for lifting, pushing, pulling and/or carrying the weight of computer equipment. * May require hand/eye coordination for semi-skilled movements, such as taking apart casings, installing parts and reconnecting computers and for performing data entry. * May involve extensive VDT exposure.Note: Applicants who meet the minimum qualifications are not guaranteed to advance through all of the steps in the selection process. ** _**Applicants must meet the Minimum Qualification requirement by the final filing date unless otherwise noted.**_** ** _DESIRABLE QUALIFICATIONS:_** * Three (3) years of experience with Microsoft SSIS or Oracle Data Integrator (ODI) * Three (3) years of experience with SQL tuning or Query OptimizationThe stated desirable qualifications may be used to identify job finalists at the end of the selection process when candidates are referred for hiring. **VERIFICATION OF EXPERIENCE AND/OR EDUCATION** :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.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.Resumes will not be accepted in lieu of a completed City and County of San Francisco application.Applications completed improperly may be cause for ineligibility, disqualification or may lead to lower scores. **Selection Procedures** : **Supplemental Questionnaire Examination (Weight: 100%):**Candidates who meet the Minimum Qualifications will be invited to complete the Supplemental Questionnaire Examination. This exam is designed to measure knowledge, skills and/or abilities in job-related areas which may include but not be limited to: problem-solving skills; a deep understanding of data integration, optimizing data feeds; experience with cloud platforms; prepare technical specifications; produce complex reports, coordinate technical procedures and complex reporting requirements; knowledge of information systems; ability to assist with developing and implementing policies, systems and procedures; ability to identify, analyze and report upon activities, issues, and problems and recommend appropriate solutions; ability to establish and maintain effective working relationships.Candidate scores on this examination may also be applied to other announcements involving other job titles, when directed by the Human Resources Director.A passing score must be achieved on the Supplemental Questionnaire Examination in order to continue in the selection process.Candidate exam responses will be vetted as appropriate using AI use detection software. Evidence of use of AI, plagiarized answers, or falsified information in exam responses will be addressed in accordance with Civil Service Rules related to fraud and cheating.The above test components are considered standardized and, therefore, test questions and answers are not available for public inspection or review.After application submission, candidates deemed qualified must complete all subsequent steps to advance in this selection process, which includes the following: **Minimum Qualification Supplemental Questionnaire (MQSQ):** Candidates will be required to complete a MQSQ as part of the employment application. This MQSQ is designed to obtain specific information regarding an applicant's experience in relation to the Minimum Qualifications (MQ) for this position. The MQSQ will be used to evaluate if the applicant possesses the required minimum qualifications. Additional Information **Eligible List/Score Report:** A confidential eligible list of applicant names that have passed the civil service examination process will be created, and used for certification purposes only. An examination score report will be established, so applicants can view the ranks, final scores and number of eligible candidates. Applicant information, including names of applicants on the eligible list, shall not be made public unless required by law. However, an eligible list shall be made available for public inspection, upon request, once the eligible list is exhausted or expired and referrals resolved. The eligible list/score report resulting from this civil service examination process is subject to change after adoption (e.g., as a result of appeals), as directed by the Human Resources Director or the Civil Service Commission.The duration of the eligible list resulting from this examination process will be of **six (6) months** , and may be extended with the approval of the Human Resources Director.To find Departments which use this classification, please see **Terms of Announcement and Appeal Rights:**Applicants must be guided solely by the provisions of this announcement, including requirements, time periods and other particulars, except when superseded by federal, state or local laws, rules or regulations. Clerical errors may be corrected by the posting the correction on the Department of Human Resources website at terms of this announcement may be appealed under Civil Service Rule 111A.35.1. The standard for the review of such appeals is ‘abuse of discretion’ or ‘no rational basis’ for establishing the position description, the minimum qualifications and/or the certification rule. Appeals must include a written statement of the item(s) being contested and the specific reason(s) why the cited item(s) constitute(s) abuse of discretion by the Human Resources Director. Appeals must be submitted directly to the Executive Officer of the Civil Service Commission within five business days of the announcement issuance date. **Additional Information Regarding Employment with the City and County of San Francisco** * ( _Information About The Hiring Process_)( * ( _Conviction History_)( * ( _Employee Benefits Overview_)( * (_Equal Employment Opportunity_)( * (_Disaster Service Worker_)( * ( _ADA Accommodation_)( * ( _Veterans Preference_)( * ( _Seniority Credit In Promotional Exams_)( * ( _Right to Work_)( * ( _Copies of Application Documents_)( * ( _Diversity Statement_)( **How to Apply**Applications for City and County of San Francisco jobs are **_only_** accepted through an online process. Visit (_ and begin the application process.• Select the “I’m Interested” button and follow instructions on the screenApplicants may be contacted by email about this recruitment 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, @smartalerts.info, and @smartrecruiters.com).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.**If you have any questions regarding this recruitment or application process, please contact the exam analyst, Valerie Tieu, by telephone at (415) 557-5031 or by email at of your information will be kept confidential according to EEO guidelines.The City and County of San Francisco encourages women, minorities and persons with disabilities to apply. Applicants will be considered regardless of their sex, race, age, religion, color, national origin, ancestry, physical disability, mental disability, medical condition (associated with cancer, a history of cancer, or genetic characteristics), HIV/AIDS status, genetic information, marital status, sexual orientation, gender, gender identity, gender expression, military and veteran status, or other protected category under the law.#J-18808-Ljbffr