Loading...
Share this Job

Data Analyst, Infrastructure

Location: 

London, GB

Job Function:  Investment Services
Job Type:  Permanent
Req ID:  9381

The Infrastructure strategy focuses on investing in infrastructure assets primarily through direct investments, complemented with a few investments in infrastructure funds and infrastructure loans.

We are looking for a suitable candidate to join our Investment Services team as a Data Analyst to support the Infrastructre team globally.

 

Internal reporting and Asset Management-related duties

  1. Prepare Portfolio/Asset section of the PMC (Portfolio Management Committee) pack
    1. Portfolio and Asset performance reporting
    2. Prepare analysis on portfolio leverage, yield profile and other metrics
    3. Manage PMC process and relevant activities
  2. Responsible for various regular portfolio reporting duties (for example, portfolio debt, portfolio asset operational performance)
  3. Perform ad-hoc analysis on INFRA operating and portfolio data
  4. Coordination and data support for asset level reporting
  5. Prepare INFRA portfolio materials for various internal reports
  6. Prepare half yearly Deal Expense reports
  7. Provide information to and support GISR/RPMD in preparation of portfolio materials for internal presentations

 

INFRA operating and portfolio data management

  1. Work with Data Solution team to maintain high standard of MAGI (Management of Asset Governance Information) process and data
    1. work with Data Solution team to ensure receiving regular good quality information from portfolio companies
    2. Make sure appropriate investment case information are captured correctly.
    3. Work with TG to develop new tools to improve current process.
  2. Regular review of INFRA dashboards
    1. Ensure portfolio and asset level data are accurately reflected in dashboards.
    2. Portfolio and Asset analysis tables and charts are up to date.
    3. Work with TG to enhance current dashboards to support INFRA needs.
  3. Participate in corporate initiatives related to INFRA (for example, Goggles, deal tracker and Asset Management systems etc.)
    1. Liaise with various internal stakeholders for example TD, ISPVMF, INFRA officers etc. to ensure smooth execution of such projects.
  4. Liaise with Technology Group (TG) and Investment Services Private Markets and Finance (ISPVMF) to support wider GIC corporate system projects
    1. Work with TG and ISPVMF to ensure that the GIC corporate wide system supports INFRA’s reporting requirements.
    2. Conduct trainings for the various data management platforms (MAGI, INFRA Dashboards, Tableau etc.) and assist with any requests the team has on the platforms.
  5. Maintain and update portfolio spreadsheets
    1. Integrate corporate data from Goggles (internal analytics platform system) to perform portfolio analysis.

 

INFRA Funds

  1. Team support
    1. Maintain a database of fund managers, and key metrics.
    2. Support in the preparation and maintenance of detailed landscaping packs, including return benchmarking for similar fund managers.
  2. Asset Management and Reporting
    1. Assist in the automation of fund and fund manager performance and monitoring reporting.
    2. Prepare first draft materials for Funds PMC and similar internal updates.
    3. Prepare sections for the annual INFRA Active Strategy Review relating to funds.
  3. Ad-hoc
    1. Support the funds team by helping to model fund terms on certain funds.
  4. Long-term
    1. Work with TG to enhance the tracking and logging of data as listed above and migrate from Excel to dedicated databases over time.

 

INFRA Debt

  1. Team Support
    1. Support with the development and maintenance of a detailed landscaping pack of infrastructure debt funds, including return benchmarking.
  2. Asset Management and Reporting
    1. Track high level asset performance for all borrowers where INFRA is a direct lender (revenues, EBITDA etc.) and credit metrics (covenants).
    2. Assist in the automation of debt performance and monitoring reporting.
    3. Prepare relevant sections for the annual INFRA Debt Active Strategy Review and PMC.
    4. Ensure data quality in Goggles system is high and inform OIC and 2IC if deal information is incomplete or incorrect.
  3. Ad hoc
    1. Support deal teams with work around internal projects, such as policy work (e.g. ratings methodologies, hedging policies, etc.).
  4. Long-term
    1. Work with TG to enhance the tracking and logging of data as listed above and migrate it from Excel to dedicated databases over time.

 

Other support

  1. Work closely with ISPVMF team globally to support internal projects or initiatives.
  2. Maintain various INFRA corporate subscriptions and remain current in understanding functionality and potential application of external data sources.
  3. Data and other support for internal INFRA led projects using INFRA information, publicly available sources, INFRA databases and other corporate subscriptions.

 

Potential Background

  • Data Analyst, mid-office role in an Investment Bank or fund
  • Finance background and interest in IT projects and Infrastructure/ asset management
  • Experience of managing databases, analyses, Exel, Powerpoint, VBA and or Tableau

 

Our PRIME Values

Our PRIME Values

GIC is a values driven organization. GIC’s PRIME Values act as our compass, enabling us to fulfil our fundamental purpose and objectives. It is the foundational bedrock which governs our behaviors, our decision making, and our focus. It informs both our long-term strategy as a firm, and the way we relate to our Client, business partners and employees. PRIME stands for Prudence, Respect, Integrity, Merit and Excellence.