Workday Prism Analytics Lead

Jade Global; Maharashtra; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Jade Global is looking for a Data Pipeline Architect in India, Maharashtra. The successful candidate will design and build scalable ETL pipelines, manage data quality, and create sophisticated data visualizations. An essential requirement is 4+ years of experience in the Workday ecosystem and an active Workday Prism Analytics certification. Proficiency in SQL and hands-on experience with analytics tools are needed. The position allows for impactful work in a collaborative environment.

Qualifications

• Active Workday Prism Analytics certification is required.
• 4+ years of hands-on experience in the Workday ecosystem.
• Deep understanding of the Workday Object Model.

Responsibilities

• Design and build scalable ETL pipelines.
• Monitor daily scheduled data imports and resolve failures.
• Serve as Tier 2/3 support for data discrepancy tickets.

Skills

Data Pipeline Architecture

Data Modeling

Advanced Visualization

SQL proficiency

Analytical Thinking

Education

Bachelor’s degree in Computer Science or related field

Workday Prism Analytics certification

Tools

Workday

Tableau

PowerBI

Job description

Key Responsibilities

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