Officer 3, Data Analyst
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.
Role type
Senior IC data analyst (ETL & reporting)
Builds
Recurring report inputs, draft report components, and validated data sets for client-specific requirements
Domain
Investment services / Private equity administration
Deliverable
production ML models | product features | dashboards & analysis
Required skills
ETL processes, data extraction, data transformation, MS SQL, Data Warehouse concepts, Tableau, Power BI, Macro/VBA, advanced Microsoft Excel, data visualization, data storytelling
Preferred skills
troubleshooting technical issues, handling complex or unstructured data, process improvement, mentoring junior team members
Technologies
MS SQL, Tableau, Power BI, Macro, VBA, Microsoft Excel
Responsibilities
Perform ETL activities across routine data sources, prepare recurring report inputs, conduct pre-validation and consistency checks, document exceptions and escalate risks, maintain reference files and follow control procedures, support operational efficiency through knowledge sharing and process improvement discussions
Seniority
Senior, hands-on IC
