Data Engineer

Company Description:
At CERN, the European Organization for Nuclear Research, physicists and engineers are probing the fundamental structure of the universe. Using the world's largest and most complex scientific instruments, they study the basic constituents of matter - fundamental particles that are made to collide together at close to the speed of light. The process gives physicists clues about how particles interact, and provides insights into the fundamental laws of nature. Find out more on http://home.cern.

Job Description/Introduction:
Are you an experienced and motivated data engineer with a passion for data modeling? Are you at ease with analysis, design and implementatoin of data pipelines and not afraid to optimise database queries, to dive into data integration processes or to configure and debug messaging/eventing systems? Then join an agile team of talented software developers and contribute to application software for CERN's Corporate Information Systems. CERN, take part!

You will join the Platforms Section of the BC Group (Business Computing) in the FAP Department (Finance and Administrative Processes), where 70+ talented international colleagues are responsible for delivering information systems for all of CERN's business functions.

The Platforms section is responsible for the maintenance and development of the CERN FHR sector's reporting and data integration processes (e.g. finances, human resources, procurement...).

The product management driven group supports clients across the whole Organisation (HR, Finance, Planning, Safety, Security, Purchasing, Logistics, and Accelerator Operations). The type of products under the Group's responsibility ranges from custom-made solutions for a few users to large and widely integrated systems with 15,000+ users. Hence, working for the BC Group provides numerous perspectives for being in touch with different technologies and business areas.

Functions:
As a Data Engineer, you will join a self-organised agile product team and you will be responsible for maintaining, evolving, and re-engineering CERN's administrative information systems, aligned with the group's strategy to modernise, replace, and consolidate legacy architectures and business-critical applications. More specifically, you will take on the following responsibilities:

- Design, implement and test data pipelines for data ingestion and data transformation across streaming and batch data flows
- Develop data models and architectures. Convert data into relevant datamarts.
- Participate in and lead cross-team technical initiatives and deliver proof of concepts demonstrating product feasibility.
- Maintain and improve group-wide high standards and guidelines of software engineering practices.
- Identify areas of improvement in the technology landscape of the group and recommend solutions.
- Mentor junior software developers.
- Provide user support including analysing user requirements, synthesizing, specifying and following-up on both software- and non-software related issues.

Qualifications:
Master's degree or equivalent relevant experience in the field of computer science or a related field.

Experience:
- Demonstrated experience with SQL, PL/SQL and Oracle databases
- At ease with modern data warehouse design and architecture principles, patterns, and their application in the data integration ecosystems
- Demonstrated experience in the design and development of ETLs built on top industry standards (Pentaho Data Integration - PDI, Airflow and similar)
- Proven experience with event streaming platforms (Kafka)
- Experience with BI solutions and reporting tools such as Power BI
- Demonstrated experience with modern monitoring tools (Prometheus, Grafana)
- Proven experience of modern software development life cycle and DevOps processes (incl. build/test/deployment tool chain)

Any of the following experience would be a plus:
- Experience developing and maintaining solutions with R Shiny
- Experience with large-scale data processing (Spark)

Technical competencies:
- Architecture and design of ICT systems: deep understanding in data architectures and data design patterns.
- Knowledge of best practices for developing secure software: knowledge of vulnerabilities (as defined by OWASP), and how to prevent them.
- Design of databases/repositories: experience with relational databases and database modelling.
- Re-use, refactoring, integration and porting of existing software: working effectively with legacy code through continuous improvement, refactoring, and technology migration. Provide re-usable components that can be shared between multiple repositories.
- Knowledge and application of software life-cycle tools and procedures: working in lean-agile environments with methodologies such as Scrum or Kanban, issue tracking systems, Git, dependencies and build tools.

Behavioural competencies:
- Working in teams: Working well in groups and readily fitting into a team; participating fully and taking an active role in team activities. Cooperating constructively with others in the pursuit of team goals; balancing personal goals with team goals. Sharing and letting others participate in own work/project; encouraging team development.
- Demonstrating accountability: Working conscientiously and reliably; delivering on promises. Taking responsibility for own actions and decisions Readily admitting to mistakes.
- Communicating effectively: Delivering presentations in a structured and clear way; adjusting style and content to the audience; responding calmly and confidently to questions. Expressing opinions, ideas and suggestions with conviction and in a logical/structured manner; keeping to the point. Demonstrating a pro-active approach to resolving differences; addressing issues of conflict constructively.
- Solving problems: Recognizing what is essential; discriminating between important and peripheral information and being able to see the whole picture Identifying, defining and assessing problems, taking action to address them. Seeking and integrating other points of view when tackling an issue; consulting experts in the field and undertaking benchmarking.

Language skills:
English spoken and written, with the ability to draw-up specifications and/or reports, and/or to make oral presentations. The ability to understand and speak French or an undertaking to acquire it.