Epic Report Writer, Community Health Services Division

Salary: $94,432.00 - $119,704.00 Annually
Location : Seattle, WA
Job Type: Special Duty Assignment or Term Limited Temp (TLT)
Job Number: 2023CF20400
Department: DPH - Public Health
Division:Community Health Services
Opening Date: 11/21/2023
Closing Date: 12/11/2023 11:59 PM Pacific
FLSA: Exempt
Bargaining Unit: Z3 : KC Personnel Guidelines
Full- or Part-Time: Full Time
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.
This Term Limited Temporary (TLT) or Special Duty Assignment (SDA) is anticipated to last through December 31, 2024. However, the end date of this position may be adjusted based on funding and program need.
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
This recruitment may be used to fill multiple vacancies for the next 6 months.
Job Duties

1. Collaborate with end-users, analysts, and other stakeholders to gather and understand reporting requirements.
2. Design and develop custom reports and dashboards using Epic Clarity tools and technologies.
3. Perform data analysis to identify trends, anomalies, and insights that can impact data quality.
4. Optimize report performance by fine-tuning queries and utilizing best practices.
5. 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.
7. Serve as the technical lead for the collection and analysis of patient satisfaction surveys across clinics.
8. Provide overall technical support to CHS programs that utilize data collection systems outside of our electronic health record system, including REDCap.
9. Liaison with the Health Information Technology (HIT) and King County Information Technology (KCIT) teams as needed to ensure report accuracy.

Experience, Qualifications, Knowledge, Skills

• Previous experience as an electronic health record Report Writer or similar role in healthcare setting.
• Previous 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.
• Skill in:
  1. 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.
  2. Researching and making recommendations, conclusions and decisions.
  3. Interpreting complex instructional manuals, guidelines, and procedures.
  4. Applying project management principles and practices.
  5. 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 Qualifications:

• Epic Clarity Certification, including previous experience with Business Objects
• Experience in cloud- based analytics platforms, including Azure SQL
• 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 , 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.
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.
Application Process:
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.
• A valid WA State Driver License is required to operate a County vehicle.

Work location: The work for this position will be performed by a combination of telework and onsite work. The position will work onsite 1 day per week either in the office or at a Public Health Center. The base for this position is the Chinook Building, located at 401 5th Ave, Seattle, WA, 98104. A County vehicle will be available for use when driving from the Chinook Building to a Public Health Center.
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 from the Seattle & King County Public Health Officer.
To support employees during this time King County has a robust collection of 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 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.
Union affiliation:This position is not represented by a labor union.
Contact:
For more information about the application process, please contact Catherine Fitzpatrick, Sr. HR Analyst at
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
Do you have previous experience as an electronic health record Report Writer or similar role in healthcare setting?

• Yes
• No

02
If you answered yes... describe the name of the system, where they did it and a brief description of the types of reports you wrote. If this does not apply to you, type n/a.
03
Do you have previous experience in leading complex analysis and infrastructure improvement projects that require advanced technical competencies in SQL or other relational databases?

• Yes
• No

04
If you answered yes to the previous question, please describe the type of projects you lead and whe...