Mid Analytics Engineer

Summary

Join Dailymotion's Data Engineering team as an Analytics Engineer and contribute to building and maintaining data products that drive data-driven decisions. You will work with a multi-petabyte data warehouse, scalable analytics, and data ingestion systems, using Google Cloud Platform technologies like BigQuery and Airflow. Responsibilities include building efficient SQL queries, managing data quality, designing data models, and serving as a subject matter expert. The role requires strong SQL skills, experience with cloud-based data warehouses, and proficiency in at least one programming language (Python, Golang, or Java). The ideal candidate is a strong team player with a proactive approach to continuous technical exploration. Dailymotion offers a hybrid work framework, various benefits, and career development support.

Requirements

• Minimum of 2-3 years of experience in Data Analytics
• Fluent in both English (pro level) and French
• Good proficiency with SQL
• Strong team player, actively contributing to continuous improvement and fostering effective collaboration
• Proactive approach to continuous technical exploration, with a keen interest in implementing new technologies and innovative solutions, including prototyping
• Ability to draft technical specifications and good understanding of data modeling techniques (star, snowflake, medallion etc)
• Hands-on experience in building and managing analytics pipelines
• Capable of making informed decisions based on business opportunities
• Proficiency in at least one of the following programming languages: Python, Golang (preferred) or Java
• Hands-on experience with cloud-based data warehouses, particularly BigQuery/Snowflake
• Proficiency in monitoring data quality of datasets and investigating discrepancies
• Good level knowledge on how to analyze, design, or improve the efficiency, scalability, and stability of data collection, storage, and retrieval processes

Responsibilities

• Create and maintain data products
• Build and manage our multi-petabyte data warehouse
• Build highly scalable client-facing analytics
• Build data ingestion & distribution systems
• Build data synchronization systems
• Maintain code and model data effectively
• 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 BQ 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 (collaboration with Business Insight)
• Innovate by proposing new tools, processes, documentation, and exploring emerging technologies during designated cool-down periods

Preferred Qualifications

Proficiency in Golang

Benefits

• Additional opportunities as we grow and learn together
• Join our open, collaborative culture
• Exciting, dynamic projects to work on
• Flexibility
• 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 month abroad)
• Saving Plan Vivendi
• Paternity leave or Coparental leave extended
• Living Employee Culture (Events / Trainings / Partys / 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)