For the Schiphol Group we are looking for a Data Analyst / BI developer
To design and build a new set of Power BI dashboards for the Deepturn product. These newly created insights will help stakeholders (airport, ground handlers, and airlines) understand and improve their process performance based on a set of KPIs related to the turnaround process.
Projectdoel
The goal of this project is to develop a new dashboard that visualizes predefined turnaround Key Performance Indicators (KPIs). This dashboard will display historical turnaround event data and compare it with the airport’s set goals for each turnaround sub-process (e.g., Power Connected). Currently, Deep Turnaround only generates raw detection data. This data needs to be processed using Python or SQL scripts to generate KPIs for visualization in the new dashboard.
Hoog niveau dashboardvereisten
1. Data Visualisatie:
- Visualize historical turnaround event data.
- Benchmark data against airport-set goals for each sub-process.
- Process raw turnaround data using Python or SQL scripts to generate KPIs.
- Provide access to the dashboard for client airports by sharing a pre-developed PBIX file or by offering role-based access to Power BI environments hosted by Aviation Solutions/Schiphol.
- Include a tabular view to display turnaround events and indicate compliance with the established KPIs.
Verwachte projecttijd
- ETL Deepturn data preparation: 4 days
- ETL Flight data processing: 4 days
- Power BI dimensional model creation: 2 days
- Process airport KPIs in the model using Python/SQL: 5 days
- Create measures (Power BI): 10 days
- Develop the front-end (Power BI): 5 days
- Total time: 30 days (approximately 6 weeks)
Vaardigheden
- Processing and transforming our complex raw backend data into usable datasets for Power BI.
- Modeling tables and relationships in Power BI to ensure an efficient logical data structure.
- Writing DAX measures and calculations to effectively visualize data.
- Thinking critically about dashboard functionality and structure to meet user needs.
- Applying the right data visualizations to effectively communicate insights and improve decision-making.
- Working with large datasets and optimizing Power BI performance.
Ervaring
- 3+ years of experience with SQL and Python for data processing and transformation.
- 3+ years of experience with Power BI, including a solid understanding of DAX and data modeling.
- Proven experience in designing and building intuitive, interactive dashboards.
- Experience in translating business requirements into data products or insights.
- Proactive, independent, and able to collaborate effectively within a team.
Eisen
- 3+ years of working in SQL and Python for data processing and transformation.
- 3+ years of working with Power BI, including a solid understanding of DAX and data modeling.
- Proven experience in designing and building intuitive, interactive dashboards.
- Experience in translating business requirements into data products or insights.
- Proactive, independent, and able to collaborate effectively within a team.
- A VGB or VOG is required for assignments at Schiphol.
- The candidate is required to have proof of identity (passport or identity card), which is valid at intake and at the start date of the candidate’s contract.
Wensen
- Process and transform our complex raw back-end data into usable datasets for Power BI.
- Model tables and relationships in Power BI to ensure an efficient logical data structure.
- Write DAX measures and calculations to effectively visualize data.
- Think critically about dashboard functionality and structure to meet user needs.
- Apply the right data visualizations to effectively communicate insights and improve decision-making.
- Work with large datasets and optimize Power BI performance.