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