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

Financials

51-250 (167)

Founded 2015

$87M raised

31 open positions

Links

View All Jobs

Senior Analytics Engineer

2 months, 2 weeks ago

North America

Full-time

Senior

Analytics Engineer

Data Science and Analytics

Apache Airflow AWS CI/CD dbt GCP Git PostgreSQL Python SQL Trino

Apply Now

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

Own the transformation layer by designing, building, and maintaining scalable data models using dbt and SQL.
Support business needs ranging from monthly financial reporting to near-real-time operational metrics.
Set and enforce best practices for data modeling, testing, monitoring, and discoverability.
Collaborate with finance, operations, customer success, marketing, data engineers, data scientists, and business users to gather requirements and deliver data products.
Integrate data models with BI tools and reverse ETL systems to enable consistent metric reporting.
Champion robust development practices, including change management, source control, code reviews, and data monitoring.
Identify and implement improvements to data warehouse performance and ETL efficiency.
Work with GCP-based, open-source data infrastructure using dbt and Trino.

Requirements

4+ years of experience in analytics engineering or data engineering with a strong focus on transformation in ELT.
Proven experience owning data products end-to-end and building scalable, high-quality data models.
Comfort working with ambiguity and taking ownership with minimal oversight in a fast-paced environment.
Expert-level SQL and dbt skills for complex queries and data transformations.
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 tools such as Cube or dbt Semantic Layer.
Experience owning CI/CD workflows and establishing standards for version control and code review, including Git.
Familiarity with cloud environments such as GCP or AWS.
Experience with data ingestion tools such as Airbyte and orchestration tools such as Airflow, preferred.
Domain experience in brokerage operations or interest in financial markets and financial data modeling, preferred.

Benefits

Competitive salary with stock options.
Health benefits.
One-time $500 home-office setup stipend for new hires.
$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 Manager - Analytics Engineering

HighLevel 251-1K Internet Software & Services

HighLevel is seeking a Senior Manager of Analytics Engineering to lead the team building the trusted data foundation that powers company-wide decision-making across a global, remote-first SaaS platform.

United States Full-time Lead Analytics Engineer

Apache Airflow CI/CD dbt Git Machine Learning Snowflake SQL

1 day, 16 hours ago

Apply

1 day, 16 hours ago

Analytics Engineer

Kaizen Gaming 1K-5K Hotels, Restaurants & Leisure

Kaizen Gaming is hiring an Analytics Engineer to support its data-driven financial reporting and analytics work within its medallion architecture.

Greece Mid Level Analytics Engineer

Azure Databricks SQL

2 days, 16 hours ago

Apply

2 days, 16 hours ago