Antoine is available for hire
Hire AntoineAntoine Anicotte
Verified Expert in Engineering
Data Engineer and Developer
Location
Montreal, QC, Canada
Toptal Member Since
December 6, 2022
Antoine is a freelance engineer with over a decade of experience in business intelligence, data and analytics engineering, and data visualization. He specializes in building data platforms for companies that want to develop a data-driven mindset. He enjoys working on projects within the data space, ideally around analytics engineering.
Portfolio
Freelance
Business Intelligence (BI), Data Integration, Data Visualization...
Lazada
Business Intelligence (BI), Data Integration, Data Visualization...
StarOfService
Business Intelligence (BI), Data Integration, Data Science, Data Visualization...
Experience
Availability
Part-time
Preferred Environment
Business Intelligence (BI), Data Integration, Data Visualization, Data Warehousing, Data Engineering, Analytics, SQL, Data Build Tool (dbt), Python, Looker
The most amazing...
...data platform I've built is for a mental health company and it scaled to 500 users using it on a daily basis for reporting and data science.
Work Experience
Data/Analytics Engineering | Business Intelligence and Data Visualization Specialist
2018 - PRESENT
Freelance
- Designed and developed data warehouses and data lakes.
- Benchmarked, selected, and deployed data visualization solutions.
- Developed dashboards for automated reporting and decision-making.
- Conducted data analysis and science on a variety of business topics.
Technologies: Business Intelligence (BI), Data Integration, Data Visualization, Data Warehousing, Data Engineering, Analytics, MySQL, PostgreSQL, Microsoft SQL Server, Redshift, Google BigQuery, Snowflake, Fivetran, Stitch Data, Airbyte, AWS Glue, Python, Pandas, Apache Airflow, Data Build Tool (dbt), Tableau, Microsoft Power BI, Looker, Metabase, Qlik Sense, Domo, Apache Superset, Google Data Studio, Dashboards, Data Analysis, Data Analytics, Data Pipelines, Data Warehouse Design, Data Architecture, ETL, Quantitative Analysis
Senior Regional Business Intelligence Developer
2017 - 2018
Lazada
- Worked with stakeholders to collect data requirements and visualization ideas.
- Developed data models in QlikView, pulling heterogeneous data (sales, traffic, and operations).
- Designed and developed dashboards with QlikSense following data visualization best practices.
- Monitored engagement and helped reach large adoption targets (3,000 daily users).
Technologies: Business Intelligence (BI), Data Integration, Data Visualization, Data Warehousing, SQL, Oracle, Microsoft SQL Server, QlikView, Qlik Sense, Dashboards, Analytics, Data Analysis, Data Analytics, Data Pipelines, Data Engineering, Data Warehouse Design, Data Architecture, ETL, Quantitative Analysis
Lead Business Intelligence Analyst
2016 - 2017
StarOfService
- Developed a data platform (warehouse, ETL, and data visualization) with Talend, Python, Redshift, and Looker.
- Oversaw complex data projects (dynamic pricing model and customer scoring).
- Managed and mentored a team of two junior data analysts.
Technologies: Business Intelligence (BI), Data Integration, Data Science, Data Visualization, Data Engineering, Data Warehousing, Analytics, SQL, Python, Talend ETL, Tableau, Looker, Dataiku, Apache Airflow, Redshift, Dashboards, Data Analysis, Data Analytics, Data Pipelines, Data Warehouse Design, Data Architecture, ETL, Quantitative Analysis
International Business Intelligence Analyst
2014 - 2016
Just Eat Takeaway.com
- Designed and developed an automated data collection platform using Talend, Python, and Redshift.
- Improved productivity by migrating to Tableau; designed a set of custom dashboards.
- Handled complex data projects with a lead scoring model, restaurant segmentation, and attribution.
Technologies: Business Intelligence (BI), Data Integration, Data Visualization, Data Warehousing, Analytics, Data Engineering, Talend ETL, Python, MySQL, Redshift, SQL, Tableau, Dashboards, Data Analysis, Data Analytics, Data Pipelines, Data Warehouse Design, Data Architecture, ETL, Quantitative Analysis
Game Data Analyst
2011 - 2014
Ooblada
- Designed and developed the data collection system from scratch with Talend and Python.
- Automated daily KPI reporting with Tableau dashboards.
- Conducted analyses with the marketing (churn and acquisition) and product (tuning) teams.
Technologies: Business Intelligence (BI), Data Integration, Data Visualization, Data Warehousing, SQL, MySQL, Talend ETL, Tableau, Python, Dashboards, Data Analysis, Analytics, Data Analytics, Data Pipelines, Data Engineering, Data Warehouse Design, Data Architecture, ETL, Quantitative Analysis
Experience
Power BI Dashboard Design and Development for a French Luxury Cosmetics Brand
https://www.clarins.fr/Clarins is a renowned worldwide luxury cosmetics brand.
I worked with the Business Intelligence team to build Power BI dashboards for their internal teams. My main achievement was designing and developing a dashboard displaying worldwide consolidated sales across all their channels for the executive team, which all the C-suite still uses today to help shape the company's future.
I worked with the Business Intelligence team to build Power BI dashboards for their internal teams. My main achievement was designing and developing a dashboard displaying worldwide consolidated sales across all their channels for the executive team, which all the C-suite still uses today to help shape the company's future.
A Modern Data Stack for a Growing Health Startup
https://www.foresightmentalhealth.com/A modern data platform for Foresight Mental Health, a mental health startup in the US that started about two years ago. Their app is based on Fivetran, BigQuery, Airflow, dbt, and Looker.
I was happy to learn recently from their data director that they raised money, were still using the same stack, and rose to 300 internal users. It was rewarding to hear that the things I built scaled as the company grew.
I was happy to learn recently from their data director that they raised money, were still using the same stack, and rose to 300 internal users. It was rewarding to hear that the things I built scaled as the company grew.
Data and Analytics Engineering for a Sport Influencer Platform
http://www.freestak.com/Freestak is a platform that connects brands to outdoors and endurance sports influencers.
I was the primary developer and maintained the data stack used by Freestack. I built the platform from scratch, scraping data from social networks, transforming it with Snowflake and dbt, and visualizing it with Tableau embedded in the app.
I was the primary developer and maintained the data stack used by Freestack. I built the platform from scratch, scraping data from social networks, transforming it with Snowflake and dbt, and visualizing it with Tableau embedded in the app.
Modern Data Stack for a French Parking Space Booking Platform
https://www.onepark.co/Onepark is a French parking space booking platform. The project entailed building the ideal data infrastructure using Stitch, Redshift, dbt, and Metabase. The client lacked a global understanding of the data lifecycle, and I helped them incorporate fully automated hourly reports paired with self-service capabilities in Metabase.
Market Data Segmentation Platform for an American Healthcare Company
Currently developed a market segmentation platform with the front end in Tableau for a US healthcare company. The platform will enable them to understand the market better and raise better questions.
I collected data from various healthcare providers (Symphony, MMIT) and census data (data.gov). I worked on storage and transformations in Databricks. I also contributed to visualization through interactive dashboards in Tableau.
I collected data from various healthcare providers (Symphony, MMIT) and census data (data.gov). I worked on storage and transformations in Databricks. I also contributed to visualization through interactive dashboards in Tableau.
Skills
Languages
SQL, Python, Snowflake
Libraries/APIs
Pandas
Tools
Tableau, Qlik Sense, Stitch Data, Microsoft Power BI, Looker, Talend ETL, Apache Airflow, AWS Glue, Domo
Paradigms
Business Intelligence (BI), ETL, Data Science
Storage
Data Integration, Data Pipelines, MySQL, Redshift, Microsoft SQL Server, PostgreSQL, Amazon S3 (AWS S3)
Other
Data Warehousing, Data Visualization, Data Engineering, Analytics, Data Build Tool (dbt), Google BigQuery, Fivetran, Metabase, Google Data Studio, Dashboards, Data Analytics, Data Warehouse Design, Data Architecture, Quantitative Analysis, Airbyte, Apache Superset, Data Analysis, Data, Data Collection
Platforms
QlikView, Dataiku, Oracle
Education
2007 - 2011
Master's Degree in Business Intelligence and Data Science
CY Tech (formerly EISTI) - Paris, France