Workday Data Analyst

PTR Global; Dallas (TX); On-site; USD 85,000 - 120,000; Full time

Job summary

PTR Global is seeking a seasoned Data Analyst specializing in Workday Analytics and Amazon Redshift to design, build, and support enterprise data solutions. You will blend Workday data with Redshift and other sources to deliver insightful reporting across HR, Finance, and operations.

Responsibilities include crafting data pipelines, optimizing queries, validating data quality, and collaborating with stakeholders to define KPIs and dashboards.

Qualifications

• 4+ years of experience in data analysis, BI, reporting, data integration, or data engineering.
• Hands-on Workday Analytics data ingestion, dataset creation, transformation, and publishing.
• Strong AWS/Redshift SQL development, data modeling, and performance tuning.
• Experience integrating Workday with Redshift and other enterprise data sources.

Responsibilities

• Design, develop, and maintain datasets and analytics within Workday Analytics.
• Integrate Workday data with Amazon Redshift and external sources.
• Develop optimized SQL queries, views, and data models in Redshift.
• Translate business requirements into scalable data models, reports, and dashboards.

Skills

Analytical skills

Stakeholder management

Communication

Problem solving

Tools

Workday Analytics

Amazon Redshift

SQL Development

ETL/ELT

Data Modeling

Data Governance

Job description

We are seeking an experienced Workday and Amazon Redshift Data Analyst to design, develop, and support enterprise data and analytics solutions. This role will integrate Workday and external data through Workday Analytics and Amazon Redshift, enabling business leaders to make informed decisions across HR, Finance, and operational functions.

Key Responsibilities

• Design, develop, and maintain datasets, data pipelines, and analytics solutions within Workday Analytics.
• Integrate Workday data with Amazon Redshift and other internal and external data sources.
• Develop and optimize SQL queries, views, tables, and data models within Amazon Redshift.
• Extract, transform, and load data between Workday Prism, Amazon Redshift, and enterprise applications.
• Gather business requirements and translate them into scalable data models, reports, dashboards, and actionable insights.
• Perform data cleansing, transformation, validation, reconciliation, and quality assurance across multiple data sources.
• Develop and enhance Workday reports, including Advanced, Matrix, Composite, and Discovery Board reports.
• Partner with HR, Finance, IT, data engineering, and business stakeholders to define key performance indicators and reporting requirements.
• Monitor and troubleshoot data pipelines, Redshift queries, reporting issues, data discrepancies, and performance concerns.
• Optimize Redshift database performance through effective query design, distribution strategies, sort keys, and workload management.
• Establish and maintain data governance, security, documentation, and reporting standards.
• Support system testing, user acceptance testing, production deployments, and post-production validation.
• Provide training and ongoing support to business users on Workday Prism datasets, reports, and dashboards.

Required Qualifications

• 4+ years of experience in data analysis, business intelligence, reporting, data integration, or data engineering.
• Hands-on experience with Workday Analytics, including data ingestion, dataset creation, data transformation, and publishing.
• Strong experience with Amazon Redshift, including SQL development, data modeling, query optimization, and performance tuning.
• Experience integrating data between Workday, Amazon Redshift, and other enterprise systems.
• Strong experience with Workday reporting tools, calculated fields, and security.
• Advanced SQL skills and experience working with large, complex datasets.
• Understanding of ETL/ELT processes, data warehousing, data validation, reconciliation, and governance principles.
• Ability to translate business needs into clear technical, reporting, and analytical requirements.
• Strong analytical, problem-solving, communication, and stakeholder-management skills.

Preferred Qualifications

• Workday Prism Analytics or Workday Reporting certification.
• AWS certification or demonstrated experience with AWS data services.
• Experience with AWS Glue, Amazon S3, AWS Lambda, or related AWS technologies.
• Experience with Workday HCM, Financial Management, Payroll, or related modules.
• Familiarity with Workday Extend, Workday Accounting Center, or Worksheets.
• Experience with visualization platforms such as Power BI or Tableau.
• Knowledge of REST and SOAP APIs, SFTP, flat-file integrations, and cloud-based data platforms.
• Experience working in Agile delivery environments.