Sorry, this listing is no longer accepting applications. Don’t worry, we have more awesome opportunities and internships for you.

Data & Process Analyst - Office of the Controller, Accounting Division (1823) - 150060

City and County of San Francisco

Data & Process Analyst - Office of the Controller, Accounting Division (1823) - 150060

San Francisco, CA
Full Time
Paid
  • Responsibilities

    Job Description

    Accounting Operations and Suppliers Division (AOSD) is responsible for monitoring, tracking and approving citywide financial transactions in conformance with established procedures and controls. It is also responsible for establishing and maintaining citywide guidelines, policies, procedures and internal controls. The City’s financial system, PeopleSoft, is used extensively in this work. The City’s reporting and analytical tool, BI, and Excel are also heavily used.

    As part of the Supplier Management, Chartfield and Policy Team within the Accounting Operations & Suppliers Division (AOSD), performs professional-level and complex analytical work in the areas of data maintenance, reporting, and analysis; leads process enhancement projects to streamline Citywide employee reimbursement processes, workflows that require CON approval, and supplier onboarding processes; collaborates with other divisions in the Controller’s Office (CON) and other City departments to achieve the City’s financial and social economic strategic goals.

    Essential Duties

    • Create a comprehensive database of Citywide accounting/financial policies, job aids, canned responses, and other knowledge bases
    • Adopt use of AI for City users’ accounting/financial questions and troubleshooting requests
    • Automate and enhance workflows involving CON approval including Surplus Transfer, P-Card onboarding and maintenance, State Travel Program onboarding and maintenance, etc.
    • Integrate data from third party applications for CON managed card programs (e.g., US Bank Access Online) with PeopleSoft, and build reporting tools for both City internal users and the general public
    • Unify and enhance the business processes for Citywide travel purchases which are currently achieved through multiple mechanisms: employee reimbursement, P-Card, City booking from local travel agencies, and City booking through State Travel Program.
    • Analyze and align business processes to enhance data governance and use of AI
    • Prepare and develop metrics in calculating efficiencies and effectiveness of alignment of business process and technology
    • Develop solution options and makes recommendations to management accordingly on various business process enhancement projects; prepare and deliver regular management reports
    • Create and update desk procedures related to workflow design, report building, and data analysis; train and develop staff for succession planning
    • Prepare analyses and analytical reviews of City departments’ financial data supporting year-end activities
    • Create, validate and analyze the data for various departmental and Citywide projects
    • Maintain, validate and analyze supplier profile and ChartField data in PeopleSoft as assigned
    • Assume AOSD Financial & Accounting Support Team (FAST) assignments as necessary
  • Qualifications

    Qualifications

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

    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.

    Desired Qualification

    • Bachelor’s degree or above majoring in Compute Science
    • Proficiency in database management and data analysis
    • Experience with applying Artificial Intelligence to business processes
    • Strong written and oral communication skills

    Additional Information

    Appointment Type: Tempoary-Exempt (TEX) Appointment. Pursuant to the City & County of San Francisco Charter, Section 10.104.13. Any person occupying a position under exempt appointment shall not be subject to civil service selection, appointment, and removal procedures. Exempt employees shall serve at the pleasure of the appointing officer.

    Additional Information Regarding Employment with the City and County of San Francisco:

    HOW TO APPLY
    Applications for City and County of San Francisco jobs are only accepted through an online process. Visit https://careers.smartrecruiters.com/CityAndCountyOfSanFrancisco1/ and begin the application process.

    • Select the “I’m Interested” button and follow instructions on the screen

    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 (@sfgov.org, @sfdpw.org, @sfport.com, @flysfo.com, @sfwater.org, @sfdph.org, @asianart.org, @sfmta.com, @sfpl.org, @dcyf.org, @first5sf.org, @famsf.org, @ccsf.edu, @smartalerts.info, and @smartrecruiters.com).

    Applicants will receive a confirmation email 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.

    Analyst Information: If you have any questions regarding this recruitment or application process, please contact the analyst Timothy Liong at timothy.j.liong@sfgov.org

    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.

  • Industry
    Government Administration