HR Data Analyst

HR Data Analyst / Analytics Engineer - Connect HRIS Data to Retention Dashboards

Budget: $3,000-$7,000 (project-based, with ongoing retainer potential) Duration: 2-6 weeks per client engagement

Hours/Week: flexible, project-based)

I'm hoping to go back-to-back so this becomes a full time position. Right now we are just starting, so might be a little random. I am fine doing it as a flat rate for the right candidate.

About Us

Experience Improvement Partners (EIP) is a consulting firm that helps growth-stage companies reduce employee turnover using data-driven diagnostics. We have existing React-based dashboards and calculators (Turnover Tax Calculator, Executive Retention Dashboard, Friction Point Analysis tools). What we need is someone who can take a client's raw HR data and make those tools come alive with real numbers.

The Job

Each client engagement starts with us receiving raw HR data exports. We need someone who can take a client's raw HR data (HRIS exports, exit interviews, scheduling logs, attendance records, performance data) and connect it into our existing React-based dashboards and calculators so that client-specific numbers populate automatically instead of manual entry.

Specifically, this role will:

Ingest and clean HRIS data (CSV, Excel, API exports from systems like ADP, Workday, BambooHR, Paylocity, UKG, Paychex)

Transform that data into the structure our React dashboards expect

Run our diagnostic framework across 250+ workforce variables (turnover by tenure band, shift type, supervisor, site, job classification, etc.)

Build the data pipeline so our cost calculators auto-populate with client-specific figures

Generate predictive risk scores for employee departure likelihood

Produce clean, client-ready data visualizations and exportable reports

We are not looking for someone to redesign the dashboards. The UI exists. We need the data layer that feeds them.

Required Skills

Must-Have:

Python (pandas, NumPy) for data cleaning, transformation, and analysis

Experience working with HRIS/HR data (understanding termination codes, tenure calculations, compensation structures, job hierarchies, shift/schedule data)

React/JavaScript proficiency to wire data into existing JSX components

SQL for querying and structuring datasets

Excel/CSV wrangling with messy, inconsistent real-world data

Statistical analysis: cohort analysis, regression, survival analysis for turnover prediction

Data visualization (Recharts, Plotly, or D3)

Strong Plus:

Prior experience with workforce analytics, people analytics, or HR tech

Familiarity with common HRIS platforms (ADP, Workday, BambooHR, UKG, Paylocity)

Experience building ETL pipelines or automated data processing workflows

Knowledge of turnover/retention metrics (cost-per-hire, time-to-fill, early attrition rates, voluntary vs. involuntary separation)

What a Typical Client Engagement Looks Like

We receive from the client:

HRIS export (18 months of employee records)

Exit interview data (coded responses)

Supervisor performance data

Scheduling and attendance logs

Offer letter vs. actual placement data

We need that turned into:

Cleaned, structured dataset mapped to our 250+ variable framework

Populated Turnover Tax Calculator with real cost-per-departure figures across 13 cost categories

Root cause analysis identifying top friction points by site, tenure band, shift, and supervisor

Predictive departure risk scores per employee or cohort

Executive-ready dashboard with live KPIs

How to Apply

Send us:

A brief description of your experience with HR/workforce data specifically

An example of a data pipeline or analytics project where you took messy source data and turned it into actionable dashboards

Your hourly rate and estimated hours for a first engagement (assume: 1,200 employees, 18 months of HRIS data, 200+ exit interviews)

We are building a long-term relationship here. Each new client means a new engagement. If the first project goes well, expect recurring work monthly.

Tags: Python, Pandas, React, Data Analytics, HRIS, Workforce Analytics, People Analytics, Data Visualization, ETL, SQL, HR Data, Recharts, Statistical Analysis

Contract duration of more than 6 months.

Mandatory skills: Data Analysis, Tableau

Optional skills: SAS, IBM SPSS