Data Analyst

Your Role

We're looking for a Data Analyst to help make Alpaca data-driven from the ground up. You will join a highly collaborative team, partnering closely with cross-functional departments (Finance, Operations, Compliance) to build foundational data models, dashboards, and deep-dive analyses that our teams rely on every day.

This role is ideal for someone who wants to take on meaningful ownership, embed deeply with subject matter experts to quickly assimilate complex brokerage knowledge, and dig deeply into data to understand why things are happening, not just what is happening.

What You'll Do

• Translate questions into insight. Partner and embed with cross-functional teams to turn ambiguous business and operational questions into clear, useful analytical outputs. You will quickly assimilate subject matter expertise across brokerage operations, ledger systems, and compliance.
• Build and own analytics data models. Write clean, maintainable SQL against PostgreSQL, Trino, and Apache Iceberg to power core financial metrics, dashboards, and analytical workflows.
• Build and iterate on metrics and tables using dbt, surfacing them through dashboards in Metabase to help teams understand transaction volumes, revenue streams, and system performance over time.
• Explore data deeply to answer open-ended questions. Use SQL as your primary tool, with Python in a notebook environment like Jupyter when helpful, to investigate trends, anomalies, complex profit and loss (P&L) calculations, and trading behaviors, connecting analyses back to real business questions.
• Help operationalize data. Identify structural opportunities for standardizing core business entities, proactively transitioning ad-hoc analytical requests into intuitive, user-friendly self-serve environments.
• Assist with reporting capabilities and streamline report automation, including servicing requests in a timely manner, cataloguing recurring reports, and driving conversations around standardization.