Data & Reporting Engineer — Hybrid, Power BI & SQL

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

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