Our client is looking for an OLAP Data Warehouse Engineer. The ideal candidate will play a crucial role in designing, implementing, and managing their on-premises data warehouse solutions, focusing on ClickHouse and Superset. You will work closely with their data science and engineering teams to enable real-time data analysis and reporting, utilising streaming technologies like Kafka. Your expertise will drive the development of scalable, high-performance data architectures that support critical business functions.
Responsibilities
Design and implement robust, scalable data warehouse solutions using ClickHouse.
Develop and maintain dashboards and reports in Superset to meet business reporting needs.
Integrate streaming data technologies such as Kafka, to facilitate real-time data ingestion and analysis.
Ensure the reliability, availability, and performance of data warehouse systems.
Collaborate with data scientists and engineers to translate business requirements into technical specifications.
Optimise data models and queries for performance and scalability.
Implement best practices for data security, backup, recovery, and archiving.
Provide technical guidance and support for on-premises data warehouse operations.
Stay abreast of the latest trends and technologies in data warehousing and analytics, and recommend improvements to our systems and processes.
Requirements
Bachelor’s or Master’s degree in Computer Science, Information Technology, or a related field.
Proven experience with ClickHouse and Superset.
Strong background in streaming technologies, especially Kafka.
Experience designing and running on-premises data warehouse solutions.
Proficiency in SQL and database optimization techniques.
Solid understanding of data modelling, ETL processes, and data integration.
Familiarity with Python or other scripting languages is a plus.
Excellent problem-solving skills and attention to detail.
Strong communication and collaboration abilities.
This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful. Full information can be found here: https://inplayrecruit.com/wp/cookies-policy/
Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.
