Junior Data Engineer (FAP-BC-ENG-2024-135-GRAE) (2024)

The European Council for Nuclear Research (CERN) is a premier research institution specializing in particle physics, where groundbreaking experiments probe the fundamental nature of matter and the universe. CERN’s innovative experiments, including the Large Hadron Collider, push the boundaries of scientific knowledge and technological development. By fostering international collaboration, CERN serves as a global hub for advancing fundamental science and exploring the universe’s deepest mysteries.

JOB SUMMARY

Job Description

Your responsibilities

Are you a Data Engineer with a passion for managing and optimizing data pipelines?

Do you thrive on transforming raw data into actionable insights and enjoy working with a variety of data tools and technologies? Are you excited about the prospect of working in an agile environment and being part of a self-organized team?

Then join our team of talented engineers and contribute to maintain and develop CERN’s Corporate Information Systems! Take part!
You will join the Business Computing (BC) group.

Our team is responsible for the operation and the further development & evolution of CERN’s core financial and procurement systems supporting the entire organization.

The type of products under your responsibility will range from custom-made solutions for a few users to large and widely integrated systems with 15,000+ users.

Working with us provides numerous perspectives for being in touch with different technologies and business areas.
Specifically, you will take on the following responsibilities:

  • Design, develop, and test data models and extractions (ETL), using Pentaho Data Integration (and other Data Integration tools/techniques), SQL, PL/SQL, R and Python;
  • Interact with relational databases using SQL;
  • Extract and visualize data in forms, reports and interactive dashboards;
  • Configure and write software to integrate data from standard third-party provided software solutions run on premise or available in the cloud;
  • Maintain, support and enhance existing (legacy) systems;
  • Provide end user support and carry out data migrations and software upgrades.

Your profile

Skills and/or knowledge

If you are excited about this role but your past experience does not align perfectly with every qualification in the job description, we encourage you to apply anyway.

You may just be the right candidate for this or other roles!

  • Experience in working with data warehouses, data integration / ETL tools and business intelligence solutions;
  • Experience with relational databases and SQL;
  • Experience with version control systems, particularly, Git;
  • Initial experience with reporting/dashboarding tools and techniques (e.g.

Pentaho Report Designer, CTools, Power BI, R, Shiny, Python);

  • Ability to work collaboratively in an Agile self-organised team environment;
  • Comfortable in working with both new and legacy systems.
  • Fluent in English, the ability to work in French would be an advantage.

Each of the following would be a plus:

  • Understanding of ERP systems and their integration with other systems;
  • Knowledge of CI/CD tools like GitLab or equivalent;

Eligibility criteria:

  • 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 IT, Software/Systems Engineering (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

Job closing date: 01.09.2024 at 23:59 (midnight) CEST.

Job reference: FAP-BC-ENG-2024-135-GRAE

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

Target start date: 01-November-2024

What we offer

  • A monthly stipend ranging between 5134 and 5647 Swiss Francs (net of tax).
  • Coverage by CERN’s comprehensive health scheme (for yourself, your spouse and children), and membership of the CERN Pension Fund.
  • Depending on your individual circumstances: installation grant; family, child and infant allowances; payment of travel expenses at the beginning and end of contract.
  • 30 days of paid leave per year.
  • On-the-job and formal training at CERN as well as in-house language courses for English and/or French.

About us

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.

Diversity has been an integral part of CERN’s mission since its foundation and is an established value of the Organization.

Employing a diverse workforce is central to our success.

REQUIRED EDUCATION: Bachelor Degree

EXPERIENCE REQUIREMENTS: 60

Junior Data Engineer (FAP-BC-ENG-2024-135-GRAE) (2024)

FAQs

What is expected of a junior data engineer? ›

A Junior Data Engineer is responsible for collecting and storing data from various sources. This may involve designing and implementing data collection systems, integrating data from different databases, or acquiring data from external sources.

Why is data engineering so tough? ›

Simply put, hard work and dedication to the craft. I've seen a lot of fence-sitters and wafflers in my time. To get ahead in Data Engineering, you need nothing but single-minded determination for the projects you work on and your personal goals as a Data Engineer. There are no shortcuts to mastery.

How to crack data engineering interviews? ›

How to Prepare for the Data Engineer Interview
  1. Master SQL: You should practice creating, modifying, and managing databases. ...
  2. Solve coding challenges: Solve Python, Scala, or C++ coding challenges. ...
  3. Design an ETL pipeline: practice to create data, ETL, or delivery pipelines.

Are data engineers hard to find? ›

The Data Engineering role is ranked 8th which makes it one of the most booming jobs. This means that now it's harder than ever for companies to hire and retain talents in this flourishing industry.

How much does a junior data engineer earn in USA? ›

How much does a Junior Data Engineer make? As of Aug 8, 2024, the average annual pay for a Junior Data Engineer in the United States is $71,799 a year. Just in case you need a simple salary calculator, that works out to be approximately $34.52 an hour. This is the equivalent of $1,380/week or $5,983/month.

How much does a junior data engineer make in NYC? ›

Junior Data Engineer Salary in New York City, NY
Annual SalaryWeekly Pay
Top Earners$106,121$2,040
75th Percentile$87,500$1,682
Average$74,666$1,435
25th Percentile$53,100$1,021

Is data engineering math heavy? ›

In general, data engineering is not math-heavy.

Is data engineering a lot of coding? ›

Coding is important for data engineers. They work on data processing, building data pipelines, and designing data architectures. Strong programming skills are needed for these tasks. Important programming languages for data engineering education include Python, SQL, Scala, and Java.

Is data engineering a good career in 2024? ›

A career in data engineering offers a unique blend of technical challenges, growth opportunities, and tangible impact on business success. The numbers speak for themselves: The global big data services market is projected to hit $77.37 billion by 2024. *

Is data engineering for introverts? ›

Being an introvert in the field of data engineering can feel like a paradox. While the technical skills excel in quiet, focused work, the collaborative nature of the field often demands communication, networking, and even presentations.

What is the hardest aspect of being a data engineer? ›

As a Data Engineer, you know how crucial it is to have reliable customer data. Without it, it's almost impossible to do your job! But capturing clean behavioral data is often easier said than done. It usually requires complicated manual work.

How many rounds of interview for data engineer? ›

Understanding the Data Engineer Interview Process

The on-site interview will have three to four rounds that include: A round based on Python, SQL, and big data frameworks. Two to three rounds on core data engineering concepts. A behavioral interview round.

Is data engineer stressful? ›

Data Engineers often work on critical systems where performance is paramount. The pressure to ensure that data systems are efficient, reliable, and secure can be a constant source of stress, which may spill over into personal time as they strive to meet or exceed performance expectations.

Who pays the most for data engineers? ›

Popular companies for a Data Engineer
  • Amazon. $116K - $161K. /yr. $135K. ...
  • Meta. $221K - $317K. /yr. $262K. ...
  • Amazon Web Services. $117K - $163K. /yr. $137K. ...
  • Cisco. $199K - $270K. /yr. $230K. ...
  • Amazon. $159K - $238K. /yr. $193K. ...
  • IBM. $110K - $151K. /yr. $129K. ...
  • Capital One. 3.9. $116K - $150K. /yr. ...
  • Cognizant Technology Solutions. $86K - $122K. /yr. $102K.

Is it possible to get a data engineer job with no experience? ›

Becoming a data engineer may seem like a daunting task, especially if you have no prior experience in the field. However, with the right approach and a lot of dedication, you can pave the way towards a successful career in data engineering.

What is expected of a junior engineer? ›

Common duties for junior engineers include: Testing engineering components. Identifying potential project obstacles. Developing actionable solutions.

What does an entry level data engineer do? ›

What does a data engineer do?
  • Acquire datasets that align with business needs.
  • Develop algorithms to transform data into useful, actionable information.
  • Build, test, and maintain database pipeline architectures.
  • Collaborate with management to understand company objectives.
Aug 14, 2024

What are the responsibilities of a data engineer? ›

Responsibilities
  • Analyze and organize raw data.
  • Build data systems and pipelines.
  • Evaluate business needs and objectives.
  • Interpret trends and patterns.
  • Conduct complex data analysis and report on results.
  • Prepare data for prescriptive and predictive modeling.
  • Build algorithms and prototypes.

How to get a junior data engineer role? ›

For a junior data engineer, the following are required:
  1. University degree in Computer Science or Mathematics.
  2. Coding skills (Python and/or Scala)
  3. SQL (Oracle/MySQL/PostgreSQL) — Select/DML/DDL and Analytical SQL.
  4. Proficiency in Linux commands, operating systems, and the ability to write shell scripts.
Oct 12, 2023

Top Articles
Latest Posts
Recommended Articles
Article information

Author: Edmund Hettinger DC

Last Updated:

Views: 5341

Rating: 4.8 / 5 (58 voted)

Reviews: 89% of readers found this page helpful

Author information

Name: Edmund Hettinger DC

Birthday: 1994-08-17

Address: 2033 Gerhold Pine, Port Jocelyn, VA 12101-5654

Phone: +8524399971620

Job: Central Manufacturing Supervisor

Hobby: Jogging, Metalworking, Tai chi, Shopping, Puzzles, Rock climbing, Crocheting

Introduction: My name is Edmund Hettinger DC, I am a adventurous, colorful, gifted, determined, precious, open, colorful person who loves writing and wants to share my knowledge and understanding with you.