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

CERN; Genf; Hybrid; CHF 59.000 - 65.000; Vollzeit

Benefits dieser Stelle

30 days leave per year

Health insurance

Pension fund

Relocation package

Hybrid work

Language training

Zusammenfassung

CERN in Geneva is seeking a Data Analysis & Reporting Specialist to maintain and modernise reporting data solutions across Finance and Procurement. You will analyse, transform, and model data, build dashboards, and collaborate with engineers in an agile environment.

You bring strong SQL, Power BI, data modelling, and experience with Oracle, dbt, Airflow, and ETL pipelines. This 24-month contract offers hybrid work, 40 hours weekly, in a vibrant international setting with training and relocation

Qualifikationen

• Familiar with data visualisation or analytics tools such as Power BI, R, or Python-based dashboards.
• Understanding of data modelling principles (dimensional/star schema, 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.

Aufgaben

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

Kenntnisse

SQL/PLSQL

Power BI

Python

Data modelling

ETL/ELT pipelines

Agile

English comms

French learning

Ausbildung

Bachelor's or Master's in CS/IS

Tools

Oracle

dbt

Airflow

Linux

Jobbeschreibung

• Full-time
• Compensation: CHF 5266 - CHF 5793 - monthly

Job Description

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.

Your profile:

Data Analysis & Reporting:

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

Business Processes & User Support:

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

Skills:

Data & Analytics:

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

Data Governance & Quality:

• Awareness of data quality, security, and governance concepts.
• Attention to detail and commitment to data accuracy.

Technical Environment:

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

Additional Information

Contract duration: 24 months, with a possible extension up to 36 months maximum.

Working hours: 40 hours per week

Job flexibility: Hybrid

This position involves:

• Work during nights, Sundays and official holidays, when required by the needs of the Organization.

Field of work: Data Science & Data Analytics

Benchmark job: 200020 - Computing Engineer

• A monthly stipend between 5266-5793Swiss Francs per month (tax free) depending on your degree.
• 30 days of paid leave per year plus 2 weeks annual closure.
• Coverage by CERN’s comprehensive health insurance scheme (for yourself, your spouse and children), and membership of the CERN Pension Fund.
• Family, child and infant monthly allowances depending on your individual circumstances.
• A relocation package (installation grant and travel expenses) depending on your individual circumstances.
• Possibility to extend your contract up to 36 months.
• On-the-job and formal training including language classes.

Overview of CERN -Discover a world where the impossible is made possible!

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.

If you are ready to be part of a dynamic, inclusive community pushing the boundaries of knowledge, CERN is the place where your curiosity and skills can thrive. Be part of our mission to uncover what lies at the heart of the universe!