Data/System Architect (m/w/d) – SQL, ETL & Data Warehouse
Core
Design and evolve the target architecture for the central AFZS (Automatic Passenger Counting Systems) data platform, ensuring stable operation and data quality for regional bus transport.
Role type
Senior Data/System Architect (ETL & Data Warehouse)
Builds
Central data platform for passenger counting systems and operational background systems for transport consortium companies
Domain
Public transport (ÖPNV) / Data Engineering
Deliverable
production ML models | product features
Required skills
Data platform architecture design, ETL/ELT process development, SQL (modeling, querying, optimization), Data Warehouse concepts, Integration architecture design, Performance analysis and optimization
Preferred skills
Power BI or similar BI platforms, Technical project management
Responsibilities
Develop technical target architecture for AFZS data landscape, Conceive and evolve data models and integration interfaces, Establish monitoring and data quality management mechanisms, Optimize data flows from ingestion to reporting, Analyze technical challenges and performance bottlenecks, Coordinate architecture and development tasks within the team
