Senior Business Analyst

Seattle, WA, United States

Salary : $113,235.20 - $143,520.00 Annually

Location : Seattle, WA

Job Type: Career Service, Full Time, 40 hrs/week

Job Number: 2024JS21854

Department: DAJD-Adult/Juvenile Detention

Division: Administrative Services

Opening Date: 06/28/2024

Closing Date: 7/11/2024 11:59 PM Pacific

FLSA: Exempt

Bargaining Unit: Z3 : KC Personnel Guidelines

Full- or Part-Time: Full Time

Summary

The Department of Adult and Juvenile Detention (DAJD) seeks a skilled business intelligence professional to join our team as a Senior Business Analyst/Data Scientist . This role will involve designing, developing, and continuously improving business intelligence solutions, providing crucial guidance for DAJD. The ideal candidate will work autonomously, leading studies and conducting analytical and statistical analyses on complex, multi-dimensional issues affecting various programs, policies, systems, and processes. Utilizing data-driven insights, the successful candidate will devise actionable strategies that align with the Department's goals to optimize efficiencies in policy, organizational structure, process improvements, inter-agency data collaboration, and service delivery initiatives.

DAJD is striving to provide in custody and community-based services that are data informed, advance safety, lead system change and promote equitable outcomes for the people we serve. The Department of Adult and Juvenile Detention is a professional and nationally recognized organization that supports safe, vibrant, and healthy communities in partnership with other criminal justice and human service agencies.

This recruitment may be used to generate a pool for future Career Service, Term Limited Temporary (TLT), and Special Duty Assignment (SDA) positions that may occur in this classification. The pool would be valid for 12 months upon creation and may be extended at the discretion of the hiring authority.

Job Duties

The job description is an overview and is intended to describe the general nature and level of work being performed. It is not an exhaustive list of all the functions and tasks required of this position.

Design, develop, implement, and maintain reporting tables, metrics, and reports that drive key business decisions using approved Microsoft and third-party BI applications.

Prepare performance dashboards, regular performance reports, and summaries of results and interpretations of findings for a wide range of audiences including agency leadership, employees, community representatives and Senior County Officials.

Conduct business analytics, research data, and create visualizations and tools to help inform data-driven decisions.

Utilize excellent verbal and written communication skills to interact professionally with diverse groups, senior leaders, managers, subject-matter experts, and convey technical information to non-technical users.

Maintain system data and system integrity by evaluating and coordinating the correction of system problems, developing solutions, and resolution documentation.

Analyze, design, and monitor system functionality. Gather, define, and translate complex system requirements into functional specifications. Document findings and specifications, develop system integration test plans, and propose efficiencies and business process improvements.

Research, design, data map, develop, test, implement, train and document enterprise application systems; BI reports, application modifications, business process improvements, system configuration changes, and other related application functions.

Analyze and test proposed system interfaces, enhancements, and upgrades prior to implementation. Develop acceptance criteria.

Lead and work closely with other multidisciplinary teams to complete complex studies and analyses to define business requirements and alternative options for improvements for a variety of operational, procedural, and management issues.

Act as consultant and primary advisor to all levels of management across division and department lines, partner agencies, County leadership and serve as an expert technical resource for cross-functional, inter-departmental, cross-agency projects and project teams.

Support business teams in identifying and delivering significant and quantifiable business process improvements through the application of process improvement methodologies.

Lead the education and training of multidisciplinary team members in the use of performance feedback systems and visual management tools to assess the health of the organization.

Apply equity and social justice principles that exemplify shared values, behaviors, and practices to all aspects of this work.

Provide support and training to end users on system software and tools.

Perform other duties as assigned.

Experience, Qualifications, Knowledge, Skills A Bachelor's degree in Information Technology, Business, Public Administration, or related field accompanied by at least 3 years relevant experience in business process analysis and improvement experience. This experience should include a minimum of two years in facilitation or leadership roles; OR,

Any combination of experience/education/training that has equipped individuals with the required knowledge, skills, and abilities to perform the work

Knowledge/Skills/Experience

Advanced expertise in analysis, design, development, and maintenance of complex business and data management systems

Knowledge and experience with data warehouse development and maintenance, preferably Microsoft Azure Synapse Analytics

Proficiency in Data Visualization tools such as Power BI and/or Tableau

Familiarity and application of project management techniques, methodologies, and tools

Competence in applying statistical analysis of variance concepts for identifying benchmarks, trends, and anomalies

Ability to analyze qualitative and quantitative data, solve intricate analytical problems, and provide recommendations based on thorough data analysis

Understanding of group dynamics and change management methods Capability to coach, mentor, train, and teach adult learners effectively

Experience in facilitating small and large group meetings, process improvement workshops, and discussion groups

Effective verbal and written communication skills, including preparing clear, concise reports and delivering presentations to diverse audiences

Ability to collaborate with individuals from varied backgrounds and organizational roles, fostering open communication and maintaining collaborative relationships

Proficiency in team building Strong customer service orientation and knowledge

Proficiency in using office software programs including word processing, spreadsheet, database, statistical analysis tools, presentation, cloud-based collaboration tools, and email

Understanding of equity and social justice principles

Experience in working with diverse groups including executives, senior leaders, managers, subject matter experts, customers, technical, and non-technical audiences

Desirable Skills and Experience

Data processing languages/tools such as SQL, FetchXML, DAX, python

Knowledge of Microsoft Power Automate

Knowledge of Microsoft Dynamics 365 design/management

SharePoint site design/management

Knowledge of process improvement methods and techniques such as Lean and Six Sigma

Knowledge and/or experience with GIS tools such as ArcGIS, etc.

Experience in corrections, or other criminal justice or 24 X 7 operating organization.

Highly Qualified Candidates will have: Microsoft Power BI Certification

Microsoft Power Platform Developer Certification

Microsoft Certified: Azure Data Engineer Associate

Microsoft Certified: Azure Data Scientist Associate

Supplemental Information

HOW TO APPLY: Completion of the full King County application and supplemental questionnaire is required. If you are interested in pursuing this position, please follow the application instructions carefully. If you need this announcement in an

alternate language or format, would like to request accommodation or assistance in the application or assessment process, or if you have questions, please contact the recruiter listed on this job announcement.

APPLICATION PROCESS:

The following items are required to be considered for this opportunity:

• An electronic application through www.kingcounty.gov/jobs or www.governmentjobs.com (use the ''.Apply" link) including work history and position duties.

• Resume

• Letter of Interest-detailing your background and describing how you meet or exceed the requirements of the position.

• Responses to supplemental questions.

Your application may be rejected as incomplete if you do not include the relevant information in the application. Cover letters and/or resumes are not accepted in lieu of a completed application. Applications and/or Supplemental Questionnaires that state "see my resume" or "see my personnel file" are considered incomplete and will not be accepted.

The selection process may include but is not limited to: evaluation of application materials and supplemental questions, interviewing, and assessments.

UNION MEMBERSHIP: This position is not represented by a collective bargaining agreement.

WORK SCHEDULE: This position will work a 40-hour workweek. Standard hours are Monday through Friday, 8:00 a.m. to 5:00 p.m.

This position is exempt under the provisions of the federal Fair Labor Standards Act (FLSA),

meaning that it is not eligible for overtime pay or compensatory time accrual, and the incumbent will be required to work the hours necessary to meet position responsibilities.

WORK LOCATION: The work associated with this position will be performed through a hybrid work model that will require both onsite and remote work. The ratio of remote to onsite work will be dependent on business needs and is subject to change.

The primary onsite work location for this position is the King County Courthouse at 516 3rd Avenue, E 245, Seattle WA 98104. However, candidates must be willing and able to report to work at different secured detention facilities in Seattle and Kent.

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

Employees will be provided with a County issued laptop and, when working remotely, must maintain a workspace with an internet connection where they can reliably perform work and remain available and responsive during scheduled work hours.

SPECIAL REQUIREMENTS: The person selected for this position may be required to complete a thorough background investigation process, including fingerprinting, criminal history check, and reference checks.

DEPARTMENT CONTACT: Questions regarding this announcement or position may be directed to: Jaclyn Smith, DAJD Sr. Human Resources Analyst; Phone Number 206-263-3379 or via email at

Forbes recently named King County as one of Washington State's best employers.

Together, with leadership and our employees, we're changing the way government delivers service and winning national recognition as a model of excellence. Are you ready to make a difference? dedicated to serving one of the nation's best places to live, work and play.

Guided by our , we are making King County a welcoming community where every person can thrive. We value diversity, inclusion and belonging in our workplace and workforce. To reach this goal we are committed to workforce equity. Equitable recruiting, support, and retention is how we will obtain the highest quality workforce in our region; a workforce that shares and will help advance our guiding principles - we are one team; we solve problems; we focus on the customer; we drive for results; we are racially just; we respect all people; we lead the way; and we are responsible stewards. We encourage people of all backgrounds and identities to apply, including Native American and people of color, immigrants, refugees, women, LGBTQ+, people living with disabilities, and veterans.

KING COUNTY IS AN EQUAL EMPLOYMENT OPPORTUNITY (EEO) EMPLOYER

No person is unlawfully excluded from employment opportunities based on race, color, religion, national origin, sex (including gender identity, sexual orientation and pregnancy), age, genetic information, disability, veteran status, or other protected class. 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.

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: Medical, dental, and vision coverage: King County pays 100% of the premiums for eligible employees and family members

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: King County employees are eligible to 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

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

Are you applying to this position as an eligible current or previous King County Employee Priority Placement Program Participant? ANDIs this position the same or lower percentage of full-time when compared to the position held at the point of the notification of layoff? ANDDo you possess the skills and abilities to qualify for this position? Yes, I was given a layoff notice from my Career Service role at King County and I am within two years of the effective date of my layoff. Additionally, the position I was laid off from was the same or a higher percentage of FT status when compared to this one.

No.

02

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 notice2. The department you worked in3. The effective date of your layoff

03

The following items are required to be considered for this opportunity: 1. An electronic application through www.kingcounty.gov/jobs or www.governmentjobs.com (use the ".Apply" link) including work history and position duties. 2. Resume 3. Letter of Interest-detailing your background and describing how you meet or exceed the requirements of the position. 4. Responses to supplemental questions. I understand and have attached all the required documents to my application prior to submitting. Yes

No

04

The Department of Adult and Juvenile Detention is firmly committed to a drug-free workplace. Employees of the department are prohibited from using illegal drugs. Should you be hired by the Department of Adult and Juvenile Detention, you acknowledge that you will adhere to the department's policies and rules regarding drug use. Yes

No

05

PLEASE NOTE: A "yes" response to any of the remaining questions may automatically disqualify you from further consideration. Responses will be confirmed and verified in the course of the department's background investigation process. Do you understand that a "yes" response to the remaining questions may automatically disqualify you from further consideration. Yes

No

06

In the last 3 years, have you been convicted of a domestic violence or a domestic violence-related crime? Yes

No

07

Have you ever been disciplined in the workplace for sexual, racial, or other harassment or discrimination? Yes

No

08

In the last 3 years, have you been convicted of Driving Under the Influence (alcohol or drugs)? Yes

No

09

In the last 3 years, have you bought, sold, offered to sell, possessed, transported, manufactured,delivered or possess with intent to manufacture or deliver a controlled substance? • Cocaine orcrack • Club drugs - Ecstasy, Ketamine, GHB, Rohypnol or MDMA • Hallucinogens - PCP, Angel dust,Wet, Phencyclidine, LSD, Mushrooms or Psilocybin • Opiates -Opium, Morphine or Heroin • Stimulants - Methamphetamines, Crank, Crystal, Ice, Speed, Glass or Amphetamine • Aerosols - Huffing paint or Nitrous Oxide (Whippits), or Khat Yes

No

10

In the last 3 years, have you illegally used any other controlled substance or other illegal drugs/narcotics? For purposes of this question, illegal drugs/narcotics/controlled substances include, but is not limited to, the following: Cocaine or Crack• Club drugs: Ecstasy, Ketamine, GHB, Rohypnol, or MDMA • Hallucinogens: PCP, Angel dust, Wet, Phencyclidine, LSD, Mushrooms or Psilocybin • Opiates: Opium, Morphine or Heroin • Stimulants: Methamphetamines, Crank, Crystal, Ice, Speed, Glass or Amphetamine • Aerosols: Huffing paint, Nitrous Oxide (Whippits), or Khat Yes

No

11

Have you undergone the background investigation process for employment with the King County Department of Adult and Juvenile Detention within the last two years? Yes

No

12

If yes, please specify the approximate date(s) and position(s) for which you previously went through the department's background process.

Required Question