Reports & Analytics Principal Business Analyst - Controller's Office

• Full-time
• Job Code and
  
  Title:
  
  1054-IS Business Analyst-Principal
• Fill Type:
  Temporary Exempt

APPOINTMENT TYPE
:
Temporary Exempt (TEX) - Category 17. This position is a temporary backfill an employee on leave (limit of 2 years).
The Controller is the chief financial officer and auditor for the City and County of San Francisco (City).The Office of the Controller’s mission is to ensure the City’s financial integrity and promote efficient, effective and accountable government. Its vision is to be a model for good government and to make the City a better place. Our team includes financial, technology, analytical and other professionals.

We value the diverse backgrounds, perspectives and lived experiences of our teams and clients in everything we do. We work in a collaborative and inclusive environment, promote equal opportunity, and invest in the professional development and wellbeing of our team members. You can expect to work alongside colleagues who are committed to serving the public with integrity and want to see positive impacts from their work.

We are looking for smart, motivated individuals who want to make a difference and use government to play a role in solving our City’s problems, including addressing long-standing and harmful disparities in our communities. For a career with purpose and professional growth, join us in the Controller’s Office.

The Systems Division of the Controller’s Office manages the City and County of San Francisco’s Enterprise Oracle and People Soft Applications, which include People Soft Human Capital Management (HCM), People Soft Financials and Supply Chain Management (FSCM), People Soft Enterprise Learning Management (ELM), and Oracle Business Intelligence. These applications are branded locally as our SF People & Pay, SF Financials, SF Procurement, SF Learning, and SF Reports and Analytics systems.

Collectively, these applications provide a robust, integrated platform that delivers mission-critical services to 55 City Departments, eliminating the need for hundreds of independent legacy systems and customized applications. The division serves over 35,000 active City employees, 75,000 retirees and 25,000 City vendors (bidders and suppliers). Peripheral and legacy applications also leveraged by the division include Oracle Identify & Access Management, Snowflake, Sherpa Budget Formulation & Management, Phire Architect, Control-M, and Fresh Works.

The technology implemented and maintained by the Systems Division provides standardization, transparency, and efficiency for the City’s crucial business processes. Users are fully supported to ensure adoption of these interconnected systems.

Specific information regarding this recruitment process are listed below:

• Application Opening
  : 9/28/2026
• Final date to receive applications
  :
  May close anytime but no sooner than Friday, 10/19/2026 at 5:00PM (PDT).
• Compensation
  : $155,298 - $195,338

The Principal Business Analyst position will be part of the SF Reports & Analytics Team and will work with City and County staff to support People Soft Reports & Analytics in the People Soft Financials System. The analyst will perform both functional (business process and systems analysis, testing, user support) and technical (report, query and dashboard development, data extract, load and transformation, metadata modeling, tuning, and troubleshooting) tasks.

Essential duties include but are not limited to: analyzing the interrelationships of business processes, complex financial data and systems to develop reporting requirements and data structures; performing fit/gap analysis; defining and implementing application…