Senior Analytics Engineer

1 month, 2 weeks 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 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

Software Engineer II, Data Analytics & Engineering

Pinterest 5K-10K Internet Software & Services

Pinterest is seeking a Software Engineer II, Data Analytics and Engineering to build reliable data foundations, analytics tools, and analysis pipelines that support trusted, self-service insights for product and cross-functional teams.

Python R SQL
1 day, 1 hour ago

Sr. Business Intelligence Engineer

ZipRecruiter 1K-5K Internet Software & Services

ZipRecruiter is seeking a Senior BI Engineer to build scalable data systems, models, and AI-powered tools that support business decision-making and product engineering across billions of daily records.

Apache Spark CI/CD Databricks dbt GCP Git Kubernetes Python Scala Snowflake SQL
2 days ago

Lead Analytics Engineer

ComputerCare 51-250 Technology Hardware, Storage & Peripherals

ComputerCare is hiring a hands-on Lead Analytics Engineer to build and own the company’s analytics function, including data pipelines, models, reporting, governance, and trusted operational insights.

dbt JIRA Looker NetSuite Power BI Snowflake SQL Tableau
4 days ago

Analytics Engineer

FiscalNote 251-1K Diversified Financial Services

FiscalNote is hiring an Analytics Engineer to build scalable data models, reporting infrastructure, and analytics capabilities that support operational efficiency and enterprise decision-making across the company.

CI/CD dbt Git Looker Metabase Pandas Python Snowflake SQL Tableau
5 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