HR Data Analyst (Span-of-Control & Organizational Design)

Posted last week

Only freelancers located in the U.S. may apply.U.S. located freelancers only

Summary

Department: People & Culture / Human Resources Engagement type: Fixed-term contractor (full-time, 8-12 weeks) Location: Remote About the Role We are undertaking a span-of-control and spans-and-layers review to ensure our organization is structured for efficiency, accountability, and growth — the right ratio of team members to managers, the right number of management layers, and minimal redundancy. We are looking for a detail-oriented HR Data Analyst to help us gather, clean, and structure the people data that powers this analysis. This is a hands-on, fast-moving engagement. You will be the data backbone of the project, partnering closely with HR leaders to turn varied inputs into a clean, analysis-ready dataset and clear, decision-ready views. What You’ll Do • Consolidate HR data from multiple sources (HRIS, org charts, headcount, job architecture, reporting relationships) into a single, reliable dataset. • Calculate and report span of control (direct reports per manager) and layers (levels between the top of the org and the front line); flag outliers — over-extended managers, single-report managers, and excess layers. • Build and maintain clean reporting structures, manager-to-IC ratios, and supporting views and dashboards. • Validate data accuracy, reconcile discrepancies, and document assumptions and methodology. • Support scenario modeling and “what-if” comparisons as leadership tests organizational design options. • Prepare clear summaries and visuals that make findings easy for HR and business leaders to act on. What You’ll Bring • 3+ years in HR data / people analytics, HR operations, or a comparable analytical role. • Strong Excel skills (pivot tables, lookups, large-dataset cleanup); experience with HRIS data is essential. • Familiarity with organizational design concepts — span of control, spans and layers, reporting hierarchies, and job leveling. • Comfort working with sensitive, confidential people data with discretion and accuracy. • Self-directed, fast, and able to deliver under a tight timeline with minimal ramp-up. • Bonus: experience with org-design or workforce-planning projects; familiarity with Power BI, Visio, or org-charting tools. Engagement Details • Duration: Approximately 60 days, with potential to extend based on project needs. • Start: As soon as possible. Completion of a criminal background check is required before you can start work.

  • More than 30 hrs/week
    Hourly
  • 1-3 months
    Duration
  • Intermediate
    Experience Level
  • $30.00

    -

    $65.00

    Hourly
  • Remote Job
  • Ongoing project
    Project Type
Skills and Expertise
Mandatory skills
Human Resources Analytics
Activity on this job
  • Proposals:20 to 50
  • Last viewed by client:52 minutes ago
  • Interviewing:
    9
  • Invites sent:
    17
  • Unanswered invites:
    8
About the client
Member since Jan 9, 2023
  • United States
    Itasca3:25 PM
  • $4.4M total spent
    216 hires, 54 active
  • 128,920 hours

Explore similar jobs on Upwork

Qualitative Research
Research Methods
Survey Design
Scientific Literature Review
Proofreading
Qualtrics
NVivo
Quantitative Analysis
Stata
Public Health
Statistical Analysis
SAS
Statistics
Basic to Advanced Excel TeacherHourly‐ Posted 2 weeks ago
Microsoft Excel
Spreadsheet Software
Data Entry
Data Analysis

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo