Functieomschrijving
What you will do
You’ll be a strategic partner to Product Managers, Engineers, and the Business Design, build, and maintain dbt models powering our behavioral analytics and event-tracking pipeline, one of the largest and most actively used parts of our data platform, processing high-volume clickstream data daily
Data Curation & Modeling, own and improve analytical data modeling practices across projects
Help evolve our data governance framework by improving our Governance projects, ranging from data compliance to access control
Monitor and optimize the performance of our dbt pipelines and Looker infrastructure, proactively identifying automation and cost-efficiency opportunities
Collaborate with Data Engineers, Data Analysts, and stakeholders across teams to keep our modeling standards consistent and well understood
Review code within our analytics projects to help the team maintain best practices as we grow
Contribute to improving data infrastructure, from pipeline health to Looker usage
Get to the bottom of data issues, determine root causes and build solutions that resolve them permanently, not just patch symptoms
AI adoption, contribute to initiatives for unlocking AI in our analytical and reporting processes (DWH/BI Tooling)
If you are passionate about Data, enjoy working on challenging business problems in a fast-moving environment, and believe in the importance of teamwork, then this could be the right opening for you.
Responsibilities
Design and implement data models with SQL in DBT
Build explores and dashboards in Looker to allow others at the company to ask the right data questions
Deep dive into large business datasets to uncover valuable insights that can be turned into actionable hypotheses
Work with Product Managers, Developers, Marketeers, and Commercial Specialists to determine and measure the right metrics in their respective domains
Keep a close eye on the ever-changing data challenges at Tiqets, and collaborate closely with Strategic Analysts, Data Engineers, Data Scientists, and other Data Analysts on the team to solve them
Educate and empower others at the company to be more self-reliant for their data needs
Mentor others in the team with technical guidance
Collaborate on the architectural evolution of the Tiqets data model and reporting framework
What you will bring
3+ years of experience working as a Data or Analytics Engineer on data-intensive applications
Strong SQL skills and hands-on experience with dbt for data modeling and transformation
Proven track record of working with a modern cloud data warehouse like Databricks, Redshift, Snowflake, or BigQuery
Experience with Apache Airflow or a comparable orchestration tool
Python proficiency, with a track record of writing clean, maintainable code
Experience with Looker or a comparable BI/semantic-layer tool
Experience with cross-functional/cross-team collaboration, with excellent oral and written communication skills
Capacity to thrive in a scale-up environment, pragmatic attitude, ability to work independently, collaborate effectively with others, and take ownership of your work
Living in the Netherlands/EU
Nice to Have
Experience with data access control and masking patterns in dbt
Familiarity with data governance, security, and regulatory compliance considerations (e.g., GDPR, SOX, PCI DSS) as they apply to data platforms and data warehouses.
Curiosity about data observability and lineage tooling
For this role, we have a salary bracket of €4,200 to €5,200 per month. Your specific placement within the range will be determined by your professional background and experience
Perks & Benefits at Tiqets
Energetic, international work environment
Bright, welcoming office located in the centre of Amsterdam
Tiqets learning academy: skill lab, group & individual learning
Annual company getaway to undisclosed location
Mental health support through our partnership with OpenUp
Daily fresh lunch buffet provided by Join Programs
Sports activities: free gym, running sessions, boot-camp, football, climbing and more
Fun, sociable company events in and out of the office
20% employee discount code to explore great museums/venues worldwide
Pension contribution and travel compensation
Our Data Analytics Stack
DBT
Looker Databricks Airflow Tiqets is an innovative ticketing platform that is revolutionizing the way visitors discover, buy and use tickets for museums, shows and attractions.