Sr. ERP/Reporting Analyst

Details Department: Ascension Data Science Institute Schedule: Full-time, 8 hour day shift, Monday - FridayLocation: RemoteSalary: $91,107.00 - $126,998.00 per yearBenefits Paid time off (PTO)Various health insurance options & wellness plansRetirement benefits including employer match plansLong-term & short-term disabilityEmployee assistance programs (EAP)Parental leave & adoption assistanceTuition reimbursementWays to give back to your community Benefit options and eligibility vary by position. Compensation varies based on factors including, but not limited to, experience, skills, education, performance, location and salary range at the time of the offer.Responsibilities Position SummaryThe 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.Key ResponsibilitiesReporting & Data Development- 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.Data Integration & Analysis- 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.Collaboration & Support- 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.Continuous Improvement- 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.Required Qualifications- 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.Preferred Qualifications- 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.Competencies- Analytical problem-solving and critical thinking.- Effective communication with technical and non-technical stakeholders.- Collaboration across business and technical teams.- Attention to detail and commitment to data integrity.- Continuous learning mindset, adaptable to evolving systems and priorities.Requirements Education:High School diploma equivalency with 2 years of cumulative experience OR Associate'sdegree/Bachelor's degree OR 4 years of applicable cumulative job specific experience required.Additional Preferences No additional preferences. #internalops #ADSI #LI-remote