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

Description

  • Own and execute the transformation layer for the data platform.
  • Design, build, and maintain scalable data models using dbt and SQL.
  • Establish and enforce best practices for data modeling, testing, monitoring, and discoverability.
  • Work with finance, operations, customer success, marketing, data science, and business users to define requirements and deliver data products.
  • Create repeatable integrations between data models, BI tools, and reverse ETL systems.
  • Maintain high standards for development, including change management, source control, code reviews, and monitoring.
  • Improve data warehouse performance and ETL efficiency.
  • Support near-real-time operational metrics and monthly financial reporting.
  • Ensure data quality and cent-level precision across reporting and models.

Requirements

  • 4+ years of experience in analytics engineering or data engineering with a focus on transformation in ELT.
  • Proven experience owning data products end-to-end with strong data quality and scalability practices.
  • Comfort working with ambiguity and collaborating with stakeholders to define requirements.
  • Ability to take ownership with minimal oversight in a fast-paced environment.
  • Experience proactively improving data warehouse performance and ETL efficiency.
  • Expert-level SQL and dbt skills.
  • Proficiency in Python for transformations beyond SQL.
  • Hands-on experience with query optimization across OLTP and OLAP systems such as Postgres and Iceberg.
  • Experience with semantic layer modeling such as Cube or dbt Semantic Layer.
  • Experience owning CI/CD workflows and team-wide standards for version control and code review, such as Git.
  • Familiarity with cloud environments such as GCP or AWS.
  • Experience with data ingestion tools such as Airbyte and orchestration tools such as Airflow (nice to have).
  • Domain experience in brokerage operations or interest in financial markets and modeling financial datasets (nice to have).

Benefits

  • Competitive salary and stock options.
  • Health benefits.
  • One-time $500 new hire home-office setup stipend.
  • $150 monthly stipend via Brex card.
  • 100% remote work environment.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Senior Data Analytics Engineer

Coforge 10K-50K IT Services

Coforge is hiring a Senior Data Analytics Engineer in LATAM to lead Power BI modernization work, migrating reporting assets from ThoughtSpot and improving enterprise analytics delivery.

Agile CI/CD dbt Power BI SQL
3 days, 1 hour ago

[Job - 31120] Mid Level Data Developer, Colombia

CI&T 5K-10K Internet Software & Services

CI&T is seeking a Data Developer to support a client in the consumer electronics and audio technology industry by maintaining reliable data models and transformation workflows that power analytics and reporting.

CI/CD dbt Git Snowflake SQL Tableau
3 days, 2 hours ago

Director, Analytics Engineering

Webflow 251-1K Internet Software & Services

Webflow is hiring a Director, Analytics Engineering to lead its data architecture and analytics engineering function, advancing scalable data foundations that support trusted metrics, self-serve analysis, and company-wide decision-making.

dbt Python Snowflake SQL Tableau
6 days, 2 hours ago

Lead / Principal Data Engineer - DBT & Databricks

Coforge 10K-50K IT Services

Coforge is hiring a remote Lead/Principal Data Engineer to build and govern DBT and Databricks data pipelines and curated analytics domains for regulated enterprise environments.

Apache Airflow Apache Spark CI/CD dbt Git Python SQL
1 week, 2 days 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