Data Analyst

Organization/Company Name: 
Position Description: 

PHI and OPHI are organizing teams of community contact tracing staff across Washington County, Oregon as a key strategy for preventing further spread of COVID-19.

The Data Analyst will perform complex technical and analytical work in the design and creation of queries and reports in order to extract data from the County’s unique, non-enterprise, business data application systems. Additionally, they will design, implement, and maintain smaller, independent, department-specific, data application systems.

Essential Duties & Responsibilities

Design, develop, and maintain complex small/independent databases for systems focusing on specific areas; design, write, and test queries in order to access databases and prepare standard and ad hoc reports to meet specified needs.

Determine needs and design reports or other methods to meet needs; provide technical assistance to outside agencies/contractors on automated data systems.

Collect, compile, extract, and organize complex information and data from multiple systems into a variety of summary and detailed executive management reports and/or presentations.

Design quality assurance management reports that include analysis of internal business/program operations as well as contracted vendor services; analyze, evaluate, and recommend modification to operating methods and procedures as they relate to departmental operations and goals; make recommendations based on research and analysis.

Perform difficult statistical or analytical studies involving complex data and records using mathematical modeling, linear, multiple and logarithmic regression as needed to support assigned functions.

Develop written documentation, internal operating procedures, and end user manuals and instructions on independent department-specific data systems; develop and conduct user training sessions; provide ongoing technical assistance to system users.

Analyze information needs of multiple users to assist in determining appropriate system structures and prepare system and report specifications.

Investigate and resolve data, reporting, and system inconsistencies; develop and implement work flow, data entry, collection, and reporting procedures.

Assist in the review, development, and installation of major department-specific information systems.

May serve as an integral member of a research or study team.

Perform other duties as assigned.

Position Function: 
Position Type: 
Full Time
Required Qualifications and Experience: 

Minimum Qualifications

Bachelor’s degree with major course work in biostatistics, computer science, data science, or a related field demonstrating the capacity for the required knowledge and skills.

Two years of work experience in data analysis, statistics, programming, operational analysis, or a related field that included performing analysis, statistical evaluation, database design, maintenance, administration, and statistical reporting.

Intermediate knowledge of STATA.

Well-versed in dataset extraction, organization, validation and visualization.

Experience handling multiple projects while successfully meeting project deadlines.

Experience troubleshooting intermediate or complex data questions.

Experience with validating and auditing data.

Excellent knowledge of statistical techniques including mathematical modeling, linear, multiple and logarithmic regression.

Ability to follow the operating procedures and policies within the work unit.

Ability to receive direction from an Epidemiologist.

The offer of a position is conditional upon an applicant’s successful completion of background check.

Desired Qualifications

Governmental public health work experience is preferred.

Knowledge of FileMaker, Python, R, SQL or other equivalent programming language is a plus.

Knowledge of Tableau is a plus.

Preference will be given to residents of Washington County, Oregon.

Required Education and / or Certifications: 

Bachelor’s degree with major course work in biostatistics, computer science, data science, or a related field demonstrating the capacity for the required knowledge and skills.

P.O. Box 13436
Portland, OR 97213
Where Will Work Be Performed?: 
To Be Determined