Oracle Planning and Budgeting Cloud Services Technical Lead (Enterprise Suprv Technology Analyst) (20534355)

The City of San José is a place where we use civic technology to help our community thrive. As the 13th largest city in the nation, the City manages a large set of services and assets. The City operates on a budget of $6 billion, with 7,000 employees serving 1+ million residents and 80,000 businesses in the heart of Silicon Valley.

Information Technology's (IT) mission: Enrich the quality of life in San José through innovation, collaboration, and engagement. IT enables that mission through business and infrastructure systems, cybersecurity, data management and analysis, productivity and collaboration tools, the San José 311 resident experience platform, data equity and privacy programs, and strategic planning. San José is powered by truly great people, a robust technology environment, and a strong sense of purpose.

We promote work-life integration and a focus on growth to bring out the best in our people. Come join us in making San Jose the most vibrant, equitable, sustainable, and innovative city in America! You can visit the Information Technology Department website to learn more about us.NOTE - The first review of applications will be on Thursday, August 15, 2024. Please submit your application by 11:59 p.m. (PST) on Wednesday, August 14, 2024, if you would like your application to be included in the first review. Candidates who pass the first application review round will be invited to interviews on the week of August 26, 2024.

The City of San José is hiring an Oracle Planning and Budgeting Cloud Services (PBCS) Technical Lead (Enterprise Supervising Technology Analyst) to provide technical support for Oracle PBCS which is used to prepare the City's Capital, Operating, and Revenue Budgets. The PBCS Technical Lead will also support the three custom budget applications: Fees and Charges, Ordinance Tracking, and Budget to Finance ERP Interface and the Budget Office (BO). The BO is responsible for developing and managing the City's operating and capital budgets and service fees and charges. This position requires strong technical hands-on experience and leadership skills, as well as the ability to take initiative and lead others. We are seeking an individual who is willing to adapt to an ever-changing environment.

The ideal candidate will have a strong technical and functional background supporting Oracle PBCS and/or Oracle Hyperion Planning, and multi-dimensional databases with strong analytical skills. In addition, development experience using .NET Framework, Java, or JavaScript to effectively manage and support custom-developed applications is essential. Expertise should cover the entire system implementation lifecycle including gathering business requirements, creating functional and technical designs, application development, and administration.
Key duties include but are not limited to:

• Collaborating with the Budget Office to understand their Oracle PBCS requirements.
• Translating business requirements into technical solution designs.
• Developing new calculations and performance-tuning existing rules.
• Creating and updating existing Financial Reports and Management reports. Creating Smart View ad-hoc sheets for troubleshooting, data analysis, and reporting.
• Applying business expertise in budgeting and planning and functional knowledge in administrating Oracle PBCS.
• Providing recommendations to enhance and accelerate Budget business processes.
• Assisting with configuring data integration, process automation, and interfacing activities.
• Developing materials, documenting technical and functional processes, and providing training to power users.
• Designing, developing, troubleshooting, implementing, and administering the City's Budget applications required to meet the City's planning and reporting needs.
• Ensure the Budget Office applications adhere to IT and the City's Cybersecurity Security policies.

Please note that the Oracle Planning and Budgeting Cloud Services (PBCS) Technical Lead (Enterprise Supervising Technology Analyst) position is currently on a hybrid telework schedule - working remotely and onsite is subject to change.
Salary Information: The actual salary shall be determined by the final candidate's qualifications and experience. In addition to the starting salary, employees in the Enterprise Supervising Technology Analyst (ESTA) classification shall also receive an approximate five percent (5%) ongoing non-pensionable compensation pay.

• Salary Range (including the 5% NPWI): $141,697.92 - $172,645.20

The ESTA classification is represented by the City Association of Management Personnel (CAMP) .
(These qualifications are typically required. An equivalent combination of education and experience sufficient to satisfactorily perform the duties of the job may be substituted.)

Education and Experience

A Bachelor's Degree from an accredited college or university in a relevant field, AND four (4) years of progressively responsible professional/journey level experience, of which at least two (2) years of experience include lead technical work in development, implementation and maintenance of electronic business systems/solutions, or application development and/or support.

Acceptable Substitution

• Additional years of increasingly responsible directly related work experience may be substituted for education on a year-for-year basis up to two (2) years.
• Completion of a Master's Degree in a relevant field from an accredited college or university may be substituted for one (1) year of the required two (2) years of experience which include lead technical work in development, implementation and maintenance of electronic business systems/solutions or application development and/or support.

Required Licensing (such as driver's license, certifications, etc.)

• Possession of a valid State of California driver's license may be required.

The ideal candidates will possess the following competencies, as demonstrated in past and current employment history. Focus on outcomes over activity is key.
Job Expertise - Demonstrates strong technical and functional knowledge and experience supporting Oracle Planning and Budgeting Cloud Services (PBCS) (or Hyperion Planning) along with strong analytical skills:

• 3 or more years of experience in implementing and optimizing Oracle PBCS or on-premise Oracle Hyperion Planning.
• Experience in the following Oracle PBCS and tools:
  • Planning
  • Human Capital Planning
  • Essbase
  • SmartView
  • Management Reporting
  • Narrative Reporting
  • Planning Cubes
  • Multi-dimensional and Relational Databases
• Development and configuration experience in the following Planning components:
  • Business Rules
  • Groovy scripting
  • Web Forms, Data Exchange and Data Maps
  • Data Management and EPM Automate
  • Financial Reporting Web Studio.
• Demonstrated experience in comprehending complex business models and resolving application problems.
• Ability to develop applications using .Net or Java, JavaScript, and SQL and/or T-SQL.

Project Management - Approaches a situation or problem by defining the problem or issue; determines the significance of problem; collects information; uses logic and intuition to arrive at decisions or solutions to problems that achieve the desired outcome.
Conflict Management - Uses appropriate interpersonal styles and methods to reduce tension or conflict between two or more people, by presenting the facts, analysis, and conclusions or solutions that show command of content and perspectives and interests of the audience.
Leadership - Leads by example; demonstrates high ethical standards; remains visible and approachable and interacts with others on a regular basis; makes informed decisions based on input from a diverse set of stakeholders; promotes a cooperative work environment, allowing others to learn from mistakes; provides motivational supports and direction.
Problem Solving - Uses efficient and cost-effective approaches to integrate technology into the workplace and improve program effectiveness.
Analytical Thinking -Approaching a problem or situation by using a logical, systematic, sequential approach.
Teamwork & Interpersonal Skills - Develops effective relationships with co-workers and supervisors by helping others accomplish tasks and using collaboration and conflict resolution skills.
Communication Skills - Effectively conveys information and expresses thoughts and facts clearly, orally and in writing; demonstrates effective use of listening skills; displays openness to other people's ideas and thoughts.

The selection process will consist of an evaluation of the applicant's training and experience based on the application and responses to the Job Specific Questions . Only the candidates whose backgrounds best match the position will be invited to proceed in the selection process. Additional phases of the selection process will consist of one or more interviews.

You must answer all job-specific questions in order to be considered for this vacancy or your application will be deemed incomplete and withheld from further consideration. In addition, please attach your resume as part of the application process. If you have questions about the duties of these positions, the selection or hiring processes, please contact Felipa Perez at Felipa.Perez@sanjoseca.gov.