Power BI Developer

Project & Portfolio Financial Governance

• Oversee project creation updates and closure within CA-PPM/Clarity.
• Manage CapEx/OpEx classification and ensure compliance with accounting policies.
• Facilitate submission validation and approval of capitalization forms.
• Track financial performance (forecast vs. actuals CapEx variance etc.).

Resource Allocation & Time Management

• Collect and validate monthly resource allocation data from TPMs and Leads.
• Ensure alignment of allocations across CA-PPM Jira and financial reporting systems.
• Manage monthly time booking process including automation of intake forms and reminders.
• Adjust for non-billable hours (vacations training etc.) to ensure accurate time postings.

Reporting & Dashboarding

• Develop and maintain dashboards for:
  • Resource utilization & allocations
  • CapEx/OpEx variance
  • Project financials and prioritization
• Provide executive-level summaries and insights for leadership decision-making.
• Drive adoption of standardized reporting frameworks (e.g. PRDT-level allocations ProdFocus mapping).

Automation & Process Improvement

• Automate repetitive processes (e.g. allocation file generation intake form follow-ups).
• Enhance efficiency in data collection validation and reporting cycles.
• Partner with Technology/PPM teams to align systems (CA-PPM/Clarity Jira).

Risk & Issue Management

• Identify risks in allocation reporting and governance processes.
• Provide timely escalations and mitigation plans (e.g. resource gaps delayed sign-offs).
• Ensure transparency and accountability in financial project reporting.

Stakeholder Engagement & Support

• Act as the bridge between Finance TPMs Accounting and Technology teams.
• Support TPMs and business leads with allocation reporting and governance queries.
• Align with leadership on priorities open issues and process changes.

• Dashboard & Report Development

  • Design build and maintain interactive dashboards and reports in Power BI to support FPMO Finance and leadership.

  • Develop visualizations for project allocations CapEx/OpEx variance non-billable tracking and monthly time booking.

• Data Integration & Modeling

  • Connect clean and transform data from multiple systems (e.g. CA-PPM/Clarity Jira Excel intake forms).

  • Build robust data models that ensure accuracy and consistency across reporting.

• Automation & Process Improvement

  • Develop automated solutions for recurring processes (e.g. intake form reminders allocation file generation).

  • Reduce manual intervention by leveraging Power BI DAX Power Query and related tools.

• Collaboration & Stakeholder Management

  • Partner with TPMs Finance and business leads to gather requirements and refine reporting outputs.

  • Ensure alignment of dashboards with evolving business processes (e.g. PRDT-level allocations ProdFocus mapping).

  • Provide training and guidance to users on dashboard interpretation and usage.

• Governance & Risk Management

  • Ensure compliance with reporting standards and data governance practices.

  • Validate and troubleshoot data inconsistencies to maintain high-quality reporting outputs.

• Proven experience as a Power BI Developer or similar role (35 years).

• Strong proficiency in Power BI DAX Power Query and SQL.

• Experience with data modeling ETL processes and integrating multiple data sources (Excel Jira Clarity etc.).

• Understanding of financial reporting project governance and resource allocation is highly desirable.

• Excellent analytical problem-solving and communication skills.

• Ability to work independently while collaborating effectively with cross-functional teams.

What we offer you

• Transparent compensation schemes and comprehensive employee benefits tailored to your location ensuring your financial security health and overall wellbeing.

• Flexible working arrangements advanced technology and collaborative workspaces.

• A culture of high performance and innovation where we experiment with new ideas and take responsibility for achieving results.

• A global network of talented colleagues who inspire support and share their expertise to innovate and deliver for our clients.

• Global Orientation program to kickstart your journey followed by access to our platform LinkedIn Learning Pro and tailored learning opportunities for ongoing skills development.

• Multi-directional career paths that offer professional growth and development through new challenges internal mobility and expanded roles.

• We actively nurture an environment that builds a sense of inclusion belonging and connection including eight Employee Resource Groups. All Abilities Asian Support Network Black Leadership Network Climate Action Network Hola! MSCI Pride & Allies Women in Tech and Womens Leadership Forum.

At MSCI we are passionate about what we do and we are inspired by our purpose to power better investment decisions. Youll be part of an industry-leading network of creative curious and entrepreneurial pioneers. This is a space where you can challenge yourself set new standards and perform beyond expectations for yourself our clients and our industry.

MSCI is a leading provider of critical decision support tools and services for the global investment community. With over 50 years of expertise in research data and technology we power better investment decisions by enabling clients to understand and analyze key drivers of risk and return and confidently build more effective portfolios. We create industry-leading research-enhanced solutions that clients use to gain insight into and improve transparency across the investment process.

MSCI Inc. is an equal opportunity employer. It is the policy of the firm to ensure equal employment opportunity without discrimination or harassment on the basis of race color religion creed age sex gender gender identity sexual orientation national origin citizenship disability marital and civil partnership/union status pregnancy (including unlawful discrimination on the basis of a legally protected parental leave) veteran status or any other characteristic protected by law. MSCI is also committed to working with and providing reasonable accommodations to individuals with disabilities. If you are an individual with a disability and would like to request a reasonable accommodation for any part of the application process please email and indicate the specifics of the assistance needed. Please note this e-mail is intended only for individuals who are requesting a reasonable workplace accommodation; it is not intended for other inquiries.

To all recruitment agencies

MSCI does not accept unsolicited CVs/Resumes. Please do not forward CVs/Resumes to any MSCI employee location or website. MSCI is not responsible for any fees related to unsolicited CVs/Resumes.

Note on recruitment scams

We are aware of recruitment scams where fraudsters impersonating MSCI personnel may try and elicit personal information from job seekers. Read our full note on