ZipRecruiter
Senior Data Analyst- Department of Building Inspection (1823 PEX)
ZipRecruiter, San Francisco, California, United States, 94199
Overview
Appointment Type: Permanent Exempt (PEX). This position is excluded by the Charter from the competitive Civil Service examination process and shall serve at the discretion of the Appointing Officer.
Specific information regarding this recruitment process listed below:
Application Opening: September 15, 2025.
Application Deadline: Applicants are encouraged to apply immediately as this recruitment may close at any time, but no earlier than September 29, 2025.
Annual Salary for this position: $121,836 - $148,070
Recruitment ID: PEX-1823-EXEMPT
What We Do The Department of Building Inspection (DBI) oversees the effective, efficient, fair and safe enforcement of City building, housing, plumbing, electrical, mechanical, and access codes for San Francisco’s more than 200,000 buildings. This position is located in the Director’s Office.
Job Description Under the direction of the Data and Performance Manager, the Senior Data Analyst will plan, organize, lead, and conduct complex, sensitive, and detailed analytical work in support of departmental strategic planning efforts, policy development, decision-making, reporting, and communications. The Senior Data Analyst will also support department staff with process improvement efforts using quality improvement tools. A strong candidate would have experience performing analyses using mapping software such as ArcGIS; analytical programming such as R, Python, and SQL; and data visualization software such as Power BI. This position will work in a highly collaborative environment and assist with the department’s efforts to deliver permitting, inspection, and code enforcement functions efficiently, effectively, ethically, and equitably.
Important and Essential Duties
Develops and implements processes, procedures, and systems to clean, manage, store, and present large volumes of complex data, including creating and maintaining automated scripts;
Conducts geospatial analysis and uses geospatial software to support the work of the department;
Creates and maintains business intelligence dashboards and generates ad hoc reports;
Collaborates with staff from DBI and other departments to inform data system designs that will support flexible and accurate business analytics and efficient, effective, ethical, and equitable business processes;
Supports continuous improvement activities, using tools like Lean Six Sigma;
Prepares clear, comprehensive reports and presentations;
Provides data analysis expertise to inform business improvement and policy development;
Responds to internal and external informational and data requests, including those of a highly sensitive nature;
Performs related duties as assigned.
Knowledge, Skills, and Abilities
Knowledge of: the principles, procedures and standards related to government and/or non-profit management and operations; policy analysis; statistical, geospatial and other analytical methods; relational table databases; applicable local, state, and federal laws and regulations affecting departmental operations; the development and implementation of complex systems and procedures; program evaluation frameworks; and process improvement in government.
Ability to: collect, synthesize, and analyze a wide variety of information; conduct difficult analytical studies involving complex administrative and financial systems and procedures; identify and define problems, determine methodology, evaluate data, make recommendations with justification, and develop/implement a plan of action; effectively prioritize and organize multiple assignments and projects; exercise sound judgment; coordinate work with other programs and departments; establish and maintain effective working relationships with departmental representatives, senior management, representatives of other departments/agencies, officials, contractors and the general public; negotiate effectively; communicate clearly and concisely; elicit information; prepare clear, accurate, well-organized written documents and management reports; use computers to research, access, extract and process data; use Windows-based software (Word, Excel, PowerPoint); use data management systems such as Oracle Developer/MS SQL Developer; use analytical coding such as Python, R, and SQL; use geospatial analysis software such as ArcGIS; use data visualization software such as PowerBI; create and maintain records; prepare correspondence, reports and other documentation, including statistical data.
Minimum Qualifications Possession of a baccalaureate degree from an accredited college or university and three (3) years full-time equivalent experience performing professional-level analytical work. Qualifying professional-level analytical work includes analysis, development, administration, and reporting in major programs and functions of an organization in the areas of budgets, contracts, grants, policy, or other functional areas related to the duties of positions in the 182X Class series.
Substitution Possession of a graduate degree (Master's degree or higher) from an accredited college or university with major coursework in specialized subject matter areas such as public or business administration, management, business law, contract law, public policy, urban studies, economics, statistical analysis, finance, accounting or other fields of study closely related to the essential functions of positions in the Class series may be substituted for one (1) year of required experience.
Additional experience as described above may be substituted for the required degree on a year-for-year basis (up to a maximum of 2 years). Thirty (30) semester units or forty-five (45) quarter units equal one year.
Verification of Education and Experience Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. More information can be found at the information page about hiring process verification.
Additional Information 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.
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.
Additional Information – Employment Resources
Information About the Hiring Process
Conviction History
Employee Benefits Overview
Equal Employment Opportunity
Disaster Service Worker
ADA Accommodation
Right to Work
Copies of Application Documents
Statement
How to Apply All job applications for the City and County of San Francisco must be submitted through our online portal. Please visit the careers portal to begin your application process. No other methods of application will be accepted.
Computers are available for the public (9:00 a.m. to 4:00 p.m. Monday through Friday) to file online applications in the lobby of the Department of Human Resources and at the City Career Center at City Hall.
Ensure your application information is accurate, as changes may not be possible after submission. Your first and last name must match your legal ID for verification, and names can be included in parentheses. Use your personal email address, not a shared or work email, to avoid unfixable issues.
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.
Upon successful submission, applicants will receive a confirmation email from the recruitment system. Keep this email for your records. If you do not receive it, your application was not submitted successfully.
Recruitment Analyst Information If you have any questions regarding this recruitment or application process, please contact the analyst via email.
EEO Statement The City and County of San Francisco encourages women, minorities and persons with disabilities to apply. Applicants will be considered regardless of ancestry, physical or mental condition, medical condition (including cancer), HIV/AIDS status, genetic information, marital status, military or veteran status, or other protected category under the law.
#J-18808-Ljbffr
Specific information regarding this recruitment process listed below:
Application Opening: September 15, 2025.
Application Deadline: Applicants are encouraged to apply immediately as this recruitment may close at any time, but no earlier than September 29, 2025.
Annual Salary for this position: $121,836 - $148,070
Recruitment ID: PEX-1823-EXEMPT
What We Do The Department of Building Inspection (DBI) oversees the effective, efficient, fair and safe enforcement of City building, housing, plumbing, electrical, mechanical, and access codes for San Francisco’s more than 200,000 buildings. This position is located in the Director’s Office.
Job Description Under the direction of the Data and Performance Manager, the Senior Data Analyst will plan, organize, lead, and conduct complex, sensitive, and detailed analytical work in support of departmental strategic planning efforts, policy development, decision-making, reporting, and communications. The Senior Data Analyst will also support department staff with process improvement efforts using quality improvement tools. A strong candidate would have experience performing analyses using mapping software such as ArcGIS; analytical programming such as R, Python, and SQL; and data visualization software such as Power BI. This position will work in a highly collaborative environment and assist with the department’s efforts to deliver permitting, inspection, and code enforcement functions efficiently, effectively, ethically, and equitably.
Important and Essential Duties
Develops and implements processes, procedures, and systems to clean, manage, store, and present large volumes of complex data, including creating and maintaining automated scripts;
Conducts geospatial analysis and uses geospatial software to support the work of the department;
Creates and maintains business intelligence dashboards and generates ad hoc reports;
Collaborates with staff from DBI and other departments to inform data system designs that will support flexible and accurate business analytics and efficient, effective, ethical, and equitable business processes;
Supports continuous improvement activities, using tools like Lean Six Sigma;
Prepares clear, comprehensive reports and presentations;
Provides data analysis expertise to inform business improvement and policy development;
Responds to internal and external informational and data requests, including those of a highly sensitive nature;
Performs related duties as assigned.
Knowledge, Skills, and Abilities
Knowledge of: the principles, procedures and standards related to government and/or non-profit management and operations; policy analysis; statistical, geospatial and other analytical methods; relational table databases; applicable local, state, and federal laws and regulations affecting departmental operations; the development and implementation of complex systems and procedures; program evaluation frameworks; and process improvement in government.
Ability to: collect, synthesize, and analyze a wide variety of information; conduct difficult analytical studies involving complex administrative and financial systems and procedures; identify and define problems, determine methodology, evaluate data, make recommendations with justification, and develop/implement a plan of action; effectively prioritize and organize multiple assignments and projects; exercise sound judgment; coordinate work with other programs and departments; establish and maintain effective working relationships with departmental representatives, senior management, representatives of other departments/agencies, officials, contractors and the general public; negotiate effectively; communicate clearly and concisely; elicit information; prepare clear, accurate, well-organized written documents and management reports; use computers to research, access, extract and process data; use Windows-based software (Word, Excel, PowerPoint); use data management systems such as Oracle Developer/MS SQL Developer; use analytical coding such as Python, R, and SQL; use geospatial analysis software such as ArcGIS; use data visualization software such as PowerBI; create and maintain records; prepare correspondence, reports and other documentation, including statistical data.
Minimum Qualifications Possession of a baccalaureate degree from an accredited college or university and three (3) years full-time equivalent experience performing professional-level analytical work. Qualifying professional-level analytical work includes analysis, development, administration, and reporting in major programs and functions of an organization in the areas of budgets, contracts, grants, policy, or other functional areas related to the duties of positions in the 182X Class series.
Substitution Possession of a graduate degree (Master's degree or higher) from an accredited college or university with major coursework in specialized subject matter areas such as public or business administration, management, business law, contract law, public policy, urban studies, economics, statistical analysis, finance, accounting or other fields of study closely related to the essential functions of positions in the Class series may be substituted for one (1) year of required experience.
Additional experience as described above may be substituted for the required degree on a year-for-year basis (up to a maximum of 2 years). Thirty (30) semester units or forty-five (45) quarter units equal one year.
Verification of Education and Experience Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. More information can be found at the information page about hiring process verification.
Additional Information 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.
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.
Additional Information – Employment Resources
Information About the Hiring Process
Conviction History
Employee Benefits Overview
Equal Employment Opportunity
Disaster Service Worker
ADA Accommodation
Right to Work
Copies of Application Documents
Statement
How to Apply All job applications for the City and County of San Francisco must be submitted through our online portal. Please visit the careers portal to begin your application process. No other methods of application will be accepted.
Computers are available for the public (9:00 a.m. to 4:00 p.m. Monday through Friday) to file online applications in the lobby of the Department of Human Resources and at the City Career Center at City Hall.
Ensure your application information is accurate, as changes may not be possible after submission. Your first and last name must match your legal ID for verification, and names can be included in parentheses. Use your personal email address, not a shared or work email, to avoid unfixable issues.
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.
Upon successful submission, applicants will receive a confirmation email from the recruitment system. Keep this email for your records. If you do not receive it, your application was not submitted successfully.
Recruitment Analyst Information If you have any questions regarding this recruitment or application process, please contact the analyst via email.
EEO Statement The City and County of San Francisco encourages women, minorities and persons with disabilities to apply. Applicants will be considered regardless of ancestry, physical or mental condition, medical condition (including cancer), HIV/AIDS status, genetic information, marital status, military or veteran status, or other protected category under the law.
#J-18808-Ljbffr