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.
Specific information regarding this recruitment process is listed below:
• Application Opening: Monday, September 14, 2026
• Application Deadline: Tuesday, October 13, 2026, 11:59PM (PST)
• Compensation Range: $200,538 - $255,996 (Range A); Range B ($256,022 - $296,322)
This is a Permanent Exempt (PEX) position. Pursuant to the City & County of San Francisco Charter, Section 10.104.13, this position shall be exempt from competitive civil service selection, appointment and removal procedures. The person serving in this position shall serve at the pleasure of the Appointing Officer.
To be considered for this position, applicants are required to complete the following at the time of application submission:
Our Mission
The Office of the Treasurer & Tax Collector serves as the banker, tax collector, collection agent, and investment officer for the City and County of San Francisco. As the entity responsible for safeguarding the City’s money, the Office uses this expertise and authority to assist San Francisco residents through award-winning programs and initiatives that help low-income families build economic security and mobility.
Our Vision
We are committed to providing excellent services for taxpayers, customers, and our community. By promoting diversity, equity, and inclusion, we are a stronger, smarter, and more informed government agency.
The Chief Investment Officer (CIO) is responsible for overseeing the investment and management of the City and County’s $19+ billion Treasurer’s Investment Pool, ensuring compliance with legal and fiduciary obligations while maximizing returns within risk parameters. The CIO manages and implements an asset/liability investment strategy with a focus of matching asset maturities to know portfolio outflows within the maximum asset maturity limit of 5 years per the California Investment code, monitors and oversees the Treasurer’s Investment Pool cashflow profile and cash forecasting models, monitors market conditions, and ensures the safety, liquidity, and performance of portfolio funds in alignment with statutory requirements and the City and County’s investment policies.
Essential Duties and Responsibilities
Investment Strategy & Management
Governance, Compliance & Risk Management
Stakeholder Communication & Reporting
Leadership & Team Management
Ideal Experience
Education: Possession of a baccalaureate degree in economics, finance, business administration, or related field from an accredited college or university; AND
Experience: Six (6) years of progressive management and buy-side experience in the management of short duration fixed income portfolios. Buy-side experience should include: asset/liability matching portfolio strategy; understanding of the mandates for managing public funds and fixed income markets; trading fixed income securities using electronic trading platforms; management of trading costs; capital market and economic trends and conditions impact on portfolio liquidity needs; and cash flow modeling.
All six (6) years of this experience must include supervising a team of professionals.
Verification
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://sfdhr.org/how-verify-education-requirements.
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 SmartRecruiters application by the filing deadline. Information must be entered into the SmartRecruiters applicant tracking system under the headings for Experience and Education. Leaving these sections blank and attaching a resume in lieu of completing the Experience and Education sections may cause your application to be rejected.
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 PROCEDURES:
After application submission, candidates deemed qualified must complete all subsequent steps to advance in this selection process, which includes the following:
The selection process will include evaluation of applications in relation to minimum requirements. Applicants meeting the minimum qualifications are not guaranteed advancement to an interview. Depending on the number of applicants, the Department may establish and implement additional screening mechanisms to comparatively evaluate the qualifications of candidates. If this becomes necessary, only those applicants whose qualifications most closely meet the needs of the Department will be invited for an interview.
Note: Applicants who meet the minimum qualifications are not guaranteed to advance through all of the steps in the selection process.
Additional Information Regarding Employment 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 https://careers.sf.gov/ and begin the application process.
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.
Recruitment Analyst Information: If you have any questions regarding this recruitment or application process, please contact, Eric Louie at [email protected].
All 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.
Seen 12 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.