Benefits at Portland Public Schools include medical, dental, vision and prescription coverage, plus life and disability insurance. An Employee Assistance Program supports well-being, with a 403(b) retirement savings plan and eligibility to participate in PERS/OPSRP. The district also offers paid leave, professional development programs, and diverse opportunities for growth and career development.
Position details — This Benefits Data Analyst III, 1.0 FTE in Finance, supports ERP/HRIS technology solutions, data integrity, reporting and system enhancements to enable strategic HR planning and district operations. The role is based on site in Portland, Oregon at the Prophet Center, with a salary range of $100,326 to $119,794 per year. The position is 1.0 FTE, Exempt, and follows a 260-day work year. Applications are reviewed as received; the posting remains open until filled.
Position overview
The Benefits Data Analyst III collaborates with district leaders, department staff and central IT to optimize HR information systems, maintain data quality, and deliver actionable reporting. The role focuses on configuring and administering ERP/HRIS modules, developing data configurations and queries, and guiding system upgrades and training to ensure effective use across the district.
Responsibilities
- Act as a subject matter expert for the department’s technology solutions, supporting district level strategic alignment with ERP or HRMS tools; maintain system tables, processes and queries; apply HR knowledge to optimize information systems; serve as a liaison between district leadership, the department, and central IT.
- Coordinate with colleagues across departments and IT to address system issues, upgrades and enhancements; lead cross-functional teams to ensure smooth integration of technology, data and software across the district.
- Troubleshoot system functionality and data output; collaborate with vendors and users to test, evaluate, revise processes, and resolve issues.
- Evaluate system performance, recommend improvements, and engage district and department leaders in discussions about needs and opportunities to enhance usability and utilization.
- Lead maintenance, testing and implementation of system upgrades; develop timelines and communicate changes to end users.
- Develop and maintain system data tables and configurations as business processes evolve; perform batch updates and create data structures to enable extraction and manipulation of data in user-friendly formats.
- Assess and prioritize staff training; ensure ongoing, sustainable training is available and updated as systems change.
- Audit data access and parameters for users; manage data records in accordance with policies.
- Ensure data integrity through QA methods, define data requirements and produce reports to support district decision making.
- Lead business process improvement, documentation and training activities related to department information systems; contribute to policies and procedures.
- Develop user training guides and classes on ERP modules or other solutions; provide technical assistance and training to staff with varying levels of tech literacy.
- Apply HR information systems knowledge to extract and analyze current, historical and forecasted data for workforce planning.
- Stay current with changes in information system technology and related policies; participate in conferences and trainings to enhance expertise.
- Understand collective bargaining contracts and prepare data analyses to inform district bargaining positions.
- Support the district’s Equity Initiative by applying relevant policies and promoting inclusive practices in HR processes.
- Perform related duties as assigned.
Requirements
- Experience with ERP business management software such as PeopleSoft or SAP.
- Knowledge of database concepts, tables, relations, data types and values.
- Basic programming concepts for querying data in relational databases (SQL, or similar; Visual Basic concept familiarity is listed).
- Proficiency with Microsoft Office Suite, including advanced Excel capabilities.
- Strong customer service skills and the ability to support users effectively.
- Experience with project management tools and change management strategies.
- Excellent oral and written communication skills.
- Familiarity with district policies and business objectives related to the department.
- Awareness of local, state and federal laws, codes and regulations as they pertain to the role.
- Ability to prepare and present reports, and to plan, schedule and coordinate work.
- Capability to use a range of technologies, including ERP systems like PeopleSoft and SQL or similar interfaces.
- Experience creating tables, databases, queries and spreadsheets; ability to extract, validate and combine data from multiple sources.
- Proficiency running moderately complex SQL queries and presenting data analyses clearly.
- Skill in supervising projects within a technology environment and guiding assigned staff.
- Strong communication, discretion, and judgment; ability to handle confidential information appropriately.
- Ability to translate business needs into system requirements and stay current with best practices and regulations.
- Commitment to equity initiatives and inclusive HR practices within the district context.
Technologies
- PeopleSoft
- SAP
- SQL
- Visual Basic concepts
- Microsoft Office Suite, including Excel
Education and experience
Minimum 3 years of relevant experience; Bachelor’s degree in Human Resources Management, Business Administration, Information Systems, or a related field.
Special requirements
- Position requires use of a personal automobile and a valid driver’s license.
- Occasional evenings and weekend hours may be required.
Working conditions
Office-based work with typical indoor conditions and potential interruptions; ability to perform duties that require sitting, standing and keyboard use for extended periods; may involve handling equipment up to 25 pounds.
