Analytics Engine Engineer - OLAP, Edge & WASM

FirstMile Ventures; United States; On-site; USD 100,000 - 140,000; Full time

Job summary

FirstMile Ventures is looking for a talented analytics engineer to build an analytics engine focused on fast and accurate data processing. The role involves designing OLAP systems and optimizing query performance across various data sources such as Supabase and ClickHouse.

Ideal candidates will possess OLAP expertise and experience with distributed systems. This unique opportunity allows you to work closely with cutting-edge technologies to transform how analytics are delivered without the need for conventional data warehouses or teams.

Qualifications

• Experience with analytical query systems at scale.
• Understanding of columnar storage and transaction workloads.
• Proficiency in DuckDB and its production use.
• Familiarity with ClickHouse's data model and performance.
• Knowledge of edge computing environments deployments.
• Experience in building cross-source analytics.

Responsibilities

• Own the Query and OLAP Layer to design analytical queries.
• Implement DuckDB pipelines to execute transformations.
• Build analytics connectors for various data sources.
• Optimize query performance and resource allocation.

Skills

OLAP Expertise

Distributed Systems Depth

DuckDB and In-Process Analytics

ClickHouse Experience

Edge and WASM Deployment

PostHog Familiarity

Postgres Depth

Accuracy Standards

Job description

FirstMile Ventures is looking for a talented analytics engineer to build an analytics engine focused on fast and accurate data processing. The role involves designing OLAP systems and optimizing query performance across various data sources such as Supabase and ClickHouse.

Ideal candidates will possess OLAP expertise and experience with distributed systems. This unique opportunity allows you to work closely with cutting-edge technologies to transform how analytics are delivered without the need for conventional data warehouses or teams.