Community Health Division Data Analyst (Analyst II - CPPW)

Full Job Description

Job Appointment: Full time, regular

Work Schedule: Monday – Friday, 8am-5pm. Alternate schedule may be available.

Work Location: The current schedule for this position is hybrid. Employees are expected work on site 50% of the time. The City is reevaluating a return-to-office (RTO) policy which could change in-person requirements with notice. The hiring manager for this position will have more up to date information at the time of all verbal/contingent offers. In-person work will be conducted at 55 SW Ash Street, Portland, OR. Remote work must be performed within Oregon or Washington. For more information, click here.

Benefits: Please check our benefit tab for an overview of benefit for this position.

Union Representation: This classification is represented by the City of Portland Professional Workers (CPPW) collective bargaining agreement. You can view the labor agreement here: Current City Labor Agreements.

Language Pay Premium Eligible: This position is or may be eligible for Language Pay Differential for qualifying employees.

Application Material: Please click APPLY to submit your application via the City of Portland’s online portal. You will need respond to the supplemental questions and attach a resume.

Position Summary:
The Data Analyst II responsibilities include assisting the Community Health Section with charting needs, overseeing quality assurance in the charting system, serving as a liaison for the CAD software system and the Bureau of Emergency Communications (BOEC), preparing reports and documents, creating ArcGIS maps for operational needs, developing reporting and exploratory dashboards with PowerBI and Tableau, and statistical analysis and forecasting for programmatic growth. This position reports to the Program Manager for CHAT.

What you'll get to do:

• Monitor and support program, project, and operational development; determine whether performance is acceptable and identify opportunities for improvement; ensure all data is reliable, accurate, and relevant.
• Collaborate with Division leadership and staff to develop and modify charting tools and data-collection processes, improving data completeness, accuracy, and usability while supporting data quality improvement and program evaluation.
• Research and compile data from a variety of sources; identify historical trends and irregularities; assemble, analyze, and interpret data; perform causal analyses; develop analytical techniques and data-gathering processes.
• Develop and present objective analyses, observations, findings, conclusions, and recommendations to supervisors, managers, and City officials via written reports, oral presentations, and public forums.
• Create maps in ArcGIS.

Develop, design, and administer databases and data sets using PowerBI; determine requirements; track and report statistics; coordinate exchange of data with other agencies and Bureaus/Offices; oversee the integration and migration of data between databases.

Experience with SQL, data transformations, DAX, and Power Query is a plus.

• Participate in development of Bureau/Office performance standards and both semi-annual and annual reports.
• Serve as liaison between designated Bureau/Office and other Bureaus/Offices, including, but not limited to: BOEC, BTS, and PSR.

About the Community Health Section:The Community Health Section, otherwise referred to as CHAT, resides within Portland Fire & Rescue.

CHAT delivers a trauma-informed approach to first response and seeks to divert non-life threatening 9-1-1 medical calls from Fire.

Two primary benefits of these new branches of first responders for non-life-threatening but crisis-related calls are:

1. Enables the City of Portland to free up Fire resources to attend to life saving calls for help; and
2. Provides quick and compassionate response by trauma informed members trained in crisis management and emergency medicine.
3. Provides in-person follow-up engagement and aftercare to community members in need of access to healthcare and health-related social needs.

These programs are expected to:

1. Reduce the number of individuals transported to the emergency department for low acuity medical related issues that could instead be addressed in a pre-hospital care setting.
2. Reduce the number of lower acuity medical calls traditionally responded to by Fire.
3. Increase access to healthcare and health-related resources including Medication for Opioid Use Disorder.

Analysis of trends, forecasting, and reporting out metrics is key to the continued success of our program.

Questions?

Requirements

The following minimum qualifications are required for this position:

1. Experience collecting, evaluating, and interpreting complex data in statistical and narrative forms
2. Experience using quantitative and qualitative analysis, tools, and modeling.
3. Ability to analyze, interpret, explain, and apply relevant laws, regulations, ordinances, policies, and procedures.
4. Experience communicating in writing and verbally technical information to non-technical audiences.
5. Experience establishing and maintaining effective working relationships with external and internal stakeholders such as Bureau/Office management and staff, representatives of other public agencies, the public, and others encountered in the course of work
6. Ability to effectively organize and prioritize multiple analytical initiatives simultaneously, adapting to shifting timelines and operational needs while ensuring accuracy and accountability

Although not required, you may have:

• Bachelor’s degree from an accredited college or university in business administration, data science/analytics, public administration, or a related field.
• Knowledge and experience with ArcGIS
• Knowledge and experience with PowerBI and Tableau
• Knowledge and experience with Alteryx
• Four (4) years of professional and responsible experience performing analytical or related work in a public agency.

Qualifications

• Resume
  • Note: Do not include your age, date of birth, or the dates you attended or graduated from school. Only provide this information if it is specifically requested to meet job requirements or to follow federal, state, or local laws or rules.
• Answer to the Supplemental Questions (click on the Questions tab to preview the questions)

Veteran documents to request for Veteran Preference (ex, DD214-Member 4, VA Benefit Letter, etc.) Effective January 1, 2026, the State of Oregon law ORS 408.225 - 408.238 is amended to expand eligibility for Veterans’ Preference to current and former Oregon National Guard service members.

If applicants are existing state or former Oregon National Guard servicemembers, they are encouraged to attach appropriate documentation to their future recruitment applications.

Update: As of March 3, 2025, if you have already submitted veteran documents and qualified for preference, you do not need to resubmit them for future recruitments.

To update or remove veteran preference for this recruitment or from your profile, contact the recruiter listed in the job announcement.

Application Tips:

• Your responses to the supplemental questions should include details describing your education, training and/or experience, and where obtained, which clearly reflects your qualifications for each of the numbered items in the "To Qualify" section of this announcement.
• Your resume should support the details described in your responses to the supplemental questions.

How We Determine Pay: The City of Portland is covered by the Oregon Equal Pay Act.

Your salary is determined based on the experience listed in your resume that is directly related and equivalent to the position for which you are applying.

It is strongly encouraged to include any transferable experience (paid or unpaid regardless of how recent) to ensure your offer is reflective of all your relevant experience.

• Do not attach materials not requested.
• All completed applications for this position must be submitted no later than on the closing date and time of this recruitment.
• All applications must be submitted via the City's online application process. E-mailed and/or faxed applications will not be accepted.
• You can use AI tools to assist with your job application, but please make sure to personalize your responses to supplemental questions. Avoid copying and pasting; instead, use AI to generate ideas and then tailor them to reflect your own experiences and skills.

• An evaluation of each applicant's training and paid and unpaid experience, as demonstrated in their resume and supplemental questions, weighted 100%.
• Your resume and responses to the supplemental questions will be the basis for our evaluation of your qualifications for this position. Incomplete or inappropriate information may result in disqualification.
• You have 14 days from the notice of the minimum qualification evaluation results to let us know if you like to review and discuss your evaluation result. Please read the City of Portland Administrative Rule 3.01 for complete information.
• Additional evaluation may be required prior to establishment of the eligible list and/or final selection.

• Candidates who meet the minimum qualifications will be placed on the equally ranked eligible list.

• Hiring bureau will review and select candidates to interview.

• A start date will be determined after all conditions of employment have been met.

Additional Information

Click here for additional information regarding the following:

• Veteran Preference
• ADA, Pregnancy, and Religious Accommodations
• Work Status
• Equal Employment Opportunity