Clickhouse

Business Intelligence and Data Analytics Manager

United States

Not SpecifiedCompensation
Mid-level (3 to 4 years), Senior (5 to 8 years)Experience Level
Full TimeJob Type
UnknownVisa
Database Management Systems, Cloud Computing, Data & AnalyticsIndustries

Position Overview

  • Location Type: Hybrid
  • Job Type: Full-time
  • Salary: Not specified

ClickHouse is the company behind the popular open-source, high-performance columnar OLAP database management system for real-time analytics. ClickHouse works 100-1000x faster than traditional approaches. By offering a true column-based DBMS, it allows for systems to generate reports from petabytes of raw data with sub-second latencies. With an amazing community already adopting our open-source technology, we are now embracing our journey in delivering Cloud first solutions to delight our customers. With top adopters such as Lyft, Cisco, and eBay - not only do our products work at lightning speed, so do we. We are an open and collaborative company. Our colleagues are curious, engaged and excited about what they do. If you want to work in an environment where you can learn, grow, be an agent of change and have your voice heard - then please read on! ClickHouse is actively seeking an experienced Business Intelligence / Data Analytics Lead to own master data management and reporting across our Operations’ and Go To Market teams, focusing on sales and support datasets. In this critical role, you will become an integral part of our organization, collaborating with the GTM teams (Sales, Partner, Support) and corresponding operations teams, along with our internal Product Analytics Data Warehouse (DWH) Team to help us scale in our next phase of growth. This is a hybrid role that will own the data pipelines for key operational teams and also generate the reporting and analytics.

Requirements

  • Experience in Business Intelligence / Data Analytics
  • Strong understanding of data warehousing concepts
  • Experience with data modeling and ETL processes
  • Familiarity with data quality and data governance principles
  • Experience with reporting and dashboarding tools
  • Ability to work independently and collaboratively
  • Excellent communication and interpersonal skills

Responsibilities

  • Design, develop, and maintain end-to-end data warehouse on behalf of the Operations’ team.
  • Manage related data molding work and optimize Extract, Transform, and Load (ETL) processes.
  • Perform some data engineering work to connect current data sources into the ClickHouse DWH.
  • Own Master Data Management across the Operations’ function, including data dictionary creation and management.
  • Ensure data quality, consistency, and accessibility.
  • Develop reusable reports and dashboards that become the “sources of truth” for respective functions, like Support, Sales, Partners.
  • Design and maintain the “all company” metrics’ dashboards.
  • Partner with central DWH team to ensure that Ops adheres to best practices, naming conventions.
  • Partner with central DWH team to extend AI functionality across Operations’ metrics (i.e. the DWAINE, Data Warehouse AI Natural Expert, project).
  • Partner with Finance and Operations team members to ensure alignment on data definitions.
  • Develop and implement a set of audit reports across operational processes to validate the accuracy and efficiency of automations and integrations. This includes creating data snapshots to preserve audit history and historical reporting.
  • Perform ad hoc analyses as needed and create clear and concise reports.

Application Instructions

  • Not specified.

Skills

Business Intelligence
Data Analytics
Data Warehousing
Data Modeling
ETL
Data Quality
Data Governance
Reporting
Dashboarding
Communication

Clickhouse

High-speed column-oriented database management system

About Clickhouse

ClickHouse provides a high-speed, column-oriented database management system designed for developers and businesses that manage large-scale data. Its primary product processes analytical queries quickly by storing data from the same columns together, making it significantly faster than traditional row-oriented databases, especially in Online Analytical Processing (OLAP) scenarios. ClickHouse stands out from competitors by offering a free, open-source database that can be deployed on local machines or in the cloud, along with a fully managed service on platforms like AWS, GCP, and Microsoft Azure. The company's goal is to deliver a cost-effective solution that simplifies data management for its clients, as evidenced by user feedback highlighting substantial cost savings.

San Francisco, CaliforniaHeadquarters
2021Year Founded
$291.8MTotal Funding
SERIES_BCompany Stage
Data & Analytics, Enterprise SoftwareIndustries
201-500Employees

Benefits

Health Insurance
Unlimited Paid Time Off
Flexible Work Hours
Remote Work Options
Stock Options
Home Office Stipend

Risks

Redpanda Serverless poses a competitive threat in real-time data processing.
Integration challenges with PeerDB may delay expected benefits.
Dependency on Supabase could pose operational risks.

Differentiation

ClickHouse's column-oriented design offers superior speed for analytical queries.
The open-source model allows flexible deployment across various environments.
Integration with Grafana enhances data visualization capabilities.

Upsides

Partnership with Alibaba Cloud boosts presence in the Chinese market.
Acquisition of PeerDB enhances real-time analytics capabilities.
Launch of ClickPipes improves data processing efficiency for real-time updates.

Land your dream remote job 3x faster with AI