Posted today · be early
Staff Analytics Engineer
Alpaca
WorldwideremotePosted today
Skill Required
Analytics-EngineerData-EngineerAnalytics-DeveloperData-AnalystStaff-Analytics-EngineerStaff-Business-Intelligence-EngineerAnalytics EngineeranalyticsQuery Optimizationdata engineeringData WarehousingEngineeringObservabilityPostgreSQLAirflowTestNGPythondesignSparkCI/CDCloudjQueryAPIsdbtETLSQLAWSGCPGitandCICDFulltime
Key highlights
- Experience: 4+ years in analytics or data engineering
- Remote: 100% remote team
- Benefit: USD $150 monthly stipend
- Key Skill: Expert-level SQL and dbt
- Compensation: 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, serving hundreds of financial institutions across 40 countries. We are seeking an Analytics Engineer to own and execute the vision for our data transformation layer within a 100% remote team, utilizing dbt and Trino on a GCP-based, open-source data infrastructure to build robust, scalable data models for stakeholders across the company.
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 over 10 million brokerage accounts.
- Backed by $400 million in funding from 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 across the USA, Canada, Japan, Hungary, Nigeria, Brazil, the UK, and beyond.
- Core values: Stay Curious, Have Empathy, and Be Accountable.
- The role involves working with data from transactional databases, API logs, CRMs, payment systems, and marketing platforms.
- The role works closely with Data Engineers, Data Scientists, and Business Users.
- Alpaca is an equal opportunity workplace dedicated to pursuing and hiring a diverse workforce.
- Recruitment Privacy Policy applies.
- Originally posted on Himalayas
