Staff Analytics Engineer
New
A
AlpacaFinancial Services
Our global team is a diverse group... teammates spanning the USA, Canada, Japan, Hungary, Nigeria, Brazil, the UK, and beyond! ... 100% remote teamFull-TimeStaff
SalaryCompetitive Salary & Stock Options
Apply NowOpens the employer's application page
Job Details
- Experience
- 4+ years of experience in analytics engineering or data engineering
- Required Skills
- AWSPythonSQLETLGCPGitCI/CDData modelingdbt
Requirements
- 4+ years of experience in analytics engineering or data engineering with a strong focus on the 'T' in ELT.
- Proven track record of owning data products end-to-end, ensuring data quality, scalability, and robust modeling.
- Comfortable working with ambiguity and collaborating with stakeholders to define requirements.
- Experience proactively identifying and implementing improvements to data warehouse performance and ETL efficiency.
- Expert-level SQL and dbt skills for complex queries and 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 modeling (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).
Responsibilities
- Design, build, and maintain scalable data models using dbt and SQL to support diverse business needs.
- Establish and enforce best practices for data modelling, development, testing, and monitoring to ensure data quality and discoverability.
- Collaborate directly with finance, operations, customer success, and marketing teams to understand requirements and deliver data products.
- Create repeatable patterns for integrating data models with BI tools and reverse ETL processes.
- Champion development standards including change management, source control, code reviews, and data monitoring.
View Full Description & ApplyYou'll be redirected to the employer's site
