Workday Prism Analytics Lead

Workday Prism Analytics Lead1

Key Responsibilities

Strategic Architecture & Project Delivery 

• Data Pipeline Architecture: Design and build scalable ETL (Extract, Transform, Load) pipelines to ingest high-volume external data into Workday Prism.

• Data Modeling: Utilize the Workday Data Catalog to create curated Prism Data Sets. Perform complex data transformations (Joins, Unions, Group By, Filter) to blend external records with Workday Core HCM/Finance objects (e.g., blending Salesforce Revenue data with Workday Sales Compensation data).

• Advanced Visualization: Design and configure executive-level Discovery Boards and Composite Reports that visualize blended data, providing insights that standard Workday reporting cannot achieve.

• Security Architecture: Define and enforce Prism Security Domains, ensuring that sensitive external data (e.g., historical payroll or diversity benchmarks) is restricted to appropriate user groups.

• Solution Design: Partner with Finance and HR stakeholders to determine the "Buy vs. Build" strategy for reporting—advising when to use Workday Prism versus external data warehouses (e.g., Snowflake, Redshift).

L2 Support & Operational Management 

• Pipeline Monitoring: specific monitoring of daily scheduled data imports (API/SFTP). Investigate and resolve failures related to "Bad Rows," API timeouts, or schema mismatches.

• Performance Tuning: Troubleshoot and optimize slow-running reports or Prism datasets that exceed processing time limits. Refactor inefficient calculated fields or join logic.

• Capacity Governance: specific management of Prism Storage Capacity. Implement data retention policies, archive obsolete datasets, and optimize row counts to remain within licensed limits.

• Change Management: Perform impact analysis on Prism datasets during bi-annual Workday releases. Ensure that changes to Core Workday objects do not break downstream Prism mappings.

• Incident Resolution: Serve as the Tier 2/3 support point for "Data Discrepancy" tickets, investigating root causes where reported numbers in Prism do not match source systems.

Qualifications

Mandatory Education & Certifications

• Workday Certification: Active Workday Prism Analytics certification (Pro or Implementer) is strictly required.

• Education: Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or related field (or equivalent experience).

Required Experience

• Workday Experience: 4+ years of hands-on experience in the Workday ecosystem.

• Prism Expertise: Minimum 2+ years of dedicated experience building Prism Data Sets, pipelines, and Discovery Boards.

• Data Engineering Skills: Strong proficiency in SQL concepts (Inner/Outer Joins, Unions, Case Logic) and data transformation principles.

• Core Knowledge: Deep understanding of the Workday Object Model (Business Objects, Fields, Instances) required to successfully map external data to internal IDs.

Preferred Skills

• Secondary Certification: Workday Advanced Reporting or Composite Reporting.

• Analytics Tools: Experience with Workday People Analytics (VIBE Central) or external BI tools (Tableau, PowerBI).

• Integration: Basic ability to read/debug XML, XSLT, or API logs.

Competencies

• Analytical Thinking: Ability to translate vague business questions (e.g., "Are we paying our sales team effectively?") into concrete data models and visualizations.

• Attention to Detail: obsession with data accuracy and validation.

• Communication: Ability to explain complex data limitations or pipeline failures to non-technical stakeholders.