Analytics Engineer (Crypto)

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.

• 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

• 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
• Будет плюсом: 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

• Competitive salary and stock options
• Health benefits
• One-time USD $500 new-hire home-office setup
• USD $150 per month via a Brex Card