Senior Programmer & Systems Analyst

Description About the Position Lane County Technology Services is seeking an experienced Senior Programmer & Systems Analyst to support the development, integration, administration, and production operation of multiple PeopleSoft enterprise environments.

This is a senior-level technical position for an experienced developer/analyst who can independently evaluate complex problems, design sustainable solutions, troubleshoot critical production issues, and make sound technical decisions with consideration for performance, security, maintainability, and future upgrades.

The successful candidate will work closely with developers, business analysts, functional analysts, business partners, vendors, and regional government partners supporting PeopleSoft HCM, FSCM, and related enterprise systems.

We are looking for someone who can do more than develop to a specification. The Senior Programmer & Systems Analyst is expected to analyze business needs, identify technical options and risks, recommend solutions, and carry complex work through development, testing, implementation, and production support.

What You Will Do PeopleSoft Development & Systems Analysis

• Design, develop, enhance, and maintain complex PeopleSoft applications and custom solutions.
• Develop using technologies such as PeopleCode, Application Engine, Application Packages, Component Interfaces, SQL, SQR, PS Query, BI/XML Publisher, and Integration Broker.
• Analyze functional and technical requirements and recommend appropriate delivered, configured, integrated, or customized solutions.
• Evaluate proposed customizations with consideration for long-term maintainability and future PeopleSoft upgrades.

Production Support & Troubleshooting

• Independently diagnose and resolve complex production issues across PeopleSoft HCM, FSCM, integrations, and related applications.
• Perform root-cause analysis using application logs, tracing, SQL analysis, process monitoring, and other diagnostic tools.
• Assess downstream impacts and ensure fixes are thoroughly tested before production implementation.
• Identify recurring issues and develop sustainable solutions rather than short-term workarounds.

Integrations

• Design, develop, support, and troubleshoot interfaces between PeopleSoft and internal or external systems.
• Evaluate appropriate integration approaches based on business requirements, security, reliability, performance, monitoring, and maintainability.
• Build appropriate error handling, logging, recovery, and support processes into integrations.

Upgrades, PUM & Application Maintenance

• Participate in and provide technical leadership for PeopleSoft patches, PUM cycles, upgrades, and implementations.
• Evaluate changes to delivered and customized objects and determine appropriate retrofit, redesign, or replacement strategies.
• Review release documentation and compare reports and coordinate technical and functional testing.
• Help reduce unnecessary customization and preserve supported upgrade paths.

Performance, Quality & Security

• Analyze and improve SQL, application, batch-processing, and integration performance.
• Apply secure development practices and appropriate application and database controls.
• Develop and execute technical test plans for enhancements, integrations, fixes, patches, and upgrades.
• Maintain clear technical documentation and development standards.

Senior-Level Technical Partnership

• Translate complex technical concepts for functional and business partners.
• Identify technical risks, dependencies, and downstream impacts.
• Provide technical guidance and contribute to standards, architecture, and team knowledge.
• Collaborate effectively with colleagues and stakeholders with different professional backgrounds, technical expertise, and perspectives.

About The Technology Services Department Mission Statement: Solutions, Service, Value Lane County Technology Services is a regional leader in delivering innovation and infrastructure to our customers and partners that maximizes the value from every technology dollar spent. In addition to serving internal customer needs, for over 50 years Lane County has hosted Regional Information Services as well serving local cities and other partners with shared datacenter, networking and application services. We are dedicated to helping our customers meet their business needs through excellent customer service and integrated solutions.

Schedule: Monday - Friday, 8:00am - 5:00pm.

*This is an AFSCME represented position*

Qualifications Training:

• Equivalent to a bachelor's degree from an accredited college or university with major coursework in computer science or a related field.

Experience

• Four years of systems analysis and programming experience that demonstrate increased responsibility in application software maintenance and development.
• An equivalent combination of experience and training that will demonstrate the required knowledge and abilities is qualifying.

Special Requirements

• As a condition of employment, these positions require a criminal background investigation and a security clearance as required by State or Federal regulatory requirements.
• This position requires the ability to obtain and maintain the security clearance required for the assignment. Due to federal security requirements, US citizenship is required.

Preferred Qualifications

• 5+ years of hands-on experience with PeopleSoft development, configuration, and systems analysis preferred.
• Progressively responsible experience developing and supporting complex PeopleSoft enterprise environments.
• Experience independently designing complex PeopleSoft solutions.
• Experience supporting both HCM and FSCM environments.
• Experience with PeopleSoft integrations and Integration Broker.
• Experience with major upgrades, implementations, and PUM process cycles.
• Experience with SQL and application performance analysis.
• Experience in a public-sector, multi-agency, or similarly complex enterprise environment.
• Experience providing technical guidance, establishing standards, or mentoring other technical staff.

This Position Requires Demonstrated Professional Experience With

• PeopleSoft application development and technical support.
• PeopleCode and/or Application Engine.
• SQL development and troubleshooting.
• Complex production support and root-cause analysis.
• PeopleSoft upgrades, patches, or PUM process cycles.
• Enterprise application integrations.
• Systems analysis and translating business requirements into technical solutions.

Candidates should also have experience with several of the following:

• Application Packages
• Component Interfaces
• Integration Broker
• SQR
• PS Query
• BI/XML Publisher
• PeopleSoft HCM and/or FSCM
• Performance tuning
• Workflow
• Web services/APIs

Studies have shown that women and BIPOC individuals are less likely to apply for jobs unless they believe they are able to perform every task in the job description. We are most interested in finding the best candidate for the job, and that candidate may be one who comes from a less traditional background. The county will consider any equivalent combination of knowledge, skills, education, and experience to meet minimum qualifications. If you are interested in applying, we encourage you to think broadly about your background and skill set for the role.

CLASSIFICATION DETAILS

Programmer & Systems Analyst - Senior Classification Details SUPPLEMENTAL INFORMATION

Selection Process Equal Employment Opportunity Lane County is an Equal Opportunity Employer. We value diversity, equity, and inclusion as essential elements that create and foster a welcoming workplace. All qualified persons will be considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, political affiliation, disability or any other factor unrelated to the essential functions of the job.

Strategic Plan In alignment with Lane County's Strategic Plan, incumbent(s) will be expected to demonstrate the following core behaviors: Passion to Serve, Driven to Connect, and Focused on Solutions.

The 2025 - 2027 Strategic Plan focuses on the areas that Lane County will pursue as a way to deliver on our vision for the residents of Lane County. To meet these challenges, we know that the basis of our efforts lies in leveraging our people and partnerships to achieve our Strategic Priorities. We also recognize that the quality and commitment of our staff is essential to a shared future where Lane County is the best place in which to live, work, and play.

Veteran Preference Information Careers With Lane County Offer Extraordinary Benefits At Lane County, we value our employees and we show it with our extraordinary benefits. We know that you chose public service for more than a paycheck, and our outstanding benefits are designed to help you Live Well, Live Lane - throughout your career. Read on to learn what great benefits await you in a career with Lane County.

Introducing ALEX, Lane County's benefit advisor! ALEX is an interactive tool that will help you understand the benefits being offered, out of pocket expenses and coverage available. You will need the Collective Bargaining Unit found in your job posting and when asked for your date of hire, please put in today's date.

• The below information describes typical benefits available for Regular Full-time Employees. Actual benefits received may differ by position, employment status (regular, temporary, or extra help) and/or bargaining group.

ALEX Benefit Advisor (click here)

Collective Bargaining Units Admin-Pro

AFSCME

AFSCME Nurses

AFSCME Physicians

FOPPO

LCPOA

Local 626

Prosecuting Attorney's

Benefits to keep you & your family well - Physically Health insurance coverage becomes effective the first of the month following your first 30-days as an eligible employee.

Medical/Rx/Vision - Lane County Offers Medical, Prescription And Vision Exam Coverage For You And Your Eligible Dependents. The Plan Options And Costs Per Month For 2026 Are Outlined Below

If you enroll in the HDHP the County will contribute to your HSA:

For eligible members of unions LCPOA, 626, Admin Pro, and AFSCME Physicians $1,700 for individual coverage and $3,400 for family coverage.

For eligible members of unions AFSCME General, AFSCME Nurses, FOPPO, PAA, and non-represented employees $1,600 for individual coverage and $3,200 for family coverage. Those who complete the requirements to receive the Live Well Credit by November 30, 2026, will receive an additional contribution of $400 individual or $800 family, funded in 2027.

These amounts are prorated based on date of hire.

All eligible employees who complete a Health History Risk Assessment (HHRA), Biometric Screening, and Comprehensive Health Review (CHR) at the Live Well Center receive a $20 per month credit.

Wellness Clinic

• The Live Well Center is for Lane County benefits-eligible employees, spouses and dependents (ages 2 and up) who are enrolled in the Lane County health plan. Marathon Health manages the Live Well Center and their clinical team provides confidential, affordable care for your acute and preventive healthcare needs. The Live Well Center also provides health coaching, chronic disease counseling, comprehensive primary care services, and much more.

Dental

• Lane County provides dental coverage for employees and their eligible dependents.

Employee Assistance Program (EAP)

• Lane County provides this counseling and concierge service to employees and members of their immediate households.

Fitness Center Membership

• Lane County provides employees with a free membership to a local fitness center.

Benefits to keep you & your family well - Financially Retirement

• Lane County pays for and enrolls employees in the Oregon Public Service Retirement Plan (OPSRP) and the Individual Account Program (IAP) following six full months of employment.

Disability

• Lane County provides Long-Term Disability coverage. Lane County complies with all State and Federal disability laws for employee, family, parental and pregnancy leaves regulations.

Time Management

• Lane County provides employees with a generous bank of hours to be used for sick, vacation, family emergencies and personal days.

Holidays

• Lane County provides 10 paid holidays per year:

New Year's Day

Independence Day

Martin Luther King Jr's Birthday

Labor Day

Presidents' Day

Veterans' Day

Memorial Day

Thanksgiving Day

Juneteenth

Christmas Day

Life Insurance

• Lane County pays for employee group term life insurance.

**County-paid Training & Development to keep your career well

On-site Classes**

• Lane County offers a variety of on-site classes to develop employees' soft and technical skills.

Online Training

• Lane County offers a variety of online classes through LEAP to help employees continually improve their skills.

Conferences & Seminars

• Lane County will consider reimbursement for employees to attend professional conferences, dependent upon budget, to encourage continuous learning and professional development.

Lane County Offers These Other Valuable Benefits Deferred Compensation Retirement Savings - Employees may enroll in a deferred compensation program 457(b) to save for retirement.

Vision

• Eligible employees may purchase supplemental vision insurance.

Supplemental Life Insurance

• Employees may purchase supplemental life insurance for themselves and their dependents/spouse.

Aflac

• Optional employee-paid voluntary group coverage is available through Aflac.

Group Discounts

• Group discounts may include homeowners and auto insurance, pet health insurance, credit union membership.

Paid medical, dental and vision coverage for dependents is determined by labor agreement or APM, as applicable. Physicians should contact their supervisor for health plan options and rates. Please note that Temporary and Extra Help positions are not typically eligible for benefits. This is only brief summary of benefits available to eligible Lane County employees. In all cases, plan documents govern. For additional information about these extraordinary benefits contact the Benefit Resource Center at 1-866-468-7272, or Lane County HR at (541) 682-3124.

01

IMPORTANT: Please ensure you have included all RELEVANT education, employment and experience in your application. To ensure compliance with Oregon Equal Pay laws, Human Resources will conduct a wage analysis based on the information you have provided in your application to determine the appropriate starting wage if you are selected.

• I acknowledge I have provided all relevant education and employment history.

02

Are you currently receiving PERS retiree benefits?

• Yes
• No

03

What is your highest level of education?

• High School diploma or equivalent to completion of twelfth grade.
• Associate's degree.
• Two-years of technical certificate or coursework.
• Bachelor's degree.
• Master's or higher degree.

04

Federal security clearance requirements for this position require the selected candidate to be a U.S. citizen. Are you able to meet this requirement?

• Yes
• No

05

How many years of systems analysis and programming experience do you have that demonstrate increased responsibility in application software maintenance and development?

• No experience, or less than two years.
• More than two years, less than three years.
• More than three years, less than four years.
• More than four years, less than five years.
• More than five years, less than six years.
• More than six years, less than seven years.
• More than seven years, less than eight years.
• At least eight years of experience or more.

06

Do you have professional experience performing systems analysis or programming in a PeopleSoft environment?

• Yes
• No

07

Describe one of the most technically complex PeopleSoft solutions you personally designed or developed. (20 points) 1. How you identified the performance bottleneck, including which diagnostic tools you used (execution plans, tracing, SQL monitoring, temp table analysis, etc.). 2. What PeopleSoft objects were involved (AE sections/steps, views, records, SQL actions, meta SQL, temporary tables). 3. What specific SQL optimizations you made (index strategies, rewrite of joins, elimination of cartesian joins, use of bind variables, restructuring of queries, or use of tableset logic). 4. What constraints influenced your solution, such as preserving delivered functionality, maintaining upgrade paths, or minimizing downstream impacts. 5 How you validated the fix (before/after metrics, regression testing, AE tracing, data comparison) and ensured that the change remained maintainable across future PUM updates.

08

Describe one of the most technically complex PeopleSoft solutions you personally designed or developed. (20 points)

09

Describe a significant PeopleSoft production problem you were personally responsible for diagnosing and resolving. (15 points)

10

Describe a complex integration you personally designed, developed, or substantially supported between PeopleSoft and another application or service. (15 points) Please describe: 1. The business need. 2. The integration approach and technologies used. 3. Why that approach was selected. 4. How data validation, security, errors, retries, logging, and monitoring were handled. 5. Technical challenges encountered. 6 How reliability and maintainability were ensured.

11

Describe a PeopleSoft customization or enhancement you were responsible for evaluating during an upgrade, patch, or PUM cycle. (15 points) Explain: 1. How you identified the impact of delivered changes. 2. How you determined whether the customization should be retained, retrofitted, redesigned, replaced with delivered functionality, or eliminated. 3. What technical tools or information you used. 4. How you tested the resulting solution. 5. How you reduced future maintenance or upgrade risk.

12

Describe a situation where a business or functional team requested a technical solution, but the requirements were incomplete, unclear, or you believed another approach would better meet the underlying need. 15 points) Explain: 1. How you determined the actual business need. 2. What alternatives you considered. 3. How you assessed technical risks and downstream impacts. 4. What you ultimately recommended and why. 5. How you gained agreement from stakeholders. 6. The outcome.

• Required Question