Workday Prism Data Specialist

Key Responsibilities

1. Data Discovery & Profiling

• Analyze and profile flat files exported from Preceda
• Identify data quality issues (gaps, duplicates, inconsistent formatting)
• Build a comprehensive data inventory and data dictionary

2. Field Mapping & Documentation

• Map Preceda source fields to Workday Prism datasets
• Collaborate with Payroll SMEs and Workday teams to define transformation logic
• Maintain version-controlled documentation and transformation rules

3. Data Transformation & Preparation

• Cleanse, normalize, and format historical flat file data (multi-year scope)
• Automate repeatable transformation pipelines using Python, SQL, Excel, or Alteryx
• Ensure formats align with Workday Prism ingestion and Australian payroll data standards

4. Workday Prism Integration

• Assist with configuration of Prism staging datasets
• Define relationships, dataset keys, and access/security parameters
• Support ingestion, validation, and troubleshooting with internal Workday teams

5. Validation & Reconciliation

• Reconcile Prism datasets against Preceda reports
• Work with Payroll SMEs to verify earnings, tax, super, and leave accuracy
• Build audit and reconciliation reports to ensure completeness and integrity

6. Reporting & Compliance Readiness

• Support creation of historical payroll dashboards and reports in Prism
• Ensure alignment with ATO STP Phase 2, record-keeping laws, and audit needs
• Document processes and outputs to meet internal and external audit standards

7. Governance & Documentation

• Apply data privacy best practices (e.g., secure handling of TFNs and termination data)
• Ensure adherence to organisational data retention and governance policies
• Prepare clear handover documentation for internal teams post-project

Required Skills & Experience

Mandatory

• 5-8 years of experience in data transformation, migration, or integration
• Strong hands-on experience with flat files (CSV, TXT, Excel) and ETL processes
• Proficiency in SQL (e.g., Snowflake, BigQuery), Python (Pandas) , Excel (PowerQuery) , and/or Alteryx
• Experience in cross-functional project teams, preferably in payroll or HR environments