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

Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.

What factors could have biased this result, and what would you look into?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

Statistics

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

Let’s say you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.

The company has been consistently growing new users in the city from January to March.

What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

Product Metrics

<h3>Job Description</h3><div>Job Description:\n\nCompany Description 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/ Specific information regarding this recruitment process is listed below:Application Opening: 12/5/2025Application Deadline: Apply immediately. Application filing will be open at least until Friday, 12/12/25 at 5:00 PM (Pacific Time) and will close any time thereafter.Compensation: $149,994 to $188,682 annuallyRecruitment ID: PBT-1054-160041 San Francisco International Airport (SFO) is a world-class, award-winning airport that served more than 54 million guests in FY24/25. SFO offers non-stop flights to 60+ international cities on over 40 international carriers. The Bay Area's largest airport also connects non-stop with 80+ U.S. cities on 10 domestic airlines. As an enterprise department of the City & County of San Francisco, SFO has a workforce of approximately 1,900 City employees. In Fiscal 2021, SFO generated more than 28,000 direct jobs and $6.1B in business activity. SFO is more than an airport —we are a dynamic organization where employees collaborate with a wide range of stakeholders to support global travel, economic development, and public service. We are recognized as a leader in safety, environmental sustainability, and forward-thinking infrastructure, and continue to be at the forefront of transforming the travel experience. Our Vision, Mission, and Core Values shape our culture and operations as we continue to build a supportive, purpose-driven workplace where all employees can thrive. Our mission is to deliver an airport experience where people and our planet come first. Learn more about careers at SFO at flysfo.com, and follow us on Facebook, Instagram, YouTube, LinkedIn, Bluesky and Threads.Job Description People Technology Program Manager The People Technology Program Manager plays a vital role in leading people technology projects within the People, Performance & Development (PPD) section, ensuring that the Airport’s human resources systems are configured, optimized, and strategically aligned with business needs. The People Technology Program Manager provides oversight of system design, development, administration, and security; leads technology evaluations and implementations; directs project teams and vendors; partners closely with SFO ITT staff; and ensures compliance with City standards, policies, and best practices. This is a unique opportunity for a skilled professional who thrives at the intersection of technology, people, and business transformation. You will elevate the impact of people technology by improving processes, strengthening data-driven decision-making, and ensuring employees have seamless access to secure and modern systems. You will work on a nimble, customer-service and solution-oriented team and report to the People Analytics and Engagement Manager. Why You’ll Love This Role As the People Technology Program Manager, you will see the tangible results of your work in every employee interaction with people-focused systems. You will:Drive meaningful change by transforming complex HR and workforce processes into intuitive, modern, and equitable systems that enhance the employee experience.Empower employees and leaders through innovative solutions that streamline workflows, strengthen data integrity, and enable better, faster decision-making.Elevate workforce analytics into a strategic advantage by translating complex data into clear, actionable insights. Your ability to manage large datasets, design meaningful dashboards, and communicate human capital trends in accessible terms will help SFO optimize workforce planning, strengthen equity, and anticipate organizational needs.Lead with influence and expertise by managing a portfolio of high-impact projects, mentoring analysts, and collaborating across SFO, including close partnerships with ITT staff on backend, integration, and security issues.Safeguard critical systems by owning role-based access for internal HR systems and applications, ensuring proper permission controls, and conducting regular audits of permissions and compliance.Shape the future of People Technology at SFO by identifying opportunities for automation, data integration, and next-generation HR technologies. Your work will directly support SFO’s mission to deliver an extraordinary airport experience and ensure that its most important resource, its people, thrive. Key Responsibilities The People Technology Program Manager provides oversight, direction, and expert-level analysis across the full systems development life cycle and ongoing administration of people technology systems. Core responsibilities include: Supervision and LeadershipSupervise and mentor staff, ensuring adherence to policies, quality standards, and professional development goals.Provide guidance on system configurations, dashboards, workflows, and application enhancements.Oversee the intake, prioritization, and assignment of requests for system improvements, integrations, and user support. Project LeadershipServe as the project leader for large-scale people technology initiatives, including system upgrades, enterprise integrations, and platform governance.Prepare project plans, budgets, proposals, and technical specifications; ensure projects are delivered on time and within scope.Manage vendor relationships, contracts, and service quality. Technical ExpertisePerform and oversee needs assessments, feasibility studies, cost-benefit analyses, and solution design.Lead configuration, testing, implementation, and post-implementation support for people technology solutions.Partner with SFO ITT staff to troubleshoot and resolve complex backend architecture issues (e.g., authentication failures, broken integrations, SQL Server maintenance).Ensure compliance with City standards, platform governance rules, and security policies. Workforce Analytics & ReportingTranslate workforce data into compelling insights that inform HR strategy, operational efficiency, and leadership decisions.Manipulate and manage large, complex databases and spreadsheets, ensuring accuracy and integrity of human capital metrics.Design and deliver dashboards, scorecards, and workforce reports that highlight trends, risks, and opportunities for workforce optimization.Present findings in clear, accessible language for diverse audiences, from executives to frontline leaders, enabling data-driven workforce planning. Systems & Application SupportProvide expert oversight of applications built on Microsoft Power Platform (Power Apps, Power Automate, Power BI, SharePoint, MS Access) and integrations with systems such as DocuSign, Cornerstone, and external APIs.Approve and direct the development of new dashboards, enhancements, and workflows, ensuring that reports support data-driven decision-making.Review and validate data flows, system integrity, and reporting capabilities.Maintain long-term strategies for platform stability, scalability, and user adoption. Security & Role ManagementDefine and map role-based access controls and permissions for PPD people technology systems while partnering with SFO ITT to manage and update as roles and permissions as needed.Conduct periodic security audits to ensure compliance with City and ITT standards, privacy regulations, and industry best practices.Collaborate with SFO ITT staff to implement governance rules, secure data, and safeguard sensitive employee information. Stakeholder EngagementAct as the senior liaison between the People Technology team, ITT, and business users.Translate business requirements into system solutions that align with PPD’s objectives.Develop and deliver training, communications, and change management support for end users.Qualifications Minimum Qualifications: Education: An associate degree in 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 computer science 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. Special Condition: Workforce Analytics Experience - 2 years of recent and verifiable experience performing data reporting and analysis on human capital metrics or in a comparable field, and within a large organization; translating complex data analysis and research principles into terms that can be understood by a broader audience; manipulating and managing large, complex databases, spreadsheets and queries and generating workforce analytics to optimize human resource 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 computer science or a closely related field. One-year full-time employment is equivalent to 2,000 hours (2,000 hours of qualifying work experience is based on a 40-hour work week). Any overtime hours that you work above 40 hours per week are not included in the calculation to determine full-time employment. Applicants must meet the minimum qualifications requirement by the final filing date unless otherwise noted. 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. 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. Note: Falsifying one’s education, training, or work experience or attempted deception on the application may result in disqualification for this and future job opportunities with the City and County of San Francisco. All work experience, education, training, and other information substantiating how you meet the minimum qualifications must be included on your application by the filing deadline. Information submitted after the filing deadline will not be considered in determining whether you meet the minimum qualifications. Resumes will not be accepted in lieu of a completed City and County of San Francisco application. Applications completed improperly may be cause for ineligibility, disqualification or may lead to lower scores. SELECTION PROCEDURES After application submission, candidates deemed qualified must complete all subsequent steps to advance in this selection process, which includes the following: Supplemental Questionnaire: (Weight: 100%) Candidates who meet the minimum qualifications will be sent a Supplemental Questionnaire. The Supplemental Questionnaire is designed to measure the knowledge, skills and abilities required for this position. All candidates’ responses to the Supplemental Questionnaire are subject to verification. All relevant experience, education and/or training must be included in the responses in order to be reviewed in the rating process. A passing score on the Supplemental Questionnaire must be achieved in order to be placed/ranked on the eligible list. Candidates will be placed on the eligible list in rank order according to their final score. NOTE: Applicants who meet the minimum qualifications are not guaranteed advancement through all of the steps in the selection procedure. Transportation Security Administration (TSA) Security Clearance: Candidates for employment with the San Francisco Airport Commission are required to undergo a criminal history record check, including FBI fingerprints, and Security Threat Assessment in order to determine eligibility for security clearance and may be required to undergo drug/alcohol screening. Per Civil Service Commission Rule Section 110.9.1, every applicant for an examination must possess and maintain the qualifications required by law and by the examination announcement for the examination. Failure to obtain and maintain security clearance may be basis for termination from employment with the Airport Commission. Medical Examination: Prior to appointment, candidates must successfully pass a medical examination to determine their ability to perform the essential functions of the job and/or the ability to meet the physical minimum requirements.Additional Information Eligible List/Score Report: A confidential eligible list of applicant names that have passed the civil service examination process will be created, and used for certification purposes only. An examination score report will be established, so applicants can view the ranks, final scores and number of eligible candidates. Applicant information, including names of applicants on the eligible list, shall not be made public unless required by law. However, an eligible list shall be made available for public inspection, upon request, once the eligible list is exhausted or expired and referrals resolved. The eligible list/score report resulting from this civil service examination process is subject to change after adoption (e.g., as a result of appeals), as directed by the Human Resources Director or the Civil Service Commission. The duration of the eligible list resulting from this examination process will be six (6) months and may be extended with the approval of the Human Resources Director. To find Departments which use this classification, please see https://sfdhr.org/sites/default/files/documents/Forms-Documents/Position-Counts-by-Job-Codes-and-Department-FY-2021-22.pdf . Certification: The certification rule for the eligible list resulting from this examination will be Rule of 10. The hiring department may administer additional position-specific selection procedures prior to making final hiring decisions. 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.smartrecruiters.com/CityAndCountyOfSanFrancisco1/ . The terms of this announcement may be appealed under Civil Service Rule 111A.35.1. The standard for the review of such appeals</div>

<h3>Job Description</h3><div>Job Description:\n\nCompany Description Who We Are The San Francisco Employees’ Retirement System (SFERS) is dedicated to securing, protecting, and prudently investing the pension trust assets, administering mandated beneﬁts programs, and providing promised beneﬁts to the active and retired members of the City and County of San Francisco. Established in 1889 as a fund for families and orphans of firefighters and police officers, today the San Francisco Employees’ Retirement System serves more than 75,000 active, vested, and retired employees of the City and County of San Francisco and their survivors. What We Do The Information Systems Division provides department-wide training and support to users of the department’s LAN and applications; coordinates City-provided technical services and support with the Department of Technology; manages the functional and technical teams assigned to develop and maintain the department’s Pension Administration system and Enterprise Content Management (ECM) project; oversees the department’s cybersecurity protocols; and leads the department’s disaster recovery and business resumption planning and policy efforts. Specific information regarding this recruitment process is listed below: This is a Position-Based Test conducted in accordance with CSC Rule 111A. Application Opening: November 26, 2025Application Deadline: May close at any time, but not before 5pm PST on Friday, December 5, 2025.Recruitment ID: PBT-1053-158819Appointment Type: Permanent Civil ServiceReporting Location: 1145 Market Street, San Francisco, CASalary range: $129,506 - $162,942Work Schedule: Full time, Monday – Friday, Hybrid Telecommuting work schedule available up to 1 telecommute day per week. This job announcement will not close before Friday, December 5, 2025. Interested applicants are encouraged to apply as soon as possible.Job Description What We’re Looking For Under general direction, the Senior IS Business Analyst is responsible for the successful completion and rollout of SFERS technology projects, including but not limited to strategically evolving the technology program, mitigating current risks, and establishing a technological foundation for future modernization. This role involves overseeing the entire development lifecycle and ongoing IT functions, participating in research, analysis, and documentation of business requirements for system changes and enhancements. The Senior IS Business Analyst will play a key role in analyzing and resolving complex systems problems, offering recommendations to meet user needs, and leading and coordinating critical projects. This position requires a proactive approach to system changes, meticulous documentation, and effective collaboration with cross-functional teams. Examples of primary duties may include:Enhance our technological resilience to ensure uninterrupted service delivery.Oversee the development-lifecycle and ongoing IT functions.Research, analyze, and document business requirements for changes and enhancements to the Enterprise Content Management system.Analyze and resolve complex systems problems.Provide recommendations to meet user’s needs.Document and submit service requests and trouble reports for the implementation of system changes.Participate in the analysis and prioritization of service requests.Respond to report requests and data requests.Write and modify reports and queries as needed to meet business needs.Develop and test system changes and coordinate testing by end users to ensure functionality and quality of modifications and enhancements.Update and maintain systems technical and procedure documentation.Consult on special requests for information and reports.Participate in audits, integrated reviews, improvement studies, and quality control reviews.Qualifications 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. Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree. How to Stand Out Desirable Qualifications: The stated desirable qualifications may be used to identify job finalists at the end of the selection process when candidates are referred for hiring.3 Years of experience with Hyland Perceptive or similar ECM application1 Year of programming experience with Hyland OnBase – Unity Forms development1 Year of experience with Microsoft Webinar application configurationKnowledge of UI/UX design principles and tools for creating visually appealing and user-friendly interfaces.Proficiency in testing methodologies, unit testing, integration testing, and debugging techniques. 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 application by the filing deadline. Information submitted after the filing deadline will not be considered in determining whether you meet the minimum qualifications. Resumes will not be accepted in lieu of a completed City and County of San Francisco application. Applications completed improperly may be cause for ineligibility, disqualification, or may lead to lower scores. SELECTION PROCEDURES After application submission, candidates deemed qualified must complete all subsequent steps to advance in this selection process, which include the following: Minimum Qualification Supplemental Questionnaire (Weight: Qualifying): Candidates will be prompted to complete a Supplemental Questionnaire as part of the online employment application. This Minimum Qualification 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 Minimum Qualification Supplemental Questionnaire will be used to evaluate if the applicant possesses the required minimum qualifications. Supplemental Questionnaire Evaluation: (Weight: 100%) Candidates who meet the minimum qualifications will be sent a supplemental questionnaire as part of the online employment application. 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: knowledge of and demonstrated skills in using the PeopleSoft Query Tool; knowledge of and demonstrated skills in Peoplesoft Human Capital Management Human Resources 9.x; knowledge of and demonstrated skills in Oracle / PeopleSoft applications, including Pension, Payroll, and Human Resources modules; knowledge of and demonstrated ability in Systems Development Life Cycle (SDLC) methodology with emphasis planning, requirements definition, design, testing, documentation, training, and support/maintenance; knowledge of pension, payroll, and human capital business processes; knowledge of training techniques; written communication ability; ability to exercise strong judgment, decisiveness, and creativity; and ability to prioritize competing requests and projects. A passing score must be achieved on the Supplemental Questionnaire Evaluation in order to be ranked on the eligible list. Please note that the answers to the supplemental questionnaire will be the main criteria for determining candidates' final scores and advancing to the next step of the selection process. Applicants meeting the minimum qualifications are not guaranteed advancement in the selection process. The department may administer additional selection procedures upon certification in order to make a final hiring decision. Candidates’ scores on this examination may also be applied to other announcements involving other job titles, when directed by the Human Resources Director. Upon approval of the Human Resource Director (see Civil Service Rule 111A.26.5), the eligible list 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 http://www.sfdhr.org/Modules/ShowDocument.aspx?documentID=21246. Search that document by title or job code to see which departments use the classification.Additional Information Eligible List/Score Report A confidential eligible list of applicant names that have passed the civil service examination process will be created, and used for certification purposes only. An examination score report will be established, so applicants can view the ranks, final scores and number of eligible candidates. Applicant information, including names of applicants on the eligible list, shall not be made public unless required by law. However, an eligible list shall be made available for public inspection, upon request, once the eligible list is exhausted or expired and referrals resolved. The eligible list/score report resulting from this civil service examination process is subject to change after adoption (e.g., as a result of appeals), as directed by the Human Resources Director or the Civil Service Commission. The duration of the eligible list resulting from this examination process will be six months, and may be extended with the approval of the Human Resources Director. Certification The certification rule for the eligible list resulting from this examination will be Rule of Three. Additional selection processes may be conducted by the hiring department prior to making final hiring decisions. 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 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:Information About The Hiring ProcessConviction HistoryEmployee Benefits Overview Equal Employment Opportunity Disaster Service WorkerADA AccommodationSeniority Credit in Promotional ExamsVeterans PreferenceRight to WorkCopies of Application DocumentsDiversity Statement HOW TO APPLY Applications for City and County of San Francisco jobs are only accepted through an online process. Visit careers.sf.gov and begin the application process.Select the “Apply Now” button and follow instructions on the screen. Applicants may be contacted by email about this recruitment and, therefore, it is their responsibility to ensure that their registered email address is accurate and kept up-to-date. Also, applicants must ensure that email from CCSF is not blocked on their computer by a spam filter. To prevent blocking, applicants should set up their email to accept CCSF mail from the following addresses (@sfgov.org, @sfdpw.org, @sfport.com, @flysfo.com, @sfwater.org, @sfdph.org, @asianart.org, @sfmta.com, @sfpl.org, @dcyf.org, @first5sf.org, @famsf.org, @ccsf.edu, @smartalerts.info, and @smartrecruiters.com). Applicants will receive a confirmation email that their online application has been received in response to every announcement for which they file. Applicants should retain this confirmation email for their records. Failure to receive this email means that the online application was not submitted or received. If you have any questions regarding this recruitment or application process, please contact the exam analyst, James Galileo, at James.Galileo@sfgov.org. 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.</div>

<h3>Job Description</h3><div>Job Description<div>Company Description Department: DataSF Job class: 1043 Senior Data Engineer Salary range: $153,686/year - $193,388/year  Role type: Permanent Exempt Hours: Full-time (Hybrid work schedule)About: Permanent Exempt: This is an Exempt position excluded by the Charter from the competitive Civil Service examination process, pursuant to the City and County of San Francisco, Charter Section 10.104. It is considered "at will" and shall serve at the discretion of the Appointing Officer.   Application Opening: Wednesday, November 19, 2025 Application Closing: Interested candidates are encouraged to apply as soon as possible, as this job announcement will close at any time, but not earlier than Friday, January 2, 2026As part of the application process, you must also complete a Supplemental Questionnaire using this link: https://forms.office.com/g/Dh3S0377ZVThe Office of the City Administrator and its 25+ divisions and departments operate core internal and public-facing services in San Francisco.    The Office of the City Administrator’s Mission and Vision  Our vision is to lead the nation in public administration and to enable City departments to effectively deliver critical public services. We aim to help the city run better, to connect San Francisco residents and constituents to the vital public services they seek, and to create a meaningful and diverse work culture that is the place of choice for people who are invested in a career in public service. We are committed to ensuring that City services are inclusive, efficient, equitable, and culturally competent for San Franciscans of all races, ethnic backgrounds, religions, and sextual orientations. This commitment requires comprehensive review and thorough analysis of existing practices and policies to remove barriers to real inclusion. We are also committed to ensuring that we have a safe, equitable, and inclusive workplace for individuals of all races. This includes creating opportunities for hiring, promotion, training, and development, for all employees, including but not limited to, Black, Indigenous, and people of color (BIPOC). To learn more about our departments, divisions, and programs, visit:  https://sf.gov/departments/city-administrator  About DataSF:Want to build robust and scalable data infrastructure to power data-driven City services? Join the DataSF team to empower and expand the use of data in government!Company DescriptionDataSF’s mission is to transform the way San Francisco works with data. We believe that data, when harnessed effectively, can improve transparency, resident engagement, and government performance. We are committed to removing barriers and making it easier for all people to access services and knowledge, and we actively seek team members whose diverse life experiences reflect the residents we serve.Job Description 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. If you are an entrepreneurial and passionate data enthusiast, join our team to improve government through good use of data!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 and more accessible for SF residents</li><li>Interest or experience in public sector data or social impact work</li></ul></li></ul>Qualifications 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 [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: Three (3) years of experience analyzing, installing, configuring, enhancing, and/or maintaining the components of an enterprise network.Substitution: Additional experience as described above may be substituted for the required degree on a year-for-year basis (up to a maximum of two (2) years). One (1) year is equivalent to thirty (30) semester units/ forty-five (45) quarter units with a minimum of 10 semester / 15 quarter units in one of the fields above or a closely related field.Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree.Verification: Please make sure it is clear in your application exactly how you meet the minimum qualifications. 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. Additional Information Selection Procedures The selection process will include evaluation of applications in relation to minimum requirements and assessment of candidates’ job-related knowledge, skills and abilities. Depending on the number of applicants, the Department may establish and implement additional screening mechanisms to evaluate candidate qualifications. This typically includes an oral interview and/or a written or performance exercise.If this becomes necessary, only those applicants whose qualifications most closely meet the Department needs will be invited to continue in the selection process. Applicants meeting the minimum requirements are not guaranteed advancement in the selection process. To find Departments which use this classification, please see: https://sfdhr.org/sites/default/files/documents/Forms-Documents/Position-Counts-by-Job-Codes-and-Department-FY-2022-23.pdf.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>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.<ul><li>Interested candidates are encouraged to apply as soon as possible, as this job announcement will close at any time, but not before Friday, January 2, 2026 (11:59 PM, PST)</li><li>Select the "Apply Now" button and follow instructions on the screen</li><li>You MUST include a cover letter.</li><li>As part of the application process, you must also complete a Supplemental Questionnaire using this link: https://forms.office.com/g/Dh3S0377ZV</li></ul>For best practices on the application process, please visit Apply for Jobs in the City and County of San Francisco Best Practices Guide. 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, @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.All your information will be kept confidential according to EEO guidelines.HR Analyst Information: If you have any questions regarding this recruitment or application process, please contact Debbie Yung at Debbie.Yung@SFGov.orgCondition of Employment: 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.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>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 The Department of Public Health prioritizes equitable and inclusive access to quality healthcare for its community and values the importance of diversity in its workforce. All employees at the Department of Public Health work to advance equity, inclusion, and diversity with a specific lens and focus on race, ethnicity, gender, sex, sexuality, disability, and immigration status. <ul><li>Application Opening: Friday, October 24th, 2025</li><li>Application Deadline: Wednesday, November 19, 2025*</li><li>Salary: $111,878-$140,738 Annually</li><li>Appointment Type: Permanent Civil Service</li><li>Recruitment ID: PBT-1052-155523-REF57618Q</li></ul>*Amended 11/17 to reflect change to selection procedures. If you applied previously, you do not need to reapply.The Mission of the San Francisco Department of Public Health (SFDPH) is to protect and promote the health of all San Franciscans. SFDPH strives to achieve its mission through the work of multiple divisions - the San Francisco Health Network, Population Health, Behavioral Health Services, and Administration. The San Francisco Health Network is the City’s only complete system of care and has locations throughout the City, including Zuckerberg San Francisco General Hospital and Trauma Center, Laguna Honda Hospital and Rehabilitation Center, and over 15 primary care health centers. The Population Health Division (PHD) provides core public health services for the City and County of San Francisco: health protection, health promotion, disease and injury prevention, and disaster preparedness and response. Behavioral Health Services operates in conjunction with SFHN and provides a range of mental health and substance use treatment services.The eligible list resulting from this recruitment may be utilized to fill future and current vacancies in this class at other locations within the DPH for the duration of the eligible list. Job Description Position DescriptionsApplications, ADS and IntegrationSupports and manages a portfolio of business-critical applications while working with various stakeholders to ensure system stability, performance, and integration. Responsibilities may include serving as the primary contact and collaborating with various stakeholders for incident resolution, system configuration, patch coordination, vendor communication, maintaining documentation, and ensuring compliance. The division also leads application enhancements and projects that drive operational efficiency.EpicConfigures, tests, implements, and supports the Epic electronic health record (EHR) system and its modules. Provides troubleshooting for physicians and staff, supports system upgrades, and collaborates across teams to meet clinical, revenue, and operational goals. Strong understanding of clinical workflows and revenue cycle processes is essential.Project Management Office (PMO) Supports the IT Program Management Office (PMO) by managing portfolio functions and providing administrative and analytical support. Assists with project intake, tracking, and reporting, and helps develop procedures, training materials, and knowledge bases. Experience in portfolio management within a healthcare system is preferred.Metrics and Data Analytics GIS Business AnalystCollaborates with Population Health, Street Health, and clinical teams to manage and analyze geospatial data. Works with IT developers to integrate data from street outreach, emergency preparedness, disease surveillance, and clinical systems to create visualizations and support data-driven insights.EXAMPLES OF IMPORTANT AND ESSENTIAL DUTIESAccording to Civil Service Commission Rule 109, the duties specified below are representative of the range of duties assigned to this job code/class and are not intended to be an inclusive list.1. Assess and optimize system designs through reviewing and analysis of user needs, customizing systems through system design and administration to meet the changing business needs of the users; participate in the development of planning for remote hardware and communications facilities.2. Analyze data processing needs; research and evaluate software on multiple platforms to assist users to meet their departmental goals; assist in developing the evaluation criteria for software.3. Determine operating characteristics and requirements; develop or modify and document general system design; write detailed design specifications; conduct "walkthroughs" for pro-posed solutions to system problems.4. Conduct feasibility studies; evaluate vendor products; make recommendations based on user requirements and systems analysis to ensure adequate planning.5. Monitor the maintenance and enhancement of complex computer and telecommunications systems to ensure proper functionality; provide support, analysis, coordination and assistance for networks, including disaster recovery.6. Troubleshoot software problems through telephone and site visit support; provide technical assistance in planning, engineering and architecture of unique systems for diverse applications; implement solutions to problems.7. Conduct user training.8. May install and maintain software; facilitate communication between clients and vendors regarding system maintenance issues; perform non-routine adds, moves and changes as needed.9. Test and modify software for network compatibility; participate in the detailed design and development of new applications; may write database applications.10. Update system software and make modifications to system configurations; facilitate data communication between systems platforms.11. Implement, maintain and update databases, tables and security access; create, document and compile manuals related to procedures.12. Participate and represent the department in computer user’s meetings or meetings of related committees.13. Research and evaluate technology through industry meetings, seminars, and vendor contacts; identify opportunities for improvements through automation; develop screen logic and reports.14. Create and generate reports and statistics to meet user and program requirements; inter-face with other departments, jurisdictions and users on regulations and reporting requests.15. Conduct database systems analysis and designs; may perform data normalization tasks; assist in the development of relational databases; assist in performance of data conversion tasks and maintenance of data dictionaries.Qualifications 1. EDUCATION:An associate degree in 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 computer science or a closely related field].AND2. EXPERIENCE:One (1) year in the information systems field, including technical support, content management, administration of network applications or system analysis.SUBSITUTION:<ul><li>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.</li><li>Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree.</li></ul>Applicants must meet the minimum qualification requirement by the final filing date unless otherwise noted. One-year fulltime employment is equivalent to 2,000 hours (2,000 hours of qualifying work experience is based on a 40-hour work week).Special Conditions:Positions with the EPIC team will require an Epic module certification.Some positions with Metrics, Analytics and Data Integration (MADI) team may require experience in Geographic Information System (GIS) performing analysis, design, development, testing, implementation, and production support for GIS applications.Special Conditions associated with other positions that may be filled with this list may include:<ul><li>Healthcare Information Technology Experience, PBX Programming Experience, SQL Query Experience</li></ul>Important Note: Please make sure it is absolutely clear in your application exactly how you meet the minimum qualifications. Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. Please be aware that any misrepresentation of this information may disqualify you from this recruitment or future job opportunities. Additional Information Selection Procedures: After application submission, candidates deemed qualified must complete all subsequent steps to advance in this selection process, which includes the following.Training and Experience Evaluation: (Weight: 100%) Candidates must achieve a passing score on the Training and Experience evaluation in order to continue in the selection process and will be placed on the confidential eligible list in rank order according to their final score. The link to the training and experience evaluation will be emailed to the address listed on the candidate’s online application. Candidates will be required to respond to the training and experience evaluation in the timeframe indicated. Additional selection processes may be conducted by the hiring department prior to making final hiring decisions.Certification  The certification rule for the eligible list resulting from this examination will be the Rule of List. Eligible List/Score Report:  Once you pass the exam, you will be placed onto an eligible list and given a score and a rank. For more information, visit https://careers.sf.gov/knowledge/process/ 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. How to apply:Applications for City and County of San Francisco jobs are only accepted online at careers.sf.gov.Our e-mail communications may come from more than one department so please make sure your email is set to accept messages from all of us at this link.Applicants may be contacted by email about this recruitment. Please consider using a personal email address that you check regularly rather than a work or school account.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.Terms of Announcement and Appeal Rights:This is a Position Based Test (PBT) administered in accordance with Civil Service Rule 111A.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: <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 Workers</li><li>Reasonable Accommodation</li><li>Right to Work</li><li>Copies of Application Documents</li><li>Diversity Statement</li><li>Veterans Preference</li><li>Seniority Credit in Promotional Exams </li></ul>If you have any questions regarding this recruitment or application process, please contact the analyst, Katrina Navarro at Katrina.navarro@sfdph.org or (628)271-6717. We may use text messaging to communicate with you on the phone number provided in your application. The first message will ask you to opt in to text messaging.<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 The Department of Public Health prioritizes equitable and inclusive access to quality healthcare for its community and values the importance of diversity in its workforce. All employees at the Department of Public Health work to advance equity, inclusion, and diversity with a specific lens and focus on race, ethnicity, gender, sex, sexuality, disability, and immigration status. <ul><li>Application Opening: Friday, October 24th, 2025</li><li>Application Deadline: Application filing will close on or after Wednesday, November 19, 2025*</li><li>Salary: $129,506-$162,942 Annually</li><li>Appointment Type: Permanent Civil Service</li><li>Recruitment ID: PBT-1053-155549-RTF0158117-01125969</li></ul>*Amended 11/14/25 to reflect change to selection procedures. If you applied previously, you do not need to reapply.The Mission of the San Francisco Department of Public Health (SFDPH) is to protect and promote the health of all San Franciscans. SFDPH strives to achieve its mission through the work of multiple divisions - the San Francisco Health Network, Population Health, Behavioral Health Services, and Administration. The San Francisco Health Network is the City’s only complete system of care and has locations throughout the city, including Zuckerberg San Francisco General Hospital and Trauma Center, Laguna Honda Hospital and Rehabilitation Center, and over 15 primary care health centers. The Population Health Division (PHD) provides core public health services for the City and County of San Francisco: health protection, health promotion, disease and injury prevention, and disaster preparedness and response. Behavioral Health Services operates in conjunction with SFHN and provides a range of mental health and substance use treatment services.The eligible list resulting from this recruitment may be utilized to fill future and current vacancies in this class at other locations within the DPH for the duration of the eligible list. Job Description Under general direction, oversees the more difficult and complex aspects of the systems development cycle, including needs analysis, cost-benefit analysis, structured systems analysis and design, feasibility analysis, technology and software assessment, telecommunications needs analysis, project planning and management, system installation, implementation and testing, conversion to production status, technical and procedural documentation, user training, and post-implementation assessment and administration; may be the primary MIS resource for an organization with a complex system.The Senior IS Business Analyst is the advanced journey level in the Business Analyst series. Positions at this level are distinguished from the journey level Business Analysts by the greater difficulty and complexity of the analytical tasks and are distinguished from the Principal by the limited supervisory responsibilities or the responsibility for smaller projects. Positions at this level require highly specialized knowledge, abilities, skills and experience and often exercise independent judgement in the performance of their duties; and possess technical or functional expertise beyond that expected at the journey level. Work is judged primarily on overall results with great latitude in determining work methods and assignment requirements. Employees have greater authority over assignments and decisions required to complete the work than lower-level positions.May provide limited supervision to professional subordinate positions, or assume responsibility for coordinating a defined program. However, supervisory responsibilities are ancillary to the main intent and focus of the positions.EXAMPLES OF IMPORTANT AND ESSENTIAL DUTIESAccording to Civil Service Commission Rule 109, the duties specified below are representative of the range of duties assigned to this job code/class and are not intended to be an inclusive list.1. Identify opportunities for improving business processes through automation; assist in the preparation of proposals to develop new systems.2. Analyze data processing needs; research and evaluate software on multiple platforms to assist users to meet their departmental goals; assist in developing the evaluation criteria for software.3. Determine operating characteristics and requirements; develop or modify and document general system design; write detailed design specifications; conduct "walkthroughs" for proposed solutions to system problems.4. Analyze the feasibility of and develop requirements for new systems and enhancements to existing systems; ensure the system design fits the needs of the users.5. May install and enhance software; program, test, debug and install new/modified programs.6. Provide technical support for computer and telecommunications systems; consult on the analysis of an application; troubleshoot system problems; implement solutions.7. Conduct system analysis and may conduct programming activities for complex systems; document new and modified systems and programs; coordinate user training in new capabilities; may convert new programming from test to production.8. Interface with users to determine system needs and requirements; instruct users on newly implemented systems; define system requirements; may design and code programs; review impact of system modifications on existing systems.9. Prepare, or assist clients in preparing, service requests to implement system changes; determine the level of effort required and the cost of implementing service requests; prioritize requests.10. May provide technical production support for on-line and batch systems; assist with setting processing schedule; update and produce reports.11. Coordinate with outside vendors and contractors to complete projects and service requests; define, assign and evaluate their work.12. May determine structure of databases; normalize data; perform conversion of data between platforms; design, develop and generate routine and ad hoc reports in response to user needs.13. Determine security levels for systems to ensure data integrity; test database applications to assure functionality and effectiveness in performing to desired specifications.Qualifications 1. 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].AND2. EXPERIENCE:Three (3) years in the information systems field, including system analysis, business process design, development and implementation of business application solutions or IT project management.ANDOne (1) of the three years of experience from above must include working with healthcare information (e.g. Public Health, Epidemiology, Health Insurance) technology or within a clinical systems environment.Substitution:Additional experience as described above may be substituted for the required degree on a year-for-year basis (up to a maximum of two (2) years). One (1) year is equivalent to thirty (30) semester units / forty-five (45) quarter units with a minimum of 10 semester / 15 quarter units in one of the fields above or a closely related field.Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree.Special Conditions:Positions with the EPIC team will require an Epic module certification.Some positions with Metrics, Analytics and Data Integration (MADI) team may require experience in Geographic Information System (GIS) performing analysis, design, development, testing, implementation, and production support for GIS applications.Special Conditions associated with other positions that may be filled with this list may include:<ul><li>Healthcare Information Technology Experience, PBX Programming Experience, SQL Query Experience, Applications Experience</li></ul>Important Note: Please make sure it is absolutely clear in your application exactly how you meet the minimum qualifications. Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. Please be aware that any misrepresentation of this information may disqualify you from this recruitment or future job opportunities. Additional Information Selection Procedures: After application submission, candidates deemed qualified must complete all subsequent steps to advance in this selection process, which includes the following.Training and Experience Evaluation: (Weight: 100%) Candidates must achieve a passing score on the Training and Experience evaluation in order to continue in the selection process and will be placed on the confidential eligible list in rank order according to their final score. The link to the training and experience evaluation will be emailed to the address listed on the candidate’s online application. Candidates will be required to respond to the training and experience evaluation in the timeframe indicated. Additional selection processes may be conducted by the hiring department prior to making final hiring decisions.Certification  The certification rule for the eligible list resulting from this examination will be the Rule of List. Eligible List/Score Report:  Once you pass the exam, you will be placed onto an eligible list and given a score and a rank. For more information, visit https://careers.sf.gov/knowledge/process/ 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. How to apply:Applications for City and County of San Francisco jobs are only accepted online at careers.sf.gov.Our e-mail communications may come from more than one department so please make sure your email is set to accept messages from all of us at this link.Applicants may be contacted by email about this recruitment. Please consider using a personal email address that you check regularly rather than a work or school account.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.Terms of Announcement and Appeal Rights:This is a Position Based Test (PBT) administered in accordance with Civil Service Rule 111A.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: <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 Workers</li><li>Reasonable Accommodation</li><li>Right to Work</li><li>Copies of Application Documents</li><li>Diversity Statement</li><li>Veterans Preference</li><li>Seniority Credit in Promotional Exams </li></ul>If you have any questions regarding this recruitment or application process, please contact the analyst, Katrina Navarro at Katrina.navarro@sfdph.org or (628)271-6717. We may use text messaging to communicate with you on the phone number provided in your application. The first message will ask you to opt in to text messaging.<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 The Department of Public Health prioritizes equitable and inclusive access to quality healthcare for its community and values the importance of diversity in its workforce. All employees at the Department of Public Health work to advance equity, inclusion, and diversity with a specific lens and focus on race, ethnicity, gender, sex, sexuality, disability, and immigration status. <ul><li>Application Opening: Friday, October 24th, 2025</li><li>Application Deadline: Wednesday, November 19, 2025*</li><li>Salary: $129,506-$162,942 Annually</li><li>Appointment Type: Permanent Civil Service</li><li>Recruitment ID: PBT-1053-155549-RTF0158117-01125969</li></ul>*Amended 11/14/25 to reflect change to selection procedures. If you applied previously, you do not need to reapply.The Mission of the San Francisco Department of Public Health (SFDPH) is to protect and promote the health of all San Franciscans. SFDPH strives to achieve its mission through the work of multiple divisions - the San Francisco Health Network, Population Health, Behavioral Health Services, and Administration. The San Francisco Health Network is the City’s only complete system of care and has locations throughout the city, including Zuckerberg San Francisco General Hospital and Trauma Center, Laguna Honda Hospital and Rehabilitation Center, and over 15 primary care health centers. The Population Health Division (PHD) provides core public health services for the City and County of San Francisco: health protection, health promotion, disease and injury prevention, and disaster preparedness and response. Behavioral Health Services operates in conjunction with SFHN and provides a range of mental health and substance use treatment services.The eligible list resulting from this recruitment may be utilized to fill future and current vacancies in this class at other locations within the DPH for the duration of the eligible list. Job Description Under general direction, oversees the more difficult and complex aspects of the systems development cycle, including needs analysis, cost-benefit analysis, structured systems analysis and design, feasibility analysis, technology and software assessment, telecommunications needs analysis, project planning and management, system installation, implementation and testing, conversion to production status, technical and procedural documentation, user training, and post-implementation assessment and administration; may be the primary MIS resource for an organization with a complex system.The Senior IS Business Analyst is the advanced journey level in the Business Analyst series. Positions at this level are distinguished from the journey level Business Analysts by the greater difficulty and complexity of the analytical tasks and are distinguished from the Principal by the limited supervisory responsibilities or the responsibility for smaller projects. Positions at this level require highly specialized knowledge, abilities, skills and experience and often exercise independent judgement in the performance of their duties; and possess technical or functional expertise beyond that expected at the journey level. Work is judged primarily on overall results with great latitude in determining work methods and assignment requirements. Employees have greater authority over assignments and decisions required to complete the work than lower-level positions.May provide limited supervision to professional subordinate positions, or assume responsibility for coordinating a defined program. However, supervisory responsibilities are ancillary to the main intent and focus of the positions.EXAMPLES OF IMPORTANT AND ESSENTIAL DUTIESAccording to Civil Service Commission Rule 109, the duties specified below are representative of the range of duties assigned to this job code/class and are not intended to be an inclusive list.1. Identify opportunities for improving business processes through automation; assist in the preparation of proposals to develop new systems.2. Analyze data processing needs; research and evaluate software on multiple platforms to assist users to meet their departmental goals; assist in developing the evaluation criteria for software.3. Determine operating characteristics and requirements; develop or modify and document general system design; write detailed design specifications; conduct "walkthroughs" for proposed solutions to system problems.4. Analyze the feasibility of and develop requirements for new systems and enhancements to existing systems; ensure the system design fits the needs of the users.5. May install and enhance software; program, test, debug and install new/modified programs.6. Provide technical support for computer and telecommunications systems; consult on the analysis of an application; troubleshoot system problems; implement solutions.7. Conduct system analysis and may conduct programming activities for complex systems; document new and modified systems and programs; coordinate user training in new capabilities; may convert new programming from test to production.8. Interface with users to determine system needs and requirements; instruct users on newly implemented systems; define system requirements; may design and code programs; review impact of system modifications on existing systems.9. Prepare, or assist clients in preparing, service requests to implement system changes; determine the level of effort required and the cost of implementing service requests; prioritize requests.10. May provide technical production support for on-line and batch systems; assist with setting processing schedule; update and produce reports.11. Coordinate with outside vendors and contractors to complete projects and service requests; define, assign and evaluate their work.12. May determine structure of databases; normalize data; perform conversion of data between platforms; design, develop and generate routine and ad hoc reports in response to user needs.13. Determine security levels for systems to ensure data integrity; test database applications to assure functionality and effectiveness in performing to desired specifications.Qualifications 1. 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].AND2. EXPERIENCE:Three (3) years in the information systems field, including system analysis, business process design, development and implementation of business application solutions or IT project management.ANDOne (1) of the three years of experience from above must include working with healthcare information (e.g. Public Health, Epidemiology, Health Insurance) technology or within a clinical systems environment.Substitution:Additional experience as described above may be substituted for the required degree on a year-for-year basis (up to a maximum of two (2) years). One (1) year is equivalent to thirty (30) semester units / forty-five (45) quarter units with a minimum of 10 semester / 15 quarter units in one of the fields above or a closely related field.Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree.Special Conditions:Positions with the EPIC team will require an Epic module certification.Some positions with Metrics, Analytics and Data Integration (MADI) team may require experience in Geographic Information System (GIS) performing analysis, design, development, testing, implementation, and production support for GIS applications.Special Conditions associated with other positions that may be filled with this list may include:<ul><li>Healthcare Information Technology Experience, PBX Programming Experience, SQL Query Experience, Applications Experience</li></ul>Important Note: Please make sure it is absolutely clear in your application exactly how you meet the minimum qualifications. Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. Please be aware that any misrepresentation of this information may disqualify you from this recruitment or future job opportunities. Additional Information Selection Procedures: After application submission, candidates deemed qualified must complete all subsequent steps to advance in this selection process, which includes the following.Training and Experience Evaluation: (Weight: 100%) Candidates must achieve a passing score on the Training and Experience evaluation in order to continue in the selection process and will be placed on the confidential eligible list in rank order according to their final score. The link to the training and experience evaluation will be emailed to the address listed on the candidate’s online application. Candidates will be required to respond to the training and experience evaluation in the timeframe indicated. Additional selection processes may be conducted by the hiring department prior to making final hiring decisions.Certification  The certification rule for the eligible list resulting from this examination will be the Rule of List. Eligible List/Score Report:  Once you pass the exam, you will be placed onto an eligible list and given a score and a rank. For more information, visit https://careers.sf.gov/knowledge/process/ 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. How to apply:Applications for City and County of San Francisco jobs are only accepted online at careers.sf.gov.Our e-mail communications may come from more than one department so please make sure your email is set to accept messages from all of us at this link.Applicants may be contacted by email about this recruitment. Please consider using a personal email address that you check regularly rather than a work or school account.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.Terms of Announcement and Appeal Rights:This is a Position Based Test (PBT) administered in accordance with Civil Service Rule 111A.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: <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 Workers</li><li>Reasonable Accommodation</li><li>Right to Work</li><li>Copies of Application Documents</li><li>Diversity Statement</li><li>Veterans Preference</li><li>Seniority Credit in Promotional Exams </li></ul>If you have any questions regarding this recruitment or application process, please contact the analyst, Katrina Navarro at Katrina.navarro@sfdph.org or (628)271-6717. We may use text messaging to communicate with you on the phone number provided in your application. The first message will ask you to opt in to text messaging.<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>

Question	Topic	Difficulty	Ask Chance
Boarding Times Bias	Statistics	Medium	Very High
Hundreds of Hypotheses	Statistics	Medium	Very High
Decreasing Comments	Product Metrics	Easy	Very High

City And County Of San Francisco Interview Questions

City And County Of San Francisco Interview Guides

City And County Of San Francisco Interview Questions

City And County Of San Francisco Opening Jobs