Business Intelligence and Data Analytics Manager
ClickhouseAbout the role
About ClickHouse
We are 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. 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.
What you will do:
- 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
What you bring:
- 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
Apply for this role
Generate a tailored application kit with a matched cover letter, interview prep, and CV highlights — in under 60 seconds.
Apply Now →Generate Application KitFree account required — sign up in 30s