HRIS Assistant

CEI; Pittsburgh (Allegheny County); Hybrid; USD 40,000 - 70,000; Full time

Job summary

An established industry player is seeking a detail-oriented HRIM Assistant for a 15-month temporary assignment in Pittsburgh. This role focuses on data entry, reporting, and procedural HR system tasks, ensuring accuracy and compliance in weekly and biweekly HR reports. The ideal candidate will possess HRIS experience and strong Excel skills, including proficiency with Pivot Tables and VLOOKUPs. Join a small, hands-on team in a structured HRIM environment, where you'll support key HCM upgrade initiatives and contribute to efficient HR data reporting. This opportunity allows for 1-2 remote days per week after training, making it a flexible choice for the right candidate.

Qualifications

• 1-2 years of experience in HRIS or HR reporting roles.
• Strong Excel skills, including Pivot Tables and VLOOKUPs.

Responsibilities

• Generate and distribute HR reports on schedule.
• Ensure data integrity and accuracy in HR reporting.
• Assist with HR data entry and audit requests.

Skills

HRIS experience

Excel proficiency

Attention to detail

SQL understanding

HTML Publisher tools

Tools

PeopleSoft

Microsoft Visio

Job description

HRIM Assistant (Pittsburgh, PA Locals ONLY. NO RELOCATION. / H1B Visa Sponsorship Available)

Job at a Glance

We are seeking a detail-oriented and self-sufficient HRIM Assistant for a 15-month temporary assignment with no extension or conversion possibility. This role is focused on data entry, reporting, and procedural HR system tasks. The primary responsibility is ensuring that weekly and biweekly HR reports are accurate, compliant, and distributed on schedule. The ideal candidate will have HRIS experience, strong Excel skills, and familiarity with PeopleSoft.

This is a 100% onsite role in downtown Pittsburgh to start. Once trained, the team may allow 1-2 remote days per week. The position follows a business professional dress code and is part of a small, hands-on team that will provide training and guidance.

Responsibilities

• Generate and distribute scheduled HR reports (weekly, biweekly, monthly, and quarterly).
• Ensure data integrity and accuracy in reports before distribution.
• Perform HR data entry related to job, position, and pay changes in the HR system.
• Utilize Excel (Pivot Tables, VLOOKUPs, sorting, etc.) for data management and reporting.
• Assist with audit requests by retrieving historical reports and verifying HR data.
• Work closely with the HRIM team to ensure compliance with reporting standards.
• Maintain and update HR system tables and assist with organizational chart development (Microsoft Visio).
• Support HCM upgrade initiatives by providing accurate data and reports.
• Assist with approval documentation for pay and title changes.

Qualifications

• 1-2 years of experience in HRIS, HR reporting, or a related role.
• Experience with relational databases (PeopleSoft preferred).
• Proficiency in Excel – must be comfortable with Pivot Tables, VLOOKUPs, and sorting functions.
• Basic understanding of SQL and HTML Publisher tools is a plus.
• Attention to detail is critical – reports must be accurate and compliant.
• Ability to work independently with minimal supervision.

About the Client

Our client is a leading investment management firm focused on maintaining compliance, accuracy, and efficiency in HR data reporting. This position offers an opportunity to work within a structured HRIM environment, supporting key HCM upgrade initiatives and ensuring timely and compliant HR reporting.

Hiring Process & Timeline

• Target Start Date: Mid-June/Early July

Seniority Level: Mid-Senior level

Employment Type: Full-time

Job Function: Administrative

Industries: Investment Banking