1823 Senior Administrative Analyst (Data Analyst)
|Date Opened||2/11/2020 4:30:00 PM|
|Filing Deadline||2/26/2020 5:00:00 PM|
|Salary||$47.16 - $57.31/hour; $8,175.00 - $9,934.00/month; $98,098.00 - $119,210.00/year|
|Job Type||Permanent PBT|
Amended to update Selection Procedures.
The City and County of San Francisco is a consolidated City and County, the only such consolidation in the State of California. The Mayor is also the County Executive and the County Board of Supervisors also acts as the City Council. Because of its unique status, the government of San Francisco exercises jurisdiction over property that would otherwise be located outside of its corporation limit and manages county welfare, health and justice functions under its city government.
José Cisneros is the elected Treasurer for the City and County of San Francisco. As Treasurer, he serves as the City’s banker and Chief Investment Officer, managing all tax and revenue collection for San Francisco. Appointed in 2004, and first elected in 2005, Cisneros has used his experience in the tech and banking industries to enhance and modernize taxpayer systems and successfully manage the City’s portfolio through a major recession.
- Facilitate voluntary compliance with the tax laws of the City and County of San Francisco by simplifying all processes and procedures and by providing efficient customer service.
- Collect all taxes and fees due and owing to the City.
- Conserve all City funds, prudently investing the monies to achieve low risk, high liquidity and market yield,
- Promote social responsibility with paperless eco-friendly solutions for the shared environment, and advocate financial empowerment and justice for our community.
Under the supervision and direction of the Office of the Treasurer & Tax Collector’s Compliance Director, the Senior Administrative Analyst (Data Analyst) is responsible for analyzing tax filings and coordinating compliance campaigns for business taxes and third-party taxes, including the gross receipts tax, payroll expense tax, business registration fees, transient occupancy tax, and parking tax. Compliance campaigns shall include: identifying taxpayers that are potentially underreporting or failing to report taxes using data analysis; communicating with identified businesses, including responding to follow-up questions by email, phone, or in person; triaging and referring taxpayers to departmental investigators and/or auditors for additional investigation or audit. The Data Analyst will maintain databases of tax filings and other sources developed by the department. The Data Analyst will supervise Management Assistants.
- Research & Data Analysis Expertise: Conducts complex research design and analyzes a variety of data related to taxpayers; leads and serves as Subject Matter Expert (SME) on data analytics, metrics, and methodology for Business Taxpayer Compliance; analyzes tax filings and coordinates compliance campaigns for business taxes and third-party taxes, including but not limited to the gross receipts tax, payroll expense tax, business registration fees, transient occupancy tax, and parking tax; summarizes analysis results; prepares complex reports and depictions of analysis results; makes recommendations to design new tax compliance research; directs and manages research efforts and recommends next steps.
- Coordinating & Directing Work: Works with Compliance Director to determine compliance campaign actions and strategy; coordinates and conducts meetings with auditors, investigators, and technical staff; coordinates and directs the work of Management Assistants to complete work related to complex financial and compliance program activities, including data entry, administration and maintenance of databases, and payment processing; supervises staff; monitors and evaluates staff performance.
1. Possession of a graduate degree (Master's degree or higher) from an accredited college or university and three (3) years of full-time equivalent experience performing professional level analytical work as described in Note A: OR
2. Possession of a graduate degree (Master's degree or higher) from an accredited college or university with major college coursework as described in Note B and two (2) years full-time equivalent experience performing professional level analytical work as described in Note A; OR
3. Possession of a baccalaureate degree from an accredited college or university and four (4) years full-time equivalent experience performing professional level analytical work as described in Note A; OR
4. Possession of a baccalaureate degree from an accredited college or university with major college coursework as described in Note B and three (3) years full-time equivalent performing professional level analytical work as described in Note A
SUBSTITUTION: Applicants may substitute up to 2 years of the required education with additional qualifying experience in budget analysis, financial analysis and reporting, legislative/policy analysis, or contract/grant administration. One year (2000 hours) of additional qualifying experience will be considered equivalent to 30 semester units/45 quarter units.
Notes on Qualifying Experience and Education:
A. Qualifying professional-level analytical experience must be in one or more of the following functional areas: complex budget analysis, development and administration; complex financial/fiscal analysis and reporting; development of complex contracting systems and administration of competitive bid processes and complex contractual agreements; development and evaluation of complex management/administrative policy; complex grant administration and monitoring; complex program evaluation and planning; complex legislative analysis; complex economic analysis; or other functional areas related to the duties of positions in Class 1823, where the primary focus of the job is complex professional-level analysis for evaluation, recommendation, development and implementation of major programs and functions of department/organization. Analytical experience equivalent to the duties of Class 1822 is considered qualifying.
B. Coursework applicable to a baccalaureate or higher degree in specialized subject matter areas such as public or business administration, management, business law, contract law, public policy, urban studies, economics, statistical analysis, finance, accounting or other fields of study closely related to the essential functions of positions in Class 1823.
The ideal candidate will be experienced and have demonstrated success with the following:
- Excellent analytical skills - data analytics and business intelligence.
- Knowledge of Excel pivot tables, SQL, and other statistical software, relational databases, scripting to work with large data sets
- Experience making business recommendations, optimizing solutions/improvements
- Experience managing projects; strategizing, leading data analysis and research projects
- Skilled at critical thinking, innovative and creative ideas
- Experience supervising and actively engaging with functionally diverse staff; teamwork and collaboration.
The stated desirable qualifications may be used to identify job finalists at the end of the selection process when candidates are referred for hiring.
How To Apply
Applications for City and County of San Francisco jobs are being 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. A video on “how to apply” can be found here: http://sfdhr.org/node/1178
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).
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 Joni Kuroyama at (415) 554-4475, or via email at firstname.lastname@example.org.
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 http://sfdhr.org/index.aspx?page=456
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.
Applicants must upload their resume during the online application process.
Minimum Qualification Supplemental Questionnaire (Weight: Qualifying):
Candidates will be prompted to complete a Supplemental Questionnaire as part of the online employment application. This Supplemental Questionnaire is designed to obtain specific information regarding an applicant's experience in relation to the Minimum Qualifications for this position. Applicants must also complete the official application. It is essential that applicants provide complete information in identifying their education, experience and training. The Supplemental Questionnaire will be used to evaluate if the applicant possesses the required minimum qualifications.
The examination process shall consist of the following listed below:
SUPPLEMENTAL QUESTIONNAIRE EVALUATION (Weight 50%):
Candidates will be required to complete a supplemental questionnaire at the time of application. However, only those candidates who pass the Written Multiple-Choice Core Examination will receive a score for their Supplemental Questionnaire responses.
The Supplemental Questionnaire Evaluation is designed to measure knowledge, skills and/or abilities in job-related areas which may include but not be limited to: Ability to direct the use appropriate qualitative and quantitative analytical methods, tools, technology to analyze and evaluate data; conduct complex research, statistics, metrics; strategize, lead and manage research and analysis projects; coordinate, work effectively with personnel at all levels and the public, establish cooperative relationships, often in stressful situations; ability to write in a clear, concise and effective manner to make recommendations and depictions via papers, reports, charts, graphs and presentations; compose reports and correspondence, document procedures, policies, guidelines, and business requirements.
WRITTEN CORE EXAMINATION (Weight 50%):
Candidates will be invited to participate in a written, multiple-choice examination, designed to measure their relative knowledge, skills and abilities in job-related areas. The "core" multiple-choice examination component may include but not be limited to:
- Ability to evaluate/analyze information/data and to exercise good judgment relative to that evaluation or analysis. Ability to communicate written information (includes ability to proofread).
- Knowledge of, and ability to apply, financial/fiscal principles (including the ability to use mathematical and statistical formulas).
- Ability to comprehend and understand written information.
- Ability to use various computer software programs.
- Ability to conduct research.
- Ability to establish and maintain cooperative and effective working relationships.
- Knowledge of, and the ability to apply, principles, practices and procedures involving office operations.
This is a standardized examination and, therefore, test questions and test answers are not available for public inspection or review.
You will receive one or more scores with respect to the multiple-choice exam component. One will correspond to the core test component and, should any specialty subtests be added to that component, you may receive one or more additional “specialty” scores. Any scores attained on these components will be valid and 'banked' for three years, starting from the date of the examination. This means that, during this three-year time period, you will not be required to take any test components for which you have already attained a score. This core test is also used for 1820 Junior Administrative Analyst, 1822 Administrative Analyst and 1823 Senior Administrative Analyst, therefore your test scores may be applied to one or more of these classes if you choose to apply to future recruitments. This is not the same exam that is used for 1824 Principal Administrative Analyst, as such your scores on this exam are not applied to any 1824 recruitments, and your scores from the 1824 exam cannot be applied to this recruitment. If the selection process for the future announcement is held within one year of the date of this examination and it includes any of these components [i.e., core exam or specialty subtest(s)], your score(s) for the corresponding test component(s) will be automatically applied to that announcement. However, after one year, you have the option to either (a) apply your test score(s) to the other announcement or (b) re-take the test component(s). Re-testing is permitted no sooner than one year from the date of the examination and only in association with your eligibility for another announcement for which the test component (core or specialty subtest) is used. Please note that, should you re-test, your re-test score would become your official score since it is the most recent.
A passing score must be achieved on the above examS in order to continue in the selection process.
Note: Applicants who meet the minimum qualifications are not guaranteed to advance through all of the steps in the selection process. Candidates must achieve a passing score on the above examination in order to be ranked on the eligible list.
The department may utilize additional position-specific selection procedures to make a final hiring decision.
The certification rule used for the ranked eligible list resulting from this examination will be the Rule of Three Scores. Additional selection processes may be conducted by the hiring department prior to making final hiring decisions.
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 6 months, and may be extended with the approval of the Human Resources Director.
Upon approval of the Human Resource Director (see Civil Service Rule 111A.26.5), the eligible list/score report resulting from this announcement may be used by other departments that also use this classification or a similar classification. To find other Departments which use this classification, please see https://sfdhr.org/sites/default/files/documents/ASO-Level-Chart.pdf?documentID=21246.
As a selected candidate 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 selected candidate. 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 a selected candidate, the hiring department will contact you to schedule a fingerprinting appointment.
Disaster Service Workers
Applicants with disabilities who meet the minimum eligibility requirements for this job announcement can find information on requesting a reasonable ADA Accommodation at: http://www.sfdhr.org/index.aspx?page=20#applicantswithdisabilities
Seniority Credit in Promotional Exams can be found at: http://www.sfdhr.org/index.aspx?page=20#senioritycredit
Information regarding requests for Veterans Preference can be found at: http://www.sfdhr.org/index.aspx?page=20#veteranspreference
General Information concerning City and County of San Francisco Employment Policies and Procedures can be found at: http://www.sfdhr.org/index.aspx?page=20 or a hard copy may be obtained 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. Information regarding this can be found at: http://www.sfdhr.org/index.aspx?page=20#copies
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. More information can be found at: http://www.sfdhr.org/index.aspx?page=20#identification
Terms of the Announcement: http://www.sfdhr.org/index.aspx?page=20#announcementsdefinitions
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 www.jobaps.com/sf.
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.
Exam Type: COMBINED PROMOTIVE & ENTRANCE
Micki Callahan, Director
Department of Human Resources
Recruitment Number: PBT-1823-103437
Issued: February 11, 2020; amended 2/12/2020
TTX/JK (415) 554-4475
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.