Staff Software Engineer - Analytics & Data Architecture

Remote. Posted 2 months ago

The role

You will own the data layer behind the analytics product and design the analytics architecture and data model. This hands-on role involves writing code and shaping the multi-quarter direction of the analytics platform.

What you will do

Find and fix database performance and scaling problems.
Own the schema and data model for analytical data.
Design and build a tiered analytics architecture spanning system of record, low-latency serving tier, and batch/ML tier.
Decide where each workload runs across tiers based on benchmarks.
Build observability into the data layer.
Partner with the ingestion team to keep read and write paths coherent as schemas evolve.

Required qualifications

Deep, production experience operating a database or analytical store under concurrent, customer-facing load.
Strong SQL and a real mental model of columnar / OLAP execution.
Solid backend engineering.
Data architecture experience designing or materially shaping a multi-tier data platform.

Nice to have

Lakehouse experience: Databricks, Spark, Delta Lake / Iceberg, or comparable.
Experience designing schemas for wide, semi-structured event data (nested objects, maps, JSON).
Streaming ingestion experience (Kafka or similar).
Track record of a migration or major re-architecture, with the cost/latency reasoning to back the decisions.
ClickHouse experience.
Connection-pool and JDBC-level tuning experience.
Familiarity with feature-flagged rollouts of query-engine behavior changes.
Open-source contributions to a query engine or related tooling.

Benefits

Competitive salary and equity packages
401k plan
Remote-first culture
100% Employer covered comprehensive health, dental, and vision insurance for you and dependents (US)
Unlimited PTO policy
Regular team events and offsites
Learning and professional development opportunities

About the company

Oscilar is building an AI Risk Decisioning Platform used by banks, fintechs, and digitally native organizations to manage fraud, credit, and compliance risk.