20 tasks, each one witnessed by the sources that watched the job — and behind every one, a prompt you can use tonight.
You’ll spend mornings checking market and portfolio metrics, usually in Microsoft Excel or Power BI dashboards, and reading overnight market news. Traders or researchers will ask for quick updates, so expect to pull data, run models, and send results by mid-morning via Outlook.
Afternoons often mean building or refining financial models (Excel, C#, or Azure-hosted tools), running stress tests or scenario analysis, and meeting with portfolio managers to explain findings and recommend trades or risk limits.
You’ll use Microsoft Excel every day for models and quick analyses, and Power BI to build dashboards for traders and operations. Large shops run models or data pipelines on Microsoft Azure and host code in C# or Linux-based environments.
Statistical work may use IBM SPSS Statistics or Python/R (if available). Outlook is used for communication and documentation. Be ready to move between desktop Excel and cloud tools.
Use AI to speed repetitive tasks—feature engineering, model backtests, or draft code—but always validate outputs with your own tests and holdout samples. Put models into a versioned environment (Azure, Git) and require peer review before using results in trading decisions.
Never let AI replace documented model specifications, stress tests, or the human check on inputs. Keep logs of data sources and ask for approval from risk managers before deploying automated decisions.
The U.S. Bureau of Labor Statistics lists 132,130 portfolio analysts and similar roles (BLS 2025). Median pay is $81,100 per year; the lowest tenth is $48,460 and the top tenth is $151,490, according to BLS.
Actual pay varies by city, firm, and your skills (Excel, Azure, C#). Quant shops and big banks near major financial centers tend to pay toward the top tenth.
Learn Excel well: pivot tables, VBA or formulas, and basic financial functions. Add Power BI for dashboards and a coding language—C# if the firm uses it, or Python/R for statistics and modeling. Get familiar with Azure basics for cloud data.
Study financial statements, valuation basics, and how to run a simple stress test. Small projects—build an Excel model, a Power BI dashboard, and a backtest of a simple strategy—are better than only coursework.
A portfolio analyst focuses on measuring and explaining portfolio performance, building models and dashboards, and recommending actions; they support traders and researchers. A trader executes trades and manages positions in real time.
A risk analyst focuses mainly on firm-wide risk metrics and capital requirements, does stress tests and regulatory reporting. Portfolio analysts bridge performance, trading signals, and reporting, often using the same systems (Excel, Power BI, Azure).
Clear, concise communication—especially writing—matters more than you think. Traders want one-page answers: the metric, the change, and the recommended action. Use Outlook and Power BI to present that information quickly.
You can build great models, but if you cannot explain assumptions, model specs, or scenario results to nontechnical stakeholders, your analysis won’t be used. Practice short summaries and annotated spreadsheets.