Data Analyst
Core
Build foundational data models, dashboards, and deep-dive analyses to make Alpaca data-driven, partnering with Finance, Operations, and Compliance to understand why things happen.
Role type
Data Analyst (Brokerage Infrastructure)
Builds
Core financial metrics, dashboards, and analytical workflows for brokerage operations and compliance teams.
Domain
Financial Services / Brokerage Infrastructure
Deliverable
dashboards & analysis
Required skills
SQL (joins, CTEs, window functions), dbt, Python (Pandas, NumPy), Jupyter Notebooks, data modeling, metric definition
Preferred skills
Analytics engineering experience, domain knowledge of broker-dealer environments, clearing infrastructure, execution lifecycles, financial accounting standards
Technologies
PostgreSQL, Trino, Apache Iceberg, dbt, Metabase, Python, Jupyter
Responsibilities
Translate ambiguous business questions into clear analytical outputs; write clean SQL to power core financial metrics; build and iterate metrics and tables; investigate trends and anomalies in P&L and trading behaviors; identify opportunities to standardize business entities; streamline report automation and catalog recurring reports
Seniority
Individual Contributor