Functional Analyst II

DPD seeks an analytical, service-oriented Functional Analyst II to provide functional systems, data, reporting, and process support to the Director's Office. The successful candidate will have access to sensitive and privileged information related to the Deputy & Director's work and is accountable for maintaining strict confidentiality. The ideal candidate is organized, comfortable with Excel databases, Office 365, and SharePoint, and able to manage several priorities and deadlines.

They should also communicate well with both technical and nontechnical individuals and approach their work through equity, inclusion, and social justice lens.

This position supports the Director and Deputy Director by organizing and analyzing data, maintaining spreadsheets and databases, preparing professional documents, and responding to special data requests. The functional analyst may also help employees use department technology by troubleshooting issues, providing training by creating instructions and training materials, and explaining technical information to employees with varying levels of technical knowledge.

This position may be filled as a Career Service (CS) Term‑Limited Temporary (TLT) or Special Duty Assignment (SDA), based on departmental needs. This recruitment may also be used to establish an eligibility list for future Functional Analyst II vacancies within the Director’s Office for up to six months.

The King County Department of Public Defense represents indigent adults and children facing a loss of liberty. Our department is an independent voice that promotes fairness and equity for our clients and advocates for their objectives, interests, and dignity.

DPD provides high-quality legal representation to indigent clients in felony, misdemeanor, juvenile defense, family defense (dependency), involuntary commitment, and sex‑offender commitment proceedings.

DPD advocates to reduce the harm and reach of the criminal and civil legal systems that restrict our clients' liberty and advances policy reforms to reduce systemic racism. We strive to create a flexible workplace culture that is inclusive, respectful, and supportive and is premised on a shared anti‑oppression framework.

• Provide technical support that requires interpreting established policies. procedures, processes, and data.
• Research and summarize specialized or technical information from varied sources. This may require selecting the most appropriate material and the use of spreadsheets and customized database applications.
• Maintain accurate spreadsheets with pertinent information and data related to the Director and Deputy Director’s work.
• Compose, draft, summarize, prepare, proofread and/or edit documents, forms, correspondence to ensure grammar and professionalism.
• Develop, create and maintain training documentation, user guides, and process documentation.
• Query, clean, and standardize data from management databases to support accurate reporting and analysis.
• Assist with ad‑hoc data requests in support of policy initiatives, strategic planning, and budgetary or programmatic needs, often under deadline.
• Support colleagues in building technical proficiency and confidence using Department data systems and software applications.
• Other duties, as assigned.

The department reserves the right to close this posting and/or make updates to the position description as deemed necessary in support of DPD's mission.

Minimum Qualifications:

• Minimum of three years of experience in the administration and expert use of data spreadsheets and systems in a legal setting; OR any equivalent combination of experience, education, or training that demonstrates…