We are looking for a Workday Prism Analytics Consultant with 4+ years of experience to design, build, and maintain enterprise data pipelines, transformation logic, and advanced reporting solutions within Workday. You will be responsible for bringing external data into Workday Prism, combining it with core Workday HCM and Financials data, and building high-performance dashboards, Discovery Boards, and reports for business stakeholders.
Data Pipeline & Schema Design: Configure, optimize, and maintain Workday Prism data pipelines, datasets, table schemas, and data change tasks.
ETL & Data Transformation: Ingest high-volume data from external systems (Salesforce, SAP, Snowflake, legacy databases) into Prism using API, SFTP, and file-based integrations. Perform complex transformations, joins, unions, and aggregations.
Reporting & Visualization: Develop advanced custom reports, matrix reports, Discovery Boards, and interactive dashboards leveraging Prism datasets alongside core Workday data.
Security & Governance: Manage and audit Prism domain security policies, dataset-level security, and access rules to ensure data compliance and governance.
Performance Optimization: Monitor pipeline performance, troubleshoot execution failures, optimize execution times, and manage data retention policies.
Stakeholder Collaboration: Partner with cross-functional teams (HR, Finance, IT, and Business Intelligence) to translate reporting requirements into functional Prism architectures.
Testing & Upgrades: Participate in end-to-end testing, User Acceptance Testing (UAT), and validate pipeline behavior during bi-annual Workday feature releases.
Requirements
Workday Expertise: Minimum 4 years of hands-on experience in Workday, with at least 2+ years dedicated to Workday Prism Analytics.
ETL & Data Warehousing: Strong background in ETL design, data modeling, schema creation, data warehousing concepts, and data transformation principles.
SQL & Calculated Fields: Proficiency in writing complex SQL queries and advanced Workday Calculated Fields.
Reporting Tools: Deep expertise in Workday Report Writer, Discovery Boards, composite reports, and matrix reports.
Integrations: Practical experience using EIBs, Workday Studio, and REST/SOAP APIs to transfer data in and out of Workday.
Education: Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related quantitative field.
Skills Required
- At least 4 years of hands-on Workday experience
- At least 2 years of Workday Prism Analytics experience
- Experience designing ETL processes, data models, schemas, data warehouses, and transformations
- Proficiency writing complex SQL queries
- Proficiency with advanced Workday Calculated Fields
- Deep expertise in Workday Report Writer, Discovery Boards, composite reports, and matrix reports
- Practical experience with EIBs, Workday Studio, REST APIs, and SOAP APIs
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related quantitative field
What We Do
Clovio Consulting is a Bangalore-based IT consulting organization serving Fortune 500 companies with cloud-based human capital management (HCM) and finance enterprise applications. It provides advisory and consulting, implementation, integration, testing, deployment, feature-release management, and information-systems audit services. The company also offers mobile-app development and AI capabilities, with an emphasis on delivering high-quality, scalable solutions that help clients maximize return on investment.
