Senior Analytics Engineer
Alpaca
See how well this job matches your profile
Sign up to get an AI match score and generate a tailored application in seconds.
Get your match scoreTags
About the role
Role Overview
Join Alpaca as a Senior Analytics Engineer on a 100% remote team. You will own and execute the vision for the data transformation layer, building robust, scalable data models and collaborating with cross-functional stakeholders to deliver reliable data products.
Responsibilities
- Design, build, and maintain scalable data models using dbt and SQL to support diverse business needs.
- Establish and enforce best practices for:
- data modeling
- development
- testing
- monitoring to ensure data quality.
- Work directly with finance, operations, customer success, and marketing to understand requirements and deliver dependable data products.
- Improve data warehouse performance and ETL efficiency through proactive optimization.
- Own end-to-end data products, applying analytics/data engineering best practices for quality, scalability, and robustness.
- Implement CI/CD workflows and standards for version control and code review (e.g., Git).
Requirements
- Expert-level SQL and dbt skills for complex queries and transformations.
- Strong proficiency with data transformation work in ELT, with 4+ years in analytics engineering or data engineering.
- Familiarity with cloud environments (GCP or AWS).
- Proficiency in Python for transformations beyond SQL.
- Comfort working in ambiguous environments, taking ownership with minimal oversight.
- Hands-on experience with query optimization across both OLTP and OLAP systems (e.g., Postgres, Iceberg).
- Experience with Semantic Layer modeling (e.g., Cube or dbt Semantic Layer).
- Comfort owning CI/CD and team standards for version control and reviews (e.g., Git).
- Ability to collaborate with stakeholders to define requirements.
Nice-to-Haves / Additional Experience
- Domain experience for brokerage operations or a strong interest in financial markets and financial dataset modeling.
- Experience with data ingestion tools (e.g., Airbyte) and orchestration tools (e.g., Airflow).
About Alpaca
Alpaca is hiring for a 100% remote team focused on building a reliable data transformation and analytics engineering foundation. The role centers on developing scalable data models and data products that support business functions across finance, operations, customer success, and marketing, indicating a data/analytics engineering environment.
Scraped 5/13/2026