Data Engineer – BigQuery & Platform Evolution (m/f/d)

Predict42; Mainz; Vor Ort; EUR 60.000 - 90.000; Vollzeit

Benefits dieser Stelle

Stock options

Research time

Pension plan contributions

Team events

Zusammenfassung

Predict42 in Mainz seeks an experienced Data Engineer (m/f/d) with a strong data warehousing background to reinforce our platform team. You will ensure operational reliability, optimize our data architecture, and lay the foundation for strategic milestones.

You will shape, build, and operate high-performing data warehouse structures and analytical models using Google BigQuery, Dataform, or dbt. Join a team embracing modern software practices, equity, and flexible work options.

Qualifikationen

• 1 to 3 years of professional experience in data engineering, data warehousing, or a similar role.
• Strong SQL skills for crafting complex queries, modeling analytical layers, and handling large datasets.
• Practical experience using Python to implement pipelines and automate tasks.
• Hands-on experience with Google BigQuery in production environments and with Dataform/dbt.
• Experience with Git-based workflows, CI/CD, and automated quality checks.
• German (B2 minimum) and fluent English (written and spoken).

Aufgaben

• DWH & Data Modeling: shape, build, and operate data warehouse structures optimized for BigQuery.
• SQL Transformations: design, test, and optimize complex data models using Dataform, dbt, or similar tools.
• Migration Projects: contribute to migrating workloads from ClickHouse to BigQuery.
• Data Pipelines & Semantic Layer: engineer robust ETL/ELT pipelines and a consistent semantic layer.
• Testing & Standards: establish automated testing, data validation, and monitoring across pipelines.
• Software Best Practices: apply version control, code reviews, CI/CD, and automated testing to data workflows.

Kenntnisse

SQL

Python

Data warehousing

CI/CD

Git-based workflows

Tools

Google BigQuery

Dataform

dbt

Git

Jobbeschreibung

We at Predict42 are the "AI-first" B2B SaaS scale-up behind the MIGO Feedback Hub. We transform scattered feedback for global market leaders into actionable knowledge – with AI as the true core of our product, rather than just a trendy feature.

As we transition from a startup to an enterprise scale-up, we are looking for an experienced Data Engineer (m/f/d) with a strong data warehousing background to structurally reinforce our platform team. In this role, you will ensure operational reliability, optimize our data architecture, and lay the foundation for our strategic milestones.

Responsibilities

• DWH & Data Modeling: You shape, build, and operate high-performing data warehouse structures and analytical models natively optimized for Google BigQuery.
• SQL Transformations: Design, develop, test, and optimize complex, maintainable, and high-performance SQL-based data models using Dataform, dbt, or comparable transformation frameworks.
• Migration Projects: Contribute directly to the modernization of our data platform and drive the migration of existing data warehouse workloads from ClickHouse to BigQuery—including data models, transformations, pipelines, and validation.
• Data Pipelines & Semantic Layer: You engineer robust, fault-tolerant ingestion and ETL/ELT pipelines and model a consistent semantic data layer for reliable downstream data delivery.
• Testing & Standards: Establish and continuously improve automated testing, data validation, and monitoring standards across all data pipelines.
• Software Best Practices: Apply modern software engineering practices—such as version control, code reviews, CI/CD, and automated testing—to elevate our data workflows.

Qualifications

• Experience: 1 to 3 years of professional experience in data engineering, data warehousing, or a similar role. You work highly independently and thrive when taking on real responsibility.
• Focus on SQL & Data: Strong SQL skills for crafting complex queries, modeling analytical layers, and handling large datasets with ease.
• Python & Automation: Practical experience using Python to implement pipelines, automate operational processes, and replace recurring manual tasks.
• Cloud & Tools: Sound 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: Solid foundation in Git-based workflows, CI/CD, and automated quality checks, paired with a pragmatic approach focused on reliability and maintainability.
• Language: German (B2 Minimum) and fluent English (written and spoken) for seamless collaboration in our international team.

EARN:Salary + Equity

We foster an entrepreneurial culture by offering a virtual stock option program.

we offer mix of remote and on-premise work, combining the best of both worlds

GROW:Research Time

all employees have blocked research time per week at their disposal.

we subsidize up to 20% of you pension plan / direct insurance via salary conversion

COMPASSION: Care

we care and support you, if you go through a difficult time at some point in your life.

BOND: Team Building

we organize different team events, including a super exciting offsite each year.