Senior Analytics Engineer

2 weeks, 3 days ago
Full-time
Senior
Data Science and Analytics
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 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 Data Analytics Engineer

Your Business Internet Software & Services

NRI North America is hiring a Senior Data Analytics Engineer for its Remote Delivery Data Analytics Data Platform team to develop and deliver business intelligence solutions for clients using the Microsoft Analytics stack.

Agile Azure CI/CD Python SQL
1 day, 5 hours ago

Senior Analytics Engineer

NIVA Health 11-50 Health Care Providers & Services

NIVA Health is hiring an Analytics Engineer to turn messy operational data into trusted reporting and dashboards that help leadership make better business decisions.

dbt GCP JavaScript Python SQL
2 days, 7 hours ago

Grid Integration Engineer - Battery Storage

Plus Power 51-250 Electric Utilities

Plus Power is seeking an early-career Grid Integration Engineer to support large load and data center interconnection studies within its energy storage development business.

Python
2 days, 13 hours ago

Analyst II, Full Stack

Affirm 1K-5K Diversified Financial Services

Affirm is hiring an Operations Analytics professional to own forecasting and planning for customer operations across multiple geographies, with the goal of improving servicing strategy, capacity decisions, and operational performance.

Databricks GCP Machine Learning Python R Snowflake SQL
4 days, 2 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