remote
Stock Data Analyst - individual investor
Data Analyst
Dedicated Stock Data Analyst to perform in‑depth market research, data extraction, and daily reporting for a personal investment portfolio using Python, SQL, Excel, and advanced visualization tools.
About the role
Key Responsibilities
- Collect, clean, and analyze historical market data using Python and SQL to identify trends and investment opportunities.
- Develop and maintain dynamic dashboards in Excel and visualization tools to present findings to the investor.
- Prepare concise daily end‑of‑day reports summarizing market movements, portfolio performance, and actionable insights.
- Collaborate closely with the investor to refine research focus and adjust analytical models based on portfolio strategy.
- Ensure data integrity and accuracy through rigorous validation and documentation practices.
Requirements
- Proficiency in Python (pandas, NumPy) and SQL for data manipulation and querying.
- Advanced Excel skills, including VBA and complex formulas.
- Experience with data visualization libraries (Matplotlib, Seaborn, or Power BI).
- Strong understanding of financial markets, securities, and portfolio management concepts.
- Excellent communication skills and ability to translate technical findings into clear, actionable reports.