End of Studies Internship - Analytics Engineer M/F - Paris

The mission:

Through the internship, you will have the opportunity to apply your skills, learn from experts, and contribute to concrete and impactful projects.

Being a consultant means participating in projects that address both technical challenges and business-oriented issues, and that concern various sectors of activity (luxury, retail, banking/insurance, industry, etc.).

Our missions combine a technical and operational dimension allowing you to deepen your knowledge on innovative subjects. You will be involved in the entire data lifecycle to develop and maintain our clients' strategic data applications. During your projects, you will be led to work on the following elements: Collection, Integration, Structuring, Reporting.

• You will participate in the identification/investigation of source data and the implementation of data feeding tools/connectors (ETL / ELT),

• You will be responsible for structuring the data model as well as transforming source data into key performance indicators (KPIs),

• You will use monitoring techniques and analysis/dataviz tools to meet the needs of business teams.

• You will develop your programming skills, combined with your proactivity, to industrialize and generalize necessary analyses.

Here are some concrete examples of recent internships:

• Retail: Implementation of ELT pipelines with DBT on a Snowflake platform to harmonize data, then reconstruction of dashboards on Tableau with new sources.

• Luxury: Development of ML model performance monitoring dashboards with dataviz tools (e.g., Looker and Grafana), based on logs generated via Airflow.

• Energy Industry: Refactoring of ETL code to use more efficient techniques (e.g., parallelization, SQL optimization), and implementation of unit and integration tests to ensure data reliability.

• Insurance / Banking: Optimization and maintenance of an ETL related to a claims solvency report.

Lab’ AVISIA:

In addition to our client missions, we conduct various internal projects that fuel our research and development. These projects give us the opportunity to offer our clients innovative analytical approaches, tested in real-world scenarios.

To support these initiatives, we have set up our own infrastructures. Our consultants thus benefit from the latest resources and market solutions for their learning, including "early adopter" versions to test before their general release.

Our commitments:

After implementing a solid internal CSR policy, we decided to dedicate our skills to projects focused on sustainable development. A dedicated initiative was born: AVISIA Impact.

This initiative is therefore our response to make a direct contribution (through our projects) and indirect contribution (through the training of our teams) to the challenges of sustainable transformation. We want to facilitate the emergence of future transformation actors and accelerate the pace of change.

For more information on these data initiatives for sustainable transformation, please consult our dedicated page.

The human aspect:

We are therefore looking for talents who have:

• Excellent interpersonal skills,

• A desire to be involved in the success of client projects,

• Strong analytical and synthesis skills,

• A particular emphasis on the quality of deliverables and presentation,

• Curiosity and a commitment to staying informed about market developments,

• A desire to continue learning to be an active participant in their own progression.

The skills:

You are in your final year of data studies at university or a higher education institution and possess the following skills:

• Knowledge of the main principles of the data lifecycle (Collection, Ingestion, Storage, DataViz...)

• Good knowledge of SQL and Python,

• Familiarity with technological platforms such as Google Cloud, AWS, Microsoft Azure, Snowflake, or Databricks.

• Bonus: Knowledge of a market ETL/ELT software solution (DBT, Airflow, Talend), data processing and analysis tool (e.g., BigQuery, Snowflake, Databricks, ...) or reporting implementation tool (Tableau, PowerBI, Qlik, SAS Visual Analytics, ...).