Search Jobs

Final Filing Date:  First review of applications will be on June 7, 2024. NCPA reserves the right to close this posting once a sufficient number of applications have been received.
 

Under the direction of the IS Operations & Support Assistant Manager, the Database Administrator architects, tests, implements, maintains, and documents Agency databases. The database administrator collaborates closely with IS development and Agency operations personnel to provide backend database solutions for custom applications, including real-time, scheduling, and settlement programs. The database administrator troubleshoots and provides solutions for database problems.

Level III
This classification supports and maintains the Agency’s database infrastructure and related applications. Administers all database objects, including but not limited to schemas, tables, clusters, indexes, and views. Performs database re-organizations as needed to improve performance. Performs impact analysis of changes to be made to database objects before implementing significant schema changes. Ensures security for all databases by creating roles and associated privileges. Controls and monitors user access to databases. This is a journey-level position and is given minimal direction in job duties and responsibilities.  

Level IV
Architects and designs the Agency’s database infrastructure and ensures the highest levels of availability. Leads database projects to establish new database architectures. Oversees upgrades and implementations of new databases or related software.   Position can perform all lower level requirements and works independently with very little direction May be called upon to provide reports or present to the Agency’s Information Technology Committee. May direct the work of lower classifications.     

ESSENTIAL DUTIES AND RESPONSIBILITIES
This position requires that the incumbent reports for work on time and maintains satisfactory attendance in accordance with Agency policy; Ensures work responsibilities are covered when absent; Arrives to meetings and appointments on time; Performs special assignments for the Assistant Manager, Information Services or others as assigned. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Responsibilities:
Design, create and maintain all Oracle databases required for development, testing, and production usage. 

Install, configure, upgrade, and troubleshoot Database server software for both stand-alone instances and Real Application Clusters (RAC). Includes patching both Oracle and Windows. 

Administer all database objects, including schemas, tables, clusters, indexes, views, sequences, constraints, packages, and procedures. This includes creating primary database storage structures (tablespaces) and primary objects (tables, views, indexes). Manage the sharing of resources between applications. 

Troubleshoot problems regarding the databases, servers, applications and development tools. Open technical support cases with support as needed and serve as primary support contact for NCPA. 

Perform capacity planning for all databases. Work closely with IS storage and system administration staff to plan and allocate database system storage. 

Experienced with creating, managing, and maintaining data warehouse technologies.

Perform ongoing monitoring and tuning of all database instances and Windows servers to optimize database performance and reliability. 

Plan and implement backup and recovery of Agency databases. Maintain remote standby databases using archive logs.

Implement and enforce security for all of the Databases through creating and maintaining users and roles, and assigning privileges. Control and monitor user access to the database. 

Perform database re-organizations as required to improve performance and ensure maximum uptime of the database. Modify the database structure from information given by application developers. Gather statistics, create indexes, create or expand tablespaces as needed. 

Perform SQL and PL/SQL tuning and performance monitoring. 

Set up and maintain documentation and standards for database practices and procedures. 

Provide technical support to application developers and database users. 

Perform impact analysis of changes to be made to database objects. Approve and implement/oversee significant schema changes and changes to database design. 

Provide support during non-standard hours (on an as-needed basis, on-call 24x7x365). 

Provide a strategic database direction for the organization.

MINIMUM QUALIFICATIONS

Level III:
Education and/or Experience
A bachelor’s degree from an accredited four-year college or university in Computer Science, Management Information Systems, Engineering, or a related field and five or more years of related experience and/or training, or an equivalent combination of education and experience.

Level IV: 
Education and/or Experience 
A bachelor’s degree from an accredited four-year college or university in Computer Science, Management Information Systems, Engineering, or a related field and eight or more years of related experience and/or training, or an equivalent combination of education and experience.

KNOWLEDGE AND ABILITIES 

Knowledge:
Knowledge of Oracle database; Oracle Recovery Manager (RMAN), Real Application Clusters (RAC); Oracle Automatic Storage Management (ASM), SQL, PL/SQL; Microsoft SQL Server; Windows; networking; virtual machines; batch/cmd scripting; PowerShell, SQL*Plus; Toad, GIT; physical database design; relational database theory; disaster recovery; back-up and recovery, relational database theory; Windows and Linux system administration; the Oracle optimizer and execution plans; troubleshooting and debugging, networking (TCP/IP), database security.

Abilities:
Ability to write complex programs and develop detailed program specifications; Ability to analyze data and situations, reason logically and creatively, identify problems, draw valid conclusions, and develop effective solutions; Ability to apply creative thinking in the design and development of methods of processing data with electronic computers; Ability to establish and maintain cooperative working relationships with those contacted in the course of the work; Ability to communicate effectively verbally and in writing, and prepare effective reports.

SPECIAL REQUIREMENTS

Valid California Driver's License and insurance as occasional travel may be required. 
While performing the duties of this job, the employee is regularly required to sit. The employee is occasionally required to stand and walk. Occasionally, the employee may be required to perform simple grasping and fine manipulation, use telephone, write or use a keyboard to communicate, crouch, crawl, reach and lift equipment up to 40 lbs. 

Level III: This job has no supervisory responsibilities. 

Level IV: This job may have supervisory responsibilities.

WORK ENVIRONMENT

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. The noise level in the work environment is usually moderate.

All employees are responsible for contributing to an inclusive, safe, and secure work environment that values diverse cultures, perspectives, and experiences and is free from discrimination.
 

PARAPROFESSIONAL TEMP - INTERN

THE DEPARTMENT:
The Community and Economic Development Department is committed to improving the quality of life in the San Rafael community.  Our mission is to make San Rafael a great place to live and to business.  The five department core functions are:

• Planning
• Building
• Code Enforcement
• Housing and Homelessness
• Economic Development and Innovation

The Economic Development and Innovation Division is dedicated to fostering economic vitality by facilitating collaboration between businesses, community, and the city.  Our mission is to increase investments in San Rafael that contribute to the growth of the City's economy, foster fiscal sustainability, expand job opportunities for all residents, and enhance the community's quality of life.

THE ROLE AND PROJECTS:
Reporting to the Economic Development Program Manager, the Intern will be engaged in project-based work to advance key economic development strategic initiatives.  Examples of the work include, but are not limited to the following:

• Implement tasks outlined in the San Rafael Economic Development Strategic Plan.
• Develop a business support communications plan in collaboration with business support partners.
• Support Division Manager to activate outreach to businesses.
• Learn and assist with contract management.
• Evaluate resources available to various business groups through an equity lens.  Research strategies for business support for underserved sectors in San Rafael.
• Support activation of the Downtown San Rafael Arts District Strategic Plan.
• Administrative tasks as assigned.

HOURS, COMPENSATION & BENEFITS:
This position will work approximately 12-20 hours per week.  The candidate will have hands-on learning and work experience at San Rafael City Hall and outreach in the community.

This is a temporary position and hours worked may not exceed 1,000 hours in a fiscal year (July 1 thru June 30).

In accordance with the salary resolution, this position receives no benefits with the exception of Paid Sick Leave and a retirement plan.  

• Temporary employees are entitled to receive sick leave in accordance with California's Paid Sick Leave Law (AB 1522).
• Participation in a retirement plan is mandated by Federal Law and you will be enrolled in the Public Agency Retirement System (PARS):
  • Employee contributes 3.75% of salary
  • City of San Rafael contributes 3.75% of salary

APPLICATION PROCESS:
City of San Rafael application is required.  Resumes do not substitute for the City application.  To file an application online, go to www.calopps.org.  Select "Member Agencies."  Select "City of San Rafael."  Follow this link to submit your application:  https://www.calopps.org/san-rafael/job-20507019.  

REASONABLE ACCOMMODATION:
The City of San Rafael will make reasonable accommodations at any phase of the application and interview process to accommodate persons with disabilities.  If you have a disability for which you require accommodation, please advise Human Resources upon submittal of your application.  For examination accommodation, please contact Human Resources at least seven (7) calendar days before the test/interview date at 415-485-3474.

San José Clean Energy, or SJCE, is San José's local, not-for-profit electricity supplier operated by the City of San José's Energy Department. Since 2019, our dedicated and motivated team has provided clean energy for residents and businesses at competitive rates, while also offering community programs, local benefits, and increased transparency and accessibility.

San José Clean Energy serves more than 350,000 customers and has a peak load of almost 1 GW. SJCE is responsible for purchasing over 4,500 GWh of electricity annually and has an annual operating budget of over $300 million. Serving our community with respect and integrity is at the core of what we do. Joining our team means that you will be making a big impact and in the forefront in the fight against climate change. SJCE plays an important role in meeting San José's ambitious goal to be carbon neutral by 2030 and in implementing Climate Smart San José, the City's climate action plan.

SJCE centers equity in its drive to provide clean, renewable energy at competitive rates and provide local benefits. Since inception, SJCE has sprinted ahead to now provide 60% renewable and 95% carbon-free energy in our base product and has contracted to add over 1GW of new solar, wind, and battery storage to the grid. SJCE's low carbon energy supply is foundational as we work to meet the electrification goals outlined in Climate Smart San José. For more information about San José Clean Energy, please visit: www.sanjosecleanenergy.org .

This department is seeking to fill one (1) full-time Power Resources Specialist I/II position to support the Risk Management and Contracts Administration Division.

This position is part of an exciting fast-paced team responsible for mitigating risks and managing a power portfolio comprised of hundreds of megawatts of renewable energy projects.

The selected candidate will have the following duties and responsibilities:

• Evaluate, review, and validate the accuracy of market positions and risk metrics such as mark-to-market, value at risk, gross margin at risk.
• Perform quantitative and analytical data modeling to quantify risks, evaluate risk reduction strategies, aid strategic/ operational decision making and provide insights.
• Update, manage and validate accuracy of Power BI business intelligence dashboards related to energy risk management such as risk limits, forward prices, collateral.
• Execute monthly and ad-hoc data reporting and quantitative modeling tasks.
• Validate and forecast collateral calls from counterparties and the CAISO and verify accuracy of collateral records.
• Collaborate with different divisions and IT department to support the build and implementation of data repository.
• Provide analytical support for power purchase and sale agreements and power supply audits.
• Compile reports, summaries, and presentations to communicate findings to management.
• Understand SJCE Risk Management Policy and Regulations and manage reviews and amendments.
• Support the development of middle office procedures.
• Monitor and evaluate energy market risks and market events. Develop and share knowledge of energy industry trends, new developments, and emerging risks.
• Perform other duties that may be assigned from time to time.

The ideal candidate is a highly motivated individual with strong analytical, quantitative, and problem-solving skills. The candidate should have effective communication skills, show attention to detail, and be able to work independently. Candidates that are highly collaborative with colleagues and outside stakeholders are ideal.

The Risk Management and Contracts Administration Division is responsible for providing independent oversight of the risks in transacting for energy products and services as well as ensuring compliance with adopted risk management policies and procedures. This unit provides strategic support to facilitate the development and execution of various contracts, and also manages the contracts administration and settlements function.

Competencies

The ideal candidate will possess the following competencies, as demonstrated in past and current employment history. Desirable competencies for this position include:

• Job Expertise - Demonstrates knowledge of applicable professional/technical principles and practices, Citywide and departmental procedures/policies and federal and state rules and regulations.
• Analytical Thinking - Approaches a problem or situation by using a logical, systematic, sequential approach.
• Initiative - Exhibits resourceful behaviors toward meeting job objectives; anticipates problems, is proactive, and avoids difficulties by planning ahead; displays willingness to assume extra responsibility and challenges; pursues continuing education opportunities that promotes job performance.
• 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.
• Multi-Tasking - Can handle multiple projects and responsibilities simultaneously; has handled a wide variety of assignments in past and/or current position(s).
• Computer Skills - Experienced with common business computer applications including but not limited to: MS Outlook, MS Word, MS PowerPoint, MS Access, MS Excel, as well as data visualization and modeling tools.
• Communication Skills - Effectively conveys information and expresses thoughts and facts clearly, orally and in writing; demonstrates effective use of listening skills and displays openness to other people's ideas and thoughts. Demonstrates basic knowledge of negotiation skills.

Salary Information:

Power Resources Specialist I is $99,503.04 - $121,255.68.

Power Resources Specialist II is $108,282.72-$131,913.60.

This range includes an approximate five (5%) ongoing on-pensionable pay. Actual pay shall be determined by the candidate's qualifications and experience.

An exciting opportunity is now open.

Senior Project Manager

$129,197 - $173,136 Annual DOQ

Or

Project Manager

$114,191 - $153,027 Annual DOQ

Opening Date: May 2, 2024

Closing Date: Open until filled.

Priority screening date: May 17, 2024

(Interested candidates are encouraged to apply immediately for consideration).

The Santa Clara County Housing Authority (SCCHA) is the county’s largest provider of affordable housing, helping make rental housing safe and affordable for approximately 20,000 low-income households.

How You Will Make an Impact:

The Santa Clara County Housing Authority (SCCHA) is the county's largest provider of affordable housing, helping make rental housing safe and affordable for approximately 20,000 low-income households. By embedding the innovative spirit of the Silicon Valley into our agency’s culture, we are elevating our efforts to address the affordable housing shortage in Santa Clara County.  To ensure equity and justice, we prioritize housing developments for extremely low-income individuals and families that embrace residents’ lived experiences.  Our resident-centered approach leverages our real estate capacity, talented staff, and community partnerships.  SCCHA’s Real Estate Development Division is a mission oriented, dynamic, and collaborative team, working closely together to creatively develop new affordable housing as well as preserve existing assets in service of the tenants and communities we serve. 

SCCHA has a robust pipeline of affordable housing development in various stages of development.  We are looking for a team member to join at either the Senior Project Manager or Project Manage role.  The project management candidate has a unique opportunity to join a growing and dynamic team dedicated to providing affordable housing, all while growing their skillset and expertise developing complex multifamily affordable communities. 

Why Join Our Team?  

• We are a mission driven local organization working to address one of the most significant crises our community faces. 

• We are strategic and aspire to achieve big impacts. 
• We are expanding our team in response to our growing pipeline and desire to extend our impact in the community. 
• We are committed to seeking out and valuing diverse perspectives so that we can respond to and serve our diverse community. 
• We are committed to caring for our staff, because we know that if we take care of our staff, they will take care of the people we serve. 

For a detailed description of the position’s essential functions, please click the applicable link:

• Senior Project Manager, click HERE
• Project Manager, click HERE

TO VIEW JOB ANNOUNCEMENT, CLICK ON THE 'JOB ANNOUNCEMENT URL' BELOW.

The position will receive a 2.5% base salary increase in July 2024.

THE POSITION

The City Attorney's Office seeks a well-qualified, motivated attorney for the position of Assistant City Attorney. This is an at-will position that serves as part of the City's executive management team. 

The Assistant City Attorney will provide legal advice, counsel, and representation to the City in areas including, but not limited to, land use, real estate, housing, and environmental law. Duties include drafting and reviewing contracts, ordinances, resolutions, deeds, permits, licenses, and other legal documents, conducting research, interpreting and updating the City Municipal Code, and providing advice to City staff. 

The Assistant City Attorney will provide counsel to the Planning Commission, the Community Development Department, other City departments, and assist with the enforcement of City Municipal Code. The Assistant City Attorney receives general direction and supervision from the City Attorney and may provide oversight and supervision to support staff. The Assistant City Attorney will oversee the work of the City Attorney's Office in the absence of the City Attorney. 

To view the full job description, click here.

THE IDEAL CANDIDATE

The ideal candidate will have a broad base of knowledge and experience in a variety of areas of municipal law such as the Brown Act, Political Reform Act, Public Records Act, contracts, personnel matters, public safety, public works, and advisory and litigation services. Extensive expertise in land use, Planning and Zoning, the Subdivision Map Act, CEQA, and Housing is especially desirable. However, applicants without land use expertise are also encouraged to apply.

The ideal candidate will have a high degree of professionalism, careful attention to detail, strong work ethic, and excellent legal judgment. The successful candidate will join a City Attorney’s Office that values collaboration, integrity, witty humor, efficiency, and exemplary customer service.  

THE DEPARTMENT

The City Attorney's Office consists of the City Attorney, Assistant City Attorney, and Department Administrative Specialist and has a departmental budget of, $1,118,400. The City Attorney's Office advises the Rocklin City Council, City Boards and Commissions, and City Departments on the legal propriety of proposed municipal actions. The City Attorney's Office also prepares and/or reviews all ordinances, resolutions. contracts and other documents and represents the City in civil litigation and acts as liaison to outside special counsel.

MINIMUM QUALIFICATIONS

Graduation from a law school accredited by the American Bar Association with a Juris Doctorate degree;

AND

Five (5) years of increasingly responsible experience as an attorney in the practice of civil or municipal law.

Licenses and Certificates:

• Active membership, in good standing, in the State Bar of California.
• A valid California Class C driver license or higher is required at the time of appointment. Individuals who do not meet this requirement due to a disability will be reviewed on a case-by-case basis.

Woodside Fire Protection District offers an exceptional Cadet Program for individuals interested in a career in the Fire Service. Cadets gain hands-on experience participating in training and public service events. Cadets work 24-hour shifts and ride-along on emergency calls.

Woodside Cadets will work and be involved in:

Emergency calls, firefighter training, public education events, fire prevention, station duties, CERPP, CPR/first aid training. They must also meet monthly hour requirements and attend monthly training drills.

The Cadet term begins in July 1st 2024 through June 30th 2025.

Cadets must have a valid EMT certification, proof of medical insurance and a valid California driver license in order to apply.

Interviews will be held June 14th and 15th.

The City of San Jose is seeking a senior level manager to direct administrative services for the Office of the City Attorney. This position works with the City Attorney and the senior management team to manage the Office and to develop and implement Office policies and procedures.

Description

The Bay Area Air Quality Management District is recruiting for the position of Assistant Counsel I/II in the Office of General Counsel. This position will focus primarily on civil prosecution of air quality violations, including cases seeking civil penalties and/or injunctive relief before the Air District’s administrative Hearing Board and in Superior Court. Experience prosecuting or defending such cases under air quality or other environmental laws, or in other similar enforcement contexts, is highly desirable. The position will also provide legal advice, counseling and representation on related legal issues arising under local, state and federal air pollution laws and regulations, including air quality permitting, development of new regulations, California Environmental Quality Act issues, contract drafting, administrative law issues, and civil rights compliance, among others. Many of the most pressing air quality issues the Bay Area faces relate to disproportionate air pollution burdens in historically disadvantaged communities, so experience and familiarity with environmental justice issues is desirable. This is a full-time, exempt, management position. There is currently one (1) vacancy.
 
About the Bay Area Air Quality Management District:

The Bay Area Air Quality Management District is the government agency responsible for protecting air quality in the San Francisco Bay Area. The Air District is tasked with regulating stationary sources of air pollution in the nine counties that surround San Francisco Bay: Alameda, Contra Costa, Marin, Napa, San Francisco, San Mateo, Santa Clara, southwestern Solano, and southern Sonoma counties. It is governed by a 24-member Board of Directors composed of locally elected officials from each of the nine counties. The Air District’s mission is to create a healthy breathing environment for every Bay Area resident, while protecting and improving public health, air quality and the global climate.
 
The Air District aims to achieve its mission through many strategic goals, including: reducing and eliminating health problems caused by air pollution, achieving and maintaining air quality standards, leading the Bay Area’s efforts to fight global climate change, creating high-quality regulatory programs, and applying environmental best practices in all operations. To do so, the Air District regulates air pollution emissions from stationary emission sources such as factories, refineries, and power plants, and from smaller facilities like gas stations and dry cleaners. The Air District ensures that such facilities comply with air pollution laws and regulations, provides incentives to replace older, higher-emitting vehicles and equipment with cleaner alternatives, and gives grants and provides outreach to encourage healthy clean air choices by businesses and consumers. The Air District implements these efforts with an equity focus, aiming to reduce air quality disparities and promote environmental justice by targeting local air pollution in overburdened communities.  
The Air District recognizes and values the contributions of every employee and works to sustain an environment where everyone is respected. We incorporate the principles of diversity, equity and inclusion within our decision-making strategies, policies, procedures, regulations, funding initiatives, public outreach, planning, and hiring.
 
About the Position:
 
Under direction, the position performs legal work of a routine to complex nature representing the Air District, provides advice and counsel to Air District management and staff, represents the Air District in court and administrative proceedings, and performs related work as assigned.
 
Distinguishing Characteristics:
 
Assistant Counsel I is the entry level in this specialized attorney series. It is designed to allow an experienced civil attorney to gain specific environmental law experience. This class is alternately staffed with Assistant Counsel II, and incumbents may advance to the higher level after gaining experience and demonstrating proficiency that meet the qualifications of the higher level class.
 
Assistant Counsel II is the journey level class of this specialized series, fully competent to perform a wide range of environmental law work. This class is responsible for providing effective legal counsel in complex and controversial environmental law matters. This class is distinguished from Senior Assistant Counsel in that the latter assists in administering and coordinating all phases of legal work for the Legal Division.

Examples of Duties for this Position

Prepares and tries routine to difficult cases, often involving a specialized body of law.

Represents the Air District in court and in administrative hearings before boards and commissions and state and federal agencies.

Investigates and prepares reports regarding claims by and against the Air District and recommends actions to be taken.

Advises Air District departmental management regarding Air District authority, jurisdiction, functions and operational procedures.

Researches legal problems and prepares opinions, briefs, ordinances, resolutions, and other legal documents.

Attends Air District departmental, board and commission meetings to provide legal advice on a variety of matters.

Reviews ordinances, resolutions, contracts and other documents for legal sufficiency; recommends modifications as required.

Maintains accurate records and files and compiles reports of work performed.

Monitors legal developments, including proposed legislation and court decisions; evaluates their impact on Air District operations and recommends appropriate action.

Minimum Qualifications

Education and Experience:
 
Assistant Counsel I: Equivalent to graduation from a college or university plus an appropriate law degree and two years of experience as an attorney engaged in the practice of law, preferably with a public agency and preferably involving environmental law and/or enforcement cases, although other relevant experience will be considered.
 
Assistant Counsel II: In addition to the above, two additional years of experience as an attorney engaged in the practice of law, preferably practicing civil environmental enforcement with a public agency in the State of California, although other relevant experience will be considered.
 
 Other Requirements:
 
 Must be a member in good standing of the State Bar of California at the time of hire.

How to Apply & Selection Criteria

HOW TO APPLY: 
Interested individuals must submit a completed application and the responses to the supplemental questions (including a writing sample) no later than 5:00 p.m. on Monday, May 20, 2024. Applications are also accepted online. Please visit our website at www.baaqmd.gov/jobs to apply or to download an application. Resumes are encouraged, but not mandatory, and may not be submitted in lieu of the required application materials. Postmarks, faxes, and E-mailed applications will not be accepted.
 
Except as requested in this announcement, do not include any additional documents, such as letters of recommendation, performance evaluations, etc. They will not be considered or returned.
 
SUPPLEMENTAL QUESTIONNAIRE INSTRUCTIONS: 
Individuals who apply for this position must respond to each of the supplemental questions. Both paper and online applications must be received by the Human Resources Office no later than the time and date specified in the vacancy announcement. The responses to the supplemental questions will be used in accordance with the procedures indicated under the Selection Criteria in the vacancy announcement.
 
Instructions: Please limit your responses to one page per question. Do not combine your responses, or reference your application, resume, or any other requested documentation that you have included with your application packet to answer a question. Please be advised that the information you provide will be evaluated “as is” and incomplete or illegible applications will likely receive lower ratings. Therefore, it is very important to provide a concise, organized, and easy to follow response to each question.
 
You must provide the following for each question regarding experience: The name of the employer where you gained your experience, your job title, length of time in years/months performing the specific function, and detailed examples that illustrate your duties and responsibilities.
 
SELECTION CRITERIA: 
Selection may be based upon a competitive examination consisting of a written exercise, interview, or combination of the two. Depending on the number of qualified applicants, an application screening and/or panel interview may be used to determine the most qualified applicants.
 
The Air District may hire from this recruitment process to fill future vacancies occurring within the next 18 months.
 
Updates regarding your status in the recruitment will be sent via email, unless you indicate a different preference on your application.
 
Persons with disabilities who may require reasonable accommodations during the application and/or selection process should notify the Human Resources Office at (415) 749-4980.
 
 The Air District is an Equal Opportunity Employer.

The City of San José, Office of the City Attorney is seeking an entry-level attorney in the Transactional division. Under the direction and supervision of senior management in the Office of the City Attorney, the Associate Deputy City Attorney position will perform basic attorney work benefiting a variety of City Departments while receiving valuable training and experience for a career in public service. This position will be assigned increasingly complex legal work under supervision in support of various City Departments in areas including public works, procurements, employment, land use planning, environmental services, public safety, utilities and housing. Responsibilities also include preparing opinions, ordinances, resolutions, contracts, and other legal documents.

The position is responsible for the performance of both the day-to-day power settlements among NCPA members, Western, California, and Federal electricity markets, local balancing authority area operators (CAISO, BANC, EIM), as well as settlement activities associated with NCPA Power Management’s Service Customers. Other responsibilities include tracking and meter data management validation duties, GHG (Greenhouse Gas) monitoring and analysis, analysis and testing associated with new CAISO market initiatives, and comprehensive analytic or technical studies, as required, including proceedings before state and federal regulatory agencies and public officials. This is a full journey-level position capable of performing all the duties and responsibilities of the Settlements Analyst I. Performs the full range of duties as assigned, receiving only occasional instruction, training, or assistance as new or unusual situations arise. Additionally, incumbents perform a variety of assigned complex technical and professional work in the areas of power accounts settlements, budgeting, systems development, and audit. Incumbents also provide technical analysis and assistance to staff, Members, contractual participants, and others, as required.

ESSENTIAL DUTIES AND RESPONSIBILITIES
This position requires that the incumbent report for work on time and maintain satisfactory attendance in accordance with Agency policy; Ensures work responsibilities are covered when absent; Arrives to meetings and appointments on time; Performs special assignments as assigned. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.

Responsibilities:
Provides technical advice, functional instruction, and guidance to less experienced Power Settlement staff as needed. Trains new Power Settlements Analysts and cross trains as roles evolve. Recommends personnel actions. Prepares and presents training/tutorials on All Resources Bill, Pre-Bill process, Power Settlement processes overall, and various other topics, as needed, in person or via webinars (s) to NCPA Members and Project Participant staff.

Serves as subject matter expert, working with Information Services, on Power Settlements application requirements, such as All Resources Bill enhancements, and testing system enhancements in development.

Implements and operates complicated power settlements systems. Prepares complex analytical reports and supporting documentation.

Provides analysis, integration, and implementation of new energy market initiatives and/or customers/Scheduling Coordination accounts (e.g., ISO, Western Energy Imbalance Market (“EIM”), renewable generating resources, Community Choice Energy/Aggregators (“CCE”).

Monitors settlements associated with Renewable Energy Credits and acts as or provides support to NCPA’s Qualified Reporting Entity representative; registers credits on the Western Renewable Energy Generation Information System (“WREGIS”) or its successor.

Monitors settlements functions of Western capacity and energy allocations, market purchases and sales, Pool transmission activity, and other transactions as they occur; Prepares or reviews power settlement transactions for proper budget classification.

Conducts special studies requiring complex, voluminous, and detailed analysis of power costs and revenues. Recommends operational changes that provide better value to Members and Participants.

Coordinates and participates in the development, analysis, and monitoring of the Agency's power supply budgets. Acts as power settlements representative to other department managers and supervisors in regard to cost summary and budgetary reports.

Assists with the implementation of systems, policies, and procedures and special projects requiring highly technical study and analyses. Recommends changes or modifications to methods or systems as applicable.

Assists with formal budget and other presentations to upper management and the governing body.
Performs special assignments for the Power Settlements Supervisor or others as assigned, including preparation of testimony and exhibits for presentation before state and national regulatory proceedings.

MINIMUM QUALIFICATIONS

Education and/or Experience
Bachelor's degree (B. A.) from a four-year college or university with an emphasis on quantitative analysis, plus four (4) years of prior experience as a Power Settlements Analyst I or an equivalent combination of education and experience.

KNOWLEDGE AND ABILITIES 
Knowledge:
Knowledge of California Independent System Operator settlements procedures for tariff services and Metered Subsystem services; NCPA settlements procedures for scheduling coordinator services and the ten-member power pool; California Energy Imbalance Markets; NCPA’s Western (WAPA) contracts
California’s Green House Gas rules; CARB renewable energy credits; Knowledge of NCPA settlements procedures for scheduling coordinator services and the ten-member power pool.

Abilities:
Ability to retrieve detailed records and summary-level data from NCPA’s Oracle database systems through the use of Structured Query Language (“SQL”) statements in proprietary software (e.g., SAS, Toad, SQL Developer, Oracle Database Connection [“ODBC”]) and process through proprietary or open-source software programming applications (e.g., SAS, Visual Basic for Applications [“VBA”], R, Python, Excel workbooks); Ability to read, analyze, and interpret CAISO tariff, NCPA operating agreements, and contracts, standard industry power purchase agreements, technical procedures, and governmental regulations; Ability to write reports, business correspondence, and procedure manuals; Ability to present information effectively and respond to questions from groups of managers, clients, customers, and the general public; and the Ability to analyze and interpret settlement formulas expressed in summation notation.

SPECIAL REQUIREMENTS

Valid California Driver's License and insurance. 

This job has no supervisory responsibilities.

WORK ENVIRONMENT

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. While performing the duties of this job, the employee is frequently required to stand; sit; use hands to finger, handle, or feel; reach with hands and arms and talk or hear. The employee is occasionally required to walk; climb or balance; stoop, kneel, crouch, or crawl, and taste or smell. The employee must occasionally lift and/or move up to 10 pounds. Specific vision abilities required by this job include close vision, distance vision, depth perception, and the ability to adjust focus.

The noise level in the work environment is usually moderate.

All employees are responsible for contributing to an inclusive, safe, and secure work environment that values diverse cultures, perspectives, and experiences and is free from discrimination.