# Data Analyst

**Company:** [Alpaca](https://hotfix.jobs/companies/alpaca)
**Location:** Remote
**Role:** Data Analytics
**Skills:** SQL, Postgres, Trino, Apache Iceberg, dbt, Metabase, Python, pandas, NumPy, Jupyter
**Posted:** 2026-06-12

> Partner with cross-functional teams to translate business questions into analytical outputs. Build and maintain data models in SQL and dbt, create dashboards in Metabase, and use Python for deeper analysis.

## Job Description

## 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. 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 and productization of data reports.

## What We're Looking For

- 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.
- Deep Analytical Intuition. Able to ask the right questions, explore data thoughtfully, and synthesize clear, well-reasoned conclusions without getting lost in rabbit holes.
- 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.
- Clear Communicator & Collaborator. Can share insights effectively with technical and non-technical partners, acting as a bridge between data infrastructure and business operations.
- Domain Agility. A strong desire to quickly learn the intricacies of a broker-dealer environment, including clearing infrastructure, execution lifecycles, and financial accounting standards.

## How We Take Care of You

- 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

## Similar roles

- [Growth Data Analyst](https://hotfix.jobs/jobs/c1f18ba3-2c96-48b4-8670-303037e5962a) - Polymarket - New York, NY
- [Pharmacy Systems Analyst](https://hotfix.jobs/jobs/8039ae85-a206-4e11-9ac5-257c55d78c23) - SmithRx - Remote - $75k – $106k/yr
- [PBM Client Delivery Analyst](https://hotfix.jobs/jobs/d224f433-cd95-41c4-92f6-522bab2f6ffe) - SmithRx - Remote - $75k – $106k/yr
- [Credit Risk Strategy and Analytics](https://hotfix.jobs/jobs/2f79e0a3-73e9-4f3f-a5b8-800c64512f92) - Stripe - Remote
- [Operation Data Analyst](https://hotfix.jobs/jobs/149dab45-9818-4eba-88fd-085867599f9d) - Forterra - Clarksburg, MD

**Apply:** https://hotfix.jobs/jobs/9e831d3b-6eee-4c47-8abb-731be31c6ba4
**Canonical:** https://hotfix.jobs/jobs/9e831d3b-6eee-4c47-8abb-731be31c6ba4