Prepare for and practice interview questions from City And County Of San Francisco.

City And County Of San Francisco Interview Questions

City And County Of San Francisco Interview Guides

Machine Learning

Missing Housing Data

85% vs 82%

Spam Classifier 

Brainteasers

How would you answer when an Interviewer asks why you applied to their company?

Why Do You Want to Work With Us

What do you tell an interviewer when they ask you what your strengths and weaknesses are?

Your Strengths and Weaknesses

Statistics

Reducing Error Margin

When an interviewer asks a question along the lines of:

<ul>
<li>What would your current manager say about you? What constructive criticisms might he give?</li>
<li>What are your three biggest strengths and weaknesses you have identified in yourself?</li>
</ul>

How would you respond?

When asked about your strengths in an interview, what is an effective way to respond?

When asked about your strengths in an interview, what is an effective way to respond?

Your Strengths and Weaknesses I

Which of the following is an acceptable strategy when discussing weaknesses in an interview?

Which of the following is an acceptable strategy when discussing weaknesses in an interview?

Your Strengths and Weaknesses II

When an interviewer asks you a question along the lines of:

<ul>
<li>Why did you apply to our company?</li>
<li>What are you looking for in your next job?</li>
<li>What makes you a good fit for our company?</li>
</ul>

How should you respond?

When asked 'What are you looking for in your next job?' in an interview, how can you tie the company's employee benefits into your response?

When asked 'What are you looking for in your next job?' in an interview, how can you tie the company's employee benefits into your response?

Why Do You Want to Work With Us I

How can company values be used effectively in an interview when asked 'What makes you a good fit for our company?'

How can company values be used effectively in an interview when asked 'What makes you a good fit for our company?'

Why Do You Want to Work With Us II

When responding to the question 'Why did you apply to our company?' during an interview, what aspect should you highlight?

When responding to the question 'Why did you apply to our company?' during an interview, what aspect should you highlight?

Why Do You Want to Work With Us III

We want to build a model to predict housing prices in the city of Seattle. We’ve scraped 100K sold listings over the past three years but found that around 20% of the listings are missing square footage data.

How do we deal with the missing data to construct our model?

We want to build a model to predict housing prices in the city of Seattle. We’ve scraped 100K sold listings over the past three years, but have discovered that around 20% of the listings are missing square footage data.

How would you approach dealing with this missing data, in order to construct the most useful predictive model possible?

We want to build a model to predict housing prices in the city of Seattle. We’ve scraped 100K sold listings over the past three years, but have discovered that around 20% of the listings are missing square footage data.

How would you approach dealing with this missing data, in order to construct the most useful predictive model possible?



Let’s say you are tasked with building a spam classifier for emails. Assume that you’ve built a V1 of the model.

What metrics would you use to track accuracy and validity of the model?

Let’s say we have a sample size of \(n\). The margin of error for our sample size is 3.

How many more samples would we need to decrease the margin of error to 0.3?

Let's say we have a sample size of N. The margin of error for our sample size is 3.

How many more samples would we need to decrease the margin of error to 0.3?

Let's say we have a sample size of N. The margin of error for our sample size is 3.

How many more samples would we need to decrease the margin of error to 0.3?

We have two models: one with 85% accuracy, one 82%. Which one do you pick?

Challenge

<h5>Senior Data Engineer (1043) - DataSF </h5>DataSF is seeking a Senior Data Engineer with 3+ years of experience to join our growing team. Reporting to the Principal Data Engineer, you will be instrumental in designing, building, and maintaining the City's data infrastructure, enabling robust data pipelines and reliable data access for analytical and operational needs. This is an exciting position for someone eager to apply advanced data engineering techniques to complex urban challenges, contributing directly to San Francisco's commitment to efficient, equitable, and ethical service delivery. Learn more about DataSF's recent work on our blog. Essential duties include, but are not limited to, the following: <ul> <li>Platform Administration: Manage our central Snowflake data warehouse, including access control, security policies, resource monitoring, performance tuning, and cost optimization. Administer our platform with a focus on data democratization and accessibility, while protecting privacy and security. </li><li>Pipeline Development: Build and maintain scalable and resilient pipelines to ingest and structure data from diverse sources. Design infrastructure to support both streaming and batch processes, and both structured and unstructured data sources. </li><li>Infrastructure as Code (IaC): Use Terraform to define, deploy, and manage data infrastructure, ensuring our pipelines are reproducible, version-controlled, and production-ready. </li><li>Best Practices & Innovation: Champion and implement best practices for documentation, data modeling, warehouse architecture, SQL optimization, and testing. Think creatively to find new ways to improve our data platform's capabilities and efficiency. Provide guidance to department partners on data engineering best practices. </li><li>Collaboration: Work closely with data scientists, analysts, product managers, software engineers, and nontechnical stakeholders in diverse domains to understand data requirements and build solutions that meet their needs. </li><li>Monitoring & Support: Proactively monitor the health of the data platform and pipelines, troubleshoot issues, and ensure high standards of data quality and availability. </li></ul> Desirable Qualifications <ul> <li>Technical Knowledge <ul> <li>Hands-on experience administering and developing on managed cloud data platforms such as Snowflake, BigQuery, or Databricks. </li><li>Demonstrated expertise in writing advanced, performant SQL, and using tools like dbt for SQL-based data transformation and modeling. </li><li>Strong programming skills in Python (with libraries like pandas, PySpark) for data processing and automation. </li><li>Proficiency with an Infrastructure as Code tool, with a preference for Terraform. </li><li>Experience building and deploying data pipelines using orchestration tools like Azure Data Factory, Airflow, Dagster, or similar technologies. </li><li>Deep understanding of data warehousing concepts, data modeling, and modern ELT principles. </li><li>Understanding of data governance, data security, and data privacy principles. </li><li>Experience with real-time data streaming technologies (e.g., Kafka, Kinesis, Snowpipe). </li><li>Experience deploying and managing data pipelines for machine learning models. </li></ul> </li><li>Collaboration and Communication Skills <ul> <li>Strong problem-solving skills with ability to design practical and effective data solutions </li><li>Excellent verbal and written communication skills, including the ability to explain technical concepts to non-technical stakeholders </li><li>A collaborative mindset with enthusiasm to work across diverse, cross-functional teams </li></ul> </li><li>Mission Alignment <ul> <li>Commitment to equity, transparency, and ethical data use </li><li>Passion for public service and using data to improve government services </li><li>Empathy for San Francisco's diverse communities and a drive to make data and services more accessible for SF residents </li><li>Interest or experience in public sector data or social impact work </li></ul> </li></ul> Education: An associate degree in computer science, computer engineering, information systems, or a closely related field from an accredited college or university OR its equivalent in terms of total course credits/units. Experience: Three (3) years of experience analyzing, installing, configuring, enhancing, and/or maintaining the components of an enterprise network. Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree. Applicants will be required to submit verification of qualifying education and experience during the recruitment and selection process. For information on how to verify experience and/or education requirements, including verifying foreign education credits or degree equivalency, please visit Verification of Experience and/or 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. Applicants must meet the minimum qualification requirement by the final application deadline unless otherwise noted.

<h3>Job Description</h3><div>Job Description<div>Company Description <ul><li>Application Opening: 12/19/2025</li><li>Application Filing Deadline: Updated to 3/6/2026<ul><li>Previously 12/29/2025, 2/9/2026, 2/13/2026, 2/20/2026, 2/27/2026</li></ul></li><li>Recruitment ID: RTF0162555 (162556)</li></ul>Amended on 2/2/26: The job announcement has been reopened from February 2, 2026, to March 6, 2026, to broaden the candidate pool. Applicants who have already applied to this recruitment do not need to re-apply.APPOINTMENT TYPE: Exempt: This position is excluded by the Charter from the competitive Civil Service examination process and shall serve at the discretion of the Appointing Officer. The duration of the appointment shall not exceed 36 months.WHO ARE WE? San Francisco Public Utilities Commission (SFPUC) Headquartered in San Francisco, we have 2,300 employees operating across eight counties serving more than 2.7 million customers in the San Francisco Bay Area – 24 hours per day, 365 days per year.Our Mission: To provide our customers with high quality, efficient, and reliable water, power, and wastewater services in a manner that values environmental and community interests and sustains the resources entrusted to our care.Our Vision: We are an innovative utility leader, recognized for excellent results in service, safety, stewardship, and inclusiveness.We are an award-winning and industry-leading utilities organization committed to our customers, community interests, and the environment. To learn more about our organization, please visit our website at https://www.sfpuc.gov.We are proud of our infrastructure and programs, but most importantly, we value our highly qualified and dedicated workforce which ensures that this vision becomes a reality.To learn more about working at the SFPUC, visit our career site at https://www.sfpuc.gov/about-us/careers-sfpucJob Description Project: Disaster RecoveryLocation: 525 Golden Gate Ave., San Francisco, CAHours: Monday – Friday, 8:00 am – 5:00 pmPosition Description<ul><li>Under the general guidance of IS Project Director, this Principal Business Analyst (Disaster Recovery) will be focused on leading and executing our organization's disaster recovery and business continuity initiatives. This senior-level position is responsible for developing, implementing, and maintaining comprehensive disaster recovery strategies that protect our critical business operations and ensure rapid restoration capabilities in the event of a disruption. This role requires business acumen to collaborate internally agencywide and within larger Citywide disaster recovery programs to meet regulatory requirements, industry standards, and City DPR3 polices.</li></ul>Essential functions of the position include: Disaster Recovery Plan Development & Maintenance<ul><li>Lead the development of comprehensive enterprise-wide disaster recovery and business continuity plans aligned with organizational objectives and risk tolerance</li><li>Conduct thorough documentation of all critical systems, applications, data, and dependencies within the plan</li><li>Create detailed recovery procedures and step-by-step runbooks for each critical system and application</li><li>Establish and document recovery time objectives (RTO) and recovery point objectives (RPO) for all business-critical systems</li><li>Maintain up-to-date disaster recovery plans through regular reviews and updates (minimally quarterly or upon significant infrastructure changes)</li><li>Coordinate with system owners and business units to gather requirements and ensure plan accuracy and completeness</li><li>Document disaster recovery roles, responsibilities, and escalation procedures</li><li>Develop and maintain the Disaster Recovery Plan documentation, including executive summaries and detailed technical appendices</li><li>Ensure disaster recovery plans address various disaster scenarios (natural disasters, cyberattacks, infrastructure failures, etc.)</li><li>Archive and version control all disaster recovery documentation for historical reference and compliance</li></ul>Strategic Planning & Infrastructure Design<ul><li>Conduct comprehensive risk assessments and business impact analyses to identify critical systems and recovery priorities</li><li>Design recovery architectures and failover strategies for mission-critical applications and infrastructure</li><li>Evaluate and recommend disaster recovery technologies and solutions that align with organizational needs and budget</li><li>Develop disaster recovery strategies across multiple infrastructure environments (on-premises, cloud, hybrid)</li></ul>Program Management & Implementation<ul><li>Lead cross-functional teams to implement disaster recovery solutions across multiple business units and technical domains</li><li>Oversee procurement, configuration, and deployment of disaster recovery technologies and platforms</li><li>Manage disaster recovery budgets and resource allocation</li><li>Develop and manage disaster recovery documentation, runbooks, and standard operating procedures</li></ul>Testing & Validation<ul><li>Plan and execute regular disaster recovery drills and full-scale exercises to validate plan effectiveness</li><li>Analyze test results, identify gaps, and recommend improvements to recovery procedures</li><li>Maintain detailed records of all testing activities and outcomes</li><li>Coordinate with business stakeholders on tabletop exercises and scenario-based planning</li></ul>Compliance & Governance<ul><li>Ensure disaster recovery programs meet regulatory requirements and industry standards (ISO 27001)</li><li>Maintain compliance documentation and audit readiness</li><li>Develop disaster recovery policies and procedures</li><li>Conduct training and awareness programs for staff</li><li>Perform other related duties as assigned. </li></ul>Qualifications Minimum Qualifications: Applicants must meet the minimum qualification requirement by the final filing date unless otherwise noted.Education: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 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].Experience: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.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.SUPPLEMENTAL INFORMATIONEssential 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 per-forming data entry. May involve extensive VDT exposure.Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree.Desired Qualifications: The stated desirable qualifications may be considered at the end of the selection process when candidates are referred for hiring. <ul><li>Utility Industry experience</li><li>Six Sigma or similar process improvement certification</li><li>Experience with security and network infrastructure</li><li>Knowledge of IT service management frameworks (ITIL)</li></ul>Verification of Education and Experience:Every application is reviewed to ensure that you meet the minimum qualifications as listed in the job ad. Please review our articles on Employment Application and Minimum Qualifications and Verification of Experience and/or Education 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.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. Applications completed improperly may be cause for ineligibility, disqualification or may lead to lower scores. Additional Information Additional Information Regarding Employment with the City and County of San Francisco: <ul><li>Information About the Hiring Process</li><li>Conviction History</li><li>Employee Benefits Overview  </li><li>Equal Employment Opportunity </li><li>Disaster Service Worker</li><li>ADA Accommodation</li><li>Veterans Preference</li><li>Right to Work</li><li>Copies of Application Documents</li><li>Diversity Statement</li></ul> Applicants will receive a confirmation email from notification@careers.sf.gov 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.HOW TO APPLY Applications for City and County of San Francisco jobs are only accepted through an online process. Visit https://careers.smartrecruiters.com/CityAndCountyOfSanFrancisco1/ and begin the application process.<ul><li>Select the “I’m Interested” button and follow instructions on the screen</li></ul>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 updated. 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 from notification@careers.sf.gov 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. Job Analyst Information: If you have any questions regarding this recruitment or application process, please contact the job analyst, Sanly Guan at Sguan@sfwater.org <div></div>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.</div></div>

<h3>Job Description</h3><div>Job Description<div>Company Description <ul><li>Application Opening: 12/19/2025</li><li>Application Filing Deadline: Updated to 2/27/2026<ul><li>Previously 12/29/2025, 2/9/2026, 2/13/2026, 2/20/2026</li></ul></li><li>Recruitment ID: RTF0162555 (162556)</li></ul>Amended on 2/2/26: The job announcement has been reopened from February 2, 2026, to February 27, 2026, to broaden the candidate pool. Applicants who have already applied to this recruitment do not need to re-apply.APPOINTMENT TYPE: Exempt: This position is excluded by the Charter from the competitive Civil Service examination process and shall serve at the discretion of the Appointing Officer. The duration of the appointment shall not exceed 36 months.WHO ARE WE? San Francisco Public Utilities Commission (SFPUC) Headquartered in San Francisco, we have 2,300 employees operating across eight counties serving more than 2.7 million customers in the San Francisco Bay Area – 24 hours per day, 365 days per year.Our Mission: To provide our customers with high quality, efficient, and reliable water, power, and wastewater services in a manner that values environmental and community interests and sustains the resources entrusted to our care.Our Vision: We are an innovative utility leader, recognized for excellent results in service, safety, stewardship, and inclusiveness.We are an award-winning and industry-leading utilities organization committed to our customers, community interests, and the environment. To learn more about our organization, please visit our website at https://www.sfpuc.gov.We are proud of our infrastructure and programs, but most importantly, we value our highly qualified and dedicated workforce which ensures that this vision becomes a reality.To learn more about working at the SFPUC, visit our career site at https://www.sfpuc.gov/about-us/careers-sfpucJob Description Project: Disaster RecoveryLocation: 525 Golden Gate Ave., San Francisco, CAHours: Monday – Friday, 8:00 am – 5:00 pmPosition Description<ul><li>Under the general guidance of IS Project Director, this Principal Business Analyst (Disaster Recovery) will be focused on leading and executing our organization's disaster recovery and business continuity initiatives. This senior-level position is responsible for developing, implementing, and maintaining comprehensive disaster recovery strategies that protect our critical business operations and ensure rapid restoration capabilities in the event of a disruption. This role requires business acumen to collaborate internally agencywide and within larger Citywide disaster recovery programs to meet regulatory requirements, industry standards, and City DPR3 polices.</li></ul>Essential functions of the position include: Disaster Recovery Plan Development & Maintenance<ul><li>Lead the development of comprehensive enterprise-wide disaster recovery and business continuity plans aligned with organizational objectives and risk tolerance</li><li>Conduct thorough documentation of all critical systems, applications, data, and dependencies within the plan</li><li>Create detailed recovery procedures and step-by-step runbooks for each critical system and application</li><li>Establish and document recovery time objectives (RTO) and recovery point objectives (RPO) for all business-critical systems</li><li>Maintain up-to-date disaster recovery plans through regular reviews and updates (minimally quarterly or upon significant infrastructure changes)</li><li>Coordinate with system owners and business units to gather requirements and ensure plan accuracy and completeness</li><li>Document disaster recovery roles, responsibilities, and escalation procedures</li><li>Develop and maintain the Disaster Recovery Plan documentation, including executive summaries and detailed technical appendices</li><li>Ensure disaster recovery plans address various disaster scenarios (natural disasters, cyberattacks, infrastructure failures, etc.)</li><li>Archive and version control all disaster recovery documentation for historical reference and compliance</li></ul>Strategic Planning & Infrastructure Design<ul><li>Conduct comprehensive risk assessments and business impact analyses to identify critical systems and recovery priorities</li><li>Design recovery architectures and failover strategies for mission-critical applications and infrastructure</li><li>Evaluate and recommend disaster recovery technologies and solutions that align with organizational needs and budget</li><li>Develop disaster recovery strategies across multiple infrastructure environments (on-premises, cloud, hybrid)</li></ul>Program Management & Implementation<ul><li>Lead cross-functional teams to implement disaster recovery solutions across multiple business units and technical domains</li><li>Oversee procurement, configuration, and deployment of disaster recovery technologies and platforms</li><li>Manage disaster recovery budgets and resource allocation</li><li>Develop and manage disaster recovery documentation, runbooks, and standard operating procedures</li></ul>Testing & Validation<ul><li>Plan and execute regular disaster recovery drills and full-scale exercises to validate plan effectiveness</li><li>Analyze test results, identify gaps, and recommend improvements to recovery procedures</li><li>Maintain detailed records of all testing activities and outcomes</li><li>Coordinate with business stakeholders on tabletop exercises and scenario-based planning</li></ul>Compliance & Governance<ul><li>Ensure disaster recovery programs meet regulatory requirements and industry standards (ISO 27001)</li><li>Maintain compliance documentation and audit readiness</li><li>Develop disaster recovery policies and procedures</li><li>Conduct training and awareness programs for staff</li><li>Perform other related duties as assigned. </li></ul>Qualifications Minimum Qualifications: Applicants must meet the minimum qualification requirement by the final filing date unless otherwise noted.Education: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 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].Experience: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.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.SUPPLEMENTAL INFORMATIONEssential 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 per-forming data entry. May involve extensive VDT exposure.Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree.Desired Qualifications: The stated desirable qualifications may be considered at the end of the selection process when candidates are referred for hiring. <ul><li>Utility Industry experience</li><li>Six Sigma or similar process improvement certification</li><li>Experience with security and network infrastructure</li><li>Knowledge of IT service management frameworks (ITIL)</li></ul>Verification of Education and Experience:Every application is reviewed to ensure that you meet the minimum qualifications as listed in the job ad. Please review our articles on Employment Application and Minimum Qualifications and Verification of Experience and/or Education 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.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. Applications completed improperly may be cause for ineligibility, disqualification or may lead to lower scores. Additional Information Additional Information Regarding Employment with the City and County of San Francisco: <ul><li>Information About the Hiring Process</li><li>Conviction History</li><li>Employee Benefits Overview  </li><li>Equal Employment Opportunity </li><li>Disaster Service Worker</li><li>ADA Accommodation</li><li>Veterans Preference</li><li>Right to Work</li><li>Copies of Application Documents</li><li>Diversity Statement</li></ul> Applicants will receive a confirmation email from notification@careers.sf.gov 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.HOW TO APPLY Applications for City and County of San Francisco jobs are only accepted through an online process. Visit https://careers.smartrecruiters.com/CityAndCountyOfSanFrancisco1/ and begin the application process.<ul><li>Select the “I’m Interested” button and follow instructions on the screen</li></ul>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 updated. 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 from notification@careers.sf.gov 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. Job Analyst Information: If you have any questions regarding this recruitment or application process, please contact the job analyst, Sanly Guan at Sguan@sfwater.org <div></div>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.</div></div>

<h5>Job Description </h5>Under general administrative direction, this position will be responsible for overseeing and directing an employee and outside vendors, as well as performing a variety of complex and difficult duties within the Risk Management Division as directed, focusing primarily on the following areas of responsibility: <ul><li>Providing support to City departments in all phases of contracts, leases, licenses, grants, permits, easements, and other agreements insurance setting, requirement interpretation, and evidence of insurance analysis. </li><li>Training City department staff personnel in insurance and risk management practices. </li><li>Managing the Request for Qualifications (RFQ)/Request For Proposal (RFP) Process to establish and maintain a new ongoing Citywide Eligible List of Insurance Vendors (Insurance Brokers and Service Providers). </li><li>Supporting the Division in managing the intricacies of budget, work order development billing, insurance placement, and the procurement of brokers & service providers unique to the Division. </li><li>Coordinating the evaluation of Citywide risk management maturity, which includes but is not limited to: </li><li>Collaborating across City departments to design, develop and administer additional training opportunities for understanding Risk Management processes and industry standards (e.g., ISO 31000) </li><li>Reviewing, implementing and maintaining policies, procedures and plan documents to ensure smooth operation of the Citys insurance programs. </li><li>Conducting data analysis and preparing presentations, reports, and materials needed to facilitate insurance renewals and measure underwriting performance for various internally and external audiences. </li><li>Researching best practices used in other jurisdictions and presenting a draft work plan with recommendations for enhancing and streamlining the Citys Risk Management program. </li><li>Preparing reports and analyzing risk management data to support decision?making. </li><li>Overseeing and directing outside vendors (e.g., brokers and risk management service providers) to ensure insurance policies and programs are placed, renewed, and well?documented in accordance with applicable policies that promote transparency and accountability. </li><li>Providing support for the Contractor Development Program (CDP) (formerly known as Surety Bonding and Financial Assistance Program under Administrative Code Section 14B.16), in coordination within the Risk Management Division, as well as Contact Monitoring Division and the CDP Administrator. </li><li>Managing technology platform(s) utilized by the city (e.g. Peoplesoft, ServiceNow, Salesforce) to manage and track risk management data. </li><li>Developing, building and maintaining strong collaborative relationships with internal and external City stakeholders on Policy, Financial and Operational matters related to the Citys Risk Management programs </li> </ul> <h5>Seniority Level </h5>Mid?Senior level <h5>Employment Type </h5>Full?time <h5>Job Function </h5>Finance and Sales <h5>Industries </h5>Insurance #J-18808-Ljbffr

<h3>Job Description</h3><div>Job Description<div>Company Description <ul><li>Application Opening: 12/19/2025</li><li>Application Filing Deadline: Updated to 2/20/2026<ul><li>Previously 12/29/2025, 2/9/2026, 2/13/2026</li></ul></li><li>Recruitment ID: RTF0162555 (162556)</li></ul>Amended on 2/2/26: The job announcement has been reopened from February 2, 2026, to February 20, 2026, to broaden the candidate pool. Applicants who have already applied to this recruitment do not need to re-apply.APPOINTMENT TYPE: Exempt: This position is excluded by the Charter from the competitive Civil Service examination process and shall serve at the discretion of the Appointing Officer. The duration of the appointment shall not exceed 36 months.WHO ARE WE? San Francisco Public Utilities Commission (SFPUC) Headquartered in San Francisco, we have 2,300 employees operating across eight counties serving more than 2.7 million customers in the San Francisco Bay Area – 24 hours per day, 365 days per year.Our Mission: To provide our customers with high quality, efficient, and reliable water, power, and wastewater services in a manner that values environmental and community interests and sustains the resources entrusted to our care.Our Vision: We are an innovative utility leader, recognized for excellent results in service, safety, stewardship, and inclusiveness.We are an award-winning and industry-leading utilities organization committed to our customers, community interests, and the environment. To learn more about our organization, please visit our website at https://www.sfpuc.gov.We are proud of our infrastructure and programs, but most importantly, we value our highly qualified and dedicated workforce which ensures that this vision becomes a reality.To learn more about working at the SFPUC, visit our career site at https://www.sfpuc.gov/about-us/careers-sfpucJob Description Project: Disaster RecoveryLocation: 525 Golden Gate Ave., San Francisco, CAHours: Monday – Friday, 8:00 am – 5:00 pmPosition Description<ul><li>Under the general guidance of IS Project Director, this Principal Business Analyst (Disaster Recovery) will be focused on leading and executing our organization's disaster recovery and business continuity initiatives. This senior-level position is responsible for developing, implementing, and maintaining comprehensive disaster recovery strategies that protect our critical business operations and ensure rapid restoration capabilities in the event of a disruption. This role requires business acumen to collaborate internally agencywide and within larger Citywide disaster recovery programs to meet regulatory requirements, industry standards, and City DPR3 polices.</li></ul>Essential functions of the position include: Disaster Recovery Plan Development & Maintenance<ul><li>Lead the development of comprehensive enterprise-wide disaster recovery and business continuity plans aligned with organizational objectives and risk tolerance</li><li>Conduct thorough documentation of all critical systems, applications, data, and dependencies within the plan</li><li>Create detailed recovery procedures and step-by-step runbooks for each critical system and application</li><li>Establish and document recovery time objectives (RTO) and recovery point objectives (RPO) for all business-critical systems</li><li>Maintain up-to-date disaster recovery plans through regular reviews and updates (minimally quarterly or upon significant infrastructure changes)</li><li>Coordinate with system owners and business units to gather requirements and ensure plan accuracy and completeness</li><li>Document disaster recovery roles, responsibilities, and escalation procedures</li><li>Develop and maintain the Disaster Recovery Plan documentation, including executive summaries and detailed technical appendices</li><li>Ensure disaster recovery plans address various disaster scenarios (natural disasters, cyberattacks, infrastructure failures, etc.)</li><li>Archive and version control all disaster recovery documentation for historical reference and compliance</li></ul>Strategic Planning & Infrastructure Design<ul><li>Conduct comprehensive risk assessments and business impact analyses to identify critical systems and recovery priorities</li><li>Design recovery architectures and failover strategies for mission-critical applications and infrastructure</li><li>Evaluate and recommend disaster recovery technologies and solutions that align with organizational needs and budget</li><li>Develop disaster recovery strategies across multiple infrastructure environments (on-premises, cloud, hybrid)</li></ul>Program Management & Implementation<ul><li>Lead cross-functional teams to implement disaster recovery solutions across multiple business units and technical domains</li><li>Oversee procurement, configuration, and deployment of disaster recovery technologies and platforms</li><li>Manage disaster recovery budgets and resource allocation</li><li>Develop and manage disaster recovery documentation, runbooks, and standard operating procedures</li></ul>Testing & Validation<ul><li>Plan and execute regular disaster recovery drills and full-scale exercises to validate plan effectiveness</li><li>Analyze test results, identify gaps, and recommend improvements to recovery procedures</li><li>Maintain detailed records of all testing activities and outcomes</li><li>Coordinate with business stakeholders on tabletop exercises and scenario-based planning</li></ul>Compliance & Governance<ul><li>Ensure disaster recovery programs meet regulatory requirements and industry standards (ISO 27001)</li><li>Maintain compliance documentation and audit readiness</li><li>Develop disaster recovery policies and procedures</li><li>Conduct training and awareness programs for staff</li><li>Perform other related duties as assigned. </li></ul>Qualifications Minimum Qualifications: Applicants must meet the minimum qualification requirement by the final filing date unless otherwise noted.Education: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 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].Experience: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.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.SUPPLEMENTAL INFORMATIONEssential 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 per-forming data entry. May involve extensive VDT exposure.Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree.Desired Qualifications: The stated desirable qualifications may be considered at the end of the selection process when candidates are referred for hiring. <ul><li>Utility Industry experience</li><li>Six Sigma or similar process improvement certification</li><li>Experience with security and network infrastructure</li><li>Knowledge of IT service management frameworks (ITIL)</li></ul>Verification of Education and Experience:Every application is reviewed to ensure that you meet the minimum qualifications as listed in the job ad. Please review our articles on Employment Application and Minimum Qualifications and Verification of Experience and/or Education 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.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. Applications completed improperly may be cause for ineligibility, disqualification or may lead to lower scores. Additional Information Additional Information Regarding Employment with the City and County of San Francisco: <ul><li>Information About the Hiring Process</li><li>Conviction History</li><li>Employee Benefits Overview  </li><li>Equal Employment Opportunity </li><li>Disaster Service Worker</li><li>ADA Accommodation</li><li>Veterans Preference</li><li>Right to Work</li><li>Copies of Application Documents</li><li>Diversity Statement</li></ul> Applicants will receive a confirmation email from notification@careers.sf.gov 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.HOW TO APPLY Applications for City and County of San Francisco jobs are only accepted through an online process. Visit https://careers.smartrecruiters.com/CityAndCountyOfSanFrancisco1/ and begin the application process.<ul><li>Select the “I’m Interested” button and follow instructions on the screen</li></ul>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 updated. 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 from notification@careers.sf.gov 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. Job Analyst Information: If you have any questions regarding this recruitment or application process, please contact the job analyst, Sanly Guan at Sguan@sfwater.org <div></div>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.</div></div>

Calculate Moving Average	SQL	Easy
Predict Customer Churn	Machine Learning	Medium
A/B Test Significance	Statistics	Medium
Optimize Query Performance	SQL	Hard
Feature Importance Analysis	Machine Learning	Medium
Clean Missing Data	Python	Easy
Neural Network Architecture	Deep Learning	Hard
Calculate Cohort Retention	SQL	Medium
Bayesian Probability	Statistics	Easy
Recommend Similar Products	Machine Learning	Hard

City And County Of San Francisco Interview Questions

City And County Of San Francisco Interview Guides

City And County Of San Francisco Interview Questions

Challenge

City And County Of San Francisco Opening Jobs

Discussion & Interview Experiences

Discussion & Interview Experiences