Data Analytics Engineer (Snowflake/DBT) (1042) - Controller's Office - (168329)
City and County of San Francisco
San Francisco, CA, United States
City and County of San Francisco
We write the CV against this exact posting — its wording, its requirements — not a template with your name in it.
$25, one-time. No subscription.
This is a Position-Based Test conducted in accordance with CSC Rule 111A. Learn more about the City’s hiring process here: https://careers.sf.gov/knowledge/process/
Application Opening: Tuesday, September 8, 2026
Application Deadline: Tuesday, September 29, 2026 by 11:59 p.m.
The job ad will close at 12:00 am PST on Wednesday, September 30, 2026. Applications must be submitted by 11:59 pm PST on Tuesday, September 29, 2026.
Salary Range: The normal annual salary range A is $161,382-$205,972-Appointments above the maximum of the normal range may be considered based on documented and substantiated recruitment and retention issues or exceptional skills.
Becoming a City employee means being a part of a team that cares about making a difference. Your work will shape both the present and future of San Francisco. When you work for the City, you’re choosing a job with purpose. As one of the most popular tourist destinations in the world, San Francisco is a city of truly international character with an eclectic mix of Victorian and modern architecture and a highly diverse cosmopolitan population. With approximately 810,000 residents in a 47 square mile area, San Francisco is the seventeenth most populous city in the United States and the fourth most populous city in California. The City is an internationally famous tourist destination known for its iconic landmarks like the Golden Gate Bridge, Fisherman's Wharf and Alcatraz Island, and its diverse culture and arts scene. For the sports fans, San Francisco is home to the Giants and Golden State Warriors, with the 49ers located nearby in the South Bay and the Golden State Valkyries. With fourteen Fortune 500 companies headquartered in the City, and a large infrastructure of professional services, including law, public relations, architecture, and graphic design, populating downtown, San Francisco is a world-class city. With Silicon Valley nearby, San Francisco has also emerged as a high-profile technology center. The City is home to San Francisco State University with over 23,000 students, the City College of San Francisco, the University of San Francisco, the University of California San Francisco and UC Law San Francisco.
The San Francisco Health Service System (SFHSS) was established in 1937 to provide medical care for municipal employees. SFHSS is responsible for all health benefits administration, including medical, dental, vision, flexible spending accounts (FSA), and a wide array of voluntary benefits for the employees, retirees, and covered dependents of the City and County of San Francisco (CCSF), San Francisco Unified School District, City College of San Francisco, and Superior Court of San Francisco. Today, we serve over 130,000 employees, retirees, and their covered dependents. The department is comprised of seven divisions: Administration, Finance, Member Services, Communications, Information System (IS), Contracts, and Well-Being.
SFHSS' Mission
SFHSS is dedicated to ensuring quality and sustainable benefits that enhance the whole-person health and well-being of our members and their families throughout their lifecycles.
This position is a dual role of traditional management responsibilities along with performing individual tasks due to the sensitivity and technical skills requirements.
The position plans, organizes, directs and controls functional and technical work of the PeopleSoft HCM system involving Benefits Administration and other key HSS enterprise systems. The Information Systems Manager reports to the Chief Operating and Experience Officer and works closely with the Operations Manager, the Chief Financial and Accountability Officer, the Contracts administration manager, the Well Being Manager and the Communications Director. This position is responsible for the department’s IT infrastructure and for the complex analysis, evaluation, recommendation, development and implementation of major healthcare management programs and functions of the Health Service System. This position plans, organizes, directs and controls functional and technical work of the PeopleSoft HCM system involving Benefits Administration.
Individual Tasks:
Management Responsibilities:
Education: Possession of a baccalaureate degree from an accredited college or university, preferably with major college coursework in management information systems, computer science, information technology, data processing operations, business administration or a related field; AND
Experience:
Substitution Language: 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.
Applicants must meet the minimum qualification requirement by the final filing date unless otherwise noted.
Desirable Qualifications:
The stated desirable qualifications may be considered at the end of the selection process when candidates are referred for hiring.
Verification of Education and Experience:
Every application is reviewed to ensure that you meet the minimum qualifications as listed in the job ad. Review SF Careers Employment Applications for considerations taken when reviewing applications.
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 https://careers.sf.gov/knowledge/experience-education/.
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. Applicants must complete the official application. 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 or disqualification.
Selection Procedure:
This is a Position-Based Test conducted in accordance with CSC Rule 111A. 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 at a later time. 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.
Management Test Battery (MTB) (Weight: 40%)
Candidates will be invited to participate in a computer-based examination designed to measure competencies in job-related areas which may include but are not limited to: Problem-Solving; Leadership; Decision Making; Interpersonal skills; Human Resources Management; Team Building; Process Improvement; Communication and Conflict Management. For more information about this Management Test (and a suggested reading list), please visit: MANAGEMENT TEST BATTERY.
Please note: This examination is only held in San Francisco. A passing score must be achieved on the Management Test Battery in order to continue in the selection process.
This is a standardized examination and, therefore, test questions and answers are not available for public inspection or review.
Scores attained on the Management Test Battery 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 the Management Test Battery. The Management Test Battery may be used for many other classes; therefore, your test score may be applied to one or more of these classes if you choose to apply to future recruitments. If the selection process for the future announcement is held within one year of the date of this examination and it includes the Management Test Battery, your score will be automatically applied to that announcement. However, after one year, you have the option to either (a) apply your test score to the other announcement or (b) re-take the Management Test Battery. 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 Management Test Battery is used. Please note that, should you re-test, your re-test score would become your official score since it is the most recent.
Training and Experience Evaluation (T&E) (Weight: 60%)
Candidates who pass the MTB will be invited to participate in a Training and Experience evaluation. The Training and Evaluation questions are designed to evaluate candidates' relative knowledge, skills and abilities in job-related areas. This may include but not be limited to knowledge of benefit administration systems, information technology and network administration including large integrated systems which may have included Human Resources, Benefits and Payroll functions in a complex organization and development and implementation of complex systems and procedures and supervisory experience. All relevant experience, education and training must be on the application in order to be reviewed in the rating process. It is essential that applicants provide complete information in identifying their education, experience and training.
Candidates will be required to respond to the T&E in the time frame indicated and must submit the completed questionnaire as directed in order to have it evaluated.
Candidates will be placed on the eligible list in rank order according to their final score.
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 6 months and may be extended with the approval of the Human Resources Director.
Certification: The certification rule for the eligible list resulting from this exam will be the “Rule of the List”.
To find Departments which use this classification, please see the city’s Position Counts by Job Codes and Departments.
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 https://careers.sf.gov/.
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:
Where to Apply
All job applications for the City and County of San Francisco must be submitted through our online portal. Please visit https://careers.sf.gov/ to begin your application process.
Computers are available for the public (9:00 a.m. to 4: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 and at the City Career Center at City Hall, 1 Dr. Carlton B. Goodlett Place, Room 110.
Ensure your application information is accurate, as changes may not be possible after submission. Your first and last name must match your legal ID for verification, and preferred names can be included in parentheses. Use your personal email address, not a shared or work email, to avoid unfixable issues.
Applicants will receive a confirmation email from [email protected] 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, you may contact Lauren Rowe at [email protected]
Recruitment ID:167228
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.
Seen 18 days ago · City and County of San Francisco postings close after a median of 14 days.
Original posting on City and County of San Francisco's site ↗
Posting text belongs to the employer. Removal requests: contact us.
Nearby
Same employer first, then the same role elsewhere.
City and County of San Francisco
San Francisco, CA, United States
City and County of San Francisco
San Francisco, CA, United States
City and County of San Francisco
San Francisco, CA, United States
City and County of San Francisco
San Francisco, CA, United States
City and County of San Francisco
San Francisco, CA, United States
City and County of San Francisco
San Francisco, CA, United States
City and County of San Francisco
San Francisco, CA, United States
City and County of San Francisco
San Francisco, CA, United States
One job at a time
Pick the job you actually want and we write for it.