xelys jobs xelys jobs

Senior Analytics Engineer

Alpaca

full-remoteseniorpermanentdatabackend Full remote 194 days ago via WTTJ

See how well this job matches your profile

Sign up to get an AI match score and generate a tailored application in seconds.

Get your match score

Tags

dbtSQLData ModelingELTPythonSemantic LayerCI/CDGitQuery OptimizationGCP

About the role

Role Overview

Join Alpaca as a Senior Analytics Engineer on a 100% remote team. You will own and execute the vision for the data transformation layer, building robust, scalable data models and collaborating with cross-functional stakeholders to deliver reliable data products.

Responsibilities

  • Design, build, and maintain scalable data models using dbt and SQL to support diverse business needs.
  • Establish and enforce best practices for:
    • data modeling
    • development
    • testing
    • monitoring to ensure data quality.
  • Work directly with finance, operations, customer success, and marketing to understand requirements and deliver dependable data products.
  • Improve data warehouse performance and ETL efficiency through proactive optimization.
  • Own end-to-end data products, applying analytics/data engineering best practices for quality, scalability, and robustness.
  • Implement CI/CD workflows and standards for version control and code review (e.g., Git).

Requirements

  • Expert-level SQL and dbt skills for complex queries and transformations.
  • Strong proficiency with data transformation work in ELT, with 4+ years in analytics engineering or data engineering.
  • Familiarity with cloud environments (GCP or AWS).
  • Proficiency in Python for transformations beyond SQL.
  • Comfort working in ambiguous environments, taking ownership with minimal oversight.
  • Hands-on experience with query optimization across both OLTP and OLAP systems (e.g., Postgres, Iceberg).
  • Experience with Semantic Layer modeling (e.g., Cube or dbt Semantic Layer).
  • Comfort owning CI/CD and team standards for version control and reviews (e.g., Git).
  • Ability to collaborate with stakeholders to define requirements.

Nice-to-Haves / Additional Experience

  • Domain experience for brokerage operations or a strong interest in financial markets and financial dataset modeling.
  • Experience with data ingestion tools (e.g., Airbyte) and orchestration tools (e.g., Airflow).

About Alpaca

Alpaca is hiring for a 100% remote team focused on building a reliable data transformation and analytics engineering foundation. The role centers on developing scalable data models and data products that support business functions across finance, operations, customer success, and marketing, indicating a data/analytics engineering environment.

Scraped 5/13/2026