Data Engineer at Areka Consulting | InternshipEiquem

Areka Consulting is an independent consulting firm providing global companies with tailored, end-to-end Business Travel Management solutions.
Created in 2010 by four founders based in Paris and Sydney, the company has grown rapidly and now brings together a team of around 40 employees across France, the United States, the United Kingdom, Australia, Belgium, and Germany.

Areka supports organizations worldwide — including many Fortune 500 companies and some of the world’s largest corporations such as L'Oréal, Microsoft and McKinsey.
Today, 20 of the CAC40 companies are Areka clients, reflecting the strong trust placed in the firm.

Our missions cover the full spectrum of business travel management: building travel strategies, supporting global organizations in supplier negotiations (airlines, hotels, travel agencies, online booking tools), designing travel policies, consolidating travel data, and delivering advanced dashboards and reporting solutions.

Joining Areka means integrating a company with a strong culture rooted in teamwork, care, and work-life balance. You will evolve in a collaborative and multicultural environment, with regular internal events such as “Chat & Breakfast” sessions, afterworks, “Lunch & Learn”, team-building activities, and company seminars.

Are you eager to join an organization committed to innovation through investing in exceptional talent and driving transformation in the business travel industry? Do you aspire to work in a flexible, dynamic, and professional environment where your ideas have the potential to become products that will propel the growth of our consulting firm?

Areka Consulting is expanding its Data Solutions team to support upcoming client projects and strengthen its internal data capabilities. In this context, the company is looking for its next Data Engineer | Intern to join the Data Solutions team, composed of 7 people from very diverse backgrounds, whose mission is to make intelligent use of the very rich and massive business travel data Areka has access to in order to solve complex questions. Working alongside the Data & Business Intelligence Engineer, you will contribute both to client deliveries and the evolution of internal tools and data infrastructure, gaining hands-on experience with modern BI and ETL technologies in an international environment.

Your missions:

You will carry out most of your tasks within the Data Solutions team to support the consulting team working for major global clients.

Client deliveries (reporting, dashboards & data quality...) (≈ 75%)

• Prepare, clean, transform, and model data using Excel, Python and SQL

• Produce monthly reports, dashboards and KPIs across ~5 client projects in parallel

• Apply and maintain data quality procedures, both manual and automated

• Ensure consistency and harmonization across multiple data sources

• Communicate results and insights to internal stakeholders and international clients

Tools improvement & R&D (≈ 25%)

• Support the improvement and evolution of existing ETL pipelines

• Assist in maintaining the data infrastructure

• Contribute to the development of new Data & BI tools using technologies like Azure Data Factory, Azure Databricks...

• Participate in R&D initiatives, including the creation of new data products (e.g. carbon emissions calculation, new datasets)

• Write and update documentation for data procedures and processes

• Currently pursuing a Master’s degree in Engineering, Data, Mathematics, Statistics, or Computer Science

• Excellent proficiency in Excel and Python (Pandas, Seaborn...)

• Ideally, good knowledge of SQL (joins, aggregations)

• Familiarity with at least one BI tool: Power BI, Spotfire, Tableau, QlikView, etc.

• Familiarity with at least one ETL tool: Azure Data Factory, Google Cloud Dataflow, Informatica, Alteryx, Talend, SSIS, etc.

• Excellent level of spoken and written English (French is a plus)

• Curious, proactive, analytical, and eager to learn

• Enjoy working with data and taking initiative in a fast-paced environment

• A multicultural, international and flexible environment, with English as a daily working language

• The opportunity to work with globally renowned companies (Fortune 500, CAC 40 clients such as BNP, L’Oréal, AXA…)

• A small, friendly and collaborative team, eager to share knowledge

• A structured onboarding with a 1-month training program :

  • First two weeks focused on tools, missions, clients and team integration

  • Daily support from your Manager 

• A phone interview with a recruiter from Eiquem's team

• A technical test on Python & Excel to do at home

• A interview with the Data & Business Intelligence Engineer 

• A final interview with the Data Solutions Manager