Reporting to the Director Payroll Analytics and Customer Support, the Senior Payroll & Timekeeping Systems Reporting Analyst is a strategic role responsible for driving data-driven payroll operations and delivering actionable insights across all payroll, timekeeping, labor distribution (LD). This role is critical in supporting the payroll, timekeeping and LD team with complex data and queries to ensure compliance of payroll operations and to support informed business decisions.
The ideal candidate combines deep payroll, timekeeping and wage and hour expertise, strong systems expertise and strong analytical capabilities.
BI Solution Development & Data Management
- Collaborate with customers and the Payroll Reporting team members to understand business requirements and design, develop, implement and support complex solutions utilizing Cognos Analytics, SQL, Cognos Event Manager and additional BI data visualization products and tools.
- Develop, maintain and monitor metrics, dashboards, and recurring reports to measure current and desired state, and incorporate into future strategy and initiatives.
- Respond to requests for data analyzing the payroll, timekeeping and Labor Distribution (LD) data. Provide technical assistance for individuals needing assistance in analyzing and interpreting data.
- Create and maintain detailed technical documentation for deliverables including but not limited to specifications and process flows.
- Ensure that leadership has the data and analytics available in an easy to digest and actionable format.
- Proactively identify opportunities for reporting solutions to meet business needs and strategic initiatives and create proposals and accompanying technical and functional specification documentation.
- Develop solutions that adhere to data governance, data security, best practices and established report standards. This work ensures that the information assets of OHSU are leveraged to enhance financial and operational decisions and to meet institution goals.
- In conjunction with other team members, establish and maintain standard core payroll, timekeeping and labor distribution reports and metrics that can be utilized in fulfilling ah-hoc user requests as well as reports that can be deployed to users to run as needed based on security profiles.
- Provide critical data needed for OHSU Financials and Budgeting to support workforce cost modeling, payroll accruals, forecasting, budgeting activities.
- Ensure data accuracy and integrity across payroll systems and reporting outputs.
- Respond to requests for information (RFI) including RFI for collective bargaining agreements and public requests related to Payroll, Timekeeping, Labor Distribution (LD).
- Respond to public data requests for Payroll, Timekeeping and Labor Distribution (LD).
- Provide ad-hoc reports and SQL queries to the Payroll, Timekeeping and LD teams. Develop and maintain SQL queries and reports for payroll, timekeeping and LD to support complex reviews and pay period processing needs.
Program & Project Management
- Management of small projects involving systems and reporting solutions that have implications for ongoing payroll, timekeeping and labor distribution efforts throughout the institution and new initiatives and programs.
- Develop and maintain project plans and other project deliverables utilizing waterfall and agile project methodologies.
- Collaborate with stakeholders and sponsors to identify key metrics, performance indicators and other project deliverables.
- Apply business area expertise to define and frame complex, multi-dimensional projects by estimating level of effort, creating timelines, identifying risks and milestones, and providing status reporting to others as defined.
- Provide project updates and coordinate communication efforts to ensure project deliverables are deployed efficiently and effectively.
- Collaborate with OHSU Finance areas to manage efforts related to improving payroll, timekeeping and labor distribution data and structures to enhance reporting capabilities and eliminate data inadequacies.
- Participate on project teams to develop/enhance data availability and technical capabilities.
- Identify opportunities to improve payroll, timekeeping and LD processes through automation, system enhancements, and data integration.
- Partner with HRIS, Finance, and IT teams on system implementations and upgrades.
Compliance & Controls
- Develop and maintain SQL queries and reports for payroll, timekeeping to review and ensure alignment with the federal, state, collective bargaining agreements and OHSU policies and procedures.
- Support internal and external audits by providing required data, documentation, and analysis.
- Monitor and enhance payroll, timekeeping and LD controls to mitigate operational and financial risk.
- Analyze payroll data to identify trends, variances, and anomalies across multiple geographies and pay groups.
- Perform root cause analysis on payroll discrepancies and recommend corrective actions.
Documentation, Education & Training, Cross-Functional Collaboration
- Create and deliver presentations interpreting and educating OHSU leadership, OHSU Finance and other departments and individuals on Payroll, Timekeeping and Labir Distribution metrics and analytics.
- Thoroughly document business requirements, data architecture solutions, business processes and training material for business and technical audiences.
- Design and develop education and training materials utilizing multiple media types for creation and delivery to various audiences.
Create guidelines, processes and other documentation ensuring transparency while adhering to confidentiality requirements.
Act as a subject matter expert for payroll, timekeeping and labor distribution data across departments.
Collaborate with the OHSU Finance team on reconciliations, accruals, and financial reporting requirements.
- Translate complex data into clear, concise insights to support leadership in decision making.
- Other duties as assigned.