Senior Analytics Engineer
AlpacaAPI Brokerage company
RemoteSenior
Drive Capital
Spark Capital
Tribe Capital
Horizons Ventures
Portage Ventures
Social Leverage
Data & AI
About the role
TL;DR
Own and execute the vision for Alpaca's data transformation layer using dbt and Trino.
- •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.
- •Key Responsibilities Own the Transformation Layer: Design, build, and maintain scalable data models using dbt and SQL.
- •Set Technical Standards: Establish and enforce best practices for data modeling, development, testing, and monitoring.
- •Enable Stakeholders: Collaborate directly with finance, operations, customer success, and marketing teams.
- •Integrate and Deliver: Create repeatable patterns for integrating our data models with BI tools and reverse ETL processes.
- •Ensure Quality: Champion high standards for development, including robust change management, source control, code reviews, and data monitoring.
- •Requirements 4+ years of experience in analytics engineering or data engineering with a strong focus on transformation.
- •Proven track record of owning data products end-to-end.
- •Comfortable working with ambiguity and collaborating with stakeholders.
- •Experience proactively identifying and implementing improvements to data warehouse performance and ETL efficiency.
- •Expert-level SQL and DBT skills; Proficiency in Python; Hands-on experience with query optimization; Proficiency with Semantic Layer modelling; 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).
Required skills
SQLdbtPythonGitGoogle CloudPostgreSQL
Nice-to-have skills
Airflow
Domain expertise
fintechcrypto
Benefits & perks
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
Tech stack
dbtGoogle CloudSQLPythonPostgreSQLGit