Mid Analytics Engineer (All genders)

Responsibilities

• Work in an environment made up of Data Lakes (BigQuery, etc.), orchestration and scheduling platforms (Airflow), container-oriented deployment and management platforms (Docker, K8S, JenkinsX), SQL, Data Quality Tools (DBT, Sifflet).
• Participate in data modeling activities and design of data flows until their implementation and support in production.
• Expose the data through various means such as datamarts and flat files for both internal and external users.
• Build complex and efficient SQL queries to transform data within our data lake into reliable business entities and reporting aggregates.
• Identify and manage dependencies for these transformations, scheduling them using tools like Airflow.
• Investigate discrepancies and quality issues in the data, as well as addressing performance issues.
• Design optimized and cost-efficient data models in BigQuery while addressing business use cases.
• Ensure data cleanliness, consistency, and availability by performing data quality checks and implementing monitoring.
• Catalog and document various aspects of the data, including business entities, datamarts, dimensions, metrics, and business rules.
• Serve as a subject matter expert on business entities and datamarts, providing training to users on SQL and analytics best practices.
• Innovate by proposing new tools, processes, documentation, and exploring emerging technologies during designated cool-down periods.

What we offer you

• Additional opportunities as we grow and learn together.
• Join our open, collaborative culture.
• Exciting, dynamic projects to work on.
• Flexibility.

For the France offices

• Hybrid Work Framework (4 types of remote work: Full office / Flex office (1/2 days remote) / Flex remote (1/2 days at the office) / Full remote + ability to work 3 months abroad)
• Saving Plan Vivendi
• Paternity leave or Coparental leave extended
• Living Employee Culture (Events / Trainings / Parties / All hands / Dailymotion tradition…)
• Career development support (training / internal mobility / compensation cycle / 360 quarter feedback review …)
• High-end Health Insurance and Personal Services Vouchers (CESU)
• Paid Time off – RTT and Saving time plan (CET)
• Meal Vouchers – Public Transport and Bike refund
• European Economic and Social Committee (sport membership / cinemas vouchers / gift vouchers / discount)