Business Systems Analyst

Home Forums Job Openings Business Systems Analyst

This topic contains 0 replies, has 1 voice, and was last updated by  Ryan Caouette 4 years, 11 months ago.

  • Author
  • #181433

    Ryan Caouette

    The San Francisco Controller’s Office is looking for a Business Systems Analyst to support and develop the City’s budget, performance, and financial reporting systems, including the SFOpenBook open data/transparency website.

    The Business Systems Analyst will administer and troubleshoot the existing systems as well as develop new functionality. The analyst will be involved with all parts of the development cycle for projects small and large and will work closely with four colleagues and also with the user community of 600+.

    The software environment is IBM/Cognos Planning and Business Intelligence (v10), Informatica (v9) for Extract, Transform, and Load (ETL), and Oracle database (v11) on a Windows Server / VMWare operating layer. We use COBOL and Easytrieve minimally to get data off the legacy mainframe application (replacement of which is currently being evaluated). We also use Microsoft Access and Excel, IIS, HTML and Javascript.

    Ideal candidate

    The ideal candidate will possess a blend of business and technical savvy, an eye for the better way to do things and a logical, systematic and creative mind. The incumbent will be a self-starter and constant learner who wants to make it easier for the City’s knowledge workers to analyze data in support of the efficient and effective provision of City and County of San Francisco services.


    Possession of a baccalaureate degree from an accredited college or university, preferably in business administration, accounting, computer science or a closely related field; AND
    One (1) – two (2) years work experience performing systems analysis, programming, macro/script and Excel model development or closely related experience that demonstrates the knowledge and ability to assume responsibility for most if not all stages of the system development cycle.

    Company Description

    San Francisco is a vibrant and dynamic city, on the forefront of economic growth & innovation, urban development, arts & entertainment, as well as social issues & change. This rich tapestry of culture and ideas is sustained by our City’s commitment to heighten the quality of life for San Franciscans and citizens of the greater Bay Area. Our employees play an important role not only in making our City what it is today, but also in shaping the future of San Francisco. The City & County of San Francisco employs more than 28,000 individuals in a diverse array of services such as maintaining city streets and parks, driving buses and cable cars, providing public health services, keeping the streets safe and fire fighting.

    Click below to submit on-line application:

    Apply Here

You must be logged in to reply to this topic.