[Remote] Staff Software Engineer - Analytics & Data Architecture

Note: The job is a remote job and is open to candidates in USA. 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

Skills

• 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

Benefits

• Equity packages, including a 401k plan
• Remote-first culture — work from anywhere
• 100% Employer covered comprehensive health, dental, and vision insurance with a top tier plan for you and your dependents (US)
• Unlimited PTO policy
• Family-Friendly environment
• Regular team events and offsites
• Unparalleled learning and professional development opportunities

Company Overview

Company H1B Sponsorship