ETL optimisation:

• Guarantee the scalability of the dataflows and analysts’ queries
• Define and implement good practices for table structures
• Implementation of a star schema, update of the tables’ data types and indexes…
• Design and execution of measures to contain the load on the warehouse, and identification and improvement of the heaviest workflows

Code good practices:

• Definition of the team’s guidelines to keep the repository’s code quality at a high standard
• Package code building blocks to speed up team development
• Update of the CI/CD processes to ensure the team’s scripts and queries are tested before deploys

Data quality:

• Design of test queries that will help improve accuracy in the company’s data before it is made available to the users
• Design of workflows, queries and table structures that will prevent inconsistencies

Leading technical choices:

• Find, test and set up tools, frameworks and technologies to improve efficiency, scalability and security of Aircall dataflows

Hard Skills:

• Python
• SQL
• Aware of the specificities in a Data Warehouse context (nice to have: Redshift)
• Docker
• Nice to have: Airflow
• Nice to have: implementing a CI/CD

Soft Skills:

• Rigorous and cautious
• Eager to learn (learnable)
• Curious
• Team player (like to work for others)
• Open to learn how to communicate efficiently

1- Phone interview with our really cool Talent Acquisition team
2- On-site (or video) interview with our Awesome tech team
3- Technical Case
4- In person debrief over your case @ Aircall
5- Lunch/Social Time with the team