Mid Analytics Engineer (All genders)

Dailymotion is the leading video discovery destination & technology that learns about your tastes over time, constantly surfacing the best, most relevant content on the web. Our mission is to provide the best video user experience for consumers on the market, connecting publishers and advertisers to engaged viewers who turn to Dailymotion for their daily fix of the most compelling music, entertainment, news and sports content around.Through partnerships with the world's leading publishers and content creators, France Télévisions, Le Monde, CBS, Bein Sports, CNN, GQ, Universal Music Group, VICE and more, Dailymotion commands 3 billion monthly pageviews across its mobile app, desktop and connected TV experiences. Dailymotion is owned by Vivendi, one of the largest mass-media corporations in the world.At Dailymotion, we‘re storytellers. We build the best place for people to enjoy the videos that matter. We do this through utilizing and developing cutting-edge technology and pushing the envelope to bring discoverable stories to life through premium content from the world’s best publishers. We do this by helping these publishers grow their audiences and monetize their content, their way.Dailymotion is proud to be an equal employment opportunity and affirmative action employer. We value inclusion and we want you to help us thrive for a more diverse community.Our team context:Dailymotion is seeking an Analytics Engineer to join the Data Engineering Teams. Our craft is responsible for most of the Data products at Dailymotion; your work will have an impact throughout Dailymotion’s business and help make data-driven decisions on products and strategy.You'll join the Data 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 an 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.Responsibilities:Ingest extensive volumes of raw data from both internal and external sources using batch and streaming methods.Expose the data through various means such as APIs, 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.Design Druid datasets tailored for external consumers, prioritizing speed, consistency, cost-effectiveness, and efficiency.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.QualificationsRequired skills:Minimum of 2 years of experience in Data Analytics.Fluent in both English (pro level) and French.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.Hands-on experience in building and managing analytics pipelines.Capable of making informed decisions based on business opportunities.Motivated to work on building batch and streaming data pipelines to handle a high volume of events.Proficiency in various programming languages such as Python, Golang (preferred) and Java with a focus on matching development standards to ensure the delivery of reusable and high-quality code.Hands-on experience with different types of databases and strong SQL knowledge.Experience in establishing and maintaining unit, integration, and end-to-end tests.Experience in automating deployments using tools such as Docker, Kubernetes and Datadog.Proficiency in monitoring systems and tools for ensuring the health and performance of data pipelines.Good level knowledge on how to analyze, design, or improve the efficiency, scalability, and stability of data collection, storage, and retrieval processes.If you meet these qualifications and are passionate about leveraging data to drive insights and innovation, we encourage you to apply.What we offer you:Additional opportunities as we grow and learn together.Join our open, collaborative culture.Exciting, dynamic projects to work on.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 VivendiPaternity leave or Coparental leave extendedLiving 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 refundEuropean Economic and Social Committee (sport membership/cinemas vouchers/gift vouchers/discount) #J-18808-Ljbffr