Career Opportunity

Junior Governance & Reporting Analyst (Hybrid Workplace) - Controller's Office (1820)

Recruitment: RTF0135795-01154415

Published: June 15, 2023

Apply using SmartRecruiters, the City and County of San Francisco's application portal.

About:

Hybrid Workplace: 
Our workplace has a hybrid/flexible weekly schedule, where colleagues work 1 day onsite (in the San Francisco office) and 4 days from home, subject to periodic review and approval.

The Controller is the City’s chief financial officer. Our team includes financial, technology, analytical and other professionals who work hard to secure the City’s financial integrity and promote efficient, effective and accountable government. We hold ourselves to high standards and strive to be a model for good government. 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 Oracle Interaction Hub, 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 Employee Portal, 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, 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 functionalities. 

• Application Opening: 6/13/2023
• Application Deadline: 6/16/2023 
• Compensation Range: $72,150 to $87,724 annually (please note: salary will increase July 1, 2023)

Role description

The Role

The Junior Governance & Reporting Analyst reports to the PMO Manager. Responsibilities include supporting the Division’s project management governance framework, performance reporting, operational improvements, integrated planning capabilities, and portfolio management services to systematically improve data-driven decision-making. This Junior Analyst will have the opportunity to mature the Division’s processes, promote PMO strategies and initiatives, and formulate viable recommendations to improve business operations and project management methodologies.

Responsibilities

1. Conducts field surveys and carries out routine research in connection with budget, legislative or management studies, and/or performs analysis of actual expenditures compared to the budget or public policy issues
2. Assists in conducting difficult and complex analysis, procedural, organizational, and operational investigations, quantitative and qualitative data analysis, surveys and/or research relating to department/agency operations
3. Provides routine information to departmental personnel on the preparation of budget and policy documents, reports, demographics, and program implementation
4. Researches, analyzes, and updates the Service Delivery and PMO policies & procedures for the City and CON-Systems
5. Analyzes, coordinates, and maintain time entry system, and continuous monitoring billable hours
6. Assists with preparation of the monthly, quarterly, and annual Comprehensive time and financial Report for each of the functional teams.
7. Assists with tracking and maintaining weekly project status dashboard and resource forecasting.
8. Analyzes and monitor Service Delivery tool KPIs by functional teams for reporting purposes
9. Assists in preparing reports and proposals
10. Prepares graphs and charts for presentations
11. Assists in the preparation of quarterly and year-end financial, program and budget, and legislative reports
12. Inputs and maintains data in computerized system and generates computerized reports.
13. Analyzes data structure, quality, inputs, and controls to identify risks and implements industry standard data governance practices
14. Assists with planning and execution of data cleanup initiatives
15. Develops operational dashboards and reports to empower individuals and teams to make better data-driven decisions
16. Develops new and improved existing standard operating procedures
17. Drives continuous process improvement by collaborating with stakeholders on design of business and technology solutions
18. Assists team members to establish a consistent level of quality, accuracy, and compliance with departmental standards
19. Prepares and presents performance, project, and executive reports
20. Performs other duties as assigned

A Successful Candidate Will…

• Operate effectively with teams and senior management
• Demonstrate comfort leading, negotiating, and influencing others
• Demonstrate strong planning, communication, organizational, and exceptional collaboration skills
• Demonstrate a broad understanding of project management, information technology service management, data governance, and reporting methodologies
• Demonstrate a strong understanding of the functional business areas supported by the Systems Division – City Finance, Accounting, Procurement, Budget, Human Resources, Benefits, Payroll, and Learning
• Think strategically and see the big picture, while also effectively managing the details, understanding interdependencies and constraints between systems and processes, and driving a project from start-to-finish
• Demonstrate strong oral and written communication skills, as well as the ability to think clearly, analyze quantitatively, solve problems, scope business requirements, and effectively prioritize planned and unplanned work.

Impact of Results:

Increased standardization and adoption of Division-wide methodologies, business processes, tools, and governance framework; resulting in a more transparent planning process, more effective project execution, and increased stakeholder, end user, and team satisfaction.

How to qualify

These minimum qualifications establish the education, training, experience, special skills and/or license(s) which are required for employment in the classification. Additional qualifications (i.e. special conditions) may apply to a particular position and will be stated in the job ad.

Possession of a baccalaureate degree from an accredited college or university

Substitution:

May substitute up to 2 years of the required education with qualifying full-time, professional-level experience in budget analysis, financial analysis and reporting, legislative/policy.

What else should I know?

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.

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

CONDITION OF EMPLOYMENT:  All City and County of San Francisco employees are required to be fully vaccinated against COVID-19 as a condition of employment. Someone is fully vaccinated when 14 days have passed since they received the final dose of a two-shot vaccine or a dose of a one-shot vaccine. Any new hire must present proof of full vaccination status to be appointed. Any new hire who will be routinely assigned or occasionally enter High-Risk Settings, must provide proof of having received a COVID-19 booster vaccine by March 1, 2022, or once eligible.

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.