data
Posted Apr 24Senior Analytics Engineer
at Alpaca
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 directly with finance, operations, customer success, and marketing teams to understand their
- 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.
- 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.
Requirements
- 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.
- Your primary responsibility will be to use dbt and Trino on our GCP-based, open-source data infrastructure to build robust, scalable data models.
- experience in analytics engineering or data engineering with a strong focus on the "T" (transformation) in ELT.
- 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). •
- 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: