data
Posted 2 days agoData Analyst
at Alpaca
Americas, United StatesRemote
Responsibilities
- 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.
- 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.
- Identify structural opportunities for standardizing core business entities, proactively transitioning ad-hoc analytical requests into intuitive, user-friendly self-serve environments.
Requirements
- We're deeply committed to open-source contributions and fostering a vibrant community, continuously enhancing our award-winning, developer-friendly API and the robust infrastructure behind it.
- 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.
- Strong SQL fundamentals. Comfortable with joins, CTEs, window functions, and clear query structure across diverse database environments.
- Analytics Engineering Familiarity. Prior exposure to building analytical data models or metrics tables using dbt or similar analytics-engineering workflows.
- Python & Notebook Proficiency.
- Comfortable using SQL as the primary analysis tool, with the ability to use Python (Pandas, NumPy) and Jupyter Notebooks for deeper, more efficient programmatic analysis.
Benefits
- Our recent Series D funding round brought our total investment to over $320 million, fueling our ambitious vision.
- Competitive Salary & Stock Options Health Benefits
- New Hire Home-Office Setup: One-time USD $500
- Monthly Stipend: USD $150 per month via a Brex Card