IS Business Analyst - CSB (SFPUC) - 1052

{
  "content_hash": "e8b01e6e3860c98dc5766c791f83db8b3c69b95d48d16e7887073858a3136d73",
  "source_hash": "3294348179d834329c7694276594afd0311b74e7447b30231b15fd17f2cb826d",
  "last_changed_at": "2026-06-20T11:11:57.093Z",
  "active_status": "active"
}

{
  "dedupe": null,
  "language": "en",
  "location": {
    "raw": "San Francisco, CA, United States",
    "city": "San Francisco",
    "region": "CA",
    "country": "United States",
    "is_remote": false,
    "confidence": 0.8
  },
  "salary_max": 145704,
  "salary_min": 115830,
  "inferred_at": "2026-06-22T11:55:10.360Z",
  "launch_scope": {
    "reason": "english_us_canada",
    "included": true,
    "language": "en",
    "location": {
      "raw": "San Francisco, CA, United States",
      "city": "San Francisco",
      "region": "CA",
      "country": "United States",
      "is_remote": false,
      "confidence": 0.8
    },
    "countries": [
      "United States"
    ]
  },
  "remote_policy": null,
  "salary_period": "hour",
  "workplace_type": null,
  "salary_currency": "USD"
}

{}

{
  "id": "3743990013716117",
  "ref": "https://api.smartrecruiters.com/v1/companies/cityandcountyofsanfrancisco1/postings/3743990013716117",
  "name": "IS Business Analyst - CSB (SFPUC) - 1052",
  "uuid": "3893b107-2b72-4913-906e-d02bc3f3de5f",
  "detail": {
    "id": "3743990013716117",
    "name": "IS Business Analyst - CSB (SFPUC) - 1052",
    "uuid": "3893b107-2b72-4913-906e-d02bc3f3de5f",
    "jobAd": {
      "sections": {
        "jobDescription": {
          "text": "<p><strong>Project:</strong></p><p>Power Business and Systems - Document Business Process Implementation Project&#xa0;</p><p><strong>Position Summary</strong></p><p>The 1052 Power Business and Systems Support Analyst serves as a key business and technology partner supporting the Oracle Customer to Meter (C2M) platform and Retail Electric Customer Service operations. This role is responsible for analyzing business processes, supporting system enhancements, ensuring data integrity, developing reports and analytics, coordinating with vendors and stakeholders, and driving continuous process improvement across utility billing and Retail Electric customer service functions.</p><p>As a Subject Matter Expert (SME) for Oracle C2M and related meter-to-cash processes, the analyst collaborates with business users, technical teams, vendors, and leadership to ensure reliable system performance, regulatory compliance, operational efficiency, and informed decision-making.</p><p><strong>Essential Functions</strong></p><p>Business and Systems Analysis</p><ul><li>Analyze Oracle C2M data, functionality, integrations, and business processes to support operational objectives and ensure regulatory compliance.</li><li>Gather, document, and validate business requirements from stakeholders and end users.</li><li>Develop business requirements, use cases, user stories, process flows, and functional specifications for system enhancements and projects.</li><li>Evaluate proposed system and process changes and provide recommendations based on business impact, risk, and operational needs.</li><li>Identify opportunities for process improvement, automation, and operational efficiencies.</li></ul><p>Application Support and System Administration</p><ul><li>Support the ongoing operation, maintenance, and enhancement of the Oracle C2M Customer Information System and related utility billing applications.</li><li>Monitor system performance, data quality, and integrations to ensure system reliability and accuracy.</li><li>Investigate, troubleshoot, and resolve application, data, and process issues.</li><li>Coordinate with vendors, technical support teams, and internal stakeholders to resolve incidents, outages, and service requests.</li><li>Escalate issues appropriately and facilitate timely resolution of complex system problems.</li></ul><p>Reporting and Data Analytics</p><ul><li>Develop, maintain, and enhance operational, financial, and executive reports and dashboards.</li><li>Perform data analysis to identify trends, operational issues, and opportunities for improvement.</li><li>Create and execute SQL queries to support reporting, reconciliation, auditing, and ad hoc business requests.</li><li>Support billing, payment processing, financial balancing, and decision-making through accurate and timely reporting.</li><li>Analyze impacts of system and process changes on financial and operational reporting.</li></ul><p>Documentation and Training</p><ul><li>Develop and maintain business process documentation, procedures, system configurations, training materials, and technical documentation.</li><li>Ensure documentation remains current and supports operational consistency, compliance, and audit requirements.</li><li>Deliver training and knowledge transfer to end users and stakeholders on C2M processes, reporting tools, and system functionality.</li></ul><p>Stakeholder and Vendor Management</p><ul><li>Serve as a liaison between CSB, Enterprise Systems and Controls (ESC), vendors, and other business units.</li><li>Facilitate meetings, workshops, testing sessions, and requirements-gathering activities.</li><li>Collaborate with stakeholders to prioritize enhancements, evaluate solutions, and ensure successful implementation of system changes.</li><li>Promote effective communication among management, users, technical teams, consultants, and vendors.</li></ul><p>Testing and Quality Assurance</p><ul><li>Develop and execute User Acceptance Testing (UAT) plans, test cases, and validation procedures.</li><li>Coordinate testing activities for system upgrades, enhancements, and defect resolution.</li><li>Verify that implemented solutions meet business requirements and operational expectations.</li></ul>",
          "title": "Job Description"
        },
        "qualifications": {
          "text": "<p>Education:</p><p>An associate degree in business administration, public administration, information systems, economics, finance, computer science 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].</p><p>Experience:</p><p>One (1) year in the information systems field, including technical support, content management, administration of network applications or system analysis.</p><p>License and Certification:</p><p>Substitution:</p><p>Additional experience as described above may be substituted for the required degree on a year-for-year basis (up to a maximum of two (2) years). One (1) year is equivalent to thirty (30) semester units / forty-five (45) quarter units with a minimum of 10 semester / 15 quarter units in one of the fields above or a closely related field.</p><p>Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree.</p><p><em><strong>Applicants must meet the minimum qualification requirement by the final filing date unless otherwise noted.</strong></em></p><p><strong>Desirable Qualifications</strong></p><ul><li>Experience supporting utility billing, customer service, financial operations, or customer information systems.</li><li>Experience supporting enterprise software vendors and managing system enhancement requests.</li><li>Knowledge of utility industry operations, regulatory compliance requirements, and meter-to-cash processes.</li><li>Proficiency in SQL, including query development, optimization, troubleshooting, and data analysis.</li><li>Experience with Oracle C2M, Customer Information Systems (CIS), ERP platforms, or comparable enterprise applications.</li><li>Experience with business intelligence and reporting tools such as IBM Cognos Analytics, Tableau, Power BI, SAS, or similar platforms.</li><li>Experience with system testing, defect management, and User Acceptance Testing (UAT).</li></ul>",
          "title": "Qualifications"
        },
        "companyDescription": {
          "text": "<ul><li><strong>Application Opening: 06/19/2026</strong></li><li><strong>Application Filing Deadline:</strong>&#xa0;<strong>6/26/26 at 5:00PM PDT</strong></li><li><strong>Annual Salary:&#xa0;</strong><a href=\"https://careers.sf.gov/classifications/?classCode=1052&amp;setId=COMMN\" rel=\"noopener noreferrer\"><strong>$</strong></a><a href=\"https://careers.sf.gov/classifications/?classCode=1052&amp;setId=COMMN\" rel=\"noopener noreferrer\">115,830-$145,704 as of July 1st, 2026</a></li><li><strong>Recruitment ID:&#xa0;TEX-1052-164519&#xa0;/ RTF0164518-01159226</strong></li></ul><p><strong>APPOINTMENT TYPE:</strong>&#xa0;Temporary Exempt: This position is excluded by the Charter from the competitive Civil Service examination process and shall serve at the discretion of the Appointing Officer.</p><p>The duration of the appointment shall not exceed 36 months.&#xa0;</p><p><strong>WHO ARE WE?</strong><br>\n<a href=\"https://youtu.be/inc4CF4VKFE\" rel=\"noopener noreferrer\">San Francisco Public Utilities Commission (SFPUC)</a><br>\nHeadquartered in San Francisco, we have 2,300 employees operating across eight counties serving more than 2.7 million customers in the San Francisco Bay Area – 24 hours per day, 365 days per year.</p><p><strong>Our Mission:</strong>&#xa0;To provide our customers with high quality, efficient, and reliable water, power, and wastewater services in a manner that values environmental and community interests and sustains the resources entrusted to our care.</p><p><strong>Our Vision:</strong>&#xa0;We are an innovative utility leader, recognized for excellent results in service, safety, stewardship, and inclusiveness.</p><p>We are an award-winning and industry-leading utilities organization committed to our customers, community interests, and the environment. To learn more about our organization, please visit our website at&#xa0;<a href=\"https://www.sfpuc.org/\" rel=\"noopener noreferrer\">https://www.sfpuc.org/</a>.</p><p>We are proud of our infrastructure and programs, but most importantly, we value our highly qualified and dedicated workforce which ensures that this vision becomes a reality.</p><p>To learn more about working at the SFPUC, visit our career site at&#xa0;<a href=\"https://www.sfpuc.org/about-us/careers-sfpuc\" rel=\"noopener noreferrer\" target=\"_blank\">https://www.sfpuc.org/about-us/careers-sfpuc</a></p>",
          "title": "Company Description"
        },
        "additionalInformation": {
          "text": "<p>Every application is reviewed to ensure that you meet the minimum qualifications as listed in the job ad. Please review our articles on&#xa0;<a href=\"https://sfdhr.org/recruitment-details#qualifications\" rel=\"noopener noreferrer\">Employment Application and Minimum Qualifications</a>&#xa0;and&#xa0;<a href=\"https://sfdhr.org/recruitment-details#verification\" rel=\"noopener noreferrer\">Verification of Experience and/or Education</a>&#xa0;for considerations taken when reviewing applications.&#xa0;</p><p>Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process.</p><p><strong>Note</strong>: 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.</p><p>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. Applications completed improperly may be cause for ineligibility, disqualification or may lead to lower scores.</p><p><strong>Important Note:</strong></p><p>Please make sure it is absolutely clear in your application exactly how you meet the minimum qualifications. Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. Please be aware that any misrepresentation of this information may disqualify you from this recruitment or future job opportunities.</p><p>One-year full-time employment is equivalent to 2,000 hours (2,000 hours of qualifying work experience is based on a 40-hour work week). Any overtime hours that you work above 40 hours per week are not included in the calculation to determine full time employment.</p><p><strong>Additional Information Regarding Employment with the City and County of San Francisco: </strong></p><ul><li><a href=\"https://careers.sf.gov/knowledge/process/\" rel=\"noopener noreferrer\">Information About the Hiring Process</a></li><li><a href=\"https://careers.sf.gov/knowledge/conviction-history/\" rel=\"noopener noreferrer\">Conviction History</a></li><li><a href=\"https://careers.sf.gov/benefits/\" rel=\"noopener noreferrer\">Employee Benefits Overview&#xa0;</a>&#xa0;</li><li><a href=\"https://www.sf.gov/what-equal-employment-opportunity-and-how-file-claim\" rel=\"noopener noreferrer\">Equal Employment Opportunity</a>&#xa0;</li><li><a href=\"https://sfdhr.org/disaster-service-workers\" rel=\"noopener noreferrer\">Disaster Service Worker</a></li><li><a href=\"https://sfdhr.org/information-about-hiring-process#applicantswithdisabilities\" rel=\"noopener noreferrer\">ADA Accommodation</a></li><li><a href=\"https://sfdhr.org/recruitment-details#veteranspreference\" rel=\"noopener noreferrer\">Veterans Preference</a></li><li><a href=\"https://sfdhr.org/recruitment-details#identification\" rel=\"noopener noreferrer\">Right to Work</a></li><li><a href=\"https://sfdhr.org/recruitment-details#copies\" rel=\"noopener noreferrer\">Copies of Application Documents</a></li><li><a href=\"https://sfdhr.org/recruitment-details#diversitystatement\" rel=\"noopener noreferrer\">Diversity Statement</a></li></ul><p>&#xa0;</p><p>Applicants will receive a confirmation email from <a href=\"mailto:[email protected]\" rel=\"noopener noreferrer\">[email protected]</a> 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. <strong>Failure to receive this email means that the online application was not submitted or received.</strong></p><p><strong>HOW TO APPLY </strong></p><p>Applications for City and County of San Francisco jobs are <strong>only </strong>accepted through an online process. Visit https://careers.smartrecruiters.com/CityAndCountyOfSanFrancisco1/ and begin the application process.</p><ul><li>Select the “I’m Interested” button and follow instructions on the screen</li></ul><p>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 updated. 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).</p><p>&#xa0;</p><p>Applicants will receive a confirmation email from <a href=\"mailto:[email protected]\" rel=\"noopener noreferrer\">[email protected]</a> 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. <strong>Failure to receive this email means that the online application was not submitted or received.</strong></p><p>&#xa0;</p><p><strong>Job Analyst Information:&#xa0;</strong>If you have any questions regarding this recruitment or application process, please contact the job&#xa0;analyst,&#xa0;Sanly Guan at [email protected].&#xa0;</p><div sr-tagline=\"\"></div><p>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.</p>",
          "title": "Additional Information"
        }
      }
    },
    "jobId": "92477083-937a-481a-8e4b-bc5194e04858",
    "active": true,
    "company": {
      "name": "City and County of San Francisco",
      "identifier": "CityAndCountyOfSanFrancisco1"
    },
    "creator": {
      "name": "",
      "avatarUrl": ""
    },
    "jobAdId": "a0f98179-c7b4-46c4-94e2-739be7900553",
    "applyUrl": "https://jobs.smartrecruiters.com/CityAndCountyOfSanFrancisco1/3743990013716117-is-business-analyst-csb-sfpuc-1052?oga=true",
    "function": {
      "id": "other",
      "label": "Other"
    },
    "industry": {
      "id": "government_administration",
      "label": "Government Administration"
    },
    "language": {
      "code": "en",
      "label": "English",
      "labelNative": "English (US)"
    },
    "location": {
      "city": "San Francisco",
      "hybrid": false,
      "region": "CA",
      "remote": false,
      "address": "525 Golden Gate Avenue",
      "country": "us",
      "latitude": "37.7808763",
      "longitude": "-122.4192072",
      "postalCode": "94102",
      "fullLocation": "San Francisco, CA, United States"
    },
    "refNumber": "RTF0164518-01159226",
    "department": {
      "id": 2297115,
      "label": "Public Utilities Commission"
    },
    "postingUrl": "https://jobs.smartrecruiters.com/CityAndCountyOfSanFrancisco1/3743990013716117-is-business-analyst-csb-sfpuc-1052",
    "visibility": "PUBLIC",
    "customField": [
      {
        "fieldId": "COUNTRY",
        "valueId": "us",
        "fieldLabel": "Country/Region",
        "valueLabel": "United States"
      },
      {
        "fieldId": "6051ed008e33797c56a381a2",
        "valueId": "default",
        "fieldLabel": "Brands",
        "valueLabel": "City and County of San Francisco"
      },
      {
        "fieldId": "6051ed008e33797c56a381a3",
        "valueId": "2297115",
        "fieldLabel": "Department",
        "valueLabel": "Public Utilities Commission"
      },
      {
        "fieldId": "6052763ed85aff5fa39f99cb",
        "valueId": "ff0d5ab1-4886-443d-9cc0-bbe79025dcd7",
        "fieldLabel": "Recruitment Type",
        "valueLabel": "Temporary Exempt"
      },
      {
        "fieldId": "60527ae56588230cf59bdca3",
        "fieldLabel": "PeopleSoft Recruitment ID - Eligible List ID",
        "valueLabel": "164519"
      },
      {
        "fieldId": "60527cac469a184e9d282df9",
        "valueId": "1052",
        "fieldLabel": "Job Code and Title",
        "valueLabel": "1052-IS Business Analyst"
      },
      {
        "fieldId": "605272618e33797c56a381b5",
        "valueId": "b8aaf635-098d-4cf1-a2d9-144cc18210b9",
        "fieldLabel": "Fill Type",
        "valueLabel": "Temporary Exempt"
      }
    ],
    "referralUrl": "https://jobs.smartrecruiters.com/external-referrals/company/CityAndCountyOfSanFrancisco1/publication/3893b107-2b72-4913-906e-d02bc3f3de5f?dcr_ci=CityAndCountyOfSanFrancisco1",
    "defaultJobAd": true,
    "releasedDate": "2026-06-20T00:17:01.846Z",
    "experienceLevel": {
      "id": "entry_level",
      "label": "Entry Level"
    },
    "typeOfEmployment": {
      "id": "permanent",
      "label": "Full-time"
    }
  },
  "company": {
    "name": "City and County of San Francisco",
    "identifier": "CityAndCountyOfSanFrancisco1"
  },
  "jobAdId": "a0f98179-c7b4-46c4-94e2-739be7900553",
  "function": {
    "id": "other",
    "label": "Other"
  },
  "industry": {
    "id": "government_administration",
    "label": "Government Administration"
  },
  "language": {
    "code": "en",
    "label": "English",
    "labelNative": "English (US)"
  },
  "location": {
    "city": "San Francisco",
    "hybrid": false,
    "region": "CA",
    "remote": false,
    "address": "525 Golden Gate Avenue",
    "country": "us",
    "latitude": "37.7808763",
    "longitude": "-122.4192072",
    "postalCode": "94102",
    "fullLocation": "San Francisco, CA, United States"
  },
  "refNumber": "RTF0164518-01159226",
  "department": {
    "id": "2297115",
    "label": "Public Utilities Commission"
  },
  "visibility": "PUBLIC",
  "customField": [
    {
      "fieldId": "6051ed008e33797c56a381a2",
      "valueId": "default",
      "fieldLabel": "Brands",
      "valueLabel": "City and County of San Francisco"
    },
    {
      "fieldId": "6051ed008e33797c56a381a3",
      "valueId": "2297115",
      "fieldLabel": "Department",
      "valueLabel": "Public Utilities Commission"
    },
    {
      "fieldId": "6052763ed85aff5fa39f99cb",
      "valueId": "ff0d5ab1-4886-443d-9cc0-bbe79025dcd7",
      "fieldLabel": "Recruitment Type",
      "valueLabel": "Temporary Exempt"
    },
    {
      "fieldId": "COUNTRY",
      "valueId": "us",
      "fieldLabel": "Country/Region",
      "valueLabel": "United States"
    },
    {
      "fieldId": "60527cac469a184e9d282df9",
      "valueId": "1052",
      "fieldLabel": "Job Code and Title",
      "valueLabel": "1052-IS Business Analyst"
    },
    {
      "fieldId": "605272618e33797c56a381b5",
      "valueId": "b8aaf635-098d-4cf1-a2d9-144cc18210b9",
      "fieldLabel": "Fill Type",
      "valueLabel": "Temporary Exempt"
    },
    {
      "fieldId": "60527ae56588230cf59bdca3",
      "fieldLabel": "PeopleSoft Recruitment ID - Eligible List ID",
      "valueLabel": "164519"
    }
  ],
  "defaultJobAd": true,
  "releasedDate": "2026-06-20T00:17:01.846Z",
  "detail_errors": [],
  "experienceLevel": {
    "id": "entry_level",
    "label": "Entry Level"
  },
  "typeOfEmployment": {
    "id": "permanent",
    "label": "Full-time"
  }
}