King County

Summary

The Community Health Services (CHS) division of Public Health- Seattle & King County (PHSKC) seeks an Epic Report Writer (Functional Analyst III) to serve as the lead writer for Epic reports that are used by providers and clinic managers within the CHS Epic Reporting Workspace. This position is a member of the CHS Data Team and supports our efforts to increase understanding of available EHR reporting tools to enhance operational efficiencies and improve patient care. The Functional Analyst III position will also support priority projects, including the collection of patient satisfaction data, and program specific reporting and evaluation needs utilizing tools like REDCap, Tableau and Apricot software.

Commitment To Equity and Social Justice

Named after Dr. Martin Luther King, Jr., one of the most influential civil rights leaders in our nation's history, King County is a vibrant international community with residents that represent countries from around the world. It is a region with increasing diversity that cherishes the traditions of many cultures.

The county government has a deep commitment to equity and social justice and advancing practices, strategies, and policies that promote fairness, justice, and opportunity for all – in our workplaces and our communities. With this commitment, King County has adopted a pro-equity agenda to advance regional change and ensure that residents from all communities are incorporated into our emergency planning and public outreach efforts.

We recognize that structural racism consists of principles and practices that cause and justify an inequitable distribution of rights, opportunities, and experiences across racial groups. Since declaring Racism is a Public Health Crisis in June 2020, King County and Public Health committed to being intentionally anti-racist and accountable to Black, Indigenous and People of Color communities.

To learn more, please visit http://www.kingcounty.gov/elected/executive/equity-social-justice.aspx

Job Duties

• Collaborate with end-users, analysts, and other stakeholders to gather and understand reporting requirements.
• Design and develop custom reports and dashboards using Epic Clarity tools and technologies.
• Perform data analysis to identify trends, anomalies, and insights that can impact data quality.
• Optimize report performance by fine-tuning queries and utilizing best practices.
• Maintain report inventories and stay-up-to date with Epic updates, including population management tools 6. Collaborate with CHS Data Team members to ensure alignment with front and back-end reporting and analytic needs.
• Serve as the technical lead for the collection and analysis of patient satisfaction surveys across clinics.
• Provide overall technical support to CHS programs that utilize data collection systems outside of our electronic health record system, including REDCap.
• Liaison with the Health Information Technology (HIT) and King County Information Technology (KCIT) teams as needed to ensure report accuracy.
• Other duties as assigned.

Experience, Qualifications, Knowledge, Skills

Required:

• Experience as an electronic health record report writer or similar role in healthcare setting.
• Experience in leading complex analysis and infrastructure improvement projects that require advanced technical competencies in SQL or other relational database
• Ability to handle multiple competing priorities and produce quality detailed work within tight timeframes.
• Experience using report and query writing languages such as advanced T-SQL and writing complex system documentation and technical reports such as the production of Tableau, Power BI, and SSRS reports.
• Researching and making recommendations, conclusions and decisions.
• Interpreting complex instructional manuals, guidelines, and procedures.
• Applying project management principles and practices.
• Working effectively and cooperatively with a variety of individuals from diverse backgrounds.
• Ability to apply principles of Equity and Social Justice in program operations and services.

Desired:

• Epic Clarity Certification, including previous experience with Business Objects
• Experience in cloud- based analytics platforms, including Azure SQL
• Experience with SSRS report development
• Proficiency in additional open-source languages such as R or Python

Supplemental Information

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.

To Apply

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 vacancy:

• NeoGov Job Application (The responses on your job application should be thorough and complete and will be used in the screening process)
• Supplemental Questions (The responses to the supplemental questions should be thorough and complete and will be used in the screening process)

Please note: Cover letter and resumes will not be used in the evaluation process.

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.

Necessary Special Requirements

• The selection process may include evaluation of application materials and supplemental questions, interviewing, and testing. You must completely fill out the application with your relevant education and work experience.
• The selected candidate must be able to pass a thorough background investigation, but findings may not necessarily disqualify an applicant for employment.
• For more information on our selection process, please refer to www.kingcounty.gov/depts/health/jobs/hiring. For tips on interviewing, please visit https://www.kingcounty.gov/~/media/audience/employees/learning-and-development/Interview_Tips.ashx?la=en.
• Employees are required to protect the privacy and security of protected health information as defined in State and Federal Law.
• Public Health relies on office automation (Microsoft Office) and web-based enabled tools, therefore candidates must be proficient and comfortable with computer use to perform functions associated with on-going work.
• Employees are required to adhere to OSHA/WISHA guidelines including but not limited to completing their mandatory trainings on time and obtaining required immunizations.
• Regular and reliable attendance, effective communication skills, and development of effective working relationships are requirements of all Public Health positions.
• When Public Health responds to an emergency, and in accordance with relevant CBA language and/or KC policy and procedures, we may assign duties outside your regular job description. This may involve responding at any time, including nights and weekends, with possible deployment to locations other than the department.
• If you need a disability accommodation in the application or testing process, please call the contact number listed on the job announcement.

Work Schedule

The normal work schedule for this position is Monday through Friday, 8:00 am to 5:00 pm – 40 hours per week. This position is not subject to the Fair Labor Standards Act and is not overtime eligible.

Work Location

This position is located at the Chinook Building, 401 5th Ave, Seattle, WA 98104.

Some of the work associated with this position will be performed through teleworking and will report to office location and to meetings as needed. Travel to other work locations may be necessary. 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. 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.

Union Membership

This position is not represented by a Labor Union.

Contact

For questions about this recruitment, please contact Sarah Dunkinson, sdunkinson@kingcounty.gov.

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.

Read Full Description