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.**