2 months ago
Remote, EMEAStaff+
Responsibilities
- Own and maintain scalable transformation-layer data models using dbt and SQL for financial reporting and operational metrics.
- Establish standards for data modeling, development, testing, monitoring, change management, source control, and code review.
- Collaborate with finance, operations, customer success, marketing, Data Engineering, Data Science, and business stakeholders to define requirements and deliver data products.
- Integrate data models with BI tools and reverse ETL processes to enable consistent metric reporting.
- Improve data warehouse performance, ETL efficiency, data quality, integrity, scalability, and discoverability.
Requirements
- Require 4+ years of experience in analytics engineering or data engineering with a strong focus on transformation in ELT.
- Demonstrated ownership of data products end to end and application of analytics and data engineering best practices.
- Expert-level SQL and dbt skills for complex queries and data transformations.
- Proficiency in Python and experience optimizing queries across OLTP and OLAP systems such as Postgres and Iceberg.
- Experience with semantic-layer modeling, such as Cube or the dbt Semantic Layer.
- Experience owning CI/CD workflows and establishing standards for version control and code review, such as Git.
- Familiarity with cloud environments including GCP or AWS.
- Preferred experience with Airbyte, Airflow, brokerage operations, financial markets, or financial data modeling.
- Ability to work with ambiguity, collaborate with stakeholders, and take ownership with minimal oversight.
Benefits
- 100% remote work arrangement.
- Competitive salary and stock options.
- Health benefits.
- One-time new-hire home-office setup support.
- Monthly stipend provided through a Brex Card.
Tech Stack
Categories
Data Engineering
About Alpaca
Alpaca builds brokerage infrastructure APIs and operates a self-clearing broker-dealer, enabling fintechs, institutions, and developers to embed trading in stocks, ETFs, options, crypto, and fixed income. Its platform includes account opening, clearing, custody, and compliance tooling, with revenue from brokerage and platform fees. Founded in 2017 and headquartered in San Mateo, California, Alpaca serves clients in 40+ countries through its subsidiaries.