Senior Analytics Engineer

Summary

Join Alpaca, a leading brokerage infrastructure technology company, as a Senior Analytics Engineer. Lead the transformation layer of our data platform, integrating data from various sources and processing hundreds of millions of events daily. You will develop scalable patterns, ensure data discoverability, and seamlessly integrate our Lakehouse with BI tools. Collaborate with cross-functional teams to meet data modeling needs and set a high standard for development practices. We offer a 100% remote work environment and competitive compensation and benefits.

Requirements

• 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)

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

Benefits

• Competitive Salary & Stock Options
• Health benefits start on day 1. In the US this includes Medical, Dental, Vision. In Canada, this includes supplemental health care. In Japan, you are offered local benefits. 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