Business Intelligence And Data Analytics Manager

ClickHouse
Summary
Join ClickHouse, a leading provider of high-performance columnar OLAP database management systems, as a Business Intelligence/Data Analytics Lead. In this critical role, you will own master data management and reporting across Operations and Go-to-Market teams, focusing on sales and support datasets. You will design, develop, and maintain data warehouses, manage ETL processes, ensure data quality, and create insightful reports and dashboards. Collaboration with various teams, including the central DWH team, is essential. This hybrid role requires strong SQL, data analysis, and communication skills, along with experience in data modeling and visualization. ClickHouse offers a competitive salary, stock options, flexible work environment, healthcare contributions, generous time off, and other perks.
Requirements
- 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 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
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
- 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
Preferred Qualifications
- Experience with Python and R
- DBT experience
- ClickHouse experience
- Superset experience
Benefits
- Cash compensation and a stock options grant
- Flexible work environment - ClickHouse is a distributed company offering remote-first work to all employees
- Healthcare - Employer contributions towards your healthcare
- Equity in the company - Every new team member who joins our company receives stock options
- Time off - Flexible time off in the US, generous entitlement in all countries
- A $500 Home office setup if you’re a remote employee
- Employee-driven international mobility - we enable you to relocate internationally if you wish (within certain countries and timelines and subject to role requirements, time zones and work permit considerations)