Staff Analytics Engineer
Alpaca
Skill Required
Key highlights
- 4+ years of experience required
- 100% remote
- USD $150 monthly stipend
- USD $500 home-office setup
- Expert-level SQL and DBT skills
- Competitive Salary & Stock Options
Role overview
Alpaca is a US-headquartered, global leader in agent-first brokerage infrastructure for stocks, ETFs, options, crypto, fixed income, 24/5 trading, and more. We are seeking an Analytics Engineer to own and execute the vision for our data transformation layer, working within a 100% remote team to build robust, scalable data models using dbt and Trino on a GCP-based, open-source data infrastructure. You will be at the heart of a data platform processing hundreds of millions of events daily from transactional databases, API logs, CRMs, payment systems, and marketing platforms, collaborating with Data Engineers, Data Scientists, and Business Users to deliver critical data products to stakeholders across finance, operations, and the executive team.
Responsibilities
- 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 modelling, 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.
Requirements
- 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.
- 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 have
- Experience with data ingestion tools (e.g., Airbyte) and orchestration tools (e.g., Airflow).
- Domain experience for brokerage operations or a passion for financial markets and modelling financial datasets.
Benefits
- 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
Additional details
- Alpaca is a licensed financial services company, serving hundreds of financial institutions across 40 countries with our institutional-grade APIs, including broker-dealers, investment advisors, wealth managers, hedge funds, and crypto exchanges, totalling over 10 million brokerage accounts.
- The global team is a diverse group of experienced engineers, traders, and brokerage professionals committed to open-source contributions and fostering a vibrant community.
- Alpaca is 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.
- The team consists of 400+ globally distributed members spanning the USA, Canada, Japan, Hungary, Nigeria, Brazil, the UK, and beyond.
- Core values: Stay Curious, Have Empathy, and Be Accountable.
- Alpaca is proud to be an equal opportunity workplace dedicated to pursuing and hiring a diverse workforce.
- Recruitment Privacy Policy
- Originally posted on Himalayas