Analytics Engineer

**What you'll do**: We are looking for an Analytics Engineer to join the team and help us transform the access to healthcare Doctolib aims at creating a **Health Data Warehouse (HDW), or Entrepôt de données de Santé (EDS)**, that will gather a big volume of medical data for research. We believe that AI can bring game-changing changes to help improve the daily life of healthcare practitioners and help people be healthier. As an Analytics Engineer specializing in health data, you will be at the center of building this HDW or EDS, taking raw data and transforming it for the EDS. - Important point at Doctolib: the data is fully encrypted and anonymized._ You will be part of the Analytics Engineering team which has different goals: - Build, maintain and push forward Doctolib data products providing insights, supporting decision-making and feeding our AIs: - Collaborate with stakeholders to understand their data needs, and communicate with them to ensure alignment during the project - Explore data to validate business rules - Evaluate complexity - Define specifications and develop the data products - Project management (project split, grooming, timeline) - Monitor the product (test and measure) - Continuous improvement on the data products - Define and implement high level reporting (KPI definitions, Dashboards creation and maintenance) - Define roadmaps in collaboration with PMs and stakeholders - Ensure data products quality (monitoring), security (GDPR, legal, infrastructure security), and availability (code optimization, performance monitoring, architecture optimization) - Stakeholders guidance, empower data self-service to your stakeholders (train and advice) Everyone in the team is able to develop full stack data skills (from the source to the publication). Your responsibilities within the team include but are not limited to: - Work with Product/Medical/Engineering teams to challenge the needs - Model, build and maintain datamarts in the Datawarehouse (SQL) - Build and maintain data pipelines (Python) - Build dashboards for the high level reporting (Tableau) - Ensure training on data to end users (Metabase and Tableau) - Monitor the quality of the data provided - Be a key player to improve our architecture **Our stack** - ETL : Airflow, dbt - Data Warehouse : Google Big Query / AWS Redshift - BI / Reporting : Metabase / Tableau - GitHub **Who you are**: If you don't meet all the requirements below but believe this opportunity matches your expectations and experience, we still encourage you to apply You could be our next team mate if you: - Have already worked with health data, in an Health Data W arehouse (Entrepot de données de santé) and have a good understanding of functional and modelization aspects of health data. Are able to interact with medical experts. - Have at least 1 year of experience as an Analytics Engineer, BI Engineer, Data Engineer or a similar role making data transformations - Are comfortable using SQL - Have experience in code hosting platform (we are using GitHub) - Are results-oriented and proactive - Speak both French & English Now, it would be fantastic if you: - Are familiar with medical data formats such as OMOP and FHIR and are following the research on this topics - Have experience with Google Big Query - Have experience with DBT - Have some knowledge of Python - Have already used BI tools such as Tableau, Metabase, Superset, Power BI - Are familiar with the GDPR regulations - Have good communication skills **What we offer**: - Free Health Insurance for you & your family - Quarterly or monthly bonus (based on your position) - Up to 14 days of RTT (except for Customer Care) - A flexible workplace policy offering both hybrid and office-based mode - Flexibility days allowing to work in EU countries and the UK 10 days per year - Wellbeing program (free mental health and coaching offer with our partner moka.care) - For caregivers and workers with disabilities, a package including an adaptation of the remote policy, extra days off for medical reasons, and psychological support. - Lunch voucher with Swile card - Work Council subsidy to refund part of sport club membership or creative class - Bicycle subsidy - Reimbursement of public transportation or company car (only for Field Sales) - Relocation support for international mobilities - Slean voucher for home-office furniture **The interview process**: - Hiring Manager interview - Live technical case study - Meet the team at the office + Behavioral interview - At least one reference check - A copy of your criminal records ("extrait de casier judiciaire B3") - Offer **Job details**: - Permanent position - Full Time - Levallois - Remuneration : fix + bonus on objectives (according to your profile) - A stock options plan for every Doctoliber - Join us in building the healthcare we all dream of_