Technical Business Analyst

Workday Business Analyst (Data Mapping Specialist)

Duration : 6 months

Location: Chicago, requires 3 days onsite

Responsibilities

• Legacy-to-Cloud Data Mapping: Analyze raw data from disparate legacy setups, translating them into standard Workday object models.
• Template Ingestion & Management: Own the manipulation, logic parsing, and cleansing of the client's master Excel migration sheets.
• Cross-Functional Data Transformation: Document rigid field-by-field definitions, transformation rules, and structural logic across HCM, Payroll, and Financials .
• Tenant Validation Support: Work closely with Workday integration engineers to resolve validation failures or schema mismatches during data load cycles.
• Stakeholder Alignment: Guide the client's business leads through ambiguous data fields to accurately map historical files to future-state Workday definitions.

Key Domain Scope

• HCM Stream: Mapping core personal details, job profiles, supervisory hierarchies, positions, and global tracking IDs.
• Payroll Stream: Structuring historical earnings data, local tax profiles, deduction categories, and calculation variables.
• Financials Stream: Translating legacy general ledgers, cost centers, companies, and project dimensions into the standard Workday Foundation Data Model (FDM).

Technical Requirements & Tools

• Excel Power User: Deep fluency in nested lookup logic (XLOOKUP/INDEX-MATCH), data formatting tricks, and structural string formatting tools to parse and clean raw data rows.
• Data Schema Familiarity: A solid conceptual understanding of how Workday groups objects, uses reference IDs, and structure fields across modules.
• Meticulous Audit Mindset: The organizational grit to manage thousands of rows of data without dropping field accuracy.