"Alerted.org

Business Systems Analyst III

Print (https://www.governmentjobs.com/careers/portlandor/jobs/newprint/4984803)

Apply



Business Systems Analyst III

Salary

$50.69 - $71.31 Hourly

Location

OR 97201, OR

Job Type

Regular

Job Number

2025-00572

Bureau

Fire & Police Disability & Retirement

Opening Date

07/21/2025

Closing Date

8/4/2025 11:59 PM Pacific

+ Description

+ Benefits

+ Questions

The Position

About the Position:

Job Appointment: Full-Time, Regular .

Work Schedule: Monday - Friday 8am-5pm, alternate schedules may be available.

Work Location: Hybrid; In-person work to be conducted at The Harrison Square Building located at 1800 SW First Avenue, Suite 250. Remote work must be performed within Oregon or Washington. For more information, click here (https://employees.portland.gov/human-resources/people-culture/workplace-framework-and-requirements) .

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

Union Representation: This classification is represented by American Federation of State, County, and Municipal Employees Local 189 (AFSCME). To view this labor agreement, please click here (https://www.portland.gov/bhr/employee-relations/labor-relations/labor-agreements) .

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. Update application materials if needed.

Position Summary

The Fire and Police Disability and Retirement Bureau (FPDR) is seeking an experienced Business Systems Analyst III. The Business Systems Analyst III serves a key role in helping FPDR deliver excellent service, work effectively and efficiently, and meet the bureau's mission. The Business Systems Analyst III will:

Keep FPDR operational by:

+ Maintaining, enhancing, and updating the FPDR SQL Database, Member Web Portal, and other FPDR-specific applications

+ Producing custom and regular reports from the FPDR database tailored to the specifications of individual end users

+ Troubleshooting all technology software and hardware problems and identify solutions to resolve problems timely and make recommendations for problem resolution

+ Managing technology vendors and collaborating with the City's Bureau of Technology Services

+ Supporting phones, faxes, and printers

+ Learning FPDR business processes and legal requirements of the FPDR Plan to ensure that our database and technology meets the business processes and legal obligations of our plan

Support FPDR staff and members (firefighters and police officers, retirees, and their beneficiaries) by:

+ Training, coaching, and supporting staff on how to use various applications and technology hardware and software they need to perform their work

+ Providing support to staff proactively or when asked; analyzing and resolving staff concerns and issues

+ Coordinating problem resolution with the City's Bureau of Technology Services, vendors, and other technical staff.

+ Providing caring customer support to staff and our members and providing clear and timely written and verbal communication to all staff when appropriate and needed

+ Working effectively with staff in person and remotely

Guide FPDR into the future by working with the FPDR management team to:

+ Develop a technical roadmap to the future, particularly relating to document management, benefit administration, and payment processing

+ Identify technologies that will improve efficiency, help FPDR better support our members, and allow FPDR to meet our members' service expectations

+ Manage change as new technology is rolled out

Manage FPDR technical projects using the appropriate project management framework, including requirements gathering and change management and regular communication with management, project team and staff.

About the Bureau:

The Bureau of Fire and Police Disability and Retirement (FPDR) provides retirement, disability, and death benefits for the City of Portland’s active and retired police officers and fire fighters and their beneficiaries. FPDR is funded by its own dedicated property tax and overseen by an independent Board of Trustees. We pride ourselves on the quality of service we provide to our members and stakeholders. As a workplace, FPDR is inclusive, fun, flexible, and committed to work-life balance.

FPDR Mission: We deliver peace of mind to our fire and police members and their survivors by providing disability and retirement benefits in a timely, compassionate, and fiscally responsible manner.

Virtual Zoom Meet & Greet Opportunity

Come meet the hiring manager and the senior recruiter! We'll be talking about the position duties and responsibilities, day to day life in the role, review the announcement, discuss how to apply, and answer questions you may have about the position.

Wednesday, July 23, 2025

12:00pm Pacific Time (US and Canada)

Zoom Meeting Link:

https://us06web.zoom.us/j/82109137426

Meeting ID: 821 0913 7426

*Please note: AI Notetaking apps will not be allowed into virtual sessions hosted by the Bureau of Human Resources Recruitment Team. If you need accommodations as defined by the American Disabilities Act, then please contact the Recruiter for assistance.

Questions?

Loan Tran Polanco, Recruiter

Bureau of Human Resources

[email protected]

To Qualify

The following minimum qualifications are required for this position:

+ Knowledge and experience with basic database theory, design rules, and development practices, including data modeling, data flow, and entity relationship analysis.

+ Experience with advanced coding in SQL/Sequel and using Excel at an advanced level.

+ Experience exercising independent judgement, communicate effectively both verbally and in writing, and to present information, proposals and recommendations clearly and persuasively.

+ Experience leading project teams and performing project management responsibilities while working with team members and stakeholders to ensure project accountability.

+ Experience coaching and training staff in both remote and in-person environments.

+ Experience translating technical information between customers and information systems professionals to ensure all parties understand, in their terms, the system needs, requirements, and constraints.

Although not required, you may have one or more of the following:

+ 3-5 years experience with SQL programming.

The Recruitment Process

STEP 1: Apply online between July 21, 2025 to August 4, 2025

Required Application Materials:

+ Resume

+ Answer to the Supplemental Questions (click on the Questions tab to preview the questions)

Optional Application Materials:

+ If you would like to request Veteran's Preference, please submit your Veteran documents (ex, DD214-Member 4, VA Benefit Letter, etc ) by the closing date of the recruitment.

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 résumé should support the details described in your responses to the supplemental questions.

+ Salary Range/Equity Pay Analysis : Please note per the Oregon State Pay Equity Law (https://www.oregon.gov/boli/workers/pages/equal-pay.aspx) your salary is determined based on the experience and education listed in your resume/application. It is strongly encouraged to include any transferable experience (paid or unpaid regardless of how recent) to ensure your offer is reflective of all directly related and equivalent experience.

+ Do not attach any additional documents. Please note, 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. Do not attach materials not requested . E-mailed and/or faxed applications will not be accepted.

STEP 2: Minimum Qualification Evaluation: Week of August 4, 2025

+ An evaluation of each applicant's training and paid and unpaid experience, as demonstrated in their resume and supplemental questions, weighted 100%.

+ Your résumé 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 would like to review and discuss your evaluation result. Please read the City of Portland Administrative Rule 3.01 for complete information.

STEP 3: Establishment of Eligible List: Week of August 11, 2025

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

STEP 4: Selection (Interview): Mid August 2025

+ Hiring bureau will review and select candidates for an interview

+ Please note, the selection process may take up to 90 days from the notification of being placed on the eligible list.

STEP 5: Offer of Employment: August/September 2025

STEP 6: Start Date: September 2025

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

Additional Information

Click here (https://www.portland.gov/bhr/career-center/recruitment-policy) for additional information regarding the following:

+ Click here (https://www.portland.gov/bhr/career-center/recruitment-policy) for additional information regarding the following:

+ City of Portland Core Values

+ Recruitment Process - Work Status

+ Equal Employment Opportunity

+ Veteran Preference

+ ADA, Pregnancy, and Religious Accommodations

Did you know? The City of Portland has How to Apply Videos (https://tinyurl.com/pdxh2a) and offers How to Apply Classes once per month. If you have questions after watching the videos you are invited to contact the recruiter listed on the announcement.

An Equal Opportunity/Affirmative Action Employer

A Career with the City of Portland offers many Employee Benefits

We offer a comprehensive benefits package, including but not limited to

+ Health Care (Medical, Vision and Dental)

+ Carrot Fertility

+ Wellness Benefits

+ Life Insurance

+ Long-term disability coverage to eligible employees and their families.

+ Employee Assistance Plan

+ Flexible Spending Accounts

+ Retirement

+ Oregon Public Employees Retirement System (PERS), including contributions to the PERS IAP plan paid by employer

+ Family Medical Leave

+ City Paid Parental Leave

AND SO MANY MORE!

Benefits may vary depending on bargaining unit and employment status. Click here to review the many different benefits the City of Portland offers (https://www.portland.gov/bhr/benefit-offerings/benefits-quickstart-guide/benefit-plan-summaries-highlight-guides) .

01

Thank you for your interest in joining the team at the City of Portland. We sincerely value your time and hope to make your application experience as positive as possible.

The following supplemental questions are an important step to assist us in determining if you have the minimum qualifications to succeed in the posted vacancy.

Write specific and unique responses to each question. Answering "No", to any of the Yes/No questions or answering an essay questions with the following "See resume", or entering "N/A" for any of the minimum qualifications listed in the "To Qualify" section may eliminate you from further consideration.

Note: If you are requesting veterans' preference, please be sure upload a copy of your DD214 and/or Veteran's administration letter stating your disability. Veteran's preference documentation must be submitted by the closing time of this announcement.

Have you read and understood all the information listed above?

+ Yes

+ No - If you have any questions, please contact the recruiter on the announcement.

02

Where did you first learn about this job opportunity? (If on a website or job board, please specify which one)

03

The City of Portland receives public records requests at times. Please indicate which response you find appropriate: (Answer will not disqualify you from the process)

+ My application was submitted with the understanding that the City of Portland would keep the information confidential and would only disclose the information if ordered to do so. I would not have submitted this application without the promise of confidentiality.

+ You may release my application; I am waiving confidentiality.

04

Do you have knowledge and experience with basic database theory, design rules, and development practices, including data modeling, data flow, and entity relationship analysis?

+ Yes

+ No

05

Provide a detailed example(s)of your knowledge and experience with basic database theory, design rules, and development practices, including data modeling, data flow, and entity relationship analysis.

In your response, include details which clearly reflect how you meet this minimum qualification. Such as:

+ Examples of when you used the knowledge skill or ability.

+ Role you served in (professional, internship, volunteer).

+ Skills, training, transferable skills or lived experience you have that will help you in this area.

+ Total years of experience applying the knowledge, skill, or ability.

06

Do you have experience with advanced coding in SQL/Sequel and using Excel?

+ Yes

+ No

07

Provide a detailed example(s)of your experience with advanced coding in SQL/Sequel and using Excel.

In your response, include details which clearly reflect how you meet this minimum qualification. Such as:

+ Examples of when you used the knowledge skill or ability.

+ Role you served in (professional, internship, volunteer).

+ Skills, training, transferable skills or lived experience you have that will help you in this area.

+ Total years of experience applying the knowledge, skill, or ability.

08

Do you have experience exercising independent judgement, communicate effectively both verbally and in writing, and to present information, proposals and recommendations clearly and persuasively?

+ Yes

+ No

09

Provide detailed example(s) of your experience exercising independent judgement, communicate effectively both verbally and in writing, and to present information, proposals and recommendations clearly and persuasively.

In your response, include details which clearly reflect how you meet this minimum qualification. Such as:

+ Examples of when you used the knowledge skill or ability.

+ Role you served in (professional, internship, volunteer).

+ Skills, training, transferable skills or lived experience you have that will help you in this area.

+ Total years of experience applying the knowledge, skill, or ability.

10

Do you possess experience leading project teams and performing project management responsibilities while working with team members and stakeholders to ensure project accountability?

+ Yes

+ No

11

Provide a detailed example(s)of your experience leading project teams and performing project management responsibilities while working with team members and stakeholders to ensure project accountability.

In your response, include details which clearly reflect how you meet this minimum qualification. Such as:

+ Examples of when you used the knowledge skill or ability.

+ Role you served in (professional, internship, volunteer).

+ Skills, training, transferable skills or lived experience you have that will help you in this area.

+ Total years of experience applying the knowledge, skill, or ability.

12

Do you have experience coaching and training staff in both remote and in-person environments?

+ Yes

+ No

13

Provide a detailed example(s)of your experience coaching and training staff in both remote and in-person environments.

In your response, include details which clearly reflect how you meet this minimum qualification. Such as:

+ Examples of when you used the knowledge skill or ability.

+ Role you served in (professional, internship, volunteer).

+ Skills, training, transferable skills or lived experience you have that will help you in this area.

+ Total years of experience applying the knowledge, skill, or ability.

14

Do you have experience translating technical information between customers and information systems professionals to ensure all parties understand, in their terms, the system needs, requirements, and constraints?

+ Yes

+ No

15

Provide a detailed example(s)of your experience translating technical information between customers and information systems professionals to ensure all parties understand, in their terms, the system needs, requirements, and constraints.

In your response, include details which clearly reflect how you meet this minimum qualification. Such as:

+ Examples of when you used the knowledge skill or ability.

+ Role you served in (professional, internship, volunteer).

+ Skills, training, transferable skills or lived experience you have that will help you in this area.

+ Total years of experience applying the knowledge, skill, or ability.

16

Please note the following questions will not be considered during minimum qualification review. The information provided will be reviewed after the eligible list is created.

+ 3-5 years experience with SQL programming.

(Enter N/A if you do not have relevant experience)

Required Question

Employer

City of Portland

Address

1120 SW 5th Ave, Room 987 Portland, Oregon, 97204

Website

http://www.portlandoregon.gov/jobs

Apply

Please verify your email address Verify Email