Data Engineer

OpenClassrooms makes education and career mobility accessible to everyone, everywhere.

We are the leading online education platform in Europe and Africa, offering fully accredited online diplomas based on the skills of the future and gathering a passionate community of 2 million students a month from around the world.

Welcome to the education revolution! #BecomeFutureProof 

We are looking for a Data Engineer to join OpenClassrooms reporting directly to the Tech Director – to democratize data insights in all areas of OpenClassrooms.

This is a new role at OpenClassrooms and the successful candidate will be confident in coming in and establishing it to add value as quickly as possible. 

This role requires an analytical and business-oriented mindset with the ability to implement rigorous database solutions and best practices in order to produce strong quality data insights to drive business decisions. This role can be fully remote or office-based. In recognition of the fact that most of the business activity is currently in France –  it would make sense for the successful candidate to be based there or in the UK and to be a fluent English and French speaker.

RESPONSIBILITIES

 As a Data Engineer, you will act as software engineers who have a particular focus on data movement, data transformation and orchestration:

• Build and maintain data pipelines from internal databases and SaaS applications

• Maintain our data warehouse with timely and quality data

• Create and maintain architecture and systems documentation

• Write maintainable, performant code

• Implement the DataOps philosophy in everything you do

• Plan and execute system expansion as needed to support the company’s growth and analytic needs

• Collaborate with Data Analysts to drive efficiencies for their work

• Collaborate with other functions to ensure data needs are addressed

COMPETENCIES REQUIRED

• 2+ years hands-on experience deploying production quality code

• Professional experience using Python, Java, or Scala for data processing (Python preferred)

• Knowledge of and experience with data-related Python packages

• Demonstrably deep understanding of SQL and analytical data warehouses (Redshift preferred)

• Hands-on experience implementing ETL (or ELT) best practices at scale.

• Hands-on experience with data pipeline tools (Airflow, dbt)

• Strong data modelling skills and familiarity with the Kimball methodology.

• Experience with Salesforce, Zuora, Zendesk as data sources and consuming data from SaaS application APIs.

• Constantly improve product quality, security, and performance

• Desire to continually keep up with advancements in data engineering practices

• Catch bugs and style issues in code reviews

• Ship small features independently

REPORTING LINE

Reports to Tech Director

HIRING PROCESS

The journey starts with a phone interview with XXX (HR team member) (30 minutes).

For the 1st round of interviews we plan face to face meetings with:

• Jonathan Lefebvre (Tech Director), (30 minutes)

• XXX, (HR Team Member) (1 hour)

For the 2nd round of interviews, you plan to:

• Take a technical assessment (business or study case,…) to be done at home or at the office (2 hours)

• Take an English or French test to be done at home (at your own pace)

For the final round, we plan face to face with:

• 2 or 4 peers from teams across the organization to discuss the Culture and Values at OpenClassrooms (2 hours)

• Meet with CTO (1 hour)

If you reach the final round, you will be asked to provide us with 5 professional references contact detail

Feel free to get the gist of who we are: https://openclassrooms.com/courses/how-do-we-work-at-openclassrooms

WHAT WE OFFER

Benefits are dependent on location, but may include:

• Remote working encouraged for employees based in FR or UK

• For Paris-based office employees – Pass Navigo paid by OpenClassrooms

• Health insurance for free (“Mutuelle” monthly fee entirely paid by OpenClassrooms)

• Meal vouchers (Employer contribution at the max authorized by law)

• Access to gym for free (Gymlib paid by OpenClassrooms)

• Unlimited days off and a 1.000€ premium once a year for 15+ days off taken

• A company MacBook

• A work environment and a strong culture built on agility, openness, respect and high quality

OpenClassrooms is a French hyper-growth company eligible to the French Tech Visa program. That means, for foreign candidates, benefiting from the accelerated procedure to apply for a “Talent Passport” residence permit. There is also a simplified “accompanying family” procedure available for spouse and dependent minor children.

More information here: https://visa.lafrenchtech.com/4/french-tech-visa-for-employees

We are an equal opportunity employer that values diversity and welcomes everyone who wants to join us and make education accessible. We are at an exciting moment and we deeply believe that various backgrounds and experiences will lead to a better product for our students.

Working at OpenClassrooms means joining a dynamic and stimulating team, take up challenges, meet awesome people every week, and change the world, a little bit, every day!