Design, develop, and analyze complex data sets from HCM and SmartFind Express, to identify trends, patterns, and areas for improvement.
Design, develop, and maintain reports, dashboards, and data extracts using Query Manager, BI Publisher, or other reporting tools.
Use R to perform statistical analyses, modeling, and visualizations to identify trends, patterns, and outliers.
Develop predictive and prescriptive models to support workforce planning, financial forecasting, and operational efficiency.
Design and implement automated workflows for data integration, validation, and reporting.
Train, mentor, and develop junior Data Analysts and business users on data tools and reporting best practices.
Advise senior leadership through advanced data analysis, dashboards, and forecasting models that inform strategic decision-making, compliance, and operational efficiency.
Leverage R scripts, SQL jobs, and scheduling tools to reduce manual work and enhance reliability by developing automations for complex business processes, audits, and workflows.
Analyze requirements, perform configurations, test changes, and implement custom code in the PeopleSoft 9.2, and update documentation.
Develop custom SQR programs and modifications according to specific business requirements using Application Designer, PeopleCode, SQL and SQR.
Apply configuration changes to PeopleSoft for earning codes, tax codes, action reasons, combo codes, department & location codes, job codes, salary grades, benefits, position data and any other table changes within PeopleSoft.
Develop new PeopleSoft interfaces and maintain existing integrations.
Work on multiple PeopleSoft modules and exercise a thorough knowledge of institutional business processes.
Develop core competency with multiple PeopleSoft technologies (SQR, PeopleTools, PeopleCode and SQL) to troubleshoot and design new solutions.
Collaborate with HR, Finance, and IT stakeholders to gather reporting requirements, provide analytical support, and deliver custom data solutions.
Perform data validation, cleansing, and reconciliation between HCM and other enterprise systems.
Provide technical guidance on data structure, table relationships, and query optimization within the HCM environment.
Support system upgrades, patching, and enhancements by conducting impact analysis and data testing.
Ensure data security and compliance with internal and external policies and regulations.
Oversee compliance-related data reporting and ensure accuracy and alignment with regulatory, and collective bargaining requirements.
Provide trending, preparation of collective bargaining reporting, and ad hoc reporting.
Investigate, research, and compile background and current information, statistics, and forecasts for the preparation of briefs, reports, proposals, and scenario building, related to HR program development, collective bargaining, settlements, grievances, and arbitration hearings.
Provide trending, preparation of collective bargaining reporting, and ad hoc reporting.
Document data sources, definitions, processes, and code for transparency and reusability.
Communicate findings to senior management via formal presentations, standard management reporting artifacts on a periodic/quarterly/annual basis.
Support upgrades, patches, and data migrations within the HCM environment including testing and updating all existing queries, reports and automations.
Perform other related duties as assigned.
