LiftmyCVLiftmyCV
AD

Associate - Portfolio Analytics

Abu Dhabi Investment Council CompanyOn-siteAbu Dhabi, AE
AI job summary

The Associate - Portfolio Analytics role at Abu Dhabi Investment Council involves the technical development and operational ownership of an in-house liquidity model. Primarily hands-on, this position focuses on writing and optimizing Python/SQL code, building data pipelines, and integrating various data sources. The role includes ensuring production stability, implementing best engineering practices, and delivering analytical outputs for stakeholders, all while following industry standards for data governance and security.

Job description

Job Description

Responsible for the technical development, engineering and operational ownership of ADIC’s in-house liquidity model and supporting analytical applications. The role is primarily hands-on, focused on writing, optimizing and maintaining production-grade code, building and operating data pipelines, and integrating ADIC’s data ecosystem (Snowflake, source systems, FactSet, internal databases) with the liquidity model. Partners with investment and support departments to deliver robust, reproducible analytics, reporting outputs and ad-hoc data extractions.

  • Design, develop, test and maintain the code base of ADIC’s in-house liquidity model and related Python/SQL applications; own the full engineering lifecycle from requirements to deployment.
  • Optimize, refactor and performance-tune existing Python and SQL code to improve execution speed, memory efficiency and maintainability of the liquidity model and analytical applications.
  • Build, operate and monitor end-to-end data pipelines (ETL/ELT) integrating Snowflake with ADIC’s broader data ecosystem, including source investment systems, FactSet, and internal repositories that feed the liquidity model.
  • Design and maintain database schemas, tables, views and stored procedures in Snowflake; write complex, performant SQL queries for transformation, reconciliation and analytics workloads.
  • Implement automated data quality checks, reconciliation routines, logging and exception handling across the liquidity model’s data and compute layers; ensure production stability and auditability.
  • Apply software engineering best practices including version control (Git), code review, modular design, testing and documentation; maintain a clean, production-ready code base.
  • Deliver ad-hoc data extractions, queries and structured data packages on demand for internal stakeholders, including inputs for department semi-annual portfolio reviews, senior management meetings and board-level presentations.
  • Automate recurring reporting outputs from the liquidity model and ensure reproducible, audit-ready analytical deliverables for executive and board consumption.
  • Where relevant, contribute commentary on factors impacting liquidity, go-forward returns and nowcast scenarios, supporting the model’s analytical narrative (desirable, complementary to the core technical mandate).
  • Ensure data engineering and modelling methodologies follow industry best practice and internal ADIC standards for security, data governance and reproducibility.
  • Review code, data models and analytical outputs produced by the team and external vendors; enforce testing, documentation and release discipline.
  • Proactively identify and implement automation, efficiency and reliability improvements across the liquidity model’s data, compute and reporting stack.
  • Independently troubleshoot and resolve production issues across the application, pipeline and database layers, including root-cause analysis and permanent fixes.
  • Work with investment and support staff, service partners and technology vendors (e.g. In516ht, Snowflake, FactSet) to resolve technical issues and deliver data and reporting requirements.
  • Carry out other similar or related duties as assigned.

Job details

Published
June 11, 2026
Job source
jworkable
Workplace
On-site · Abu Dhabi, AE
First seen
June 11, 2026
AI match explained

See how well you match this job

Log in or sign up and Eva will compare your profile with this role, explain your strengths and show what to improve.

Sign up to see your matchAlready have an account? Log in

More at Abu Dhabi Investment Council Company

Similar jobs from this company

None listed.

Across the market

Similar jobs from other companies

Third-party content disclaimer

Full job descriptions are sourced directly from third-party applicant tracking systems (ATS), job boards, recruitment platforms, and employer career pages.

LiftmyCV does not claim ownership of this content or guarantee its accuracy or current availability. All original content is the intellectual property of the respective employers or other rights holders.

LiftmyCV hiring intelligence, availability checks, and related-job recommendations are generated from LiftmyCV data and public sources.

If you prefer, you may apply directly via the original listing for transparency.