Senior Analytics Engineer

Alpaca
North America
Workplace: RemoteFull timeFunction: Data Analytics & Business IntelligenceExperience: 4+ yearsSkills: ["Accountability","Collaboration","Ownership"]

Own the data transformation layer that powers Alpaca’s data platform, processing hundreds of millions of events daily. Build scalable, high-quality data models using dbt and SQL with Trino on GCP-based infrastructure, ensuring accuracy and precision for stakeholders. Partner with Data Engineers, Data Scientists, and business users to translate requirements into reliable data products delivered through BI tools, reports, and reverse ETL, while setting standards for development, testing, monitoring, and change management.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
Alpaca
Alpaca
3 days ago

Senior Analytics Engineer

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI
Last checked: 21 hours agoStatus: Live

Job Summary

Own the data transformation layer that powers Alpaca’s data platform, processing hundreds of millions of events daily. Build scalable, high-quality data models using dbt and SQL with Trino on GCP-based infrastructure, ensuring accuracy and precision for stakeholders. Partner with Data Engineers, Data Scientists, and business users to translate requirements into reliable data products delivered through BI tools, reports, and reverse ETL, while setting standards for development, testing, monitoring, and change management.
Location: North America
Workplace: Remote
Employment Type: Full time
Job Function: Data Analytics & Business Intelligence
Seniority: Mid level

Key Responsibilities

  • •Design, build, and maintain scalable data models using dbt and SQL to support business reporting and near-real-time metrics.
  • •Establish and enforce best practices for data modeling, development, testing, and monitoring to ensure data quality and integrity.
  • •Collaborate with finance, operations, customer success, and marketing to understand requirements and deliver reliable data products.
  • •Create repeatable integration patterns connecting data models to BI tools and reverse ETL for consistent metric reporting.
  • •Maintain high development quality through change management, source control, code reviews, and ongoing data monitoring.

Pay and Benefits

Perks:Health InsuranceEquityHome Office

Key Requirements

  • •4+ years in analytics engineering or data engineering, focused on the transformation (“T”) in ELT.
  • •Own data products end-to-end, applying analytics/data engineering best practices for quality, scalability, and robust models.
  • •Comfortably work with ambiguity and collaborate with stakeholders to define requirements with minimal oversight.
  • •Identify and implement improvements to data warehouse performance and ETL efficiency.
  • •Expert SQL and dbt skills; proficiency in Python for transformations; experience with query optimization and semantic layer modeling; CI/CD and version control (e.g., Git); familiarity with cloud (GCP or AWS).
Experience:4+ years
Skills:AccountabilityCollaborationOwnership
Languages:English
Tech Stack:DbtSQLTrinoGCPPythonELTPostgresIcebergSemantic LayerCubeDbt Semantic LayerCI/CDGitOLTPOLAPAirbyteAirflowAWSReverse ETL

Company Brief

Alpaca
Provides developer-first APIs and brokerage infrastructure for algorithmic and automated stock trading, enabling fintechs and developers to build trading applications with commission-free market access and custody services.
Industry: Fintech Infrastructure
Company Size: Medium (51 to 250 employees)
Growth: Scaleup
Funding: Series C
Headquarters: San Mateo, United States
Founded: 2015
WebsiteLinkedIn