Skip to content
AlpacaAlpacaUnited States

Data Analyst

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.

Salary not listed
RemoteData Analytics

About the role

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

Skills

SQLPostgresTrinoApache IcebergdbtMetabasePythonpandasNumPyJupyter

Similar roles

Data Analytics jobs
Polymarket

Growth Data Analyst

PolymarketNew York, NY

Growth Data Analyst responsible for building SQL queries, Hex dashboards, React data components, and Python analyses to drive marketing growth, acquisition, and retention decisions at Polymarket.

Salary not listed
On-siteData Analytics
SmithRx

Pharmacy Systems Analyst

SmithRxUnited States

Design, build, and maintain complex pricing models and BI tools in SQL and Looker for pharmacy client savings projections. Translate business needs into technical specs, support data warehouse development, perform deep-dive analyses, and provide Tier 3 technical support. Requires 3-5 years data analytics experience, advanced SQL, and BI tool proficiency.

75k – 106k
Remote3+ YOEData Analytics
SmithRx

PBM Client Delivery Analyst

SmithRxUnited States

The PBM Client Delivery Analyst independently queries large datasets, performs ad hoc and deep-dive analyses on historical claims data, generates insights for risk management and client transitions, and delivers high-quality reporting and presentations to stakeholders. Requires 3-5 years experience, strong analytical and project management skills, and proficiency in SQL, Excel, Looker, and Tableau.

75k – 106k
Remote3+ YOEData Analytics
Stripe

Credit Risk Strategy and Analytics

StripeUnited States

Drive credit risk strategy for Stripe Capital by architecting policies, analyzing data (proprietary + third-party), monitoring portfolios, and collaborating with Product, Data Science, and Engineering teams to underwrite and scale lending products.

Salary not listed
Remote5+ YOEData Analytics
Forterra

Operation Data Analyst

ForterraClarksburg, MD

The Operations Data Analyst translates semi-structured engineering data into structured records in PLM/ERP systems, owns master data integrity, and supports material planning and allocation across programs. Requires 5+ years in data/configuration management or supply chain, advanced Excel, and cross-functional collaboration in a fast-paced technical environment.

Salary not listed
On-site5+ YOEData Analytics