Stage Data Analyst / Data Engineer Supporting Marketing F/HOrange

Company: Orange, Europe Division, Finance and Strategy Department

At the heart of developments in the digital world, Orange is an international telecommunications group with a turnover of more than EUR40 billion in 2024, bringing together more than 290,000 customers and 127,000 employees in 26 countries around the world. With societal issues at the heart of its strategy, Orange has chosen as its raison d'être: 'Giving everyone the keys to a responsible digital world.'

The Europe Division comprises six countries (Belgium, Luxembourg, Moldova, Romania, Slovakia, and Poland) and monitors the activities of its joint venture in Spain. It is a region of growth, innovation, and transformation. The mission of the Europe Division is to provide a solid foundation for the success and sustainable growth of the group's telecommunications subsidiaries in Europe.

Within the Europe Marketing Department, the Data & AI team supports Orange subsidiaries in Europe by defining and deploying Artificial Intelligence projects across various business areas, including networks, customer relations, marketing, sales, and support functions. This team works with the seven countries in the Europe zone (Belgium, Luxembourg, Slovakia, Poland, Romania, Moldova) to implement transformation programs. Additionally, the team is responsible for steering their activities to meet Orange Group's performance objectives.

The Data & AI / Marketing Europe team has launched a project to create a Data Lake on GCP for the Europe region, along with a visualization solution in Power BI. The goal is to automate data collection from different countries and group-wide tools, ingest it into GCP for various business lines (Finance, Marketing, Sales, HR, etc.), and design dashboards specific to each domain to facilitate business performance monitoring via Power BI.

As part of this project, you will contribute to:
- Defining and structuring the KPI framework for all business domains.
- Identifying and mapping the available data sources across the six countries in the Europe zone.
- Automating the ingestion of data into GCP, ensuring quality, consistency, and reliability.
- Supporting the project team (comprising a project director and two project managers) in all project management activities, including:
- Gathering and defining business requirements for each dashboard.
- Preparing Steering Committees (SteerCo).
- Reporting and tracking the progress of different work streams.
- Risk management.
- Ensuring the smooth operation of the Data Lake, including managing GCP folders, access permissions.
- Maintaining, updating, and developing data democratization tools, as well as data products to meet business user needs.
You will be part of a multidisciplinary team, combining expertise in data architecture, data engineering, data analysis, data visualization, data product ownership, as well as business owners from various domains (Finance, Marketing, Sales, cross-functional projects) at both the group and country levels.
In direct collaboration with teams from the six countries in the Europe zone, you will be actively involved in all phases of the project.
This includes building the KPI repository to ensure consistency and standardization of performance indicators, as well as identifying and mapping available data sources across the different countries and group-wide tools.
You will also contribute to automating the ingestion of structured data into GCP, ensuring its quality and reliability, while participating in the implementation and optimization of the Data Lake to centralize and facilitate data access.
Finally, you will play a key role in the development and deployment of analytical dashboards in Power BI, enabling business teams to monitor their activities efficiently and make informed decisions.

Location : 44-46 Avenue de la République, 92320 CHATILLON

Required Education and Experience:
- Engineering school specialization in Data & Cloud (Bac + 5)
- Previous experience in a corporate setting, with at least one or more significant internships in data, cloud, or software development environments.
Required Skills and Personal Qualities:
- Strong knowledge in Data Engineering, Data Analysis, and Public Cloud, particularly in:
- GCP tools: BigQuery, Cloud Storage, Cloud Functions, Airflow...
- DevOps practices: CI/CD, Terraform.
- Data ingestion automation tools: GCP-native tools (Pub/Sub, etc.).
- Programming and querying languages: SQL, Python.
- Visualization and reporting: Power BI.
- Fluent in English (minimum C1 level) as all communication, professional interactions, and documentation are conducted exclusively in English.
- Beyond technical skills, you have:
- A strong analytical mindset and the ability to solve problems logically and efficiently.
- Creativity, rigor, and proactiveness in improving processes and data solutions.
- Proficiency in PowerPoint, with the ability to create impactful presentations within short deadlines.
- Excel skills for data analysis, projections, and simulations.
- A strong team spirit, an ability to collaborate with diverse profiles, and openness to teamwork to ensure project success..
- 6 months intership