Analytics Engineer

Alpaca; Canada; Remote; CAD 60,000 - 80,000; Full time

Job summary

A leading financial services company is looking for an Analytics Engineer to enhance its data transformation layer. This remote role involves collaborating with various teams and building robust data models using dbt and SQL. The ideal candidate should have extensive SQL skills and over 3 years of experience in data analytics or engineering, coupled with a strong work ethic. Competitive salary and home-office setup benefits are included.

Benefits

Competitive Salary & Stock Options

New Hire Home-Office Setup: One-time USD $500

Monthly Stipend: USD $150

Qualifications

• 3+ years of experience in data analytics or data engineering.
• High fluency in SQL.
• Deep understanding of data modeling and transformation principles.
• Proven experience with dbt.

Responsibilities

• Design, build, and maintain scalable data models.
• Establish technical standards for data modeling.
• Collaborate with various teams to understand their data requirements.
• Create repeatable patterns for integrating data models.

Skills

SQL expertise

Data modeling

Data analytics

Transformations in ELT

Technical versatility

Work ethic

Tools

dbt

API tools

Airflow

Airbyte

Job description

Overview

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 C funding round brought our total investment to over $170 million, fueling our ambitious vision. 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, totaling over 6 million brokerage accounts. Our global team is a diverse group of experienced engineers, traders, and brokerage professionals working to open financial services to everyone on the planet. We are 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 backed by investors including Portage Ventures, Spark Capital, Tribe Capital, Social Leverage, Horizons Ventures, Unbound, SBI Group, Derayah Financial, Elefund, and Y Combinator.

Our Team: We are a dynamic team of 230+ globally distributed members across the USA, Canada, Japan, Hungary, Nigeria, Brazil, the UK, and beyond. We seek passionate individuals to contribute to Alpaca's rapid growth and encourage applications from those who align with our core values—Stay Curious, Have Empathy, and Be Accountable.

Your 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 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 (managing data ingestion), Data Scientists, and Business Users (consuming 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 support stakeholders across the company—from finance and operations to the executive team—and are delivered via BI tools, reports, and reverse ETL systems.

Our team is 100% distributed and remote.

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 with finance, operations, customer success, and marketing teams to understand requirements and deliver reliable data products.
• Integrate and Deliver: Create repeatable patterns for integrating 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 products and data evolve.

Must-Haves

• Core Experience: 3+ years of experience in data analytics or data engineering with a strong focus on the transformation in ELT.
• Expert SQL Skills: High fluency in SQL for complex queries and data manipulation on large datasets.
• Analytics Engineering Fundamentals: Deep understanding of data modeling, transformation principles, and data engineering best practices (e.g., source control, code reviews, testing).
• dbt Experience: Proven experience building scalable transformation layers using formalized SQL modeling tools, preferably dbt.
• Technical Versatility
• Work Ethic: Comfortable with ambiguity, able to take ownership with minimal oversight, and adaptable in a fast-paced environment.

Nice to Haves

• Experience with data ingestion tools (e.g., Airbyte) and orchestration tools (e.g., Airflow).
• Experience with Semantic Layer modelling (e.g. Cube, dbt Semantic Layer).

Benefits

• Competitive Salary & Stock Options
• 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.

Equal Employment Opportunity

Alpaca is an equal opportunity employer. We do not discriminate on the basis of any protected group status under applicable law. This section reflects our commitment to fair hiring practices.

Voluntary Self-Identification

For government reporting purposes, candidates may respond to the below self-identification survey. Completion is voluntary and confidential. Information may be used to measure outreach and recruitment efforts in compliance with applicable laws. Further details are available in the full EEO/VEVRAA policy. This content is kept for compliance and transparency purposes.