Analytics Engineer

Orange Cyberdefense; Île-de-France; Hybride; EUR 45 000 - 65 000; Plein temps

Résumé du poste

A leading cybersecurity company is seeking an Analytics Engineer to design and maintain data models for reporting and analytics while ensuring data accuracy and reliability. The ideal candidate has advanced SQL and Python skills, strong knowledge of CI/CD practices, and is proficient in BI tools. Join a hybrid work environment that promotes continuous learning and transparency.

Prestations

Training and certification opportunities

Healthy snacks available

Transparent communication

Qualifications

• Advanced SQL skills and dimensional data modeling experience.
• Proficient in Python for building ETL/ELT processes.
• Experience with CI/CD practices for data workflows.
• Experience with at least one database technology.
• Comfortable working with orchestration tools.

Responsabilités

• Translate reporting requirements into scalable data models.
• Build and maintain ETL/ELT pipelines using Python/SQL.
• Implement data quality tests and documentation.
• Integrate diverse data sources for comprehensive analytics.
• Partner with analysts to design dashboards.

Connaissances

Advanced SQL and data modeling skills

Strong Python for data processing

Experience with CI / CD for data

Experience with PostgreSQL

Orchestration tools experience

Linux and Docker knowledge

BI/visualization experience

Writing tests

Full professional proficiency in English

Outils

PostgreSQL

Docker

Git

Airflow

Power BI

Description du poste

Overview

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.

What we are looking for

• 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

What makes you stand out

• 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).

What you can expect from us

• 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.