About
Alpaca provides agent-first brokerage infrastructure for stocks, ETFs, options, crypto, fixed income, and 24/5 trading. Its licensed financial services subsidiary serves financial institutions in 40 countries through institutional-grade APIs.
Responsibilities
•Design, build, and maintain scalable data models using dbt and SQL to support business needs, from monthly financial reporting to near-real-time operational metrics
•Establish and enforce best practices for data modelling, development, testing, and monitoring to ensure data quality, integrity, and discoverability
•Collaborate with finance, operations, customer success, and marketing teams to understand requirements and deliver reliable data products
•Create repeatable patterns for integrating data models with BI tools and reverse ETL processes to enable consistent metric reporting
•Champion high development standards, including change management, source control, code reviews, and data monitoring as products and data evolve
Requirements
•4+ years of experience in analytics engineering or data engineering, with a strong focus on the transformation layer in ELT
•Proven experience owning data products end-to-end and applying analytics and data engineering best practices to ensure data quality, scalability, and robust data models
•Ability to work with ambiguity, collaborate with stakeholders to define requirements, and take ownership with minimal oversight in a fast-paced environment
•Experience proactively identifying and implementing improvements to data warehouse performance and ETL efficiency
•Expert-level SQL and dbt skills for complex queries and data transformations
•Proficiency in Python for transformations beyond SQL
•Hands-on experience with query optimization across OLTP and OLAP systems, such as Postgres and Iceberg
•Proficiency in semantic layer modelling, such as Cube or dbt Semantic Layer
•Experience owning CI/CD workflows and establishing team-wide standards for version control and code review, such as Git
•Familiarity with cloud environments such as GCP or AWS
Nice to have
•Experience with data ingestion tools such as Airbyte and orchestration tools such as Airflow
•Brokerage operations domain experience or an interest in financial markets and modelling financial datasets
Benefits
•Competitive salary and stock options
•Health benefits
•One-time USD $500 new-hire home-office setup
•USD $150 per month via a Brex Card
