Alpaca Logo

Alpaca

Senior Analytics Engineer

Reposted 25 Days Ago
Remote
Hiring Remotely in USA
Senior level
Remote
Hiring Remotely in USA
Senior level
The Analytics Engineer will design, build, and maintain scalable data models, collaborating with various teams to ensure data quality and robust reporting, mainly using dbt and SQL.
The summary above was generated by AI

Who We Are:

Alpaca is a US-headquartered self-clearing broker-dealer and brokerage infrastructure for stocks, ETFs, options, crypto, fixed income, 24/5 trading, and more. Our recent Series D funding round brought our total investment to over $320 million, fueling our ambitious vision.

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 9 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 top-tier global investors, including Portage Ventures, Spark Capital, Tribe Capital, Social Leverage, Horizons Ventures, Unbound, SBI Group, Derayah Financial, Elefund, and Y Combinator.


Our Team Members:

We're a dynamic team of 380+ 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 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.

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 a passion for financial markets and modelling 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

Similar Jobs

Yesterday
Remote
United States
164K-193K Annually
Senior level
164K-193K Annually
Senior level
Healthtech • Social Impact • Software • Telehealth
Design, build, and optimize modular dbt pipelines and data models; translate ambiguous product requirements into production-grade data assets; diagnose query performance and lower warehouse compute costs (including migration to Snowflake); enforce code hygiene, data security, testing, and peer review; mentor junior engineers and adopt AI-assisted development tools to speed test generation and legacy discovery.
Top Skills: BigQueryDbtGitRedshiftSnowflakeSQL
10 Days Ago
Remote
United States
140K-175K Annually
Senior level
140K-175K Annually
Senior level
Agency • Consumer Web • eCommerce • Social Media
Owner of the analytics foundation: design and maintain BigQuery/dbt models, pipelines, and Looker Studio reporting; build AI workflows and web apps on GCP; integrate marketing, e-commerce, and fulfillment data; ensure GCP ops, security, and reliability; use AI-assisted tools daily and collaborate with business and client stakeholders.
Top Skills: Ad PlatformsBigQueryClaude CodeCloud FunctionsCloud RunCloud SchedulerCursorDbtDbt CloudGa4GCPGeminiGemini Enterprise Agent PlatformGitIamLlm ApisLooker StudioNext.JsPub/SubPythonReactSecretsService AccountsShopifySQLVertex AiWorkflows
Yesterday
Remote
United States
145K-170K Annually
Senior level
145K-170K Annually
Senior level
Fintech • Financial Services
Design, build, and maintain scalable dimensional data models, semantic layer, and production transformation pipelines. Collaborate with Data Engineering, Data Science, BI, DevOps, and Product to enable AI-ready data, ensure data quality and governance, support ML feature delivery, and coach analytics team members for robust, production-ready data products.
Top Skills: DatafoldDbtFivetranPythonRedshiftSnowflakeSQLTableau

What you need to know about the Los Angeles Tech Scene

Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.

Key Facts About Los Angeles Tech

  • Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
  • Key Industries: Artificial intelligence, adtech, media, software, game development
  • Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
  • Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account