Systems Integration Manager (Hybrid Workplace) - Controller's Office (1044) - City and County of San Francisco

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.

Controller’s Office
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 well-being 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 issues, 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.

Specific information regarding this recruitment process are listed below:  

• Application Opening:  10/21/2024
• Application Deadline:  Continuous 
• Compensation:  $159,692 - $200,850

Systems Integration Manager (1044)

Position Description: Under the general direction of the division Chief Technology Officer, the Systems Integration Team Manager manages the team whose main role is to provide operations support to the enterprise applications. The manager will provide advanced level of operational and batch support to the PeopleSoft ELM, PeopleSoft HCM, and PeopleSoft FSCM applications. Batch processing tools includes PeopleSoft Process Scheduler, BMC Control-M scheduling systems, and GlobalScape secured transmission (sFTP) system.

Essential duties include but not limited to:

• Manage the systems integration team resources, including recruitment, performance goals, performance appraisal reviews, training plans, assigns work to staff appropriately to maximize team efficiency
• Provides technical leadership and direction and assumes technical responsibility for the operations support of the systems integration batch jobs and automated processing and file transfers
• Provide strong leadership and proactive coaching to the team members through mentoring, career development, interpersonal skills, teamwork ethic, and building leadership skills.
• Develop strategies as needed regarding live retention of data, archiving of older data, disaster recovery and continuation of operations procedures.
• Work in partnership with the infrastructure team to support 3rd third party production applications, e.g., server configuration, Control-M, jump server configurations, etc.
• Coordinate with teams responsible for database administration, server and network administration, hardware configuration, and cybersecurity to meet project objectives.
• Production support and management of all PeopleTools Process Scheduler, Control-M and SFTP Global Space automated job requirements for CON Systems Enterprise applications (PeopleSoft ELM, PeopleSoft HCM, and PeopleSoft FSCM, Oracle Business Intelligence) production and non-production interface and batch job requirements.
• Work in partnership with the PMO team to design, plan, integrate, test, implement, document, and enhance all components required for PeopleSoft application updates and PeopleTools upgrades.
• Research, analyze, troubleshoot, evaluate, and stays current on industry best practice standards for these technologies; maintaining and installing Control-M infrastructure application and supporting tools: PGP Encryption, OS scripts, etc.
• Create and execute work plans for applying Control-M updates and patches.
• Provide ongoing review and feasibility assessment to improve efficiency of automated jobs across all tools (Control-M, DT GlobalSpace EFT Management Service and PeopleSoft Scheduler)
• Be able to work on multiple projects concurrently and deliver quality outcomes.
• Participate and lead inter-departmental system projects such as PUM Upgrades, new module implementations, etc.
• Act as the liaison between vendors, technical support hot-lines and departments to resolve interface related problems.
• Coordinate maintenance support with the Application administration teams.
• Ensure job scheduling operations meet defined service levels.
• Work in partnership with the Oracle Business Intelligence team for integration with PeopleSoft applications.
• Participates and represents the system integration efforts during weekly Capacity Advisory Board (CAB) and Move to Procure (MTP) meetings.
• Completes annual Performance Plan and Appraisal Report (PPAR) for all direct reports.
• Provide guidance to staff to create Standard Operating Procedure, technical design and batch operation documentation.
• Performing other duties as assigned.

Education:  An associate degree in computer science, computer engineering, information systems, 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].

Experience:  Five (5) years of experience analyzing, installing, configuring, enhancing, and/or maintaining the components of an enterprise network.

License and Certification:

Substitution:

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.

Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree.

Desirable Qualifications:

The stated desirable qualifications will be used to identify job finalists at the end of the selection process when candidates are referred for hiring.

• Experience with one or more of the following Oracle PeopleSoft systems and modules:  PeopleSoft Human Capital Management (Human Resources, Benefits Administration, Time & Labor, Absence Management, Payroll for North America); PeopleSoft Enterprise Learning Management; PeopleSoft Financials & Supply Chain Management (Accounts Payable, Accounts Receivable, Asset Management, Billing, Cash Management, Customer Contracts, E-Settlements, Expenses, General Ledger, Grants Management, Maintenance Management, Project Costing, Requisitions, Catalog, Supplier Portal, Inventory, Purchasing, Strategic Sourcing, Supplier Contracts)
• Working knowledge of job scheduling system, such as BMC’s Control-M
• Working knowledge of transmission tools and systems, such as FileZilla, WinSCP, GlobalScape, MOVEit
• Experience with PeopleSoft Administration and maintenance of the Process Scheduler component
• Experience in Linux and/or Windows scripting
• Link business processes with the setup, rules, workflow, and batch processing to the ELM, HCM, and FSCM applications
• Familiarity with Tier-1 ERP systems
• Developing reports and metrics to assist in documenting production support activities and enhancing production efficiency and effectiveness
• Demonstrated experience preparing and maintaining user training materials; conducting online user trainings and oral presentations

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.

SELECTION PLAN

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

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.