Officer 3, Accounting 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 within an investor services context.
Role type
Mid-level IC accounting data analyst (ETL & reporting)
Builds
Recurring report inputs, draft report components, and validated data sets for client-specific requirements
Domain
Investment services / Accounting / Data processing
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/unstructured data, data storytelling, process improvement, mentoring junior team members
Responsibilities
Perform ETL activities across routine data sources; prepare recurring report inputs and conduct pre-validation checks; maintain client-specific requirements understanding; document exceptions and escalate risks; support operational efficiency through knowledge sharing and process improvement discussions
