Associate - Portfolio Analytics
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
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 inMore 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.