Data & Reporting Specialist (FAP-BC-DL-2026-203-GRAE)

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.

At CERN, the European Organization for Nuclear Research, we are pushing the frontiers of science and technology. Our groundbreaking work brings together not only physicists but also a diverse range of professionals from engineering, technical, scientific, and administrative fields. Together, we foster an environment where innovation and collaboration thrive. Every day, we face exciting new challenges and opportunities to contribute to cutting-edge research that shapes our understanding of the universe. We meet these challenges through the diverse perspectives within our teams, ensuring every contribution is valued and driving our shared sense of inclusion and purpose. Diversity is a core value of CERN since its foundation, and it remains central to our mission and continued success.

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

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

• You are a national of a CERN Member or Associate Member State.

• By the application deadline, you have a maximum of two years of professional experience since graduation in Computer Science (or a related field) and your highest educational qualification is either a Bachelor's or Master's degree.

• You have never had a CERN fellow or graduate contract before.

• Applicants without University degree are not eligible.

• Applicants with a PhD are not eligible.