Epidemiologist II - Informatics
Do the following interest you?
Data system architecture
Public Health – Seattle & King County is seeking to fill an Epidemiologist II position to support the Analytics & Informatics team. This position is part of the Communicable Disease Epidemiology and Immunization Section (CD-EPI). The position will provide informatics coverage for COVID as well as for general communicable disease support.
The Epidemiologist II position leads bodies of work, is independently responsible for the design of major surveillance infrastructure, and supervises the work of assigned staff. This position is responsible for supporting the development of infrastructures and processes that ensure that data can be collected and reported to health planners and other public health officials to guide policy making and the development of effective disease intervention programs. The Epidemiologist II is responsible for gathering data needed for guiding and evaluating public health programs; designing, implementing, and evaluating disease surveillance systems; planning optimal methods for collecting and managing data, including designing system architectures; and supporting development and maintenance of data pipelines that are needed to identify and prioritize key health issues.
In accordance with the King County Equity and Social Justice Ordinance and the King County Strategic Plan, the positions support and advance Public Health values for fair and culturally competent service delivery, innovative, effective and efficient application of resources, building a culture of performance and expanding opportunities to seek input, listen and respond to community members.
WHO MAY APPLY: This position is open to all qualified candidates. A Special Duty Assignment (SDA) position is open to all King County career service employees who have completed their initial County probation. You must have supervisor approval prior to taking a Special Duty Assignment.
WORK SCHEDULE. Work schedule is normally Monday through Friday, 8:00 a.m. – 5:00 p.m. This position is subject to the Fair Labor Standards Act and is overtime eligible where time exceeds 40 hours per week. Overtime during evenings and weekends may be required as part of emergency response. 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.
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 (access may be supplemented in some situations) where they can reliably perform work and remain available and responsive during scheduled work hours. Please note that when an employee conducts work that is likely to bring them in contact with another individual, safety precautions are required, including the wearing of masks in some situations. King County is doing its part to reduce the spread of COVID-19 and remains committed to reducing our carbon footprint.
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 that is redefining how we work as we transition to the department's hybrid environment.
The duration of this Special Duty/Term-Limited Temporary position may be less than one year if demands on the program decrease.
CONTACT: If you have questions about your application or the application process, please contact Debbie Baker, Human Resource Analyst, at firstname.lastname@example.org or 206-263-4053
A complete application packet will consist of the following:
- NEOGOV/Government Jobs on-line or paper application
- Supplemental Questions - answered completely and thoroughly
- Cover letter detailing your qualifications
- CV or resume
- Sample Materials - as described in the supplemental questions, please submit the following materials with your application. Please do not write new programs or make modifications to existing ones. If you have concerns about sharing these examples, please send an email to email@example.com.
- One example (in SAS, R, or SQL) that demonstrates your programming skills.
- Copy and paste one or more documents into the text resume section of the application.
- Attach multiple documents/files in the resume attachment section.
TIMELINE: Candidates who pass the initial screening (based on their responses to the supplemental questions) will be contacted approximately 2-3 weeks after the application period closes. Eligible candidates will be invited to at least one (and possibly two) interviews. Candidates will generally be notified of a final decision within 1-2 weeks of their interview date.
- Job Duties
- Extract and merge data from disparate data sources/databases and prepare data for analysis.
- Conduct data integration using extracts pulled from local, state, and external databases.
- Consult and coordinate with communicable disease investigation subject matter experts to determine database requirements, design modifications to local databases, and coordinate with partners at the State Department of Health on the design and modification of state-managed databases and data systems, to ensure that they meet local surveillance needs.
- Contribute to the design of end user databases to organize data, develop tables, and design queries and reports.
- Create and manage Extract, Transfer, and Load (ETL) data pipelines.
- Create scheduled and custom reports and develop queries.
- Conduct data quality assurance, including data cleaning and developing data quality reports and dashboards, and troubleshooting data inconsistencies.
- Coordinate data exchange across partners.
- Develop and maintain documentation for system changes.
- The position may supervise assigned staff.
- Experience, Qualifications, Knowledge, Skills
- Master's degree in epidemiology, informatics, biostatistics, or related field OR any equivalent combination of experience and education which provides the applicant with the skills, knowledge and abilities required to perform the work
- Expertise programming in SAS or R, including knowledge of methodologies for extracting or creating data sets, conducting text string searches, creating coding efficiencies, recoding data values, writing macros, creating date/time calculations, applying formats to variables, merging data sets, and transposing data
- Knowledge of large-scale relational databases or advanced knowledge of database design and use in end user database systems
- Experience creating and managing Extract, Transfer, and Load (ETL) data pipelines
- Experience with task automation (e.g., automating data analysis programs such as SAS or R, or automating shell scripts)
- Experience manipulating data from complex databases, including longitudinal data and relational datasets
- Skill conducting data quality assurance
- Analytical, problem solving and troubleshooting skills
- Skill in converting client needs into system requirements
- Technical documentation skills, including ability to identify and write specifications
- Planning and organizational skills
- Strong written, oral, and interpersonal communication skills
- Ability to work independently with minimal direction, as well as work well on a team
- Excellent problem-solving skills
- Strong attention to detail
- Demonstrated ability to critically analyze and interpret data
- Ability to work well under pressure with multiple competing priorities and deadlines
- Experience working in a local or state public health practice setting
- Experience designing and managing REDCap databases
- Experience creating data visualizations in Tableau or similar visualization tools
- Experience with SQL server
- Supervisory experience
- 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.
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 your recruiter listed on this job announcement.
- This selection process may include but is not limited to: evaluation of application materials and supplemental questions, testing and interviewing. For more information on our selection process, please refer to http://www.kingcounty.gov/healthservices/health/jobs.aspx
- 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.
- 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 a role as a first responder in the event of a Public Health emergency.
NECESSARY SPECIAL REQUIREMENTS:
- The selected candidate must 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 their mandatory trainings on time.
This position is represented by WSC of County & City Employees, Local 21.
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 experience extracting and merging data from disparate data sources/databases and prepare data for analysis, and conducting data integration?
02Describe your experience extracting and merging data from disparate data sources/databases and prepare data for analysis, and conducting data integration. Include years of experience (beyond coursework) and setting(s) where you applied these skill sets. If you do not have this experience, please type N/A.03Do you have experience contributing to the design of end user databases to organize data, develop tables, and design queries and reports?
04Describe your experience contributing to the design of end user databases to organize data, develop tables, and design queries and reports. Include in your description any experience you have creating and managing Extract, Transfer, and Load (ETL) data pipelines. If you do not have this experience, please type N/A.05Do you have experience conducting data quality assurance, including data cleaning and developing data quality reports or dashboards, and troubleshoot data inconsistencies?
06Describe your experience conducting data quality assurance, including data cleaning and developing data quality reports and dashboards, and troubleshoot data inconsistencies. Include years of experience (beyond coursework), tools you are experienced using for data quality assurance, and setting(s) where you applied these skill sets.07Did you attach a cover letter, CV, and supplemental materials (example of a technical report and SAS/R code), as requested in the position announcement?
08Are 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?
09If 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.