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

38 open positions

Links

View All Jobs

Senior Analytics Engineer

1 month, 1 week 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 38

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

Lead Analytics Engineer

Workato 251-1K IT Services

Workato is hiring a data engineering professional to design and maintain scalable data pipelines and analytics infrastructure that support enterprise data ingestion, governance, and reporting.

United States Full-time Junior Analytics Engineer

$124k-$175k

CI/CD dbt NetSuite Python Salesforce Snowflake SQL

17 hours, 57 minutes ago

Apply

17 hours, 57 minutes ago

Wellhub is hiring a Senior AI Analytics Engineer for its Global Analytics team in Brazil to build governed data foundations and AI-ready analytics assets that support reliable self-serve insights across the company.

Brazil Full-time Senior AI Engineer Analytics Engineer

CI/CD GitHub Actions LLM Looker Python SQL

19 hours, 25 minutes ago

Apply

19 hours, 25 minutes ago