Senior Analytics Engineer

11 hours, 33 minutes 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 Analytics Engineering Manager

Monzo 1K-5K Banks

Monzo is hiring an Analytics Engineering Manager in Barcelona to lead the Borrowing data warehouse work that supports better lending decisions and scalable data governance.

Agile dbt GCP Looker
11 hours, 28 minutes ago

Analytics Engineer, Sentry

Anduril Industries 1K-5K Aerospace & Defense

Anduril Industries is hiring an Analytics Engineer for its Sentry platform to turn operational data into decision-making tools that improve fleet performance, deployment visibility, and business operations.

Datadog ERP Grafana Looker Power BI Python React SQL Tableau
15 hours, 2 minutes ago

Analytics Engineer

realtor.com 1K-5K Internet Software & Services

Realtor.com is hiring an Analytics Engineer to own the data layer for a new HR Performance and Goal Management product supporting about 1,500 employees across review cycles.

Agile Apache Airflow dbt Git Looker Python SFTP Snowflake SQL Tableau
15 hours, 44 minutes ago

Senior Analytics Engineer (Python, SQL, Asset Management)

Toucanberry Tech Internet Software & Services

A financial services consultancy is hiring a hands-on data analyst consultant to work on reinsurance and investment-related data challenges for senior stakeholders and client teams.

Agile Azure dbt GCP NumPy Pandas Python SQL
16 hours, 17 minutes 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