About this role
Workday Data & Integration Specialist ? Job Description
Duration:
• 3 months (if the person has knowledge of just Finance/Accounting module). • 8 months (if the person meets all of the requirements).
Summary: This contractor will serve as the Workday data and reporting expert embedded within the EBI team. The role has three core mandates:
• Build: Develop custom RaaS (Report as a Service) reports, web service integrations, and data extraction pipelines to move Workday data into the BI staging environment. The build must align with data warehousing needs/requirements. • Map: Complete field-level source-to-target mapping between legacy systems (Great Plains, PeopleSoft, Taleo) and Workday objects/fields, including transformation logic and business rules. • Transfer: Train and coach the existing BI team members to independently build, maintain, and govern Workday reports and data extractions, creating a sustainable internal capability.
Responsibilities: Workday Data Extraction & Integration (50%):
• Design and build custom advanced (RaaS) reports in Workday to extract transactional and master data for BI consumption across HCM, Finance, Payroll, Recruiting, Benefits, Absence, and Learning modules. • Configure Workday web service integrations for setup/reference data extraction (organizations, cost centers, companies, locations, job profiles). • Resolve extraction limitations, including the matrix/composite report constraint for summarized financial data (GL balances, income statements, balance sheets) that cannot be exposed as RaaS. • Collaborate with the BI integration team (via CData middleware) to validate that extracted data populates staging and fact tables correctly, with field-level accuracy. • Document all custom reports, data sources used, calculated fields created, filters applied, and business logic embedded ? to a standard sufficient for ongoing maintenance by staff.
Source-to-Target Mapping & Data Modeling Support (30%):
• Complete the Workday-side field mapping for all GP Finance fact tables, identifying which Workday field, data source, and report corresponds to each legacy staging table column. • Extend the mapping to PeopleSoft HR, Taleo Recruiting, and D2L/Lambda Learning staging tables as modules come into scope. • Support the Enterprise Data Architect in validating Workday metadata for the Microsoft Purview business glossary, including object definitions, field descriptions, and relationship context. • Advise the data modeling team on Workday-specific nuances: effective-dated records, multi-instance relationships, supervisory org hierarchies, and cross-module joins that impact dimensional model design. • Support data reconciliation between legacy reports and new Workday-sourced reports, identifying and resolving variances caused by differing business logic, field semantics, or aggregation rules.
Knowledge Transfer & Training (10%):
• Conduct structured hands-on training sessions for 4 BI team members on Workday Report Writer, data sources, business objects, calculated fields, and custom fields. • Create internal reference documentation: a practical Workday reporting guide tailored to company configuration (not generic Workday training material). • Pair-program with BI analysts on RaaS reports end-to-end, progressively transferring ownership so team members can build independently by month 4. • Establish report development standards: naming conventions, security domain considerations, testing protocols, and change governance proc