Role Overview
Join our Data Team as a Junior Data Engineer (m/w/d) at CKM Group and help build our data platform. You will work closely with an experienced Data Engineer, develop data models, and create the foundation for meaningful dashboards and data-driven decisions while gradually taking on more responsibility in Data Engineering.
Responsibilities
- Develop and maintain Data Vault data models using dbt (Hubs, Links, Satellites) for existing and new data sources.
- Build Data Marts as the data basis for Grafana dashboards, coordinating structure and content with analysts.
- Support migration of PowerBI dashboards to Grafana and convert calculation logic into structured, tested SQL models.
- Maintain and extend Airflow DAGs for orchestrating and automating data pipelines.
- Ensure data quality by creating and evolving tests and documentation in dbt.
- Work with Spark to efficiently process larger data volumes when needed.
- Assist with platform operations, monitoring, error analysis, and pipeline restarts.
- Collaborate with the Data Engineer through pairing and code reviews, gradually taking ownership of data infrastructure.
Requirements
- Completed degree or comparable training in Computer Science, Data Science, Business Informatics, or related field; motivated career changers with practical knowledge welcome.
- Good SQL skills with ability to independently create structured queries using joins and aggregations.
- Basic Python knowledge for smaller scripts or data processing.
- Basic understanding of data modeling (facts and dimensions, relational databases, normalization).
- First practical experience with data through internships, working student roles, study projects, or own projects.
- Willingness to learn new technologies and concepts and develop professionally in Data Engineering.
- Careful, structured, solution-oriented work style with high quality standards.
- Very good German language skills in speaking and writing.
Nice to Have
- First experience with dbt, Airflow, or Spark.
- Advanced SQL skills (e.g., window functions).
- Experience with Git and version control/code reviews.
- First experience with Data Vault or other data modeling approaches.