At a Glance
- Tasks: Develop and enhance Python integrations for ClickHouse's data ecosystem.
- Company: Join ClickHouse, a fast-growing leader in real-time analytics and AI workloads.
- Benefits: Enjoy flexible work, healthcare contributions, equity options, and generous time off.
- Other info: Be part of a dynamic team that values collaboration and innovation.
- Why this job: Shape the future of data engineering with cutting-edge technology and impactful projects.
- Qualifications: 7+ years in software development, with experience in data engineering or data science.
The predicted salary is between 70000 - 90000 £ per year.
About ClickHouse
Recognized on the 2025 Forbes Cloud 100 list, ClickHouse is one of the most innovative and fast-growing private cloud companies. With more than 3,000 customers and ARR that has grown over 250 percent year over year, ClickHouse leads the market in real-time analytics, data warehousing, observability, and AI workloads. The company’s sustained, accelerating momentum was recently validated by a $400M Series D financing round. Over the past three months, customers including Capital One, Lovable, Decagon, Polymarket, and Airwallex have adopted the platform or expanded existing deployments. These customers join an established base of AI innovators and global brands such as Meta, Cursor, Sony, and Tesla. We’re on a mission to transform how companies use data. Come be a part of our journey!
The Connectors team is the bridge between ClickHouse and the broader data ecosystem. We build and maintain the integrations that make ClickHouse accessible to millions of developers, data practitioners, and AI agents worldwide from high-level data visualization plugins (Tableau, PowerBI, Superset, Metabase) to connectors for data frameworks (Apache Spark, Flink, Kafka Connect, Fivetran), orchestration platforms, and AI tooling. Our work directly shapes how companies process massive datasets: real-time analytics platforms ingesting millions of events per second, observability systems monitoring global infrastructure, and increasingly, the AI-powered data applications redefining how teams work with data. We collaborate closely with the open-source community, internal teams, and enterprise users to ensure ClickHouse integrations set the standard for performance, reliability, and developer experience.
About the role
As a Senior Software Engineer specializing in Python and the Data Ecosystem, you'll be a core contributor owning and evolving critical parts of ClickHouse's data engineering ecosystem. This role sits at the intersection of high-performance database engineering and developer experience. You'll craft tools that enable Data Engineers and Data Scientists to harness ClickHouse's speed and scale in the frameworks they already use. We're looking for someone who has lived the Data Engineer or Data Scientist experience firsthand. The data practitioner's world is shifting rapidly: databases are no longer just query targets, but they're becoming active participants in AI-powered workflows, serving as vector stores for RAG pipelines, backends for LLM-powered agents, and real-time feature stores for ML inference. You understand these workflows not from the outside, but because you've operated within them. You don't just build integrations, you bring product-level insight into what we should build and why. You'll own the full lifecycle of key Python integrations, driving architecture, performance, and feature direction across:
- Orchestration Platforms: Apache Airflow, Dagster, Prefect
- Transformation Tools: dbt, SQLMesh
- AI & LLM Ecosystem: LangChain, LlamaIndex, n8n, and broader AI tooling: embedding pipelines, retrieval-augmented generation with ClickHouse as a vector store, ML feature stores, and LLM-powered data applications
ClickHouse's columnar architecture and query performance make it exceptionally well-positioned in this new landscape. Your job is to make that potential real: building the robust, production-ready connectors that make ClickHouse the natural choice when data practitioners design their next-generation AI and data systems.
What you'll do
- Own and evolve ClickHouse's Python connector and SDK ecosystem, raising the bar on performance, reliability, and API design
- Build and maintain integrations with orchestration platforms (Airflow, Dagster, Prefect) and transformation tools (dbt) to enterprise-grade quality standards
- Drive the AI/LLM integration strategy: designing connectors and patterns that make ClickHouse a natural fit in RAG architectures, ML feature pipelines, and LLM-powered data applications
- Engage actively with the open-source community: triage issues, support contributors, advocate for users, and shape the roadmap based on real-world feedback
- Collaborate with Product, Cloud, and other engineering teams to align integration work with broader platform priorities
- Bring a practitioner's perspective to roadmap decisions, grounding prioritization in genuine Data Engineer and Data Scientist workflows
About you
- 7+ years of software development experience, ideally with hands-on time as a Data Engineer, Data Scientist, or ML Engineer
- Deep, proven experience designing, building, and maintaining production-grade Python connectors, SDKs, or integrations for at least one major platform (orchestration, BI, MLOps, or data transformation)
- Solid experience with the Python data ecosystem: Pandas, NumPy, Pydantic, and related libraries
- Prior contributions to, or deep practical experience with, popular data orchestration tools (Airflow, Dagster, or Prefect)
- Hands-on experience with AI/ML in data engineering contexts: embedding generation, vector search, feature pipelines, or LLM-powered tooling in production, not just experimentation
- Strong understanding of database fundamentals: SQL, data modeling, query optimization, and familiarity with OLAP/analytical databases
- Solid experience with concurrent Python: threading, multiprocessing, and async patterns
- Outstanding written and verbal communication skills; comfortable collaborating across engineering functions and with open-source communities
Bonus points for:
- Experience deploying AI/ML models in production, including inference APIs and vector databases
- Prior experience as a Data Engineer or Data Scientist in a product-facing or platform role
- Familiarity with ClickHouse or similar high-performance OLAP platforms
- Familiarity with the JVM ecosystem
Eligible locations: USA, Canada, UK, Portugal, Spain, France, Italy, Germany, Netherlands, Poland, Czech Republic, Israel, UAE
Compensation
For roles based in the United States, the typical starting salary range for this position is listed above. In certain locations, such as the San Francisco Bay Area and the New York City Metro Area, a premium market range may apply, as listed. These salary ranges reflect what we reasonably and in good faith believe to be the minimum and maximum pay for this role at the time of posting. The actual compensation may be higher or lower than the amounts listed, and the ranges may be subject to future adjustments. An individual’s placement within the range will depend on various factors, including (but not limited to) education, qualifications, certifications, experience, skills, location, performance, and the needs of the business or organization. If you have any questions or comments about compensation as a candidate, please get in touch with us at paytransparency@clickhouse.com.
Perks
- Flexible work environment - ClickHouse is a globally distributed company and remote-friendly. We currently operate in over 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 a rapidly scaling start up, 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.
Senior Software Engineer - Python and Data Ecosystem employer: Clickhouse
ClickHouse is an exceptional employer, offering a flexible and remote-friendly work environment that spans over 20 countries. With a strong focus on employee growth, team members receive stock options and generous time-off policies, while actively contributing to a culture that values innovation and collaboration. Join us in shaping the future of data engineering and enjoy the unique opportunity to work with cutting-edge technology alongside a diverse and talented team.
StudySmarter Expert Advice🤫
We think this is how you could land Senior Software Engineer - Python and Data Ecosystem
✨Tip Number 1
Network like a pro! Reach out to current employees at ClickHouse on LinkedIn or other platforms. Ask them about their experiences and any tips they might have for the interview process. Personal connections can give you an edge!
✨Tip Number 2
Prepare for technical interviews by brushing up on your Python skills and data engineering concepts. Practice coding challenges and be ready to discuss your past projects in detail. We want to see how you think and solve problems!
✨Tip Number 3
Show your passion for the data ecosystem! Be ready to discuss the latest trends in AI, ML, and data integration. Share your thoughts on how ClickHouse can fit into these evolving landscapes. We love candidates who are genuinely excited about our mission!
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re serious about joining our team at ClickHouse!
We think you need these skills to ace Senior Software Engineer - Python and Data Ecosystem
Some tips for your application 🫡
Tailor Your Application:Make sure to customise your CV and cover letter for the Senior Software Engineer role. Highlight your experience with Python and the data ecosystem, and show us how your background aligns with what we're looking for.
Showcase Your Projects:Include any relevant projects or contributions you've made, especially those involving data engineering or AI/ML. We love seeing practical examples of your work, so don’t hold back!
Be Clear and Concise:When writing your application, keep it straightforward. Use clear language and avoid jargon unless it's necessary. We want to understand your experience without getting lost in technical terms.
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way to ensure your application gets into the right hands and shows us you're serious about joining our team!
How to prepare for a job interview at Clickhouse
✨Know Your Python Inside Out
As a Senior Software Engineer, you'll need to demonstrate your deep understanding of Python and its data ecosystem. Brush up on libraries like Pandas and NumPy, and be ready to discuss how you've used them in real-world projects. Prepare examples that showcase your experience with building production-grade connectors and SDKs.
✨Familiarise Yourself with ClickHouse
Since ClickHouse is at the heart of this role, take some time to understand its architecture and features. Explore how it handles real-time analytics and data warehousing. Being able to discuss its strengths and how they relate to the integrations you'll be working on will show your genuine interest and preparedness.
✨Prepare for Technical Questions
Expect technical questions that dive into your experience with orchestration platforms like Airflow or Dagster. Be ready to explain your approach to designing connectors and how you ensure performance and reliability. Practising coding problems related to concurrent Python and database fundamentals can also give you an edge.
✨Showcase Your Collaboration Skills
This role involves working closely with various teams and the open-source community. Be prepared to share examples of how you've successfully collaborated in past projects. Highlight your communication skills and how you've engaged with users or contributors to shape product direction based on feedback.