Org Design Data Analyst | Excel & Workday Prep

Lancesoft; Summit (NJ); On-site; USD 60,000 - 90,000; Full time

Job summary

Lancesoft is seeking a Data Support Specialist / Data Analyst in Summit, NJ to support an organizational design initiative by capturing and validating organization structure data for downstream HR systems. You will partner with project Super Users and Design Leads to encode designs in data form and perform Excel-based analysis, cleansing, and transformation for data uploads to Workday and other systems.

The role requires advanced Excel skills, experience with HR/workforce data, familiarity with

Qualifications

• Advanced Microsoft Excel skills (pivot tables, formulas, lookups, data analysis).
• Experience working with HR, workforce, or organizational data.
• Familiarity with organizational design, workforce planning, or HR transformation initiatives.
• Experience with Workday, including EIBs, data loads, and data validation.
• Strong attention to detail and ability to manage large, complex datasets.

Responsibilities

• Capture, validate, and prepare organization structure data for downstream HR systems.
• Partner with project Super Users and Design Leads to encapsulate organizational designs in data form.
• Perform Excel-based data analysis, data cleansing, and data transformation for Workday uploads and other systems.

Skills

Data Analysis

Python

Tableau

SQL

Data Visualization

Business Partnering

Tools

Excel

Workday

EIBs

Job description

Lancesoft is seeking a Data Support Specialist / Data Analyst in Summit, NJ to support an organizational design initiative by capturing and validating organization structure data for downstream HR systems. You will partner with project Super Users and Design Leads to encode designs in data form and perform Excel-based analysis, cleansing, and transformation for data uploads to Workday and other systems.

The role requires advanced Excel skills, experience with HR/workforce data, familiarity with