Reports & Analytics Principal Business Analyst - Controller's Office (1054) - 168336

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.

Systems Division of the Controller’s Office:
The Systems Division of the Controller’s Office manages the City and County of San Francisco’s Enterprise Oracle and PeopleSoft Applications, which include PeopleSoft Human Capital Management (HCM), PeopleSoft Financials and Supply Chain Management (FSCM), PeopleSoft 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 FreshWorks.  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
• Application Deadline:  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 PeopleSoft Reports & Analytics in the PeopleSoft 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 configuration settings; working with the project team on transition plans for re-engineered business processes; analyzing and testing security roles and permissions; writing functional and technical specifications; designing and building solutions to specifications; developing and executing system and user acceptance test plans and evaluating test results; developing and providing support and training for users in person, on the phone and in workshops; writing business and system process and technical documentation; identifying, managing and escalating issues and risks throughout software development life cycle; supervising support resources, including recruitment, performance goals and reviews for subordinate staff; performing other duties as assigned.

Education: An associate degree in business administration, public administration, information systems, economics, finance, computer science, 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].

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:One year of additional experience as described above may be substituted for the required degree.

Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree.

Desirable Qualifications:

• Strong hands on experience with SQL Scripting and PL/SQL experience
• Demonstrated understanding of Data Warehouse concepts and working knowledge of data modeling in large data warehouses.
• Experience analyzing, creating, documenting functional business/application solutions with clients and/or end users for large complex systems.
• Experience with formal software development life cycle methodologies i.e. SDLC, .
• Working knowledge of business process flows used to support a complex Data warehouse, and experience in developing and executing Data Extraction and Dashboards.
• Expertise in utilizing appropriate tools for analyzing data, documenting processes, developing and testing prototype solutions, including Oracle SQL Query, Visio, MS Access, FTP.
• Senior level experience in enterprise relational database and/or On-line Analytical Processing (OLAP) modeling and design. 
• Two (2) years of PeopleSoft Financials and Supply Chain Management (FSCM) Experience.  Verifiable and recent experience with PeopleSoft Financials and Supply Chain Management (FSCM) enterprise resource planning systems 9.1 or higher, performing production support, data analysis, design and testing.
• Hands on experience with SQL Scripting and PL/SQL experience
• Experience working with DBAs, BI Dev, PeopleSoft and / or EBS Functional Teams, and Security teams to improve performance and data quality using Agile sessions
• Supporting the design and development of the Enterprise Data Warehouse
• Professional IS Business Analyst work experience in the Public Sector (Government or Nonprofit).  
• Familiarity with “Tier 1” ERP solutions.
• Demonstrated understanding of financial processing in a governmental environment. (Governmental Accounting and Financial Reporting Standards and practices including City, State, Federal requirements). This would include governmental budgeting, grants and project accounting, fund accounting, cost allocation, and work order.
• Demonstrated understanding of purchasing and inventory management in a large government or highly regulated environment. 
• Five (5) years experience analyzing, creating, documenting functional business/application solutions with clients and/or end users for large complex financial systems. 
• Experience with formal software development life cycle methodologies.
• Working knowledge of business process flows used to support a complex accounting system, and experience in developing and executing application test plans.
• Expertise in utilizing appropriate tools for analyzing data, documenting processes, developing and testing prototype solutions, including Oracle SQL Query, Visio, Beyond Compare, MS Access, FTP.
• Two (2) years experience supervising staff for a large-scale IT system conversion project.

Collaboration and Communication Skills

• Strong problem-solving skills with ability to design practical and effective data solutions.
• Excellent verbal and written communication skills, including the ability to explain technical concepts to non-technical stakeholders.
• A collaborative mindset with enthusiasm to work across diverse, cross-functional teams.
• Experience with project management collaboration including project updates, identification of risks.
• Proactive and facilitative experience with third party and other organization stakeholders and partners.

Mission alignment

• Commitment to equity, transparency, and ethical data use.
• Passion for public service using data to improve government services.

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.

SELECTION PLAN

Interviews:  Selected candidates will be invited to participate in one or more interviews at the Controller’s Office.

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
• Right to Work
• Copies of Application Documents
• Diversity Statement

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.