About the Role
Take responsibility for our data warehouse based on BigQuery and dbt Cloud, covering architecture, data models, quality standards, and stack development. Refactor and document the existing setup. Integrate new data sources and develop a canonical ID strategy for Data Warehouse, App, and CRM. Develop the technical Semantic Layer (MetricFlow) based on defined Finance KPIs to ensure consistent and reliable data for all analyses and reports. Collaborate with Finance, Marketing, App Development, and the BI team to create a platform for transparent data and independent data utilization.
Responsibilities
- Take responsibility for our data warehouse based on BigQuery and dbt Cloud – from architecture and data models to quality standards and further development of the entire stack.
- Refactor and document the existing setup.
- Integrate new data sources such as Provet Cloud, Personio, Quinyx, and finance systems.
- Develop a canonical ID strategy that serves as the basis for Data Warehouse, App, and CRM.
- Develop the technical Semantic Layer (MetricFlow) based on defined Finance KPIs.
- Ensure that all analyses and reports are based on a consistent and reliable data foundation.
- Create a platform that provides transparent data and enables independent work with the provided data in collaboration with Finance, Marketing, App Development, and the BI team.
Requirements
- Solid SQL knowledge and experience with BigQuery or a comparable Cloud Data Warehouse.
- Experience with dbt (ideally dbt Cloud), including modeling, testing, and documentation.
- Deep understanding of modern data warehouse architectures (e.g., Star Schema, fact tables, snapshots, and metrics).
- Experience with ELT pipelines and integrating SaaS systems via REST APIs and OAuth.
- Long-term thinking and development of scalable architectures.
- Taking responsibility for topics.
- Careful documentation of work.
- Clear explanation of technical contexts to Finance, Marketing, and management.
Skills
- SQL
- BigQuery
- dbt Cloud
- Data Modeling
- Data Warehousing
- ELT Pipelines
- REST APIs
- OAuth
- Python
- PHP
Location
- Berlin
- Hybrid
Work Type
- Hybrid
Experience Level
- Experienced
Benefits
- 30 days of vacation
- Comprehensive mental health program
- Access to exclusive corporate benefits
About the Company
- We are an active network of small animal practices and clinics throughout Germany.
- Our mission: 'Together we work to create the best experience for animals and people every day.'
- We continuously improve working conditions for veterinarians and veterinary assistants by ensuring family-friendly working hours, modern practice equipment, innovative technologies, and investing in an internal training and further education academy.
- Our network strengthens practice teams and sustainably improves the experience for animals and customers.
- Our community is characterized by diversity within the network.
- We value each other and consider the expertise and goals of every employee.
- We foster exchange between practices.
- As a network, we can overcome the many challenges of the industry, such as staff shortages, high workloads, and outdated practices, and ensure sustainable animal health.
- We are already active in many regions: there we receive and create veterinary care structures.
- Since our founding in 2019, Tierarzt Plus Partner has established itself as a supra-regional network for veterinary practices.
- Our Berlin central team supports the local practice teams in practice management, marketing, personnel, digitalization, and finance.
- Whether at headquarters or on-site at the practice – we are united by our vision: 'Living healthy veterinary medicine, partner-style.'
