HRIS Analyst/Human Resources Representative

RPMGlobal; Burlingame (CA); On-site; USD 90,000 - 125,000; Full time

Job summary

RPMGlobal in Burlingame, CA is seeking an HRIS Analyst who bridges Human Resources and IT to design data pipelines, develop SQL queries, and model data for reporting. You will create dashboards, reports, and HRIS configurations to support management’s labor and employee relations programs.

The role requires SQL, Power BI, Dayforce experience, strong analytical skills, and the ability to handle confidential data with sound judgment. Bachelor's degree preferred.

Qualifications

• Bachelor's degree preferred or equivalent experience in HR
• Experience writing SQL queries and working with relational databases
• Experience developing reports, dashboards, and analytical solutions using Power BI or similar tools
• Strong analytical, troubleshooting, and problem-solving skills
• Ability to handle confidential data with sound judgment

Responsibilities

• Designs, develops, and maintains data pipelines and datasets that support reporting and analytics
• Creates, maintains, and optimizes reports, dashboards, and analytical solutions using Power BI, SQL, and other tools
• Monitors data quality and data integrity across systems
• Supports HRIS administration and user training materials
• Participates in testing, validation, and user acceptance testing for software releases

Skills

SQL queries

Power BI

HRIS experience

Data modeling

Data integrity

Education

Bachelor's degree preferred

Tools

Dayforce

Relational DBs

Job description

General Description

This position provides highly skilled support to the department’s management team in the delivery of the department’s services and programs. It directly supports management’s labor relations and employee relations programs and processes. In addition, it requires understanding of Human Resources competencies, specifically working as an HRIS analyst. In this role, the incumbent will bridge Human Resources and information technology with designing data pipelines, developing SQL, modeling data for reporting, and creating reports and dashboards.

The confidential and sensitive nature of the work performed by this position requires the incumbent to exercise self-initiative, good judgment, and have a thorough knowledge of CTA internal policies and procedures as well as good understanding of the Human Resources field and its core competencies. The incumbent will also provide the Human Resources Management team with administrative support in various committees, training workshops and HR activities.

Duties and Responsibilities

• Designs, develops, and maintains data pipelines and datasets that support reporting and analytics initiatives.
• Creates, maintains, and optimizes reports, dashboards, and analytical solutions using Power BI, SQL, and other reporting tools.
• Monitors data quality, analyzes discrepancies, and helps ensure data integrity across systems.
• Troubleshoots data-related issues and supports enhancements to reporting and integration processes.
• Maintains accurate employee records, run regular data audits, and build custom dashboards and metrics reports.
• Configures workflows, business processes, security roles, and user permissions within platforms such as Dayforce.
• Generates routine and customized reports from HRIS.
• Manages the HRIS support, resolves day-to-day user issues, and creates training job aids or documentation.
• Participates in testing, validation, and user acceptance testing (UAT) for regular software releases and system enhancements.
• Translates business needs into technical configurations to automate and streamline HR operations.
• Responsible for the full cycle of HR responsibilities related to staff employment such as but not limited to recruitment, hiring/onboarding, personnel action changes, and maintainingpersonnel files.
• Provides administrative and logistical support for various training programs and workshops.
• Provides high-level administrative support to the department’s management team, which in addition to other responsibilities includes drafting and preparing letters, memos, reports and other documents, note-taking at meetings, coordinating calendars, appointments and making travel arrangements and assist with expenses.
• Responds to inquiries on behalf of the department’s management team exercising sound and independent judgment and reliance on an extensive department and organizational knowledge base.
• Researches and prepares information and materials affecting management policies regarding staff.
• Researches and prepares information and materials that relate to management’s strategies and positions relative to the negotiation process with the employee bargaining units.
• Acts on behalf of the department management team and follows through on communications with leadership, management and staff as directed.
• Coordinates application of employee health and welfare benefit programs, insurances, leaves of absences, and maintains relevant data.
• Provides support for labor and employee relations programs and processes.
• Provides support and assists in the coordination of CTA’s safety programs and policies.
• Carries out to completion complex projects requiring extensive knowledge of department policies and procedures and technical expertise.
• Performs other appropriate duties as assigned.

Qualifications - Minimum Required

• Bachelor's degree preferred, or Associate degree and four (4) years of administrative experience preferable in Human Resources.
• Experience writing SQL queries and working with relational databases.
• Experience developing reports, dashboards, and analytical solutions using Power BI or similar reporting tools.
• Strong analytical, troubleshooting, and problem-solving skills.
• Strong attention to detail and sound judgment when working with sensitive workforce and personnel data.
• Requires self-initiative, ability to effectively organize work, and set priorities.
• Ability to follow through on work assignments with little supervision.
• Demonstrated proficiency in databases.
• Demonstrated ability to exercise planning, coordinating and follow through skills as applied to large complex logistical projects.
• High proficiency in administrative skills including composing and preparing letters, memorandums and utilizing proper report formatting, punctuation and spelling.
• Ability to learn and communicate CTA structure, policies and procedures.
• Ability to communicate, develop and maintain effective working relationships with all levels within and outside of CTA.
• Demonstrated ability to communicate clearly, verbally and in writing.
• Excellent interpersonal skills and problem solving skills as first point of contact with employees.
• Demonstrated ability to maintain confidentiality.
• Proficiency in the use of computer technology, and ability to learn and use the Association’s software programs and HR related database programs.
• Ability to travel as needed.
• Ability to work overtime as needed.

Preferred Qualifications

• Experience and proficiency working with HRIS systems and implementation of new software and updates.

* This is a confidential assistant position external to the CAS bargaining unit.