Business Systems Analyst III

Salary: $50.69 - $71.31 Hourly
Location : OR 97201, OR
Job Type: Regular
Job Number: 2024-00260
Bureau: Fire & Police Disability & Retirement
Opening Date: 03/04/2024
Closing Date: 3/18/2024 11:59 PM Pacific
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 (20 hours per week) 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 the District Council of Trade Unions (DCTU). To view this labor agreement, please click here External applicants start at the entry salary rate. If you are a DCTU represented employee, see labor agreement for additional information or talk to your union representative.
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
• Troubleshooting all technology software and hardware problems
• Managing technology vendors and collaborating with the City's Bureau of Technology Services
• Supporting phones, faxes, and printers
• Learning FPDR business processes

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
• 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.
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.
Questions?
Karen Ehn, Recruiter
Bureau of Human Resources
To Qualify
The following minimum qualifications are required for this position:

1. Knowledge and experience with basic database theory, design rules, and development practices, including data modeling, data flow, and entity relationship analysis.
2. Experience coding in SQL/Sequel and using Excel at an advanced level.
3. Ability to exercise independent judgement, communicate effectively both verbally and in writing, and to present information, proposals and recommendations clearly and persuasively.
4. Experience leading project teams and performing project management responsibilities while working with team members and stakeholders to ensure project accountability.
5. Experience coaching and training staff in both remote and in-person environments.
6. 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 March 4, 2024- March 18, 2024
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 March 18, 2024-March 25, 2024

• 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 March 25, 2025- April 1, 2024

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

STEP 4: Selection (Interview): early/mid April

• 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: late April/early May
STEP 6: Start Date: TBD

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

Additional Information
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

Did you know? The City of Portland has How to Apply Videos and offersHow to Apply Classes once per monthIf 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
• Short- and 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.
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 coding in SQL/Sequel and using Excel at an advanced level?

• Yes
• No

07
Provide a detailed example(s)of your experience coding in SQL/Sequel and using Excel at an advanced level.
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 the ability to exercise 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 ability to exercise 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)....