Senior Business Intelligence (BI) Data Engineer
- Haiilo GmbH
- Hamburg, Germany
- 21/08/2024
Job Description
This role is a hybrid role within Germany, Finland or the UK. You can work mostly remotely from these countries, but join one of our offices in Hamburg, Helsinki or London at least once a month. We cannot support any relocation support at the moment for this role.
Haiilo is a 360° Employee Communications Platform that strengthens the cohesion, motivation and culture in organizations. With more than 1,000 international clients such as Coca Cola, EY, Deutsche Bahn and Deutsche Telekom, we're one of the largest global providers of employee communications software for companies to reach, engage and understand more than 3.5 million employees every day.
As a Senior Business Intelligence (BI) Data Engineer you will play a pivotal role in creating data insights and drive all BI-related initiatives independently forward. In this position, you will be responsible for designing, developing, and maintaining the data architecture, pipelines, and systems that support our BI and analytics capabilities. This role will involve collaborating with cross-functional teams to understand data requirements, ensuring data quality, and optimizing data flows to support business intelligence initiatives.
It is your chance to enter an already grown and successful company while being able to still leave your visible footprint.
What we are looking for:
- Your background: You should have a minimum of 5 years of experience in data engineering, BI development, or a similar role where you gained expertise in SQL and relational databases like PostgreSQL, MySQL etc.
- Your expertise:
- Must: You can demonstrate your know-how with data warehousing solutions like BigQuery, Redshift, or Snowflake, have proficiency in ETL tools and frameworks like Apache Airflow, Airbyte, Talend and experience with cloud platforms
- Must: For our own application we use python scripts with Kubernetes and SQL logic with BigQuery, therefore you should have built experience with that as well as with BI and data visualization tools (eg, Tableau, Power BI, Looker etc.).
- Must: Experience in developing and optimizing data transformation workflows using dbt
- Bonus points:, knowledge of data governance and compliance frameworks (EG, GDPR) and familiarity with ML concepts
- Your personal skills: You have strong analytical and problem-solving skills with an ability to identify and resolve data-related issues
- Your teamwork abilities : You are a team player, who takes responsibility for what they do and who is able to collaborate in an international environment with excellent communication skills
We encourage you to apply even if your profile does not yet meet all the requirements for the position. At Haiilo we support your personal development as well as your individuality, no matter what background you have.
What you'll do:
- You are the first point of contact for all BI topics, from architecture to reporting issues and will have an integral role in data in data projects, collaborating with engineers and business stakeholders to gather requirements and deliver data solutions that support business needs
- Design and implement robust, scalable data pipelines to collect, process, and store data from various sources
- Develop and maintain ETL (Extract, Transform, Load) processes to ensure data integrity and availability
- Optimize and maintain data warehouses and databases to ensure high performance and reliability
- Implement and enforce data governance policies and procedures to maintain data quality, consistency, security and compliance
- Create and maintain documentation for data processes, systems architecture, and data models
- Monitor and troubleshoot data pipeline performance, identifying and resolving issues promptly
