Career Opportunity
Power BI and City Data Project IT Director, MADI (1070-Technology Product Director)–DPH-166752
Recruitment: RTF0166751-01122962
Published: November 20, 2026
Apply using SmartRecruiters, the City and County of San Francisco's application portal.
Job class: 1070-IS Project Director
Salary range: $171,158.00 - $243,646.00
Role type: Permanent Civil Service What does this mean?
Hours: Full-time
Exam type: Contact us for more information
Rule: Contact us for more information
List type: Contact us for more information
About:
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.
This is a Position-Based Test conducted in accordance with CSC Rule 111A. Learn more about the City’s hiring process here: https://careers.sf.gov/knowledge/process/
- Application Opening: Friday, November 20, 2026
- Application Deadline: Application filing will close on or after Friday, December 11, 2026.
- Salary: $171,158 to $215,306 Annually
- Appointment Type: Permanent Civil Service
- Recruitment ID: PBT-1070-166752
- Work Arrangement: Onsite
Becoming a City employee means being a part of a team that cares about making a difference. Your work will shape both the present and future of San Francisco. When you work for the City, you’re choosing a job with purpose.
The Mission of the San Francisco Department of Public Health (SFDPH) is to protect and promote the health of all San Franciscans. Fulfilling this mission requires employees working across our hospitals, clinics, programs, and offices to deliver services and support the communities we serve. Individuals interested in joining SFDPH should expect to work in person across these settings.
The San Francisco Health Network, Population Health, Behavioral Health Services, and Administration are the core divisions of SFDPH. 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.
Critical to the delivery of care, population health surveillance, and healthcare outcomes for vulnerable populations are robust data platforms, comprehensive analysis, and agile reporting. The Metrics, Analytics, and Data Integration (MADI) team focuses on database creation and administration, master data management, and creating reporting standards and processes to integrate data from various sources.
Role description
The Power BI and City Data Project IT Director, MADI (1070-Technology Product Director) serves as the technical lead for enterprise data visualization and integrated data initiatives within SFDPH, including projects shared across City agencies and public-facing dashboards. Reporting to the DPH IT Analytics Director and Chief Data Officer, this position leads the development of enterprise Power BI solutions that support epidemiology, healthcare operations, community health programs, regulatory reporting, and population health initiatives, while managing complex IT projects that enhance data infrastructure, improve data quality, strengthen operations, and advance data-driven decision-making. The Director supervises a team of Power BI developers and data analysts and collaborates with healthcare providers, epidemiologists, program managers, leaders from other City agencies, and DPH executive leadership to ensure that data and technology solutions are accurate, secure, efficient, and aligned with health equity priorities, community well-being, and departmental strategic goals.
The Power BI and City Data Project IT Director, MADI (1070-Technology Product Director) performs the following essential job functions:
- Design, develop, and deploy enterprise Power BI dashboards and datasets supporting epidemiology, community health, emergency preparedness, and DPH operational performance
- Build scalable data models using Power Query, DAX, SQL, and cloud-based data platforms
- Ensure compliance with all public health data requirements, including privacy standards for PHI/PII, HIPAA, and local/state data-sharing regulations
- Develop and enforce Power BI governance standards, workspace management, role-based security, and data refresh protocols
- Partner with program teams to define KPIs, data standards, public health metrics, and common reporting frameworks
- Optimize analytical products for performance, reliability, and clarity for diverse users including leadership, field staff, epidemiologists, and partner agencies
- Provide mentoring and technical guidance to analysts, developers, and program staff using BI tools
- Coordinate multidisciplinary teams including IT, clinical leadership, analytics, operations and executive leadership
- Support strategic initiatives such as health equity analytics, community health assessments, emergency management dashboards, and population health metrics
- Ensure project alignment with DPH and City priorities, population health objectives, regulatory requirements, information security standards, and clinical workflow needs
- Provide transparent communication and status reporting to stakeholders and executive leadership
- Ensure that systems and processes meet public health regulations, data governance standards, and security requirements
- Oversee testing, documentation, training, go-live coordination, and post-implementation evaluation
The Power BI and City Data Project IT Director, MADI (1070-Technology Product Director) may perform other duties as assigned/required.
Please note that incumbents in this classification may be required to perform duties as listed in the class specification: https://careers.sf.gov/classifications/?classCode=1070&setId=COMMN
How to qualify
Required Minimum Qualifications
Education: An associate degree in computer science, information systems, business administration, UX/UI design 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], AND
Experience: Five (5) years of experience in digital product management, system administration, information systems development, maintenance and support, software engineering, or information technology project management, including two (2) years of
- experience leading a major technology product, system, or project involving cross-functional teams and multiple stakeholders, AND
- healthcare information technology experience*, AND
- SQL query experience*
License and Certification: None
Substitution: One year of additional experience as described above may be substituted for the required degree.
*The above minimum qualifications reflect special conditions associated with the position(s) to be filled. They may differ from the standard minimum qualifications associated with this classification.
Applicants must meet the minimum qualification requirement by the final filing date unless otherwise noted.
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).
DESIRABLE QUALIFICATIONS: The stated desirable qualifications may be considered at the end of the selection process when candidates are referred for hiring.
- Extensive experience developing Power BI dashboards, data models, and advanced DAX calculations
- SQL, data architecture, ETL processes, and enterprise BI systems experience
- Experience managing IT or data projects, preferably in a government, public sector, or public health environment
- Experience working with public health data sources, epidemiological datasets, and regulatory privacy requirements
- Experience collaborating with multidisciplinary teams including technical staff and non-technical program stakeholders
Verification of Education and Experience:
Every application is reviewed to ensure that you meet the minimum qualifications as listed in the job ad. Review SF Careers Employment Applications for considerations taken when reviewing applications.
Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. If education or experience verification is required, information on how to verify education and experience requirements, including verifying foreign education credits or degree equivalency, can be found at https://careers.sf.gov/knowledge/experience-education/.
Note: Falsifying one’s education, training, or work experience or attempted deception on the application may result in disqualification for this and future job opportunities with the City and County of San Francisco.
What else should I know?
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 (SQ): (Weight: 100%)
The Supplemental Questionnaire (SQ) is designed to measure the knowledge, skills, and abilities in job related areas which may include but not be limited to:
- Knowledge of healthcare information systems, EHR data, and healthcare financial and operational reporting to support strategic decision-making and enterprise reporting initiatives
- Knowledge of relational databases, SQL, business intelligence platforms, reporting technologies, and emerging data solutions to guide system design and reporting strategy
- Knowledge of data governance, data quality standards, validation methodologies, and reporting best practices to ensure accurate, reliable, and compliant information management
- Ability to provide strategic direction for the design, implementation, integration, and ongoing support of complex reporting and analytics solutions
- Ability to lead and oversee large-scale projects, programs, and technical teams, including priority setting, resource management, and delivery of organizational objectives
- Ability to analyze complex business and technology issues, exercise sound judgment, and recommend solutions that balance operational needs, risks, and long-term organizational goals
- Ability to communicate complex technical and business information effectively and build collaborative partnerships with executive leadership, staff, vendors, and other stakeholders
Candidates must achieve a passing score on the Supplemental Questionnaire (SQ) exam to continue in the selection process and will be placed on the confidential eligible list in rank order according to their final score.
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 the List.
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 6 months and may be extended with the approval of the Human Resources Director.
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.
To find Departments which use this classification, please see the city’s Position Counts by Job Codes and Departments.
Terms of Announcement and Appeal Rights
Applicants must be guided solely by the provisions of this announcement, including requirements, time periods and other particulars, except when superseded by federal, state or local laws, rules or regulations. Clerical errors may be corrected by the posting the correction on the Department of Human Resources website at https://careers.sf.gov/.
The terms of this announcement may be appealed under Civil Service Rule 111A.35.1. The standard for the review of such appeals is ‘abuse of discretion’ or ‘no rational basis’ for establishing the position description, the minimum qualifications and/or the certification rule. Appeals must include a written statement of the item(s) being contested and the specific reason(s) why the cited item(s) constitute(s) abuse of discretion by the Human Resources Director. Appeals must be submitted directly to the Executive Officer of the Civil Service Commission within five business days of the announcement issuance date.
Additional Information Regarding Employment with the City and County of San Francisco
- Information About the Hiring Process
- Conviction History
- Employee Benefits Overview
- Equal Employment Opportunity
- Disaster Service Worker
- ADA Accommodation
- Veterans Preference
- Seniority Credit in Promotional Exams
- Right to Work
- Copies of Application Documents
- Diversity Statement
Where to Apply
All job applications for the City and County of San Francisco must be submitted through our online portal. Please visit https://careers.sf.gov/ to begin your application process.
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.
Computers are available for the public (9:00 a.m. to 4:00 p.m. Monday through Friday) to file online applications in the lobby of the Dept. of Human Resources at 1 South Van Ness Avenue, 4th Floor and at the City Career Center at City Hall, 1 Dr. Carlton B. Goodlett Place, Room 110.
Ensure your application information is accurate, as changes may not be possible after submission. Your first and last name must match your legal ID for verification, and preferred names can be included in parentheses. Use your personal email address, not a shared or work email, to avoid unfixable issues.
Applicants will receive a confirmation email from notification@smartrecruiters.com 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 analyst, Marielle Saldajeno at marielle.saldajeno@sfdph.org or (628) 271-6820.
We may use text messaging to communicate with you on the phone number provided in your application. By applying, you accept the Trust and Privacy Policy and you may opt out of text messaging anytime.
POSITION #: 01122962
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.
