Compensation and Workforce Data Analyst
Job Description
Compensation and Workforce Data Analyst will serve as the Bank’s primary analyst for compensation programs and workforce analytics in Middletown, RI.
Responsibilities
- Act as the primary analyst and administrator for compensation programs, supporting organizational alignment, market competitiveness, internal equity, and regulatory requirements.
- Run market pricing analyses using salary surveys and external compensation databases; recommend improvements to pay practices.
- Produce annual compensation studies, salary structure reviews, and job evaluation analyses, identifying trends, compression concerns, and internal equity issues.
- Analyze compensation data and recommend starting salaries, promotional increases, market adjustments, retention adjustments, and annual salary administration activities.
- Partner with business leaders, the VP Total Rewards, and the SVP CHRO to develop data-driven compensation recommendations for talent attraction, retention, and workforce planning.
- Perform statistical analysis of compensation data, including compa-ratios, range penetration, pay-for-performance outcomes, turnover trends, and demographic analyses.
- Support the annual merit increase process by modeling budget scenarios, forecasting costs, validating recommendations, and preparing executive reporting.
- Assist with the design, administration, and ongoing improvement of employee incentive and bonus programs.
- Conduct incentive plan effectiveness analyses; measure outcomes against business objectives and recommend modifications.
- Calculate, validate, audit, and report incentive plan results to ensure accurate and timely payouts.
- Build incentive plan performance dashboards and reporting tools to track achievement against goals and key performance indicators.
- Partner with Finance and business line leaders to model incentive plan costs, forecast payouts, and assess financial impacts of proposed plan changes.
- Ensure compensation and incentive programs are administered consistently and in line with internal governance and applicable regulations.
- Complete and submit compensation and benefits surveys; analyze results to identify emerging market trends and opportunities.
- Maintain job architecture, salary grades, job titles, career progression frameworks, and compensation data integrity in HR systems.
- Research compensation best practices and emerging trends; present actionable recommendations to leadership.
- Develop and maintain HR dashboards, scorecards, and workforce analytics reports for executive leadership and the Board of Directors.
- Analyze workforce trends across headcount, turnover, retention, hiring, diversity, compensation, engagement, and productivity.
- Use HRIS, payroll, and compensation data to identify trends, risks, and opportunities and recommend next steps.
- Create predictive and trend analyses to support workforce planning, succession planning, and budgeting.
- Produce quarterly and annual compensation, incentive, workforce, and HR metrics reports for senior leadership.
- Perform data validation and auditing to ensure accuracy and integrity of employee, compensation, and organizational data.
- Design and automate recurring reports and dashboards to improve efficiency and enable data-driven decisions.
- Provide ad hoc analytical support for strategic Human Resources initiatives and organizational projects.
- Maintain HRIS applications and modules, ensuring accurate and timely processing of payroll and employee information updates.
- Respond to employee inquiries related to payroll, employee data, payroll adjustments, and HR system transactions.
- Lead and prepare bi-weekly payroll to ensure accurate and timely processing, processing manual checks when necessary.
- Coordinate with Finance to support timely and accurate general ledger submissions and other financial reporting requirements.
- Compile payroll data including garnishments, vacation accruals, insurance deductions, and 401(k) contributions.
- Monitor completion of required policy acknowledgements and compliance sign-offs; follow up as needed.
- Coordinate and support Human Resources, payroll, benefits, retirement plan, and HRIS audits.
- Serve as primary HR liaison for internal and external audits: prepare documentation, respond to audit requests, maintain supporting records, and ensure corrective actions are completed on time.
- Maintain records and reporting for benefits programs and compliance filings, including ACA, EEO-1, Affirmative Action, and other required employment reporting.
- Administer the Bank’s Nationwide Mortgage Licensing System (NMLS) program: new license applications, renewals, continuing education tracking, employee status changes, and regulatory reporting.
- Maintain NMLS records and coordinate with Compliance, Lending, and management to ensure ongoing adherence to licensing requirements.
- Generate and analyze payroll, HRIS, benefits, and workforce reports for business and regulatory needs.
- Recommend process improvements that enhance efficiency, compliance, data integrity, and employee experience.
Requirements
- Bachelor’s degree in Human Resources, Business, Finance, Data Analytics, or a related field; equivalent experience may be considered.
- Five or more years of experience in compensation, total rewards, HR or workforce analytics, finance, or a related field.
- Knowledge of market pricing, job evaluation, salary structures, pay equity, merit administration, and incentive programs.
- Strong analytical skills, including experience interpreting data, developing models and forecasts, and presenting actionable recommendations.
- Advanced Microsoft Excel skills plus experience with HRIS, payroll, reporting, and data-visualization tools.
- Strong attention to detail, communication, project management, and judgment with confidential information and multiple priorities.
- Compensation, Human Resources, or analytics certification preferred.
Technologies
- Microsoft Excel
- HRIS
- Payroll
- Data-visualization tools
- Nationwide Mortgage Licensing System (NMLS)
- General ledger
Physical Requirements
- Travel independently to the primary work location, other bank properties, and work-related activities or events outside the Bank.
- Effectively communicate and exchange accurate information and ideas.
- Operate a computer and office machinery (calculator, copy machine, printer, and role-related software).
- Sit or stand at a workspace and use a computer or other equipment for prolonged periods.
- Meet the hybrid work schedule requirements: work in the office during normal business hours on Mondays and Wednesdays and another day of choice to meet business needs.
- Move office items weighing up to 35 pounds.
- Work in an environment with low to moderate noise levels.
Independent Action
- Uses considerable independent judgment to analyze compensation and workforce data, identify trends, develop recommendations, and administer compensation and incentive programs.
- Makes recommendations regarding salary actions, market adjustments, pay structures, incentive plan effectiveness, and workforce metrics.
- Escalates policy exceptions, significant compensation decisions, and strategic compensation matters to the VP Total Rewards and SVP CHRO for final approval.