Data Quality & Interoperability Lead (Project/Program Manager III)
Public Health – Seattle & King County’s Community Health Services (CHS) Division is seeking to fill a Data Quality and Interoperability Lead (Project/Program Manager III) position to help build its technical capacity and consistency in managing data across multiple databases and platforms. The goal of the position is to improve the timeliness and accuracy of performance measurement and population health data across our Division with a prioritization on homelessness and housing data. This position involves a combination of analysis, documentation, quality improvement, and management. It plays a lead role in translating business needs to our partners in the King County Information Technology Department (KCIT).
The Project/Program Manager III focuses on four priorities:
- create and maintain standard operating procedures and documentation for SQL code development and quality assurance;
- manage Tableau dashboard development, maintenance, and end user support;
- oversee daily operations for the Health Care for the Homeless Network (HCHN) contractor file management and integration; and
- implement patient satisfaction survey processes across the division.
This position is being offered as a Term Limited Temporary (TLT) or Special Duty Assignment (SDA). The work performed is anticipated to last 18 months. However, the end date of this position may be adjusted based on funding and program need.
Commitment To Equity And Social Justice: As the only county in the United States named after Martin Luther King Jr, one of the most influential civil rights leaders in our nation’s history, King County is a vibrant community with residents that represent countries from around the world. It is a region with increasing diversity that cherishes the artistic and social traditions of many cultures. Together, we're changing the way government delivers service and winning national recognition as a model of excellence.
We continue to build on an enduring legacy of shared values of equity and social justice, employee engagement, innovative thinking, and continuous improvement. With this commitment, King County has adopted a pro-equity agenda aimed at advancing regional change and is developing the systems and standards necessary to achieve better outcomes for all of our residents, regardless of their race or income. All of these qualities make King County one of the nation's best places to live, work, and play.
This recruitment may be used to fill multiple vacancies for the next 3 months.
- Job Duties
- Partner with CHS functional analysts and epidemiologists to oversee the creation and maintenance of scalable data architecture to support reporting, visualization, dashboard and tool development.
- Serve as the technical lead to prepare system documentation and translate business needs to partners in the King County Information Technology Department (KCIT).
- Co-create and manage systems to support efficient, reliable, and collaborative production and use of code, including all aspects of development (majority SQL).
- Manage Tableau dashboard development, maintenance, and end user support. This includes serving as a liaison with King County Information Technology to set-up user accounts and work with clinic staff to determine access and training needs.
- Oversee the integrity and quality of the Health Care for the Homeless Network (HCHN) contractor XML file management system representing 18 different sources. This includes creating procedure manuals and ensuring data is ready for reporting and analytic projects.
- Implement a new patient satisfaction survey process that includes both written and automated tool development via our electronic health record system.
- Support data system integration and quality improvement projects across Public Health and the King County Department of Community and Human Services (DCHS).
- May lead the work of other employees, including assigning and checking work, and training employees.
- Other duties as assigned.
- Experience, Qualifications, Knowledge, Skills
- Skill in interpreting and writing complex instructional manuals, guidelines, and procedures
- Related work experience, primarily in data management, data analysis, or data administration roles.
- Demonstrated experience creating and managing complex Tableau dashboards and supporting end users in accessing and utilizing visualizations.
- Demonstrated experience working with large SQL databases and writing queries using structured query language (SQL).
- Demonstrated knowledge and experience with data management, analysis, quality assurance, and visualization tools, such as R, Python, SAS, Stata, and Tableau. Capabilities in more than one area are a plus.
- Demonstrated knowledge of creating, processing, and manipulating XML files.
- Demonstrated experience developing and automating surveys.
- Experience managing data integrity and quality assurance review and/or testing pipelines.
- Experience with version control technology
- Deep knowledge of equity and social justice principles and practices, and understanding of the effects of place, race and policy and systems-based inequities on marginalized communities and populations.
- Experience documenting and sharing knowledge to improve team skills and performance and desire to continuously learn new technologies, skills, methods, and best practices.
- Strong oral and written communication skills, including the ability to communicate well with diverse groups in multiple settings.
- Experience successfully managing complex projects, in detail, and meeting deadlines.
- Knowledge of health and human service business process and use of performance management tools within a service and clinic environment (preferably electronic health record systems)
- Familiarity with virtual collaboration tools (Microsoft Teams, SharePoint, M365, One Drive, etc.).
- Experience in utilizing Github or similar platforms
- Experience with large administrative data sets and/or cloud computing (preferably Azure).
- Supplemental Information
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? 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.
COVID-19 Vaccination Requirement
King County Executive Branch employees are required to be fully vaccinated against COVID-19. If you are the successful candidate for the position you applied for, the County will send you a conditional offer letter.
As a condition of employment, prior to a final offer of employment, you will be required to:
- submit proof of vaccination, or
- have an approved request for medical or religious exemption and an approved accommodation. Philosophical, political, scientific, or sociological objections to vaccination will not be considered for an exemption or accommodation.
People are considered fully vaccinated against COVID-19 two weeks after receiving the final dose of a vaccination approved by the Center for Disease Control and Prevention (CDC).
The Executive Branch includes employees in the Executive branch, the Assessor's Office, Elections, the King County Sheriff's Office, and the Executive Office.
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.
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.
Who May Apply: This position is open to all qualified internal and external candidates. To be considered as a Special Duty applicant, you must be a current Career Service, King County employee who has successfully passed probation and must get your supervisor's approval if this assignment is offered to you.
The following items are required to be considered for this vacancy:
- An electronic application through www.kingcounty.gov/jobs or www.governmentjobs.com (use the "Apply" link) including work history and position duties.
- Responses to Supplemental Questions. Please do not copy and paste your resume or resume sections as responses to Supplemental Questions. Doing so will result in an incomplete application, unless the submitted information completely and directly answers the questions posed.
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 NeoGov 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 testing. For more information on our selection process, please refer to www.kingcounty.gov/depts/health/jobs/hiring.
- Regular and reliable attendance, effective communication skills, and development of effective working relationships are requirements of all Public Health positions.
- Staff may be required to play an active role in the event of a public health emergency, which may include changes in responsibilities, work location and working hours.
Necessary Special Requirements
- The selected candidate will be required to pass a thorough background investigation.
- Employees are required to protect the privacy and security of protected health information as defined in State and Federal Law.
- Employees are required to adhere to OSHA/WISHA guidelines including but not limited to completing required training on time.
Work location: Some of the work associated with this position will be performed through a combination of teleworking complemented with onsite work and meetings as needed. Employees will have access to shared workspaces at various King County facilities. 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 must maintain a workspace with an internet connection where they can reliably perform work and remain available and responsive during scheduled work hours. Employees must reside in WA state and within a reasonable distance to their King County worksite to respond to workplace reporting requirements. There will be situations where the employee is required to report to a County worksite. Please note that when an employee conducts work that is likely to bring them in contact with another individual, safety precautions are required by the department in alignment with the Public Health Directive from the Seattle & King County Public Health Officer.
To support employees during this time King County has a robust collection of tools and resources to support working remotely. The individual selected for this opportunity will be joining an innovative and progressive team. King County is doing its part to reduce the spread of COVID-19 and remains committed to reducing our carbon footprint.
Work schedule: The normal work schedule for this position is normally Monday through Friday, 8:00 a.m. – 5:00 p.m. This position is exempt from the provisions of the Fair Labor Standards Act, and is not eligible for overtime pay. Alternative work schedules may be considered. Occasional evening and weekend work may be required. At Seattle/King County Public Health we strive to be accessible to those we serve. This position may require flexibility to accommodate different work schedules and work locations.
Duration of position:
The work performed in this position is anticipated to last until 18 months. However, the end date of this position may be adjusted based on funding and program need.
This position is not represented by a labor union.
For more information about the application process, please contact Catherine Fitzpatrick, HR Analyst at Catherine.email@example.com.
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
- 10 paid holidays each year (plus 2 personal holidays)
- Generous vacation and paid sick leave
- Paid parental leave, family and medical leaves, and volunteer leave
- Flexible Spending Account
- Wellness programs
- Onsite gyms and activity centers
- Employee giving program
- Employee assistance programs
- Flexible schedules and telecommuting options, depending on position
- Training and career development programs
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. Also, in the event of any incorrect information in this document, applicable laws, policies, rules, CBAs, or official plan documents will prevail.
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.
01Do you have skill in interpreting and writing complex instructional manuals, guidelines, and procedures?
02If you answered yes to the previous question, please describe the topics you wrote about, and in which format(s) they were distributed. If you do not have this experience, type n/a.03Do you have demonstrated experience working with large SQL databases and writing queries using structured query language (SQL)?
04If you answered yes to the previous question, please detail that experience. Include in your answer the name(s) of the SQL database(s) you used and where you used them. If you do not have this experience, type n/a.05Do you have demonstrated experience creating and managing complex Tableau dashboards and supporting end users in accessing and utilizing visualizations?
06If you answered yes to the previous question, please describe your experience creating and managing complex Tableau dashboards, and supporting end users in accessing and utilizing visualizations. If you do not have this experience, type n/a.07Are 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?
08If 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
- Yes, I was given a layoff notice from my role at King County AND I am within two years of the effective date of my layoff. AND The position I was laid off from was the same or a higher percentage of FT status when compared to this one.