Business Systems Analyst III at City of Portland – Portland, Oregon
Explore Related Opportunities
About This 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.
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.
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
- 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
- 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
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.
To view the recording from the Meet & Greet session click here.
*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?
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.
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 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.
Click here for additional information regarding the following:
- Click here 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