Bi Reporting Analyst

Role & responsibilities:

About the Role:

The P&G Project Management Office (PMO) team is seeking a highly detail-oriented and analytical Financial Reporting Analyst to support the generation and analysis of critical month-end variance reports. This contractor role is essential for providing Project Managers (PMs) with timely insights into project forecast accuracy and enabling proactive adjustments. The ideal candidate will possess a strong understanding of financial reporting, data analysis, and experience working with large datasets, preferably within a project accounting environment.

Responsibilities:

• Data Sourcing & Preparation: Extract, transform, and prepare financial data from various source systems, ensuring accuracy and consistency for reporting.
• Report & Dashboard Development: Design, build, and maintain comprehensive financial variance reports and interactive dashboards. This includes various views like overall summaries, category breakdowns, and detailed variance analyses.
• Advanced Data Analysis: Perform in-depth analysis of financial data, identify variances, and support reconciliation efforts. This includes capturing data snapshots for historical comparison.
• Stakeholder Support: Collaborate with Project Managers and other teams to understand reporting needs, provide insights, and ensure reports facilitate effective decision-making.

---

Required Skills & Experience:

• 5-6 years of experience in financial reporting, data analysis, or a similar role.
• Proven ability to work with large datasets from financial systems like Oracle Time & Labor (OTL).
• Expertise in data extraction and manipulation using SQL.
• Strong experience developing reports and dashboards with Strategy (Formerly: MicroStrategy).
• Advanced proficiency in data analysis using Microsoft Excel.
• Solid understanding of financial concepts, forecasting, and project accounting.
• Exceptional attention to detail and commitment to data accuracy.
• Strong analytical and problem-solving skills.
• Effective communication and collaboration abilities.
• Ability to work independently in a dynamic environment.