高级分析工程师
Senior Analytics Engineer
我们是谁：
Alpaca 是一家总部位于美国的全球领先代理优先经纪基础设施公司，提供股票、ETF、期权、加密货币、固定收益、24/7交易等服务。
在我们的子公司中，Alpaca 是一家获得许可的金融服务公司，通过我们机构级 API 为全球 40 个国家的数百家金融机构提供服务。这包括经纪自营商、投资顾问、财富管理公司、对冲基金和加密货币交易所，总计超过 1000 万笔经纪账户。
我们的全球团队是由经验丰富的工程师、交易员和经纪专业人士组成的多元化团队，致力于实现我们让全球每个人都能享受金融服务的使命。我们高度重视开源贡献并积极培育充满活力的社区，持续提升我们获奖的、开发者友好的 API 及其背后的强大基础设施。
Alpaca 获得了来自顶级全球投资者的 4 亿美元资金支持，包括 Portage Ventures、Spark Capital、Tribe Capital、Social Leverage、Horizons Ventures、Opera Tech Ventures、SBI Group、Derayah Financial、Unbound、Peak XV、Elefund 和 Y Combinator。
我们的团队成员：
我们是一个由 400 多名分布在世界各地的成员组成的充满活力的团队，大家在自己喜欢的地方工作，团队成员遍布美国、加拿大、日本、匈牙利、尼日利亚、巴西、英国等国家！
我们正在寻找渴望为 Alpaca 的快速发展做出贡献的热情人士。如果你认同我们的核心价值观——保持好奇、富有同理心、承担责任，并准备好产生重大影响，我们鼓励你申请。
关于职位：
我们正在寻找一名数据分析工程师，负责并执行我们数据转换层的愿景。你将处于我们数据平台的核心，每天处理来自各种来源（包括事务型数据库、API 日志、CRM、支付系统和营销平台）的数亿条事件。
你将加入我们 100% 远程的团队，与数据工程师（负责数据摄入）以及数据科学家和业务用户（使用你的数据模型）密切合作。你的主要职责是使用 dbt 和 Trino 在基于 GCP 的开源数据基础设施上构建稳健、可扩展的数据模型。这些模型对公司各个部门的利益相关者（从财务和运营到高管团队）至关重要，并通过 BI 工具、报告和反向 ETL 系统进行交付。
你将负责：
- 主导 Trino 的使用
查看英文原文
Who We Are:
Alpaca is a US-headquartered, global leader in agent-first brokerage infrastructure for stocks, ETFs, options, crypto, fixed income, 24/5 trading, and more.
Amongst our subsidiaries, Alpaca is a licensed financial services company, serving hundreds of financial institutions across 40 countries with our institutional-grade APIs. This includes broker-dealers, investment advisors, wealth managers, hedge funds, and crypto exchanges, totalling over 10 million brokerage accounts.
Our global team is a diverse group of experienced engineers, traders, and brokerage professionals who are working to achieve our mission of opening financial services to everyone on the planet. We're deeply committed to open-source contributions and fostering a vibrant community, continuously enhancing our award-winning, developer-friendly API and the robust infrastructure behind it.
Alpaca is proudly backed by $400 million in funding from top-tier global investors including Portage Ventures, Spark Capital, Tribe Capital, Social Leverage, Horizons Ventures, Opera Tech Ventures, SBI Group, Derayah Financial, Unbound, Peak XV, Elefund, and Y Combinator.
Our Team Members:
We're a dynamic team of 400+ globally distributed members who thrive working from our favorite places around the world, with teammates spanning the USA, Canada, Japan, Hungary, Nigeria, Brazil, the UK, and beyond!
We're searching for passionate individuals eager to contribute to Alpaca's rapid growth. If you align with our core values—Stay Curious, Have Empathy, and Be Accountable—and are ready to make a significant impact, we encourage you to apply.
About the Role:
We are seeking an Analytics Engineer to own and execute the vision for our data transformation layer. You will be at the heart of our data platform, which processes hundreds of millions of events daily from a wide array of sources, including transactional databases, API logs, CRMs, payment systems, and marketing platforms.
You will join our 100% remote team and work closely with Data Engineers (who manage data ingestion) and Data Scientists and Business Users (who consume your data models). Your primary responsibility will be to use dbt and Trino on our GCP-based, open-source data infrastructure to build robust, scalable data models. These models are critical for stakeholders across the company—from finance and operations to the executive team—and are delivered via BI tools, reports, and reverse ETL systems.
What You'll Do:
- Own the Transformation Layer: Design, build, and maintain scalable data models using dbt and SQL to support diverse business needs, from monthly financial reporting to near-real-time operational metrics.
- Set Technical Standards: Establish and enforce best practices for data modeling, development, testing, and monitoring to ensure data quality, integrity (up to cent-level precision), and discoverability.
- Enable Stakeholders: Collaborate directly with finance, operations, customer success, and marketing teams to understand their requirements and deliver reliable data products.
- Integrate and Deliver: Create repeatable patterns for integrating our data models with BI tools and reverse ETL processes, enabling consistent metric reporting across the business.
- Ensure Quality: Champion high standards for development, including robust change management, source control, code reviews, and data monitoring as our products and data evolve.
What You Need (Must-Haves):
- 4+ years of experience in analytics engineering or data engineering with a strong focus on the "T" (transformation) in ELT.
- Proven track record of owning data products end-to-end, applying analytics and data engineering best practices to ensure data quality, scalability, and robust data models.
- Comfortable working with ambiguity and collaborating with stakeholders to define requirements; able to take ownership with minimal oversight in a fast-paced environment.
- Experience proactively identifying and implementing improvements to data warehouse performance and ETL efficiency.
- Technical Versatility:
- Expert-level SQL and DBT skills for complex queries and data transformations.
- Proficiency in Python for transformations that extend beyond SQL.
- Hands-on experience with query optimization across OLTP and OLAP systems (e.g., Postgres, Iceberg).
- Proficiency with Semantic Layer modelling (e.g. Cube, dbt Semantic Layer).
- Experience owning CI/CD workflows and establishing team-wide standards for version control and code review (e.g., Git).
- Familiarity with cloud environments (GCP or AWS).
Nice to Haves:
- Experience with data ingestion tools (e.g., Airbyte) and orchestration tools (e.g., Airflow).
- Domain experience for brokerage operations or passion for financial markets and modeling financial datasets.
How We Take Care of You:
- Competitive Salary & Stock Options
- Health Benefits
- New Hire Home-Office Setup: One-time USD $500
- Monthly Stipend: USD $150 per month via a Brex Card
Alpaca is proud to be an equal opportunity workplace dedicated to pursuing and hiring a diverse workforce.
Recruitment Privacy Policy