Sr. ERP/Reporting Analyst - Workforce Management

Ascension

1d•$91,107 - $126,998•Remote

About The Position

The Ascension Data Science Institute (ADSI) Workforce Management (WFM) Sr Analyst will serve as the reporting and analytics support for Ascension’s Workforce Management solutions, partnering closely with the WFM Data Expert & Solutions Specialist. This role will leverage Oracle Fusion Data Intelligence (FDI), GCP BigQuery, and related reporting platforms to deliver accurate, actionable workforce insights. The Sr Analyst will ensure that UKG Pro data is effectively integrated, validated, and transformed into dashboards and reports that drive operational efficiency, labor optimization, and strategic decision-making.

Requirements

2+ years of experience in reporting, data analysis, or ERP/WFM systems.
Proficiency in SQL and experience working with GCP BigQuery.
Familiarity with visualization/reporting tools (Tableau, Power BI, Oracle OTBI/BIP/FDI, Google Looker).
Strong ability to translate complex workforce data into clear, business-ready insights.
High School diploma equivalency with 2 years of cumulative experience OR Associate's degree/Bachelor's degree OR 4 years of applicable cumulative job specific experience required.

Nice To Haves

Knowledge of UKG Pro WFM and UKG HCP data structures and reporting.
Experience in healthcare workforce planning and operations and understanding of workforce KPIs, benchmarks, and best practices.
Proficiency in Python or R for advanced analytics and statistical modeling a plus.

Responsibilities

Build, maintain, and validate WFM data, dashboards, reports, and extracts using Oracle FDI, BigQuery, and BI tools (Tableau, Power BI, Oracle OTBI/BIP).
Translate UKG Pro workforce data into actionable insights on scheduling, staffing, compliance, and labor utilization.
Partner with the WFM business team to ensure accuracy, timeliness, and consistency in reporting deliverables.
Support the flow of WFM data between UKG Pro, UKG Healthcare Productivity (HCP), Oracle ERP, Oracle FDI, and BigQuery.
Write advanced SQL queries for workforce data validation, transformation, and reporting.
Contribute to machine learning/statistical analyses by preparing clean, accurate datasets.
Monitor KPIs, thresholds, and targets for operational efficiency.
Work alongside HR, Finance, Payroll, and Clinical Operations to gather reporting requirements and deliver solutions.
Support troubleshooting of workforce reporting issues, identifying root causes and recommending improvements.
Proactively identify opportunities for efficiency reporting, automation, and data pipeline optimization.
Document data processes, definitions, and reporting logic to ensure transparency and sustainability.
Contribute to data governance and compliance practices across ERP and WFM reporting.