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.
