What you'll do

Are you passionate about data, problem-solving, and turning complex information into clear insights? Do you enjoy maintaining and improving data systems, from legacy databases to modern reporting platforms? Join our agile, self-organised team of engineers to help maintain and develop CERN's Corporate Information Systems! Take Part! You'll be part of the Business Computing (BC) group, supporting Finance and Procurement.

Your mission: analyse, improve, and help modernise reporting and data solutions, while supporting the transformation of CERN's enterprise systems and ensuring that future analytics needs are properly understood and addressed.

Your responsibilities

Extract, transform, model, and visualise data in reports, dashboards, and analytics platforms.
Interact with relational databases, mainly Oracle, using SQL and PL/SQL.
Develop, maintain, and test reporting data models and semantic models supporting CERN's Finance and Procurement systems.
Maintain, support, and enhance existing reporting and data solutions while helping define and implement their future evolution.
Contribute to data profiling, mapping, quality checks, validation, and reconciliation activities during migration and transition phases.
Contribute to the development and maintenance of ETL/ELT pipelines and other data-processing activities where required.
Collaborate with business users, functional experts, architects, and developers to ensure data consistency, usability, and technical feasibility.
Support testing, troubleshooting, documentation, maintenance, and third-level support for reporting and data solutions.

Still here? Let's make a quick check about

Your profile

Experience in SQL (writing, optimising, debugging complex queries).
Familiarity with data visualisation or analytics tools such as Power BI, R, or Python-based dashboards.
Understanding of data modelling principles (dimensional/star schema design, semantic models, data warehouses).
Experience analysing data structures, flows, and dependencies in complex enterprise systems.
Exposure to data pipeline concepts and tools such as SQL, dbt, Airflow, or Python for data processing.
Interest in maintaining and modernising reporting and data solutions during a systems transformation.
Interest in providing end-user support, troubleshooting, escalation, and issue resolution.
Awareness of Finance and Procurement processes or interest in learning about business domains.
Experience working in group projects, ideally in collaborative or Agile environments.
Your studies focused on Computer Science.

Your skills

Excellent knowledge of SQL and relational databases.
Knowledge of data visualisation and analytics tools, particularly Power BI.
Ability to contribute to the design and maintenance of data models for reporting and analytics.
Ability to understand and document complex data structures, data flows, dependencies, and transformation logic.
Awareness of data quality, security, and governance concepts.
Attention to detail and commitment to data accuracy.
Knowledge of version control systems and basic interaction with Linux servers via the command line.
Knowledge of Agile practices and experience maintaining reporting solutions and data pipelines in an agile environment.
Comfortable in working with both new and legacy systems.
Excellent communication skills and the ability to present complex information effectively.
Spoken and written English, with a commitment to learn French.