Established in 2009, ClickHouse leads the industry with its open-source column-oriented database system, driven by the vision of becoming the fastest OLAP database globally. The company empowers users to generate real-time analytical reports through SQL queries, emphasizing speed in managing escalating data volumes.Enterprises globally, including Lyft, Sony, IBM, GitLab, Twilio, HubSpot, and many more, rely on ClickHouse Cloud. It is available through open-source or on AWS, GCP, Azure, and Alibaba.
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
New York Area / San Francisco Area - Salary Range
$136,000—$200,000 USD
Washington State - Full Salary Range
$115,000—$180,000 USD
General US Remote Salary Range
$108,800—$172,800 USD
Los Angeles, CA / Washington, DC - Salary Range
$122,500—$190,000 USD
Seattle, WA - Full Salary Range
$122,500—$190,000 USD
For roles based in the United States, you can find above our typical starting salary ranges for this role, depending on your specific location.
The positioning of offers within a certain range depends on various factors, including: candidate experience, qualifications, skills, business requirements and geographical location.
If you have any questions or comments about compensation as a candidate, please get in touch with us at [email protected].
Perks
- Flexible work environment - ClickHouse is a globally distributed company and remote-friendly. We currently operate in 20 countries.
- 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 other countries.
- A $500 Home office setup if you’re a remote employee.
- Global Gatherings – We believe in the power of in-person connection and offer opportunities to engage with colleagues at company-wide offsites.
Culture - We All Shape It
As part of our first 500 employees, you will be instrumental in shaping our culture.
Are you interested in finding out more about our culture? Learn more about our values here. Check out our blog posts or follow us on LinkedIn to find out more about what’s happening at ClickHouse.
Equal Opportunity & Privacy
ClickHouse provides equal employment opportunities to all employees and applicants and prohibits discrimination and harassment of any type based on factors such as race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
Please see here for our Privacy Statement.
Top Skills
Similar Jobs
What you need to know about the Los Angeles Tech Scene
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering
