You'll join the Data & Analytics Engineering craft at Dailymotion, to create and maintain data products. The Analytics Engineering team focuses on providing reliable data for analysis company wide. This includes building and managing our multi-petabyte data warehouse, highly scalable client-facing analytics, data ingestion & distribution, and data synchronization systems. As a Senior Analytics Engineer, you'll blend software engineering and data skills to maintain code and model data effectively. If you're eager to solve challenging business problems, this role offers a broad impact across all of Dailymotion's businesses. 

Our stack runs almost exclusively on Google Cloud Platform. You will 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). You will also 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 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. 

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 Flexible
• 🍼  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) 

🔍Want to learn more about us: 

• Dailymotion.com 
• New-York office - BuiltIn 
• Offices in France - Welcome to the Jungle 
• Our articles  

• Minimum 5 years of experience in Data Analytics.  

• Fluent in both English (pro level) and French. 

• Advanced SQL skills 

• Strong leader, 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. 

• Strong ability to draft technical specifications and strong understanding of data modeling techniques (e.g star, snowflake, medallion) 

• 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  

• Advanced experience with cloud-based data warehouses, particularly BigQuery/Snowflake and how to optimize their costs 

• 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. 

• Demonstrated ability to mentor and guide junior team members 

If you meet these qualifications and are passionate about leveraging data to drive insights and innovation, we encourage you to apply.