Senior Analytics Engineer

Who We Are: Alpaca is a US California headquartered brokerage infrastructure technology company and self-clearing broker-dealer, delivering execution and custody solutions for Stocks, ETFs, Options, Cryptocurrencies, and more, and has raised over $170 million in funding. Amongst our subsidiaries, Alpaca is a licensed financial services company in multiple countries, and we serve hundreds of financial institutions globally such as broker-dealers, investment advisors, hedge funds, and crypto exchanges. Alpaca’s globally distributed team members bring in diverse experiences such as engineers, traders, and brokerage professionals to achieve our Mission of opening financial services to everyone on the planet. We are also deeply committed to open-source contributions and fostering a vibrant community. We will continue to enhance and improve our award-winning developer-friendly API and the infrastructure behind it. Our Team Members: We’re a team of 150+ globally distributed members who love working from our favorite places worldwide. Our team spans the USA, Canada, Japan, Hungary, Nigeria, Brazil, the United Kingdom, and more! We’re looking for candidates eager to join Alpaca’s growing organization, who are excited about our Mission of “Open financial services to everyone on the planet and share our Values of “Stay Curious,” “Have Empathy,” and “Be Accountable.”   Your Role:We are looking for a Senior Analytics Engineer to lead the vision for the transformation layer of our data platform. This platform integrates data from transactional databases backing core Alpaca applications, API logs, CRMs, payment systems, and marketing platforms. We process hundreds of millions of events daily, a number that is rapidly growing as we onboard new customers. We prioritize open-source solutions and use Google Cloud Platform (GCP) as the foundation of our data infrastructure. Our transformation layer, powered by dbt running through the Trino query engine, builds data models that are delivered to end users via BI tools, reports, and reverse ETL. Our stakeholders range from finance to operations, customer success, and the executive team, necessitating varying data availability (from monthly to near-real-time) and integrity (up to cent-level precision). You will be working alongside our Data Engineers who drive the ingress of the data and the infrastructure of the Lakehouse and related services, and Data Scientists who consume the data models and augment them with new features. Our team is 100% distributed and remote. Responsibilities: Develop scalable patterns in the transformation layer to support consistent BI tools integration across business verticals. Ensure data discoverability and maintain high standards of change management, including model testing and data monitoring, as Alpaca’s products evolve. Seamlessly integrate the Lakehouse with BI tooling to create repeatable ways of surfacing metrics to end users. Set a high standard for development practices, ensuring quality in new data models and their orchestration. Collaborate closely with finance, operations, customer success, and marketing teams to meet data modeling needs. Must-Haves: 3+ years of experience in data engineering or data analytics, focusing on the transformation component of the ELT process. Experience building scalable transformation layers, preferably through formalized SQL models (e.g., dbt). Experience in Python for transformations beyond SQL. Experience with CI/CD and code version control. Strong hands-on experience with relational databases (e.g., Postgres, Iceberg), including query optimization. Ability to adapt quickly in a fast-paced environment and tailor solutions to evolving business needs. Experience with ETL technologies for ingestion (e.g., Airbyte) and orchestration (e.g., Airflow). Experience working in a cloud environment (AWS or GCP). How We Take Care of You: Competitive Salary & Stock Options Benefits: Health benefits start on day 1. In the US th...