Senior Software Engineer, OLAP/Clickhouse

Cognitiv; Vancouver; On-site; CAD 150,000 - 190,000; Full time

Benefits offered by this job

Medical, Dental and Vision plan

Hybrid work model

Equity

Parental leave

Career development

Job summary

Cognitiv, a Vancouver-based AdTech innovator, seeks a Senior Software Engineer for the Attribution & Events team. You will lead design and delivery of large-scale data systems, solving cross-device identity challenges and linking ad events to conversions.

Expect heavy focus on ClickHouse, SQL, and backend services in C#/.NET Core and Java. Join the founding Vancouver engineering team to shape the technical bar, drive performance, and advance ML-powered campaign measurement in a rapidly evolving

Qualifications

• Deep hands-on experience with a columnar/OLAP store (ClickHouse preferred) at petabyte scale.
• Advanced SQL with partitioning, large-scale joins, window functions, and views.
• High-throughput data pipelines handling millions to billions of events daily.
• Backend services experience in C# / .NET Core and Java, end-to-end ownership.
• Cloud infrastructure knowledge, particularly AWS, and observability focus.

Responsibilities

• Own end-to-end design and delivery of high-volume data services on ClickHouse.
• Architect pipelines ingesting billions of ad events and optimizing queries.
• Build and operate C#/.NET Core services powering attribution and campaigns.
• Ingest signals from various sources and manage identity graphs at scale.
• Improve reliability, observability, and performance of data platforms.
• Mentor teammates and drive high-quality design docs and patterns.
• Collaborate with Product, Science, and Engineering to align with business goals.

Skills

Big Data & OLAP

SQL Fluency

High-Throughput Event Systems

Backend Proficiency

Cloud & Infrastructure

Engineering Discipline

Operational Mindset

Ownership

Communication

Tools

ClickHouse

C# / .NET Core

Java

AWS

SQL Databases

Job description

Senior Software Engineer, OLAP/Clickhouse

Are you ready to revolutionize the advertising industry?

At Cognitiv, we are not just another AdTech company—we are industry trailblazers redefining media buying with our Deep Learning Advertising Platform. Since 2015, we have harnessed the power of cutting-edge deep learning technology and data science to transform how brands connect with their customers. Our mission? To bring intelligence to advertising and deliver unparalleled precision, relevance, and impact at scale.

With our innovative platform, advertisers enjoy unprecedented flexibility—whether it is activating Dynamic Deals through their preferred DSP, leveraging our managed service DSP, or utilizing our industry-first ContextGPT product. As a part of Cognitiv, you will be at the forefront of AI-driven advertising solutions, driving change and achieving remarkable growth in a rapidly evolving industry.

Now, we’re growing!

The Role

As a Senior Software Engineer on the Attribution & Events team, you will be the driving force behind the platform that proves campaign performance. You will own the design, delivery, and reliability of high-stakes data systems that solve the hardest cross-device identity challenges, surgically linking purchases with customers who saw an ad. This mission is absolutely critical to the performance of our ML and overall campaign effectiveness. Get ready to master data at an epic scale, managing datasets with billions of records and trillions of data points across identity resolution, attribution, incrementality measurement, and campaign management.

This role is heavily weighted toward big data engineering, analytical SQL, and OLAP systems (primarily ClickHouse), with backend service work in C# / .NET and Java to operationalize the data products you build.

You’ll navigate ambiguity and make the critical tradeoffs that drive system performance and engineering effectiveness — and you’ll do it as part of the founding Vancouver engineering team, helping us set the technical bar and shape the culture of a new hub from day one.

Your Impact

In this role, success is measured by the reliability, scalability, and performance of our event data platform. You will:

• Lead Technical Design: Own end-to-end delivery of high-volume data services — from ClickHouse schema and partitioning to ingestion pipelines to the C# services on top — accounting for scalability, failure modes, and cost up front.


• Build & Scale the Data Backbone: Architect ClickHouse-backed pipelines that ingest, store, and query billions of ad events (impressions, conversions, identity signals). Own loaders, partitioning, materialized views, and query optimization end-to-end.


• Operationalize via Backend Services: Build C# / .NET Core 8 services that power attribution, incrementality measurement, and campaign management on top of the data layer.


• Integrate Identity & Event Sources: Ingest events from LiveRamp, pixels, CTV, and IP-based signals; integrate identity graphs and resolve cross-vendor IDs at scale.


• Elevate Reliability: Identify bottlenecks across the data path, improve observability (ingestion lag, query latency, data quality), lead blameless post-mortems, and implement long-term systemic fixes.


• Drive Engineering Excellence: Strengthen the team through high-quality code and SQL reviews, mentorship, and strong design docs, data models, and query patterns.


• Navigate Ambiguity: Make strong calls on the open questions, balancing long-term data architecture health with development velocity.


• Collaborate on Direction: Partner with Product, Science, and Engineering to align technical work with measurement and business priorities.

Required Experience & Capabilities

• Big Data & OLAP: Deep hands-on experience with a columnar/OLAP store (ClickHouse strongly preferred; Snowflake, BigQuery, Redshift, or other petabyte scale big data experience acceptable). Experience designing schemas, tuning queries, and operating at billion-row scale.


• SQL Fluency: Advanced SQL experience including partitioning strategies, large-scale joins, window functions, materialized views, query tuning, and cost-aware analytical patterns.


• High-Throughput Event Systems: Experience building pipelines handling millions to billions of events per day, including ingestion, deduplication, late-arriving data, and backfills.


• Backend Proficiency: Strong programming skills in C# / .NET Core (DI, hosted services, ASP.NET Web APIs) or comparable backend stack with ability to ramp quickly. Comfortable owning services end-to-end (schema, migrations, deploys, on‑call).


• Cloud & Infrastructure: AWS experience (S3, SSM/Parameter Store, IAM basics).


• Engineering Discipline: Strong testing mindset with integration tests against real databases; improves infrastructure rather than working around it.


• Operational Mindset: Strong understanding of reliability, observability, and maintainable system design for data pipelines and analytical systems.


• Ownership: Ability to independently drive technical initiatives from problem definition to deployment.


• Communication: Able to clearly explain technical tradeoffs to technical and non-technical stakeholders.

Nice to Have Experience

• Ad-tech experience (RTB, DSP/SSP, attribution, incrementality, identity graphs, LiveRamp, IAB standards)

Salary: $150,000 - $190,000 CAD Base Salary + Equity

What We Offer

Compensation is based on experience, skills, and other factors. Base salary is just one part of your total rewards at Cognitiv—you’ll also receive equity and a comprehensive benefits package.

Highlights include:

• Medical, Dental and Vision plan for US employees & Extended Health Benefits for Canadian employees


• 12 weeks paid parental leave + 4 weeks WFH


• Unlimited PTO + Work-From-Anywhere August


• Career development with clear advancement paths


• Equity for all employees


• Hybrid work model & daily team lunch


• Health & wellness stipend + cell phone reimbursement


• 401(k) & RRSP with employer match


• Employee Assistance Program


• and more!

What You’ll Find at Cognitiv

• Festiv – We make work fun with cross-team games, events, and creative team bonding.


• Responsiv – You’ll be close to clients and leadership, influencing real outcomes.


• Inclusiv – Diversity and individuality are celebrated across all levels.


• Inventiv – We reward curiosity and embrace bold ideas.


• Transformativ – We support your growth with training, mentorship, and flexibility.


• Collaborativ – We operate across coasts, connected by purpose and teamwork.

Cognitiv is proud to be an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive workplace for all.

Note on AI Use: Cognitiv may use AI technology to assist with certain administrative aspects of the hiring process, such as note-taking, interview documentation, and reporting. However, every resume and application is reviewed directly by our recruiting team. AI tools are used solely for operational support and do not influence candidate evaluation or hiring decisions.