Unhooked Owl

Your system integrator for open source technologies.

We design, build and operate data platforms based on open source technologies, with ClickHouse as our main focus. We are a small team of senior specialists based in Sweden.

What we do

Data platforms on open source

We work with the whole lifecycle of a data platform, from architecture and development to production operations, and lead the programs and change that make it succeed.

Architecture and development

Assessment of the current data landscape, target architecture and data models for analytical workloads, and hands-on development of pipelines, transformations and integrations.

Migration

Planning and running migrations, including pipelines, data validation and cutover, together with the client's team.

Operations

Ongoing responsibility for databases in production: performance tuning, monitoring, backup and restore, security, upgrades and capacity planning.

Program and change management

Leading data and technology programs from strategy to delivery, managing change and aligning stakeholders so the platform is adopted across the organisation.

Technologies

What we work with

ClickHouse

The core of most of our work. We help organisations adopt, migrate to and run ClickHouse.

  • Data modelling for analytical workloads: MergeTree table engines, partitioning, ordering keys, materialized views and projections
  • Migrations from other databases, with data validation and cutover planning
  • Query and ingestion optimisation
  • Day-to-day operation, self-hosted or on ClickHouse Cloud

PostgreSQL

Relational database for operational and analytical workloads.

  • Administration, performance tuning and query optimisation
  • Backup and restore, high availability and upgrades
  • Monitoring, security and capacity planning

Kafka

Event streaming for real-time data.

  • Topic design and cluster setup
  • Streaming ingestion into ClickHouse and other targets
  • Operation and monitoring

Debezium

Change data capture from operational databases.

  • CDC from PostgreSQL and other sources
  • Real-time replication into analytical platforms
  • Low-downtime migrations

Spark

Large-scale data processing.

  • Batch and streaming jobs
  • Processing of formats like Parquet and Iceberg
  • Performance tuning

dbt

SQL-based transformation and modelling.

  • Dimensional and analytical data models
  • Testing and documentation
  • CI/CD for data changes

Dagster & Airflow

Orchestration of data pipelines.

  • Pipeline design and scheduling
  • Dependencies, retries and alerting
  • Deployment and operation

Cube

Semantic layer on top of the data platform.

  • Consistent metric definitions
  • Caching and pre-aggregations
  • APIs for dashboards and applications

Superset

Open source BI and dashboards.

  • Dashboards and self-service analytics on ClickHouse and PostgreSQL
  • Setup and access control
  • Operation and upgrades

How we work

A partner, not just a supplier

It starts with business value

Every engagement starts with the business value the platform should deliver. Architecture, technology choices and priorities follow from that, and we make sure the value is actually delivered.

We take responsibility

We take ownership of the platform as a true partner. You don't have to specify every task. We keep the platform healthy, see what needs to be done and act on it, and keep you informed along the way.

Senior and hands-on

A small team of senior specialists who value technical depth, pragmatism and getting things done.

Yours to own

We build solutions you can own and grow over time. We document architecture and runbooks and share knowledge with your team.

From platform to business impact

Alongside technical depth, we bring senior experience in business-driven technology strategy and transformation. We lead programs, manage change and align stakeholders, so the platform is adopted across your organisation and delivers the value it was built for.

We lead programs

From technology strategy to delivery, across teams and suppliers.

We manage change

So new ways of working take hold and the platform is actually used.

We align stakeholders

Business and IT pulling in the same direction.

Contact

Get in touch

Email us at info@unhookedowl.com