Vacantes en Massy, Francia

Orange Cyberdefense, an Orange Group company, is one of the world's leading cyber security services and solutions providers and enjoys 25 years’ experience in the field of global information security, providing products and services for leading organisations in over 160 Countries.

We are building a safer digital society, protecting individual and corporate freedom across geographies.

Working as an Analytics Engineer

Our ISS development teams within Global Operations design, build, and run mission-critical data services and closely related systems. We’re strengthening our data and reporting capabilities so our analysts and leaders can make fast, informed decisions. You’ll help structure our data for reporting needs and evolve our data warehouse to deliver trusted, self-service analytics across the organization.

As an Analytics Engineer focused on Data & Reporting, you will design and maintain data models, pipelines, and data products that power operational reporting and analytics. You’ll collaborate with security analysts and stakeholders to translate reporting requirements into robust warehouse schemas, semantic layers, and dashboards. You’ll apply strong CI / CD and testing practices to ensure the reliability, accuracy, and security of our analytical datasets. This role includes participation in an on-call rotation and offers growth in a hybrid work environment.

Key Responsibilities

• Translate reporting and analytics needs into scalable data models (star / snowflake), conformed dimensions, and data marts.
• Evolve the data warehouse architecture and schema design to support new use cases and performance goals.
• Build and maintain ETL / ELT pipelines in Python / SQL; orchestrate workflows and enforce data quality checks.
• Implement a semantic / metrics layer to support consistent KPIs and enable self-service analytics.
• Define and run data quality tests, anomaly detection, lineage, and documentation to improve trust in data.
• Integrate diverse data sources (operational systems, relational DBs, Elasticsearch, APIs, message queues).
• Optimize performance (partitioning, indexing, clustering, materialized views) for reporting and ad-hoc analysis.
• Maintain security, confidentiality, and integrity of data in line with relevant regulations; implement RBAC and data masking where appropriate.
• Partner with analysts to design dashboards and reporting assets; enable BI best practices and governance.
• Participate in the on-call rotation to ensure data pipelines and services remain reliable.

• Advanced SQL and data modeling skills (dimensional modeling, SCDs, normalization vs. denormalization).
• Strong Python for data processing (e.g., pandas, SQLAlchemy) and building ETL / ELT with automated testing.
• Experience with CI / CD for data (Git, code reviews, data tests using dbt / Great Expectations or similar).
• Experience with at least one of : PostgreSQL, MySQL / MariaDB, or Elasticsearch.
• Orchestration and transformation tools (e.g., Airflow / Prefect and / or dbt).
• Comfortable with Linux, Docker, and Git.
• BI / visualization experience (e.g., Power BI, Tableau, Looker, Superset, or Metabase) and dashboard design fundamentals.
• Writing tests gives you confidence in your code.
• Willingness to work in an on-call rotation.
• Full professional proficiency in English (written and verbal) essential

• Experience with message queues and streaming (RabbitMQ, Kafka).
• Exposure to modern cloud warehouses (Snowflake, BigQuery, Redshift) or columnar / time-series stores (ClickHouse, TimescaleDB).
• Experience with Kubernetes for deploying data workloads.
• Data catalog / lineage tooling (DataHub, OpenLineage, Amundsen) and metrics layer design (dbt metrics, LookML, semantic layers).
• Security telemetry analytics experience and governance for sensitive data (RBAC, masking, GDPR).

• Never stop learning - We want to be the best in what we do and therefore we provide training, certifications and learning opportunities for every employee so you continuously enrich your skills.
• Transparency - Communication is key! So we organize company and team meetings on a regular base so everyone is informed properly.
• Snack to your heart's desire - At Orange Cyberdefense we keep it healthy. So, you can enjoy an assortment of fresh fruit and healthy snacks. For those with an occasionally sugar dip, there are sweet snacks available.
• Reputable brand - You will join an internationally, growing company with over 25 years experience in the industry. This makes us experts in what we do. We have an international presence and yet local teams to assist our customers.
• The good life ...

Are you interested? Then jump in!

Orange Cyberdefense are equal opportunities employer, welcoming applications from all people, regardless of their race, sex, disability, age, religion, or sexual orientation.