Staff Engineer – Analytics, Data Architecture

Oscilar

Staff Engineer owning analytics architecture and data modeling at Oscilar, an AI risk decisioning platform for fraud, credit, and compliance. Building tiered data infrastructure, optimizing database performance, and shaping long-term analytics platform strategy.

Posted 8/14/2026full-timeRemote • 🇨🇦 CanadaLead💰 CA$220,000 - CA$262,500 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in data architecture and analytics platform design, with a strong focus on SQL, database performance optimization, and multi-tier data systems. Proven ability to manage schema evolution and implement observability in data layers.

Highest-signal resume keywords

SQL ExpertiseData Architecture ExperienceLakehouse ExperienceStreaming Ingestion ExperienceBackend Engineering Experience

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Database Performance OptimizationSchema DesignMulti-Tier Data Platform DesignQuery Plan AnalysisOLAP Execution Understanding

Tools & Technologies

DatabricksSparkDelta LakeIcebergKafka

Industry Keywords

Analytics ArchitectureData ModelObservabilityConnection-Pool TuningOpen-Source Contributions

Tech Stack

Tools & technologies

KafkaSparkSQL

About the role

Key responsibilities & impact

Own the data layer behind the analytics product and design the analytics architecture and data model
Find and fix database performance and scaling problems
Own the schema and data model for analytical data
Design and build a tiered analytics platform spanning the system of record, low-latency serving tier, and batch/ML tier
Decide workload placement across tiers using measured latency, cost, and isolation benchmarks
Build observability into the data layer so problems surface early
Partner with the ingestion team to keep read and write paths coherent as schemas evolve
Write code and shape the multi-quarter direction of the analytics platform

Requirements

What you’ll need

Deep, production experience operating a database or analytical store under concurrent, customer-facing load
Ability to reason from a query plan to a fix
Strong SQL and a real mental model of columnar / OLAP execution
Solid backend engineering experience; ability to read and modify a real codebase
Data architecture experience designing or materially shaping a multi-tier data platform
Ability to defend architectural decisions with measurements
Lakehouse experience with Databricks, Spark, Delta Lake, Iceberg, or comparable technologies preferred
Experience designing schemas for wide, semi-structured event data preferred
Streaming ingestion experience with Kafka or similar preferred
Track record of a migration or major re-architecture, with cost/latency reasoning preferred
ClickHouse experience nice to have
Connection-pool and JDBC-level tuning experience nice to have
Familiarity with feature-flagged rollouts of query-engine behavior changes nice to have
Open-source contributions to a query engine or related tooling nice to have
Legal authorization to work in the country of the position is requested in the application form

Benefits

Comp & perks

Candidates are hired as CLT and are offered competitive salary
Stock options
100% of Medical/Dental (Care Plus) for you and your dependents
100% Life / LTD (Prudential)
Caju Card for monthly meal allowance
Remote first culture
Family-Friendly environment
Regular team events and offsites
Unparalleled learning and professional development opportunities
Making the internet safer by protecting online transactions