Clean Energy Application Lead

NOTE – The first review of applications will Friday, October 20, 2023. Please submit your application by 11:59 p.m. (PST) on Thursday, October 19, 2023. 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 October 30, 2023.

About the Department

The City of San José is a place where we use civic technology to help our community thrive.

As the 10th largest city in the nation, the City manages a large set of services and assets. The City operates on a budget of $5 billion, with 7,000 employees serving 1 million residents and 80,000 businesses in the heart of Silicon Valley.

Information Technology’s (IT) mission: Put powerful tools and information in the hands of people to unleash their brilliance in service to our community. IT enables that mission through business and infrastructure systems, cybersecurity, data management and analysis, productivity and collaboration tools, the San Jose 311 resident experience platform, data equity and privacy programs, and strategic planning. San Jose 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!

Position Duties

The City of San José is recruiting for a Clean Energy Lead (Enterprise Supervising Technology Analyst) as a dedicated technical support resources for the existing and new technology solutions in the Clean Energy Department (CED). This position will be responsible for developing technology strategic plans and developing technology solutions to increase operating efficiencies, enhance specialized energy industry software, ensure compliance with California Public Utilities Commission (CPUC) privacy protection standards for customers, and ensure alignment with City policies on cybersecurity standards.

This position will be responsible for developing technology strategic plans to address the business needs and changes in the clean energy industry. In addition, this position will evaluate and promote new technologies to increase efficiently throughout the various energy programs and develop a technology roadmap for the Department. This position will support CED on data management and data analytics needs such as designing, managing and monitoring databases and reporting tools, data processing, process automation, data security, data governance, implementation and management of specialized CED software’s, such as Energy Trading Risk Management Platform. This position will work closely with CED business users to provide insightful data and analytics to support a growing organization.
The position will also assist supporting and resolving the backlog of work and helping with system implementations, developing processes, and mitigating employee down time for services.

The ideal candidate must be able to take ownership of projects to completion and beyond by providing awareness and visibility from a standard IT best practice for operations and security perspective to the rest of the organization. A team leader, team player, and positive attitude are essential to this position.

Responsibilities include but not limited to the following:

• Working collaboratively with different teams such as the Business Solutions SME, Data Warehouse and
• Business Intelligence Manager, Development Services, and Cybersecurity teams within the City to deliver key business insights from transactional data.
• Develop and Manage REST or SOAP web services calls to connect pull datasets various data sources.
• Creating, designing, and developing data models.
• Validating report results and perform data cleansing.
• Monitoring and tuning data loads and complex quires.
• Prepare plans for ETL (Extraction, Transformation and Load) procedure to load data from various source systems like flat files, Excel, Webservices and SQL Server.
• Bringing together disparate data sets, in accordance with open data standards set forth by the federal government.
• Create Executive Reports, Scheduled Department Reports, and other Ad Hoc reports using reporting databases in MS SQL and Oracle.
• Managing deliverables in a multi-departmental environment.

Please note that the Clean Energy Application 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): $136,237.92 – $166,005.84

The ESTA classification is represented by the City Association of Management Personnel (CAMP) bargaining unit.

Minimum Qualifications

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.

Competencies

The ideal candidates will possess the following competencies, as demonstrated in past and current employment history.

Job Expertise –

• Experience in SQL, Stored Procedures, Triggers, Debugging, Troubleshooting and/or Performance Tuning.
• Experienced in using different tools for database access and development (e.g. SQL, MySQL, Oracle, etc.).
• Experience in creating reusable transformations, map, Mapplets and worklets.
• Experience in ETL Tools and Java Scripting.
• Experience in XML Technologies like SOAP and REST.
• Experience in creation of access-based web application for data CRUD operations.
• Experienced in data structures, performance tuning and query optimization.
• Experience in JavaScript libraires like Angular.js, React.Js, Node.js.

Project Management – Ensures support for projects and implements goals and strategic objectives.

Planning – Acts to align own unit's goals with the strategic direction of the organization; defines tasks and milestones to achieve objectives, while ensuring the optimal use of resources to meet those objectives.

Problem Solving – 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.

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.

Selection Process

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, one of which

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 Tram Nguyen at