Data & Reporting Specialist

The Data & Reporting Specialist will analyse, improve, and help modernise reporting and data solutions, supporting the transformation of CERN’s enterprise systems and ensuring future analytics needs are met. The role involves maintaining and developing data systems, reporting data models, and collaborating with business users and technical teams.

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.

Requirements

• You are a national of a CERN Member State or Associate Member State, excluding Pakistani, Lithuanian, Latvian, Cypriot and Croatian nationals due to ceiling limits.
• By the application deadline, you have a maximum of 2 years of professional experience since graduation in the respective field.
• Your highest educational qualification is either a bachelor’s or master’s degree; you must have a university degree and cannot hold a PhD.
• You have never had a CERN fellow or graduate contract before.
• 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.

Skills

• SQL Query Writing
• SQL Query Optimisation
• SQL Debugging
• Data Visualization
• Power BI
• R Programming
• Python Dashboards
• Data Modelling
• Dimensional Schema Design
• Star Schema
• Semantic Models
• Data Warehouse
• Data Analysis
• Data Pipeline Concepts
• dbt
• Airflow
• Python Data Processing
• Reporting Solutions
• IT End User Support
• Technical Troubleshooting
• Issue Resolution
• Finance Processes Awareness
• Procurement Processes Awareness
• Agile Methodologies
• Collaborative Project Work

Languages

English, French