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.
Employment conditions
- Work during nights, Sundays and official holidays, when required by the needs of the Organization.
Global Benefits at CERN
Let's get you ready
Be sure to meet the eligibility criteria
- You are a national of a CERN Member State or Associate Member State. Currently, we cannot consider applications from Pakistani, Lithuanian, Latvian, Cypriot and Croatian nationals, as the ceiling defined under Article II.5 of the Associate Membership Agreement has been reached.
- By the application deadline, you have a maximum of 2 years of professional experience since graduation in the respective field and your highest educational qualification is either a bachelor’s or master’s degree. You must have a university degree and can’t hold a PhD.
- You have never had a CERN fellow or graduate contract before.
- Please pay attention to the additional criteria and requirements for this specific position and mentioned above.
You will need these documents to complete your application
- Your CV (English or French)
- A copy of your most relevant diploma or a certificate of achievement from your school (if you don't yet have your paper diploma)
- Any document you consider relevant to your application