Business Intelligence and Data Analytics Manager, ClickHouse
$108.8-200k
Salary dependent on location. Plus stock options grant
More information about location
Open-source database for real-time apps and analytics
Be an early applicant
Open-source database for real-time apps and analytics
101-200 employees
Be an early applicant
$108.8-200k
Salary dependent on location. Plus stock options grant
More information about location
101-200 employees
Company mission
ClickHouse's mission is to allow users to generate analytical reports using SQL queries in real-time.
Role
Who you are
- 7+ years of experience with SQL and data analysis
- 2+ at a fast-paced technology company
- Strong expertise in writing complex SQL queries and creating optimized views
- Experience with Python and R preferred
- Experience with business intelligence tools (e.g., Power BI, Tableau, Superset)
- Familiarity with Extract, Transform, and Load (ETL) processes
- Proven track record of translating business requirements into technical solutions
- Strong communication skills with ability to explain technical concepts to non-technical audiences
- Experience creating clear, impactful data visualizations
- Background in data modeling and database design
- Ability to manage multiple projects and priorities effectively
- DBT experience preferred
- ClickHouse experience is a plus
- Superset experience is a plus
What the job involves
- 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
- Our centralized DWH team will support you in the former, but you will own the work streams associated with the teams you support from beginning to end
- 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
- Some data engineering work needed 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 visualizations to communicate findings
- Implement Tableau or related BI tool to ensure ease of use
- Lead enablement sessions to drive self service across stakeholder teams
- Potential expansion to support other teams, e.g., HR, Marketing, Finance
- Partner with Security team to ensure proper protocols are maintained to safeguard our data
Our take
Database management systems have long been important to the operations of businesses. However, these systems can be painfully slow. ClickHouse solves this problem with its ultra-fast database management system, that powers real-time analytics and apps.
ClickHouse's founding team hail from companies including Yahoo!, Netflix, Salesforce and Google. This has not only lent the company an impressive amount of credibility, but has also allowed it to identify the needs and challenges of enterprises when it comes to their databases. Its system works between 100 and 1,000 times faster than traditional options, and has led to the company being trusted by the likes of eBay, Uber and Spotify.
Valued at $1 billion back in 2021, it is clear that ClickHouse holds a strong position in the market, though it does face competition from rivals such as StarTree and Imply. It has seen substantial funding, the most recent of which is cited to help expand its product and engineering teams. In 2022, the company also launched ClickHouse Cloud - a fully managed, SOC 2 Type 2-compliant cloud-hosted version of its database that is now available in the AWS Marketplace.
Freddie
Company Specialist at Welcome to the Jungle
Company
Funding (2 rounds)
Nov 2021
$250m
SERIES B
Sep 2021
$50m
SERIES A
Total funding: $300m
Company benefits
- Flexible work environment - ClickHouse is a distributed company offering both office based and remote work options (your choice!). We do not check when you log in or out. You are the owner of your calendar because work-life balance is important to us
- Employer contributions towards your healthcare
- Equity - Any new team member who joins our company is eligible to receive stock options
- Our competitive time-off policy complies with all local country laws at a minimum of given time off + all paid bank holidays
- Home office setup allowance for our remote employees
Company HQ
Old Palo Alto, Palo Alto, CA
Leadership
Aaron Katz
(CEO)Previously worked as a Consultant at PeopleSoft, and was SVP of Enterprise Sales at salesforce.com. Was also CRO of Elastic.
Yury Izrailevsky
(President, Product & Technology)Was Director of Engineering for Yahoo!'s Search Engine Core. Worked as VP of Cloud Computing at Netflix, and then joined Google as VP of Engineering.
Alexey Milovidov
(CTO)Was previously Head of ClickHouse at Yandex.
Share this job
View 26 more jobs at ClickHouse