Associate - Portfolio Analytics
Job Fit Check
Base Career helps you apply smarter for this job.
Key skills for this role
About the Role
Abu Dhabi Investment Council is seeking an Associate for Portfolio Analytics to own the technical development and operational management of the in-house liquidity model. This hands-on role involves writing production-grade Python/SQL code, building data pipelines, and integrating with Snowflake and other data sources.
Key Skills for This Role
Responsibilities
- Design, develop, test and maintain the code base of ADIC's in house liquidity model and related Python/SQL applications
- Optimize, refactor and performance tune existing Python and SQL code to improve execution speed, memory efficiency and maintainability
- Build, operate and monitor end to end data pipelines (ETL/ELT) integrating Snowflake with ADIC's broader data ecosystem
- Design and maintain database schemas, tables, views and stored procedures in Snowflake
- Implement automated data quality checks, reconciliation routines, logging and exception handling
- Apply software engineering best practices including version control (Git), code review, modular design, testing and documentation
- Deliver ad hoc data extractions, queries and structured data packages on demand for internal stakeholders
- Automate recurring reporting outputs from the liquidity model and ensure reproducible, audit ready analytical deliverables
- Review code, data models and analytical outputs produced by the team and external vendors
- Proactively identify and implement automation, efficiency and reliability improvements across the liquidity model's stack
Requirements
- University degree in Computer Science, Software Engineering, Data Science, Financial Engineering, Quantitative Finance, Mathematics or related quantitative discipline
- Minimum 3 5 years of hands on experience in data engineering, quantitative development or applied analytics
- At least 5 years building and maintaining production Python/SQL applications and data pipelines in a financial services or asset management setting
- Advanced Python skills including production grade application development, object oriented design, unit testing
- Deep, hands on Snowflake expertise including complex SQL, stored procedures, views, performance tuning
- Proven experience building and operating data integrations across heterogeneous systems
- Strong working knowledge of Git based version control, code review workflows, and CI/CD practices
- Experience with data pipeline orchestration and scheduling (e.g., Airflow, dbt, Snowflake Tasks)
- Solid grounding in relational data modelling, database design, and query optimization
Full Job Posting
Role Overview
- 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.
Key Responsibilities
- 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.
Requirements
- University degree in Computer Science, Software Engineering, Data Science, Financial Engineering, Quantitative Finance, Mathematics or a related quantitative discipline.
- Relevant technical certifications (e.g. Snowflake, AWS/Azure Data Engineering) or finance qualifications (CFA, CAIA) desirable but not required.
- A minimum of 3 5 years of hands on experience in data engineering, quantitative development or applied analytics, with at least 5 years building and maintaining production Python/SQL applications and data pipelines in a financial services or asset management setting.
- Proven track record engineering analytical applications for Asset Owners, sovereign wealth funds, or large multi asset class asset managers, covering both public and private markets data.
- Core: Advanced Python skills, including production grade application development, object oriented design, unit testing, and experience with libraries such as pandas, NumPy, SQLAlchemy, and pytest.
- Core: Deep, hands on Snowflake expertise including complex SQL, stored procedures, views, performance tuning, role based access, warehouses, streams and tasks.
- Core: Proven experience building and operating data integrations across heterogeneous systems (databases, APIs, flat files) and connecting analytical/quant models to enterprise data platforms.
- Nice to have: Familiarity with liquidity risk concepts and portfolio liquidity forecasting in investment portfolios (buyouts, VC, real assets, public markets, overlays).
- Core: Strong working knowledge of Git based version control, code review workflows, and CI/CD practices; comfortable collaborating on shared code bases.
- Core: Experience with data pipeline orchestration and scheduling (e.g. Airflow, dbt, Snowflake Tasks, or equivalent), including dependency management and failure recovery.
- Core: Solid grounding in relational data modelling, database design (star/snowflake schemas), and query optimization; high level of accuracy and attention to detail in production code and data.
- Nice to have: Familiarity with financial data platforms (FactSet, Bloomberg, PitchBook, MSCI Private Capital / Burgiss) and private markets data structures (commitments, calls, distributions, NAVs).
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Abu Dhabi Investment Council (ADIC)
Quantitative Researcher - Strategy
Abu Dhabi, UAE
ADIC is seeking a Quantitative Researcher to join the Strategy team. You will support investment decision-making through quantitative research, model development, and AI-driven solutions across public and private markets
Executive Assistant - Real Assets Department
Abu Dhabi, UAE
ADIC is seeking an experienced Executive Assistant to provide high-level administrative support to the Real Assets Department. The role involves diary management, meeting coordination, travel logistics, and maintaining p
Principal, European Infrastructure
Abu Dhabi, UAE
Abu Dhabi Investment Council seeks an experienced Principal for European Infrastructure investments. The role involves leading origination, evaluation, execution, and management of infrastructure investments across Europ
Strategy - Associate Principal - Long Term Asset Allocation (UAE National)
Abu Dhabi, UAE
ADIC is seeking an Asset Allocation Associate Principal to join the Long-Term Asset Allocation team in Abu Dhabi. The role involves supporting the development of long-term macroeconomic outlooks, conducting research on a
Vice President - Multi-Asset Derivatives Trading
Abu Dhabi, UAE
ADIC seeks a Senior Execution Trader (VP) to join the Public Markets Execution Trading team, focusing on execution across global macro markets with emphasis on derivatives in interest rate, FX, and synthetic credit instr
Corporate Finance - VP - Portfolio Analytics
Abu Dhabi, UAE
ADIC seeks a hands-on VP to own the technical development and operational ownership of its in-house liquidity model. The role involves writing production-grade Python/SQL code, building data pipelines on Snowflake, and i
Quantitative Researcher - Strategy
Abu Dhabi, UAE
Executive Assistant - Real Assets Department
Abu Dhabi, UAE
Principal, European Infrastructure
Abu Dhabi, UAE
Strategy - Associate Principal - Long Term Asset Allocation (UAE National)
Abu Dhabi, UAE
Vice President - Multi-Asset Derivatives Trading
Abu Dhabi, UAE
Corporate Finance - VP - Portfolio Analytics
Abu Dhabi, UAE