IS Business Analyst - CSB (SFPUC) - 1052

Appointment Type 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. The duration of the appointment shall not exceed 36 months. Job Title Power Business and Systems Support Analyst (Position ID: 1052) Position Summary 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. Essential Functions Business and Systems Analysis Analyze Oracle C2M data, functionality, integrations, and business processes to support operational objectives and ensure regulatory compliance. Gather, document, and validate business requirements from stakeholders and end users. Develop business requirements, use cases, user stories, process flows, and functional specifications for system enhancements and projects. Evaluate proposed system and process changes and provide recommendations based on business impact, risk, and operational needs. Identify opportunities for process improvement, automation, and operational efficiencies. Application Support and System Administration Support the ongoing operation, maintenance, and enhancement of the Oracle C2M Customer Information System and related utility billing applications. Monitor system performance, data quality, and integrations to ensure system reliability and accuracy. Investigate, troubleshoot, and resolve application, data, and process issues. Coordinate with vendors, technical support teams, and internal stakeholders to resolve incidents, outages, and service requests. Escalate issues appropriately and facilitate timely resolution of complex system problems. Reporting and Data Analytics Develop, maintain, and enhance operational, financial, and executive reports and dashboards. Perform data analysis to identify trends, operational issues, and opportunities for improvement. Create and execute SQL queries to support reporting, reconciliation, auditing, and ad hoc business requests. Support billing, payment processing, financial balancing, and decision-making through accurate and timely reporting. Analyze impacts of system and process changes on financial and operational reporting. Documentation and Training Develop and maintain business process documentation, procedures, system configurations, training materials, and technical documentation. Ensure documentation remains current and supports operational consistency, compliance, and audit requirements. Deliver training and knowledge transfer to end users and stakeholders on C2M processes, reporting tools, and system functionality. Stakeholder and Vendor Management Serve as a liaison between CSB, Enterprise Systems and Controls (ESC), vendors, and other business units. Facilitate meetings, workshops, testing sessions, and requirements-gathering activities. Collaborate with stakeholders to prioritize enhancements, evaluate solutions, and ensure successful implementation of system changes. Promote effective communication among management, users, technical teams, consultants, and vendors. Testing and Quality Assurance Develop and execute User Acceptance Testing (UAT) plans, test cases, and validation procedures. Coordinate testing activities for system upgrades, enhancements, and defect resolution. Verify that implemented solutions meet business requirements and operational expectations. Education 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 (at least 60 semester or 90 quarter units with a minimum of 20 semester or 30 quarter units in one of the fields above). Experience One (1) year in the information systems field, including technical support, content management, administration of network applications or system analysis. Substitution Additional experience 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 30 semester units / 45 quarter units with a minimum of 10 semester / 15 quarter units in one of the fields above. Completion of the 1010 Information Systems Trainee Program may also be substituted for the required degree. Desirable Qualifications Experience supporting utility billing, customer service, financial operations, or customer information systems. Experience supporting enterprise software vendors and managing system enhancement requests. Knowledge of utility industry operations, regulatory compliance requirements, and meter-to-cash processes. Proficiency in SQL, including query development, optimization, troubleshooting, and data analysis. Experience with Oracle C2M, Customer Information Systems (CIS), ERP platforms, or comparable enterprise applications. Experience with business intelligence and reporting tools such as IBM Cognos Analytics, Tableau, Power BI, SAS, or similar platforms. Experience with system testing, defect management, and User Acceptance Testing (UAT). Equal Employment Opportunity 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, 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. #J-18808-Ljbffr San Francisco Public Utilities Commission