Data Engineer
Stellenbeschreibung
About The Company
Neue Pressegesellschaft mbH & Co. KG is a major media company with a workforce of approximately 3,400 people. Its central digital unit, NPG Digital, develops and markets digital products for audiences and businesses across Brandenburg and Baden-Württemberg.Its portfolio includes news platforms such as moz.de, lr.de, stuttgarter-zeitung.de, stn.de, and swp.de. NPG Digital combines the flexibility and innovative spirit of a focused digital team with the stability of an established media group. The working culture is collaborative and informal, with flat hierarchies, open communication, and strong team connections.
About The Role
As a Data Engineer, you will help advance NPG Digital’s data platform, from processing event and business data to developing trusted models in the data warehouse.Your main focus will be data modeling: building clear, reliable structures that support analytics, dashboards, A/B testing, personalization, and better business decisions. You will work across data pipelines, the warehouse, and analytics, collaborating closely with Data Engineers, Analytics Engineers, Data Analysts, and business teams.
You will help shape the architecture of the data warehouse and establish reusable standards for the wider organization. As AI-assisted development becomes more common, your understanding of business logic and sound data design will be especially valuable. You will translate requirements into precise specifications, guide coding agents where appropriate, and review their work for technical quality and business accuracy.
Qualifications
- Several years of professional experience in Data Engineering or a comparable role.
- Practical experience with dimensional modeling, particularly Kimball methods, including fact and dimension tables, star schemas, conformed dimensions, historical data, and incremental models.
- Strong SQL skills and experience transforming large datasets with dbt or a comparable tool.
- Experience developing and operating data pipelines, ideally handling high-volume event data.
- Experience with a cloud data warehouse; BigQuery experience is preferred.
- Good Python skills and confident use of Git, shared development standards, and code reviews.
- Very good German skills, at least C1 level.
- The ability to understand business logic, create precise technical specifications, and critically assess the results produced by coding agents.
Responsibilities
- Design and implement dimensional data models, including facts, dimensions, star schemas, and conformed dimensions.
- Build performant One Big Tables and wide tables, and model historical data using slowly changing dimensions and snapshots.
- Develop the dbt-based warehouse architecture and contribute to shared modeling standards.
- Build and operate pipelines for event and business data, including terabyte-scale Snowplow data and incremental processing.
- Optimize BigQuery performance and costs through appropriate partitioning, clustering, and efficient query design.
- Strengthen data quality through testing, monitoring, and clear documentation.
- Help improve orchestration, CI/CD, Kubernetes-based infrastructure, and Infrastructure as Code.
- Clarify requirements and business logic with colleagues and stakeholders, document specifications, and review implementation outcomes.
- A permanent position in a financially stable media company.
- Meaningful influence on the data platform and data warehouse architecture.
- A modern technology environment using dbt, BigQuery, Snowplow, and Lightdash, with substantial datasets and practical use cases.
- Individual professional and personal development opportunities.
- An informal, supportive culture with flat hierarchies and short decision-making paths.
- A collaborative team, regular team events, corporate benefits, discounted public transport, and sports offerings.
Equal Opportunity
Neue Pressegesellschaft mbH & Co. KG is committed to a respectful and inclusive workplace. We welcome applications from qualified candidates with different backgrounds, experiences, and perspectives. Employment decisions are based on qualifications, skills, and role-related requirements.Interessiert an dieser Stelle?