Group Data Engineer

at  Stage Entertainment

Amsterdam Headoffice Full time IT Other
Stage Entertainment is one of the world’s leading theater producers and owners. We have offices and theaters across Europe and produce the world’s biggest titles, such as &Juliet, MJ, the Blue Man Group, Moulin Rouge, Disney’s The Lion King, Alladin and Frozen as well as in-house developed productions such as TINA-The Tina Turner Musical on Broadway and West-End and are touring in several countries with it.
Stage Entertainment is owned by Advance Publications Inc. based in New York. Advance is a family-owned company that operates globally and invests in a wide range of media, communication, and technology businesses globally.
Passion connects us
Our strong passion for live entertainment, musicals and first-class theater performances is what connects us at Stage Entertainment. This common bond turns a colorful mix of people from a wide variety of professions into one dedicated team: a true “we”. A team that does exceptional work by always striving for the best. A team that knows how to thrill millions of spectators with extraordinary shows on all our stages across Europe. We want to share our passion with you, too. That’s why we’re looking for you!
Data Engineer here is where your challenge starts:

As a data engineer at Stage Entertainment you play a vital role in making data accessible, reliable, and usable for various data-related tasks within an organization. You bridge the gap between raw data and valuable insights, enabling data-driven decision-making across departments and teams. The data engineer will be responsible for designing, building, and maintaining the data infrastructure of the global organization that supports data interchange, generation, enrichment, transformation, and storage.

• Design and develop data models that align with business requirements and facilitate data analysis and reporting; work with data scientists and analysts to ensure data models meet their needs.
• Design, develop, and maintain data pipelines to efficiently and reliably move data from various sources into our BigQuery data warehouse using Fivetran as the data integration tool; collaborate with data analysts and stakeholders to understand data requirements and ensure seamless data integration.
• Develop Extract, Transform, Load (ETL) processes to cleanse, transform, and prepare data for analysis and reporting; monitor and troubleshoot ETL processes to ensure data quality and reliability;
• Manage and optimize our BigQuery data warehouse to support fast and efficient data querying and analysis.
• Implement best practices for data partitioning, clustering, and optimization in BigQuery.
• Utilize Google Cloud Platform (GCP) to deploy and manage data infrastructure.
• Work with Fivetran configurations and integrations to optimize data extraction from various data sources.
• Implement data governance policies and security measures to protect sensitive data and ensure compliance with industry regulations.
• Continuously monitor data pipelines, data flows, and data storage systems to identify and address issues promptly; monitor and optimize data pipelines and data warehouse performance to reduce latency and enhance data processing speed.
• Collaborate with data scientists, analysts, and other stakeholders to understand data needs and deliver solutions.
• Communicate technical concepts and solutions effectively to non-technical team members.
• Maintain documentation for data pipelines, data models, and data infrastructure to enhance knowledge sharing and facilitate future maintenance

Qualifications and experience:

• Bachelor’s degree (master is preferred) in Computer Science, Data Engineering, or a related field (or equivalent experience).
• Minimum of 2 years work experience in similar position.
• Fluent in English. Working knowledge of German, Dutch, Spanish or French will be a plus.
• Proven experience as a data engineer.
• Excellent knowledge of data pipelines and ETL processes, data modelling, SQL and Python.
• Hands on experience with: Cloud-based data warehousing (preferably BigQuery) and data processing technologies, Cloud Infrastructure, preferably Google Cloud, Data Build Tool(DBT) and Git version control.
• Experience with PowerBI and CI/CD (Github actions) is a plus.
• Up to date with developments in Data Engineering.
• Experience with Scrum and Agile methodologies

You are highly motivated, and have a strong business insight, able to build strong relationships with stakeholders in various roles and levels. You thrive in a fast-paced, dynamic and international environment.
Your contributions as a Data Engineer will have a profound impact not only on Stage Entertainment Headquarters but also on the broader organization.

What does Stage Entertainment offer?

• 25 vacation days, 1 D&I day and 2 designated days off from Stage Entertainment.
• Competitive salary in line with the market.
• Good pension scheme and travel allowance.
• Great if you work in the office, but we also offer the opportunity to work partially from home.
• The opportunity to work remotely for two weeks at a destination of your choice.
• We value your personal development, that’s why there are plenty of opportunities for training and education.
• Your work makes an impact both Stage Entertainment headquarters and internationally. You will work with diverse, passionate colleagues all over Europe.

Are you excited to join us as a Data Engineer?
Let’s arrange a meeting to discuss the exciting opportunities that await you!
We encourage you to apply for this vacancy, even if you don’t fit all qualifications. We are looking for candidates of all backgrounds and the candidates will be considered without regard to race, color, religion, sex, national origin, age, sexual orientation, gender identity, gender expression or disability. We realize that a diverse mix of colleagues gives us access to a wide range of ideas, perspectives and insights that allow us to touch hearts and create memories. Please find more information about our D&I initiatives: https://www.stage-entertainment.com/de

• Design and develop data models that align with business requirements and facilitate data analysis and reporting; work with data scientists and analysts to ensure data models meet their needs.
• Design, develop, and maintain data pipelines to efficiently and reliably move data from various sources into our BigQuery data warehouse using Fivetran as the data integration tool; collaborate with data analysts and stakeholders to understand data requirements and ensure seamless data integration.
• Develop Extract, Transform, Load (ETL) processes to cleanse, transform, and prepare data for analysis and reporting; monitor and troubleshoot ETL processes to ensure data quality and reliability;
• Manage and optimize our BigQuery data warehouse to support fast and efficient data querying and analysis.
• Implement best practices for data partitioning, clustering, and optimization in BigQuery.
• Utilize Google Cloud Platform (GCP) to deploy and manage data infrastructure.
• Work with Fivetran configurations and integrations to optimize data extraction from various data sources.
• Implement data governance policies and security measures to protect sensitive data and ensure compliance with industry regulations.
• Continuously monitor data pipelines, data flows, and data storage systems to identify and address issues promptly; monitor and optimize data pipelines and data warehouse performance to reduce latency and enhance data processing speed.
• Collaborate with data scientists, analysts, and other stakeholders to understand data needs and deliver solutions.
• Communicate technical concepts and solutions effectively to non-technical team members.
• Maintain documentation for data pipelines, data models, and data infrastructure to enhance knowledge sharing and facilitate future maintenanc