Functional Analyst II

King County•Seattle, WA

1d•Hybrid

About The Position

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 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 Department's Mission Statement 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.

Requirements

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 the desired skills, knowledge, and ability required to perform the work
Valid Washington Driver’s License or the ability to travel throughout King County in a timely manner.
Organizational skills and the ability to manage multiple, sometimes competing, priorities to produce accurate and timely work products.
Client organizational business systems and practices, business systems integration and design, workflow analysis.
Systems analysis; relational databases and automated systems data modules, automated systems testing procedures, data conversion analyses, design, and troubleshooting applications; table relationships, and views
Provide technical support to non-technical staff.
Create training materials and deliver training to staff with varying levels of technical proficiency.
Manage documents and information within Microsoft Office Suite: Excel, Power Point, Visio, Word, Access, Power BI, and SharePoint, including organizational structure and access management.
Analyze raw data, including cleaning and standardizing data for reporting purposes.
Interact with a broad range of key interested parties — including staff, leadership, and external partners — to understand needs, translate them into workable solutions, and communicate technical information clearly to non-technical audiences.
Apply a lens of equity and social justice in the work and demonstrate inclusive behaviors as a team member.
Communicate effectively, both orally and in writing, with individuals from diverse backgrounds and technical skill levels.
Handle multiple competing priorities and producing quality detailed work within tight timeframes.

Nice To Haves

Demonstrated working experience in a law firm, preferably public defense.
Demonstrated working experience in a unionized environment.
Creating reporting tools used by Leadership or Executives.
Experience developing dashboards, reports, and using tools like Power BI, Power Query, Tableau, or similar platforms.

Responsibilities

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.