Data Analytics Engineer Senior

About

Astrelya is a Franco-Swiss consulting firm, experiencing very strong growth since its creation in 2017, specializing in digital transformation, operational excellence, and technological innovation. It is composed of 300 passionate experts. The firm supports its clients throughout the transformation cycle, from the scoping phase to operational implementation, with strong expertise in Data/AI, Cloud, DevOps, and agile methods. Astrelya distinguishes itself through a model based on proximity, trust, and a strong human culture, which places employees at the heart of value creation.

Your Mission

As a Senior Data Analytics Engineer, you will be involved in the core of analytical modeling, data product structuring, and data valorization in a Risk (liquidity) context. You will play a key role in transforming transactional data into robust, high-performing analytical models that can be used by the Risk, Finance, and Data teams.

Responsibilities

Concretely, you will:

• De-normalize transactions and transform them into a star schema suitable for analytical uses.
• Design and structure a data product allowing partitioning and clustering according to business analysis axes.
• Collaborate closely with the Risk teams to understand liquidity challenges, key indicators, and regulatory constraints.
• Implement reliable, documented, and industrialized transformation pipelines.
• Ensure the quality, performance, and governance of the exposed data.
• Contribute to the continuous improvement of DataOps workflows and analytical engineering best practices.
• Participate in defining analytical modeling and architecture standards within the team.

Your Future Technical Environment

• Google Cloud Platform
• BigQuery – data warehouse & analytical engine
• DBT – transformation & analytical modeling
• Airflow – orchestration
• DataProc – distributed processing
• Cloud SQL – storage & relational databases
• DataOps, CI/CD, analytical engineering best practices