Job
- Level
- Experienced
- Job Field
- Data, Database
- Employment Type
- Full Time
- Contract Type
- Permanent employment
- Salary
- 3.879 to 5.233€ Gross/Month
- Location
- Mainz
- Working Model
- Onsite
Job Summary
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.
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.
This text has been machine translated. Show original
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.
This text has been machine translated. Show original
What we offer
- Salary: €3,879.11 - €5,233.92 per month.
This text has been machine translated. Show original
Benefits
Work-Life-Integration
Topics that you deal with on the job
Job Locations
This is your employer
Predict42 GmbH
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.
Description
- Company Type
- Startup
- Working Model
- Hybrid, Onsite
- Industry
- Internet, IT, Telecommunication
Data Engineer Focus Data Warehouse
- Salary
- 3.879 to 5.233€ Gross/MonthNet salary converted from the gross salary in the job ad using tax class I.2.540 to 3.249 € net/Month · Tax class I
- Location
- Mainz
- Working Model
- Onsite
- Diversity
- Open for all genders
