高级薪酬系统分析师
Sr Payroll Systems Analyst
部门简介
该职位位于OHSU财务部的薪资、考勤和劳动力分配服务中心。OHSU财务部是俄勒冈健康与科学大学内部负责准确处理、报告和解释大学财务交易的部门。我们通过为机构、其资助方和社区提供高质量的财务信息和服务，支持OHSU的治疗、教学、研究和外展工作。在财务运营副总裁的指导下，该职位在提供薪资、考勤和劳动力分配数据的报告、分析和解读方面发挥关键作用，以支持有依据的战略决策。
职位职责
向薪资分析与客户支持主任汇报，高级薪资与考勤系统报告分析师是一个战略性职位，负责推动基于数据的薪资运营，并在所有薪资、考勤和劳动力分配（LD）领域提供可操作的见解。该职位对薪资、考勤和LD团队提供复杂的数据和查询支持，以确保薪资运营的合规性并支持有依据的业务决策。
理想的候选人具备深厚的薪资、考勤和工资工时专业知识，强大的系统专业知识和强大的分析能力。
BI解决方案开发与数据管理
- 与客户和薪资报告团队成员合作，了解业务需求，利用Cognos Analytics、SQL、Cognos事件管理器以及其它BI数据可视化产品和工具设计、开发、实施和支持复杂解决方案。
- 开发、维护和监控指标、仪表板和定期报告，以衡量现状和目标状态，并将其纳入未来的战略和计划中。
- 回应关于薪资、考勤和劳动力分配（LD）数据的分析请求。为需要帮助分析和解读数据的个人提供技术支持。
- 为交付成果创建和维护详细的的技术文档，包括但不限于规格说明和流程图。
- 确保管理层能够以易于理解和可操作的格式获得数据和分析。
- 主动识别满足业务需求和战略计划的报告解决方案机会，制定提案及相应的技术与功能规范。
查看英文原文
Department Overview
This position is in the Payroll, Timekeeping and Labor Distribution Service Center, within OHSU Finance. OHSU Finance is the division within Oregon Health & Science University charged with the overall responsibility of accurately processing, reporting, and interpreting the university's financial transactions. We support healing, teaching, discovery, and outreach at OHSU by delivering quality financial information and services to the institution, its sponsors, and the community. Under the direction of the VP of Financial Operations, this role is critical in providing expertise in reporting, analyzing and interpreting Payroll, Timekeeping and Labor Distribution data to support informed strategic decisions.Function/Duties of Position
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 asdefined.
- 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.
Required Qualifications
- Bachelor’s degree in related field or equivalent education/experience.
- Five years of experience with database query, analytic and reporting tools.
- Three years of experience as a project manager for technical projects.
- Two years of Payroll experience that demonstrates understanding of the administrative systems, processes and human resources functional areas.
Skills & Abilities
- Strong analytical, problem-solving and conceptual skills.
- Ability to use current enterprise BI tools to write complex reports including joining data from different systems and external data sources.
- Ability to build interactive dashboards.
- Demonstrated ability to consult with and provide data driven insights to non-technical audiences, including senior executive leadership
- Ability to plan, organize and present training and other presentations to diverse employee groups.
- Advanced level experience with MS Office suite (Excel, Word, PowerPoint, Access, Outlook, Visio, Project)
- Ability to map processes. Can take a Payroll, Timekeeping or Labor Distribution process, map it and then understand how data is entered and stored in the source system and then the ETL and Framework Manager process to create the structure used for reporting.
- Strong problem solver who can evaluate a situation and ask the critical questions to understand the problem and then select a solution resulting in problem resolution.
- Good organization, follow through and time management skills; ability to prioritize and meet timelines; accomplish work in order of priority while professionally maintain composure and effectiveness under pressure and changing conditions.
- Experience establishing and maintaining effective working relationships with individuals from a variety of professional backgrounds and levels in an organization.
Preferred Qualifications
- Power BI experience.
- Experience with IBM Cognos Business Intelligence Tools.
- SQL/Database (Oracle, SQL Server, etc.) experience.
- Experience creating technical documentation for reports and data/report models.
- Advanced expertise with the Oracle payroll and UKG Kronos systems.
- Experience with data modeling tools.
- Experience with Systems Development Life Cycle (SDLC) processes and procedures.
Additional Details
Benefits
- Healthcare for full-time employees covered 100% and 88% for dependents.
- $50K of term life insurance provided at no cost to the employee.
- Two separate above market pension plans to choose from.
- Paid time off - 208 hours per year, prorated for part-time.
- Extended illness bank - 64 hours per year, prorated for part-time.
- 9 paid holidays per year.
- Substantial Tri-Met and C-Tran discounts.
- Employee Assistance Program.
- Childcare service discounts.
- Tuition reimbursement.
- Employee discounts to local and major businesses.
Why apply to OHSU?
We are Oregon's only public academic health center. In addition to caring for patients, we lead groundbreaking research. We also train the next generation of health care professionals. As Portland's largest employer, we give you opportunities to learn and advance in a system of hospitals and clinics across Oregon and Southwest Washington. All are welcome. OHSU welcomes people of all ages, ethnicities, genders, national origins, religions and sexual orientations. We are striving to build an anti-racist, multicultural institution and encourage people with diverse backgrounds to apply. To request reasonable accommodation, contact Originally posted on Himalayas