Officer 3 (Data Analytics), Asset Owner Solutions
Core
An experienced preparer role responsible for handling routine ETL and data processing activities, performing pre-validation checks, and preparing draft inputs for senior review within Asset Owner Solutions.
Role type
Mid-level data analyst (ETL & reporting)
Builds
Recurring report inputs, draft report components, and validated data sets for client-specific requirements
Domain
Investment services / Asset Owner Solutions
Deliverable
production ML models | product features | dashboards & analysis
Required skills
ETL processes, data extraction, data transformation, MS SQL, Data Warehouse concepts, data visualization, Tableau, Power BI, Macro/VBA, advanced Microsoft Excel
Preferred skills
Troubleshooting technical issues, handling complex or unstructured data, data storytelling, process improvement, mentoring junior team members
Responsibilities
Perform ETL activities across routine data sources, prepare recurring report inputs, conduct pre-validation and consistency checks, document exceptions and escalate risks, support operational efficiency through knowledge sharing and process improvement discussions