Functional Analyst II

King County, WA; Seattle (WA); Hybrid; USD 85,000 - 120,000; Full time

Benefits offered by this job

Hybrid schedule

Pension plan

Transit pass

Training opportunities

Job summary

King County Department of Public Defense seeks an analytical, service‑oriented Functional Analyst II to organize and analyze data, maintain spreadsheets and databases, prepare professional documents, and respond to special data requests for the Director’s Office.

The successful candidate will use Excel databases, Office 365, and SharePoint, communicate with technical and non‑technical staff, and apply an equity and social justice lens while managing multiple priorities under deadlines.

Qualifications

• Three years of experience with data spreadsheets and systems in a legal setting.
• Valid Washington Driver’s License or ability to travel across King County.

Responsibilities

• Provide technical support interpreting policies, procedures, processes, and data.
• Research and summarize technical information from varied sources using spreadsheets and databases.
• Maintain accurate spreadsheets and data for the Director and Deputy Director.
• Draft and edit documents, forms, and correspondence for professionalism.
• Create training materials, user guides, and process documentation.
• Query, clean, and standardize data from management databases for reporting.
• Assist with ad‑hoc data requests for policy, planning, and budgets under deadlines.
• Support colleagues in building technical proficiency with department data systems.

Skills

Analytical thinking

Communication

Equity lens

Data interpretation

Tools

Excel

Power BI

Power Query

Tableau

SharePoint

Visio

Access

Job description

Summary

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 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.

Job Duties

• 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.

Other Functions

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.

Experience, Qualifications, Knowledge, Skills

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 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.

Desired Qualifications:

• 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.

Knowledge Of:

• 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

Ability To:

• 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.

Supplemental Information

King County offers great benefits, to include a pension plan, holidays, transit pass, plus training and education opportunities to promote growth and development. Our focus is to provide our employees with work life balance.

This opportunity is open to all applicants.

This recruitment may be used to fill a Career Service (CS), Term‑Limited Temporary (TLT) or Special Duty Assignment (SDA) Functional Analyst II position, and to establish an eligibility list for vacancies that may occur within the next six months. Term‑Limited Temporary and Special Duty Assignments may last up to 12 months and may be extended or end early based on business needs.

Special Duty opportunities are only open to current King County career service employees that have completed their initial probation. Special Duty applicants must have approval from their current supervisor to accept an assignment.

Pay Upon Special Duty Placement: current employees selected for special duty will be compensated based upon the provisions of the King County Code/Personnel Guidelines for their base position.

WORK SCHEDULE AND LOCATION

The Director’s Office works in a hybrid model, with an onsite minimum of three (3) days per week. During the probationary period, employees are required to work onsite four (4) days per week. The ratio of telecommuting to onsite work will be dependent on business needs and is subject to change. The primary onsite location for this position is the Dexter Horton Building, 710 Second Avenue, Seattle.

Employees must reside in Washington state and within a reasonable distance to their King County worksite to respond to workplace reporting requirements.

King County has a robust collection of tools and resources to support working remotely. The individual selected for this opportunity will join an innovative and progressive team that is redefining how we work as we transition to the department's hybrid environment. Employees will be provided with a County‑issued laptop and must maintain a home workspace with an internet connection where they can reliably perform work and remain available and responsive during scheduled work hours.

The typical workweek is 40 hours per week, Monday through Friday, 8:00 a.m. to 5:00 p.m. This position is non‑exempt from the provisions of the Fair Labor Standards Act and is eligible for overtime.

Rotations of work location and practice area and/or workflow are an essential function and can occur based on business need. You may be required to report to any of our Seattle and/or Kent locations.

DPD Policies

Outside Work Policy for Administrative Staff will apply to employees, such that you must receive approval from your supervisor and Managing Attorney before being permitted to engage in outside employment for compensation or volunteer.

Union Membership

This position is not represented by a union.

King County's Vision, Mission, and ACTIVATE Values unite us.

King County serves residents with a relentless sense of urgency, delivering on commitments with transparency and accountability. We are action‑oriented, creative problem solvers who collaborate across roles, engage directly with communities, and challenge the status quo to achieve meaningful impact. As a unified team, we uphold high ethical and stewardship standards, embrace change, stay curious, and continuously improve. Across all interactions, we listen first, act quickly, and stay aligned as a team to earn and sustain public trust. Learn more about our Vision, Mission, and ACTIVATE Values here and visit our Why work at King County page.

King County is an Equal Employment Opportunity (EEO) Employer

No person is unlawfully excluded from employment opportunities based on sex, race, color, national origin, ethnicity, religious affiliation, disability, sexual orientation, gender identity or expression, age except by minimum age and retirement provisions, pregnancy, status as a family caregiver, parental status, marital status, military status or status as a veteran who was honorably discharged or who was discharged solely as a result of the person's sexual orientation or gender identity or expression, citizenship or immigration status, genetic information, or other protected class. However, to the extent that distinction or differential treatment on the basis of citizenship or immigration status is authorized by either federal or state law, regulation, or government contract, it is not an unfair practice.

Our EEO policy applies to all employment actions, including but not limited to recruitment, hiring, selection for training, promotion, transfer, demotion, layoff, termination, rates of pay or other forms of compensation.

Benefits

King County offers a highly‑competitive compensation and benefits package designed to meet the diverse needs of our employees and support our employees' health and well‑being. Eligible positions receive the following benefits and have access to the following programs:

• Excellent medical, dental, and vision coverage options: King County provides eligible employees with options, so they can decide what’s best for themselves and their eligible dependents
• Life and disability insurance: employees are provided basic coverage and given the opportunity to purchase additional insurance for both the employee and eligible dependents
• Retirement: eligible King County employees may participate in a pension plan through the Washington State Department of Retirement Systems and a 457(b) deferred‑compensation plan
• Transportation program and ORCA transit pass
• 12 paid holidays each year plus two personal holidays
• Generous vacation and paid sick leave
• Paid parental, family and medical, and volunteer leaves
• Flexible Spending Account
• Wellness programs
• Onsite activity centers
• Employee Giving Program
• Employee assistance programs
• Flexible schedules and telecommuting options, depending on position
• Training and career development programs

For additional information about employee benefits, visit our Benefits, Payroll, and Retirement Page.

This is a general description of the benefits offered to eligible King County employees, and every effort has been made to ensure its accuracy. If any information on this document conflicts with the provisions of a collective bargaining agreement (CBA), the CBA prevails.

NOTE

Benefits for Term Limited Temporary (TLT) or Short Term Temporary (STT) positions, including leave eligibility and/or participation in the pension plan through the Washington State Department of Retirement Systems, will vary based upon the terms and details of the position. Short Term Temporary positions are not eligible for an ORCA transit pass.

For inquiries about the specifics of this position, please contact the recruiter identified on this job posting.

01

Specifically, describe how you meet the 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.

02

Did you attach a cover letter to your online application?

• Yes
• No (a cover letter and resume is required, please make sure to attach one before submitting your application).

03

Are you applying to this position as an eligible current or previous King County Employee Priority Placement Program Participant? Is this position the same or lower percentage of full‑time when compared to the position held at the point of the notification of layoff? Do you possess the skills and abilities to qualify for this position?

04

If you answered yes to the question above and you are applying for this position as a Priority Placement Participant, to be considered, you must provide the following three pieces of information in the space provided: 1. The title you held when you received your layoff notice 2. The department you worked in 3. The effective date of your layoff

05

Skills

To ensure a fair and consistent evaluation process, candidates are not permitted to use artificial intelligence (AI) tools or assistants at any stage of the interview, or any other technology that generates or influences interview answers. All interview responses must reflect the candidate's own knowledge, skills, and experience. The use of unauthorized AI tools during the interview process may result in removal from consideration. Please confirm that you understand and agree to this requirement:

• Yes, I understand and agree not to use AI tools or assistants during my interview.
• No, I cannot agree to this requirement.

06

This position requires employees to work onsite a minimum of three (3) days per week. During the probationary period, employees may be required to work onsite four (4) days per week. Additional onsite attendance may be required based on business needs. Are you able to meet these requirements?

• Yes
• No
• Required Question