Staff Software Engineer - Analytics & Data Architecture

Oscilar is building an AI Risk Decisioning Platform that helps banks, fintechs, and digitally native organizations manage fraud, credit, and compliance risk. The Staff Software Engineer will own the data layer and analytics architecture, designing a tiered platform while improving database performance, reliability, observability, and schema evolution.

Responsibilities:

• Find and fix database performance and scaling problems
• Own the schema and data model for our analytical data
• Design and build our analytics architecture: a tiered platform spanning our system of record, a low-latency serving tier, and a batch/ML tier
• Decide where each workload runs across those tiers, backing placement decisions with real benchmarks rather than vendor claims
• Build observability into the data layer so problems surface early
• Partner with the ingestion team to keep the read and write paths coherent as schemas evolve

Requirements:

• Deep, production experience operating a database or analytical store under concurrent, customer-facing load: you can reason from a query plan to a fix, not just from documentation
• Strong SQL and a real mental model of columnar / OLAP execution
• Solid backend engineering. Our stack is Java, but we care more that you can read and modify a real codebase than which tools you've used
• Data architecture experience: you've designed or materially shaped a multi-tier data platform and can defend those decisions with measurements
• 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