Senior Analytics Engineer

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.