Remote Analytics Engineer: Transformation Lead

Alpaca; United States; Remote; USD 120,000 - 180,000; Full time

Job summary

Alpaca is seeking an Analytics Engineer to own and execute the vision for our data transformation layer. You will work on a GCP-based data platform handling hundreds of millions of events daily, collaborating with data engineers, data scientists, and business users to deliver robust data models.

You will use dbt and Trino to build scalable models, enabling reliable metrics across finance, operations, and executive teams via BI tools and reverse ETL.

Qualifications

• 4+ years in analytics engineering or data engineering with ELT focus.
• Proven data products ownership end-to-end with quality and scalability.
• Ability to define requirements with stakeholders and work autonomously.

Responsibilities

• Own the Transformation Layer: design, build, and maintain scalable data models with dbt and SQL.
• Set standards for data modeling, development, testing, and monitoring.
• Collaborate with finance, operations, marketing, and customer success to deliver data products.
• Create repeatable patterns for BI integrations and reverse ETL processes.
• Ensure data quality with robust change management and code reviews.

Skills

Advanced SQL

dbt

Python

Query optimization

CI/CD

Cloud platforms

Tools

Airbyte

Airflow

dbt Semantic Layer

Postgres

Iceberg

Job description

Alpaca is seeking an Analytics Engineer to own and execute the vision for our data transformation layer. You will work on a GCP-based data platform handling hundreds of millions of events daily, collaborating with data engineers, data scientists, and business users to deliver robust data models.

You will use dbt and Trino to build scalable models, enabling reliable metrics across finance, operations, and executive teams via BI tools and reverse ETL.