Ppm Data Analytics

Requisition ID: 223310

Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.

**The role**:
As a PPM Data Analytics & **Power BI Specialist** you will be at the forefront of extracting, analysing and visualizing data from Clarity PPM ( and other sources) to provide stakeholders with actionable insights into project performance, resource utilization and portfolio management. You will be responsible for designing BI dashboards/reports that drive business and operational efficiency. You will collaborate closely with various stakeholders/teams/ management reps across the bank to understand business objectives and reporting needs, unique requirements and deliver comprehensive Power BI solutions that meet their needs while adhering to quality and standards.

**What will you do?**
- **
Data Modeling and Transformation**: Extract/download data from Clarity PPM and other relevant systems/sources, clean, massage and reprocess data as needed. perform in-depth analysis to identify trends, patterns, and key performance indicators related to project management, time tracking and resource allocation. Design and implement robust data models.
- ** Dashboard and Report Development**: Maintain & Develop visually appealing and intuitive dashboards, reports, and visualizations using Power BI. Support stakeholders with real-time insights into data related to project management, statuses, resource utilization/allocation, budget variance, time tracking and other critical metrics..
- ** Data Integration & Building Solutions**: Understand the data from various systems - Clarity PPM data & other data sources such as financial systems or HR databases, to provide a comprehensive view of project performance and portfolio management. Build solutions that meet the stakeholders requirements/expectations from power bi dashboard reporting standpoint.
- ** Performance Optimization**: Optimize BI reports and queries to ensure fast and efficient performance, specially when dealing with large volumes of data.
- ** Data Quality**: Implement rigorous data quality checks and validation processes to ensure the accuracy, consistency, and integrity of data used in Power BI dashboards/solutions.
- ** Stakeholder Collaboration**: Collaborate closely with project managers, business analysts, directors, senior Leaders & other stakeholders to understand their reporting requirements and translate them into effective BI solutions (that drive informed decision-making) following a well defined work intake process. Regularly prioritize the initiatives with the stakeholders and set the right expectations.
- **Documentation and Training**: Create comprehensive documentation for BI solutions, including data models, report specifications, and user guides. Provide training and support to end users to ensure they can effectively utilize BI reports and dashboards.

**What do you need to succeed?**
- Bachelor's degree in Computer Science, Information Systems, Finance, or a related field.
- 4 years of experience working as a Power BI developer and data engineer preferably in financial services industry.
- 3 years of experience working on Clarity PPM ( project portfolio management technology) preferably in financial services industry.
- Excellent analytical skills with a keen attention to detail.
- Strong communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams.
- Experience with data modeling techniques and best practices, particularly in the context of project management, time tracking, resource management, Dashboard reporting, data extracts and other banking data.
- Proficiency in Structured Query Language for data manipulation and querying, with a solid understanding of relational data structures and schema.
- Strong knowledge of software lifecycle, project management, time tracking, financial management and processes
- Proven track record of developing insightful dashboards and reports using Power BI in an enterprise environment.
- Familiarity with financial performance metrics, risk management principles, and regulatory reporting.
- Extensive Experience with Power BI dashboards and data management in the banking industry.
- Knowledge of Clarity CA-PPM, programming languages, data analysis and automation.
- Familiarity with cloud-based data platforms
- Relevant certifications in Power BI, data engineering, or banking systems data analytics.

**What's in it for you?**
- We have an inclusive and collaborative working environment that encourages creativity and curiosity and celebrates success
- We provide you with the tools and technology needed to create meaningful customer experiences
- You'll get to work with and learn from diverse industry leaders, who have hailed from top technology companies around the world
- We hire you for your talent — not just a job — so you can grow with us. We’ll equip you for success not only in your role, but also in your career as a