HRIS Specialist - Part Time

Stony Brook University; New York (NY); On-site; USD 52,000 - 76,000; Part time

Job summary

Stony Brook Medicine is seeking an HRIS Specialist (Part Time) to design and modify report queries in PeopleSoft/Oracle, build HR dashboards, and deliver accurate data to leaders. You will leverage Excel, Power BI, and collaboration tools to support compliance and strategic HR initiatives. Strong communication and data governance skills are essential.

Responsibilities include creating ad-hoc reports, presenting findings to executives, and ensuring data integrity across HR systems.

Qualifications

• 3+ years of HRIS reporting and analytics experience.
• Strong data governance and HR data lifecycle understanding.
• Ability to translate business needs into accurate, repeatable reports.

Responsibilities

• Write/modify queries in PeopleSoft/Oracle.
• Develop HR dashboards and ad-hoc reports for executives.
• Utilize advanced Excel to produce summaries and dashboards.
• Create/maintain reports for compliance and HR initiatives.
• Collaborate with HR, IT and leadership to ensure data accuracy.

Skills

Advanced Excel

HRIS reporting

Data governance

Dashboards

Education

Bachelor's degree

Tools

Power BI

Jira

SharePoint

Teams

Excel (Advanced)

Job description

HRIS Specialist - Part Time

Position Summary

At Stony Brook Medicine, a HRIS Specialist will work as part of the HRIS team and will be responsible for writing, designing and/or modifying report queries, preparing and presenting report summaries, and dashboards and presentations related to HR and Compensation data. Overall goal is to provide accurate data in a timely manner, while safeguarding sensitive and confidential information.

Duties of a HRIS Specialist may include but are not limited to the following:

• Writes and/or modifies report queries in PeopleSoft/Oracle upon request.
• Working with IT to build more insightful HR dashboards to provide trend and predictive analytics to support strategic initiatives and leadership planning.
• Utilizing advanced excel features - creates both summary and detailed reports and dashboards on the status of HR regulatory requirements including annual required education, professional credential expiration dates, annual physicals, performance programs, performance evaluations, permanent appointment packages, etc.
• Creates and maintain dashboards, reports, scorecards, and visualizations for operational and strategic decision-making.
• Build and schedule standard and ad-hoc reports for distribution to HR partners and executives.
• Develops and presents department head and executive level presentations on the status of compliance items and/or other HR strategic and tactical initiatives.
• Collects information on needed changes and updates to employee data and in collaboration with HRIS Manager and other members of HRIS, makes any corrections needed to ensure data accuracy.
• Responds to questions related to reports and/or other questions in a timely manner.
• Coordinates with other HR units all correspondences to employees, supervisors, department heads regarding employees who are not compliant with key items, such as Annual Physical, Annual Require Educations, Flu shots, etc.
• Proactively identify opportunities to streamline and standardize HR data reporting and analytics workflows.
• Lead or participate in Oracle implementation to improve HRIS current processes, reduce bottlenecks, and enhance data access.
• Document and refine process using HRIS playbook to support adoption of improved processes.

Qualifications

Required Qualifications: Bachelor's degree. At least 3 years of Human Resources experience to include HRIS reporting and analytics experience in a complex operationally driven environment. Deep understanding of HR data governance, data definitions, and the HR data lifecycle across systems (from entry through reporting and downstream use). Ability to modify and enhance existing reports, including adding or adjusting data fields based on business needs. Ability to interpret business requirements and translate them into accurate, consistent, and sustainable reporting outputs. Strong data validation skills and attention to detail, ensuring accuracy and consistency across systems and reports. Strong collaboration skills with HR, IT, and business stakeholders. Advanced Excel skills, including proficiency in pivot tables and lookup tables. Exceptional written and verbal communication skills, with the ability to communicate clearly and concisely to broad audiences, including executive leadership.

Preferred Qualifications: Prior experience writing advanced queries using functions, expressions, inner/outer joins, and other advanced features. Familiarity with Microsoft 365 collaboration tools (Power BI, Teams, SharePoint) and Jira to support reporting, project tracking, cross-functional collaboration and continuous process improvement initiatives. Familiarity with Press Ganey requirements. Familiarity with Joint Commission Requirements. Familiarity with collective bargaining agreements. Prior experience with PeopleSoft/Oracle HCM. Experience working for Higher Education, Public Employment, and in a diverse and unionized environment. Experience working in a healthcare environment.

Posting Overview

This position will remain posted until filled or for a maximum of 90 days. If within the initial review no candidate was selected to fill the position posted, additional applications will be considered for the posted position; however, the posting will close once a finalist is identified, and at minimal, two weeks after the initial posting date.