Job SummaryWe are seeking a PeopleSoft Reporting Specialist with expertise in PeopleSoft 9.2, Power BI, and Excel automation to support reporting, analytics, and process improvement initiatives. This role will be responsible for extracting and analyzing data, developing business reports and dashboards, automating reporting processes, and delivering actionable insights to stakeholders. The ideal candidate will possess strong analytical skills, experience with business intelligence tools, and the ability to translate business requirements into effective reporting solutions.
Key Responsibilities- Utilize PeopleSoft 9.2 to extract, analyze, and interpret data to support business and operational reporting needs.
- Develop, maintain, and enhance reports for business users, ensuring data accuracy, consistency, and usability.
- Collaborate with stakeholders to gather reporting requirements and deliver meaningful business insights.
- Troubleshoot and resolve issues related to data extraction, reporting, and reporting system functionality within PeopleSoft.
- Design and develop interactive dashboards, visualizations, and reports using Power BI.
- Utilize Excel automation tools, including Power Query and VBA, to streamline data processing and automate recurring reporting activities.
- Integrate PeopleSoft data with Power BI and Excel to create comprehensive reporting and analytics solutions.
- Analyze business processes and identify opportunities for reporting improvements, automation, and operational efficiencies.
- Conduct data analysis to identify trends, patterns, anomalies, and process bottlenecks.
- Recommend and implement process automation solutions to improve reporting efficiency and accuracy.
- Support continuous improvement initiatives by leveraging advanced analytics and reporting technologies.
- Monitor industry trends, best practices, and emerging technologies related to reporting, business intelligence, and process improvement.
- Maintain documentation related to reporting processes, data sources, business rules, and reporting methodologies.
- Collaborate effectively with cross-functional teams to support business objectives and reporting requirements.
Required Qualifications- Proven experience working with PeopleSoft 9.2.
- Experience developing reports, extracting data, and analyzing information within PeopleSoft environments.
- Strong experience with Power BI, including dashboard development, data visualization, and report creation.
- Experience with Excel automation tools, including Power Query and VBA.
- Bachelor's degree in Business Administration, Engineering, Information Systems, Data Analytics, or a related field.
- Strong analytical, problem-solving, and critical-thinking skills.
- Excellent written and verbal communication skills.
- Ability to work effectively with business users, technical teams, and cross-functional stakeholders.
- Strong organizational skills and attention to detail.
- Experience using reporting, analytics, and process improvement tools and methodologies.
- Ability to interpret complex data and translate findings into actionable business recommendations.
Preferred Qualifications- Experience integrating PeopleSoft data with business intelligence and reporting platforms.
- Experience developing automated reporting solutions and data workflows.
- Knowledge of process improvement methodologies and operational efficiency initiatives.
- Experience conducting trend analysis, business performance reporting, and operational analytics.
- Familiarity with data governance, data quality, and reporting best practices.
- Experience supporting enterprise reporting and business intelligence initiatives.