RemoteLeaf Logo
Log in Sign up

Data Analyst

1 month, 1 week ago
Remote
Full-time
Mid Level
Data Analyst
Data Science and Analytics
dbt Metabase NumPy Pandas PostgreSQL Python SQL Trino
Apply Now
Alpaca

Alpaca

Alpaca is a developer-first API for stock and crypto trading, offering easy-to-use APIs for building apps and trading algorithms.

Capital Markets
51-250
Founded 2015
$87M raised
View All Jobs 31

Description

  • Partner with cross-functional teams to turn ambiguous business and operational questions into clear analytical outputs.
  • Build and own analytics data models to support core financial metrics, dashboards, and analytical workflows.
  • Write clean, maintainable SQL across PostgreSQL, Trino, and Apache Iceberg.
  • Build and iterate on metrics and tables using dbt and surface them in Metabase dashboards.
  • Investigate trends, anomalies, P&L calculations, and trading behaviors using SQL and Python in notebooks when needed.
  • Help operationalize data by standardizing core business entities and creating self-serve analytical environments.
  • Assist with reporting capabilities and automate recurring reports.
  • Catalog recurring reports and drive standardization and productization of reporting processes.
  • Work closely with subject matter experts to learn brokerage operations, ledger systems, and compliance context.
  • Communicate insights clearly to both technical and non-technical partners.

Requirements

  • Strong SQL fundamentals, including joins, CTEs, window functions, and clear query structure across diverse database environments.
  • Prior exposure to building analytical data models or metrics tables using dbt or similar analytics engineering workflows.
  • Strong analytical intuition with the ability to ask the right questions and synthesize clear conclusions.
  • Comfort using Python for analysis, including Pandas, NumPy, and Jupyter Notebooks.
  • Ability to communicate effectively with technical and non-technical stakeholders.
  • Strong desire to quickly learn broker-dealer concepts such as clearing infrastructure, execution lifecycles, and financial accounting standards.
  • Experience working in or around brokerage, financial services, or similar complex operational domains is preferred.
  • Familiarity with SQL-based analysis as the primary tool and Python as a secondary tool is preferred.
  • Ability to work collaboratively in a cross-functional environment is preferred.
  • Comfort embedding with subject matter experts and handling complex, domain-specific data is preferred.

Benefits

  • Competitive salary with stock options.
  • Health benefits.
  • One-time USD $500 new hire home-office setup stipend.
  • Monthly USD $150 stipend via Brex card.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

QuestBridge

Data Analyst

QuestBridge 11-50 Diversified Consumer Services

QuestBridge is seeking a Data Analyst to support educational programs by managing program data operations, generating operational insights, and collaborating across teams.

United States Full-time Junior Data Analyst
$95k-$115k
Git Python R SQL Statistics Tableau
15 hours, 51 minutes ago
Horizon Surgical Systems

Research Data Analyst

Horizon Surgical Systems 11-50 Health Care Providers & Services

Horizon Surgical Systems Inc. is hiring a Research Data Analyst to support AI- and imaging-guided surgical robotics research for ophthalmology by managing experimental data and informing engineering and product work.

United States Full-time Junior Data Analyst
Linux Python
16 hours, 21 minutes ago
Perr&Knight

Statistical Analyst

Perr&Knight 51-250 Insurance

Perr&Knight is hiring an insurance operations professional to format, validate, and analyze statistical data feeds for regulatory reporting and client support.

United States Full-time Junior Data Analyst
$66k-$72k
SQL Server
16 hours, 36 minutes ago
Jensen Hughes

Financial Data and Analytics Manager

Jensen Hughes 1K-5K Construction & Engineering

Jensen Hughes is hiring a Data & Analytics Manager to partner with Finance and Operations leadership on finance transformation, operational improvement, and executive decision-making in a professional services environment.

United States Full-time Senior Data Analyst Financial Analyst
$95k-$143k
CRM ERP Machine Learning Power BI Python R SQL
1 day, 15 hours ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers