Enter a job title or keyword

Functional Analyst II


Job Location:

Seattle, WA - USA

Hourly Salary: USD 45 - 58
Posted: 2 October 2026 (17 hours ago)
Application Deadline: 30 December 2026
Vacancies: 1 Vacancy

Job Summary

Summary


DPD seeks an analytical service-oriented Functional Analyst II to provide functional systems data reporting and process support to the Directors Office. The successful candidate will have access to sensitive and privileged information related to the Deputy & Directors 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 Directors Office for up to six months.

The Departments 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

ESSENTIAL JOB FUNCTIONS AND DUTIES include but are not limited to the following:

  • 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 Directors 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 DPDs 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; ORany equivalent combination of experience education or training that demonstrates the desired skills knowledge and ability required to perform the work
  • Valid Washington Drivers 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.

Are you ready to make a difference Comejoin the team dedicated to serving one of the nations best places to live work and play. This opportunity is open to all applicants.

To be considered for this role submit the following items:

  • Completed King County application.
  • A current/chronological resume.
  • Cover letter detailing your background and what you can bring to the Department of Public Defense.

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.

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

The selection process may include evaluation of application materials and supplemental questions interviewing references a personnel file review going back the last three (3) years and if applicable a background check. You must completely fill out the application with your relevant education and work experience and attach the required documents to your application.

WORK SCHEDULE AND LOCATION
The Directors 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 departments 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 Staffwill 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.

Application Process

If you are interested in pursuing this position and supporting King Countys vision for unified equitable and high-performing government please follow the application instructions carefully. Provide us with your work history as applicable ensuring that you provide details that highlight your ability to fulfill the requirements for this position.

If you need this announcement in an alternate language or format or you would like to request accommodation or assistance in the application or assessment process please contact Peter Ocholla at .

King Countys 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 here.

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


Required Experience:

IC