Data Analyst (AIA Investment Management)
Core
Central coordinator for data sourcing, management, and quality assurance to support investment analysis and reporting.
Role type
Data Analyst (Data Sourcing & Quality)
Builds
High-quality datasets for investment analysis and reporting
Domain
Investment Management / Financial Services
Deliverable
dashboards & analysis
Required skills
Data sourcing, Data collation, Data cleaning, ETL, Data quality checks, Documentation, Stakeholder coordination
Preferred skills
SQL, Python, Power Query, Investment management knowledge, Cloud data platforms, Data visualization
Technologies
Excel, SQL, Python, Power Query
Responsibilities
Coordinate with business users and external providers to obtain data; Collect and consolidate data from multiple sources; Perform routine data extraction, transformation, and loading; Conduct completeness, accuracy, and consistency checks; Maintain data dictionaries and process documentation.