Senior Analytics Engineer

About Alpaca

API-first stock and crypto brokerage platform

Tech

**TECH STACK** Go, Google Cloud, Kubernetes, React, PostgreSQL, RabbitMQ, Redis **ENGINEERING TEAM AND PROCESSES** Our engineering team process is somewhere between scrum and kanban. We do daily standup every morning and manage project progress with JIRA. All the code reviews are done in GitHub and release process is seamlessly built around Google Cloud Build, Google Container Registry, GKE, etc. Everyone is encouraged to review others code and have transparent access to any information to improve products from any aspect. **TECHNICAL CHALLENGES** We have built MarketStore (https://github.com/alpacahq/marketstore) in Go from scratch that is time-series database designed for financial data and made it open source. The challenge in our trading system is that you need to deal with real-time market environment to minimize latency while you need to make sure things work correctly as money management system. The requirements and system architecture are totally different and unique which is very exciting to tackle.

The role

### **Who We Are:** Alpaca is a fast-growing series B fintech company that’s raised over $120 million in funding.\ Alpaca is an API-first stock and crypto platform that enables developers and businesses across the world to build trading algorithms, applications, and brokerage services.\ Our globally distributed team consists of developers, traders, and brokerage specialists, and is backed by a group of prominent investors and highly experienced industry angel investors, including Portage Ventures, Spark Capital, Tribe Capital, Social Leverage, Horizons Ventures, Unbound, SBI Group, Eldridge, Positive Sum, Elefund, and Y Combinator. And, of course, we are very enthusiastic about open source contributions as well as community building. ### **The Alpaca Team:** We have 150+ globally distributed (remote) team members who love to work from their favorite places in the world. We have team members based in the USA, Canada, Hungary, Japan, Brazil, Spain, Philippines, Nigeria, UK, and more! We love candidates who have a passion for making a global difference in financial services and technology, by impacting local communities and becoming a part of our hyper-growth company. **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). If you're passionate about analytics engineering and thrive in a dynamic startup environment, we'd love to hear from you! **How We Take Care of You:** * Competitive Salary & Stock Options * Benefits: Health benefits start on day 1. In the US this includes Medical, Dental, Vision. In Canada, this includes supplemental health care.  Internationally, this includes a stipend value to offset medical costs.    * New Hire Home-Office Setup: One-time USD $500 * Monthly Stipend: USD $150 per month via a Brex Card * Work with awesome hard working people, super smart and cool clients and innovative partners from around the world _Alpaca is proud to be an equal opportunity workplace dedicated to pursuing and hiring a diverse workforce._

Skills

• Git
• SQL
• Data Warehousing