Job Description

§ Data Gathering, Cleansing, and Validation

- Work with different teams, departments, and stakeholders to collect data from various sources.

- Clean data to correct errors, remove inconcsistencies, and ensure reliability.

- Conduct regular audits to maintain data accuracy and adherence to standards.

§ Advanced Data Analysis for Performance Metrics

- Analyze project data using statistical methods to track metrics like budget, timelines, and resources.

- Create automated models for real-time performance monitoring and agile decision-making.

- Identify inefficiencies and bottlenecks, and provide insights to enhance project delivery and outcomes.

§ Tracking and Reporting on Project Performance

- Develop dashboards and reports to track key project metrics for senior management.

- Conduct regular analysis to identify trends, risks, and optimization opportunities.

- Customize reports for various audiences to support informed decision-making.

§ Trend and Forecasting Analysis

- Analyze historical data to inform predictive models for future performance.

- Use forecasting techniques to predict resource needs, budget, and risks for better strategic planning.

- Collaborate with business units to align forecasts with organizational goals.

§ Risk Assessment and Mitigation Proposals

- Analyze past performance and market conditions to assess risks.

- Develop and recommend strategies to mitigate risks.

- Work with PMO teams to integrate risk assessments into project plans for effective risk management.

Requirements

§ Experience

- 7-13 years of data analysis experience, preferably in a PMO or project-based environment, with a strong grasp of project structures, KPIs, and reporting.

- Proven background in industries where project data supports strategic decision-making, such as construction, engineering, or IT.

§ Technical Skills

- Engineering Knowledge: Strong understanding of engineering principles for contextualizing data in complex projects.

- Advanced Excel Skills: Proficient in Excel with advanced functions, Power Query, pivot tables, and macros for efficient analysis and reporting.

- Data Visualization: Skilled in Power BI for creating interactive dashboards and reports.

- SQL and Python: Experienced in SQL for querying datasets; Python preferred for advanced analysis, automation, and scripting.