Job
In this role, you will develop data warehouse structures in Google BigQuery, optimize SQL transformations, and assist in migrating existing workloads from ClickHouse while establishing robust data pipelines and standards.
This listing has been machine translated. Show original
Job technologies
Your role in the team
- DWH & Data Modeling: Development and operation of data warehouse structures and analytical data models in Google BigQuery.
- SQL transformations: design, development, testing, and optimization of complex, maintainable, and high-performance SQL-based data models using Dataform, dbt, or a comparable transformation framework.
- Migration project: Collaboration in the modernization of our data platform and the migration of existing Data Warehouse workloads from ClickHouse to BigQuery - including data models, transformations, pipelines, and validation.
- Data Pipelines & Semantic Layer: Design, development, and operation of robust ingestion and ETL/ELT pipelines, as well as modeling a consistent semantic data layer for reliable data provisioning.
- Testing & Standards: Establishment and improvement of automated testing, data validations, and monitoring standards.
- Software best practices: Application of modern software engineering practices such as version control, code reviews, CI/CD, and automated testing in our data workflows.
Our expectations of you
Qualifications
- Focus on SQL & Data: Very good SQL skills for complex queries and large data volumes.
- Python & Automation: Utilizing Python to implement pipelines, automate operational processes, and replace repetitive manual tasks.
Experience
- Experience: Three to five years of professional experience in Data Engineering, Data Warehousing, or a comparable role. You work very independently and are willing to take responsibility.
- Cloud & Tools: Extensive hands-on experience with Google BigQuery in a production environment as well as practical experience with Dataform or a comparable SQL transformation framework (e.g., dbt).
- Engineering mindset: Experience with Git-based workflows, CI/CD, and automated quality checks. You have a pragmatic working approach focused on reliability and maintainability.
What we offer
- Salary: €3,879.11 - €5,233.92 per month.
Benefits
Work-Life-Integration
Topics you will work on
Job locations
About your employer
Predict42 GmbH, based in Mainz, focuses on data- and software-based solutions. Its main emphasis is on AI, cloud, and platform topics, as well as the development and provision of corresponding software solutions. The company is described as an emerging AI/software company.
- Startup
- Onsite, Hybrid
- Internet, IT, Telecommunication
More jobs
These jobs might also interest you
Hello, let's say WE! We - the HUK-COBURG Insurance Group - are among the top 10 in Germany. Founded over 90 years ago, we are now the leading insurer for private households with over 13 million customers and the largest German auto insurer. Our...
The role As a Forward Deployed AI Engineer, you go directly into our specialist departments, understand the processes, and develop production-ready AI and automation solutions that will fundamentally change the way the entire GGW Group operates. You do...
You’ll be joining at a stage where we’re building and evolving our new CRM platform. That’s exactly what makes this role special: you won’t just develop features—you’ll actively help shape the technical foundation of a modern CRM ecosystem. Together...
