Oregon Staffing
Business Systems Analyst III
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 bureaus 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. 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. The Recruitment Process STEP 1: Apply online between July 21, 2025 to August 4, 2025 Required Application Materials: Resume Answer to the Supplemental Questions Optional Application Materials: Veterans Preference Documents Application Tips STEP 2: Minimum Qualification Evaluation: Week of August 4, 2025 STEP 3: Establishment of Eligible List: Week of August 11, 2025 STEP 4: Selection (Interview): Mid August 2025 STEP 5: Offer of Employment: August/September 2025 STEP 6: Start Date: September 2025 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 Benefits may vary depending on bargaining unit and employment status. Click here to review the many different benefits the City of Portland offers. 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. Have you read and understood all the information listed above? Where did you first learn about this job opportunity? (If on a website or job board, please specify which one) The City of Portland receives public records requests at times. Please indicate which response you find appropriate: 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. Do you have knowledge and experience with basic database theory, design rules, and development practices, including data modeling, data flow, and entity relationship analysis? Do you have experience with advanced coding in SQL/Sequel and using Excel? Do you have experience exercising independent judgement, communicate effectively both verbally and in writing, and to present information, proposals and recommendations clearly and persuasively? Do you possess experience leading project teams and performing project management responsibilities while working with team members and stakeholders to ensure project accountability? Do you have experience coaching and training staff in both remote and in-person environments? 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? 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
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 bureaus 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. 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. The Recruitment Process STEP 1: Apply online between July 21, 2025 to August 4, 2025 Required Application Materials: Resume Answer to the Supplemental Questions Optional Application Materials: Veterans Preference Documents Application Tips STEP 2: Minimum Qualification Evaluation: Week of August 4, 2025 STEP 3: Establishment of Eligible List: Week of August 11, 2025 STEP 4: Selection (Interview): Mid August 2025 STEP 5: Offer of Employment: August/September 2025 STEP 6: Start Date: September 2025 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 Benefits may vary depending on bargaining unit and employment status. Click here to review the many different benefits the City of Portland offers. 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. Have you read and understood all the information listed above? Where did you first learn about this job opportunity? (If on a website or job board, please specify which one) The City of Portland receives public records requests at times. Please indicate which response you find appropriate: 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. Do you have knowledge and experience with basic database theory, design rules, and development practices, including data modeling, data flow, and entity relationship analysis? Do you have experience with advanced coding in SQL/Sequel and using Excel? Do you have experience exercising independent judgement, communicate effectively both verbally and in writing, and to present information, proposals and recommendations clearly and persuasively? Do you possess experience leading project teams and performing project management responsibilities while working with team members and stakeholders to ensure project accountability? Do you have experience coaching and training staff in both remote and in-person environments? 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? 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