King County, WA

Senior Business Analyst - Data Analytics Platform Product Manager

Seattle, WA (Hybrid)

Summary Come make a difference and join team Metro! King County Metro’s Business Intelligence team is seeking an exceptional leader to serve as the Senior Business Analyst – Data Analytics Platform Product Manager. This role is a Scrum Product Owner responsible for guiding the strategy, development, maintenance, and continuous improvement of Metro’s enterprise data warehouse and related business intelligence products (Azure Synapse / Databricks / Power BI). The successful candidate will blend strong business analysis expertise, platform expertise and experience, and product management leadership to ensure Metro’s data analytics platform, tools, and processes effectively support operational, strategic, and equity-focused decision making across the agency. This role is primarily responsible for interfacing with cross functional teams to understand business needs, translate them into technical requirements, and deliver data products that support Metro’s operational and strategic goals. The position facilitates analytical work, evaluates business processes, and helps develop meaningful performance measures and KPIs that drive improvement across the organization. As the Data Analytics Platform Product Manager, the role guides the development and enhancement of Metro’s data systems by managing product backlogs, prioritizing features, and collaborating with developers, and end-users. It also supports Agile workflows, ensures reliable and secure data access and reporting, and works with internal and external partners to strengthen data sharing practices, governance, and the overall usability of Metro’s data warehouse analytics platform. About The Business Intelligence Team The Business Intelligence Team falls within Metro's Finance & Administration division. Metro's Finance and Administration division supports other Metro divisions and department leadership by providing consistent and cross-functional enterprise-wide support services to advance Metro's strategies and targets through evidence-based management. The Business Intelligence team serves this function by developing data structures through the development of a data warehouse and the creation of data products such as data visualization, analytics and tool development. The Business Intelligence team also drives the growth of business literacy throughout the organization by developing a data-based business review process focused on continuous improvement. Position Info: This recruitment will be used to fill one (1) Career Service (CS) Senior Business Analyst classification vacancy. In addition, this selection process may be used to generate an eligibility list for future Special Duty Assignment (SDA), Term Limited Temporary (TLT), and Career Service (CS) vacancies that may occur in this classification within this workgroup. The eligibility list will be retained for 12 months from the date of posting and may be used at the discretion of the hiring authority. Job Duties Applying equity and social justice principles is a daily responsibility and foundational expectation for all King County employees. In this role, you will apply equity and social justice principles that exemplify shared values, behaviors, and practices to all aspects of this work. This position is comprised of the following core duties: Lead product or program management activities for data warehouse and business intelligence products Apply Scrum and Agile development processes and serve in a Product Owner capacity Oversee multiple concurrent projects and ensure timely delivery of data solutions Translate business requirements into technical specifications and communicate effectively between developers and -end-users Build and maintain internal and external partnerships to support data sharing and governance Support modern data engineering and analytics work using Python and Databricks Use T--SQL, Azure DevOps, and other technical tools to support data product development Provide people management support such as guiding individuals, teams, facilitating work, and coordinating efforts Design, develop, implement, and maintain reporting tables, metrics, and reports that drive key business decisions using 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, and community representatives. Utilize excellent verbal and written communication skills in order 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. Develop, maintain, and update MS Teams and SharePoint systems and applications. 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. Provide support and training to end users on system software and tools. Lead multidisciplinary teams to carry out 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; serve as expert technical resource for cross-functional, inter-departmental projects and project teams. Support business teams in identifying and delivering significant and quantifiable business process improvements through the application of process improvement methodologies such as Lean and Six Sigma. Initiate and lead problem solving efforts, working closely with internal and external stakeholders. Support multidisciplinary teams in the use of performance feedback systems and visual management tools to assess the health of the organization. Engage line/process/department personnel in all phases of improvement efforts including value stream mapping, creating standard work, and implementing daily management systems. Perform other duties as assigned. Experience, Qualifications, Knowledge, Skills We are looking for candidates who have: A bachelor’s degree or certification in business, business analytics, data science, computer science, management information systems, or related field, AND a minimum of four (4) years related business process analysis and improvement experience, which includes two (2) or more years of facilitation and/or leadership experience; OR a combination of experience and education that provides the required knowledge, skills, and abilities to perform the responsibilities of the position. Advanced knowledge of analysis, design, and development and maintenance of complex business and data management systems. Knowledge and experience with data warehouse product or program management. Knowledge of Scrum and Agile Development processes and procedures. Knowledge and experience with project management techniques methodologies and tools. Two (2) or more years of experience with using Microsoft Power BI (Business Intelligence) or similar BI tools. Intermediate to advanced proficiency with Microsoft Excel. Skill in using office software programs including word processing, spreadsheets, databases statistical analysis tools, presentation, cloud based collaboration tools, and email. Knowledge and skill in application of statistical analysis of variance concepts and theories for identification of benchmarks, trends, and anomalies. Knowledge and skill with performance management processes, data analysis and strategy. Skill and experience analyzing qualitative and quantitative data, solving complex analytical problems, and making recommendations based on analysis of data and information. Skill in translating business requirements into technical requirements/language and vice versa; experience in liaising between developers and end users Ability to manage multiple projects. Skill and experience working with a variety of individuals from diverse backgrounds and organizational roles, breaking down barriers to open communication and developing/maintaining collaborative relationships Experience working with diverse groups including executives, senior leaders, managers, subject matter experts, customers, technical and non-technical audiences. Strong verbal and written communication skills, including preparing clear, concise reports and making presentations to diverse audiences Strong customer service skills and knowledge Strong team building skills Skill and ability to coach, mentor, train and/or teach adult learners Knowledge and understanding of group dynamics and change management methods Knowledge and understanding of Equity and Social Justice principles Highly Competitive Candidates Will Have (desired, But Not Required) Knowledge/Experience with SharePoint administration Knowledge/Experience with data processing languages/tools such as SQL, R, SPSS, python and Databricks Knowledge/Experience using Azure DevOps Knowledge/Experience with user access management Experience as a Scrum Product Owner Experience working with large public sector agencies or governmental organizations Knowledge of King County Metro’s operations, mission, and policies Knowledge of King County Metro data systems and tools Knowledge of process improvement methods and techniques such as Lean and Six Sigma Knowledge and/or experience with GIS tools such as ArcGIS, etc. People management or supervisory experience Supplemental Information Who may apply: We are accepting applications from all qualified individuals including current King County employees and the general public. To Apply The Following Application Materials Are Required An online King County application updated with accurate contact information and relevant work history. Resume Completed supplemental questions. A letter of interest (cover letter) that addresses why you are interested in this role and how your experience, skills and/or education have prepared you for this position. Selection Process Applications that do not include all of the required materials listed above will not be considered. Only the materials explicitly requested will be reviewed—additional documents or information will not be evaluated. Application materials will be screened for completeness and competitiveness. The most competitive candidates may be invited to participate in one or more interviews and possibly other selection process elements. Final offers are contingent on successful completion of reference checks and/or a record review. If you need this announcement in an alternate language or format, would like to request accommodation or assistance in the application/assessment process, or have questions, please contact: Sabrina Brazzle at sbrazzle@kingcounty.gov. Other Position Information Work Location: This is a hybrid position. The team works in a hybrid model, with days in the office as well as telecommuting. Currently the team is required to work 1 day in office on Tuesdays each week. In office requirements are anticipated to increase to 2-3 days per week in 2026. The ratio of remote to onsite work will be dependent on business needs and is subject to change. The primary onsite location is King Street Center, 201 S. Jackson, Seattle, Washington 98104. 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. Work Schedule: The position is exempt from the provisions of the Fair Labor Standards Act and is not overtime eligible. The typical workweek is 40 hours per week, Monday – Friday. Union Representation: The position is represented by PROTEC17: Professional and Technical Employees, Local 17 Class Code: 2811200 BUSINESS ANALYST - SENIOR Forbes 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? Come join the team dedicated to serving one of the nation's best places to live, work and play. Guided by our "True North", 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. 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 How many years of experience do you have in a position dedicated to business process analysis and improvement? None, my experience does not align with the statement above. My application describes my relevant experience. Less than 2 years 2 years to less than 3 years 3 years to less than 4 years 4 years to less than 5 years More than 5 years 02 How many years of facilitation and/or leadership experience do you have? None, my experience does not align with the statement above. My application describes my relevant experience. Less than 1 year 1 year to less than 2 years 2 years to less than 3 years More than 3 years 03 How many years of professional experience do you have using Microsoft Power BI (Business Intelligence) or similar BI tools? None, my experience does not align with the statement above. My application describes my relevant experience. Less than 1 year 1 year to less than 2 years 2 years to less than 3 years More than 3 years 04 Which of the following choices most closely describes your skill level with Microsoft Excel? None at this time. Very limited. I have completed training, but have not used it much. Beginner. I am able to: create, open and save spreadsheets; cut, paste and delete cells; enter numbers; change font size, margins and paper size; print and use the print preview. Intermediate. In addition to the beginner-level skills, I am also able to: use the insert and auto-sum function; replace text; change the format of numbers to currency, percentage, etc.; set print areas; protect cells; display charts, audit and validate data; create formulas; set up filters, link data, use statistical functions. Advanced. In addition to the beginner and intermediate-level skills, I am also able to: create macros, perform horizontal lookups, create functions and formulas, use pivot tables, use solver, use goal seek. 05 Which of the following knowledge, skills, or experience do you possess? (select all that apply) Advanced knowledge of analysis, design, and development and maintenance of complex business and data management systems. Knowledge and experience with data warehouse product or program management. Knowledge of Scrum and Agile Development processes and procedures. Knowledge and experience with project management techniques methodologies and tools. Experience manage multiple projects with competing priorities. None of the above 06 Which of the following desired qualifications do you possess? (select all that apply) Knowledge/Experience with SharePoint administration Data processing languages/tools such as SQL, R, SPSS, python and Databricks Knowledge/Experience using Azure DevOps Knowledge/Experience with user access management Experience as a Scrum Product Owner Experience working with large public sector agencies or governmental organizations Knowledge of King County Metro’s operations, mission, and policies Knowledge of King County Metro data systems and tools Knowledge of process improvement methods and techniques such as Lean and Six Sigma Knowledge and/or experience with GIS tools such as ArcGIS, etc. People management or supervisory experience None of the above 07 If you have relative that works for King County Metro Transit, please provide the employee's name, position, and your relationship. (If this is not applicable please write N/A) 08 If you have a family member who works for Metro, please provide the Division of King County Metro that they currently work in. Select all that apply. a. Bus Operations Division b. Capital Division c. Employee Services Division d. Facilities Division e. Finance & Administration Division f. General Manager's Office g. Marine Division h. Mobility Division i. Rail Division (including Streetcar) j. Safety, Security & Quality Assurance k. Vehicle Maintenance l. I do not know which Division my relative works in at Metro Transit m. I do not have a relative that works for King County Metro 09 Are you applying to this position as an eligible current or previous King County Employee Priority Placement Program Participant? AND 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? AND Do 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. 10 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 Required Question