Ana Clara Kandratavicius Ferreira, Developer in São Carlos - São Paulo, Brazil
Ana is available for hire
Hire Ana

Ana Clara Kandratavicius Ferreira

Verified Expert  in Engineering

Bio

Ana is a seasoned developer with over six years of experience in data engineering and analytics. With a master's degree in computer science and applied mathematics and a dual bachelor's degree in computer science and statistics, she's passionate about using data to drive efficiency and innovation. Ana has specialized in ETL development, SQL, Python, PySpark, and data visualization tools, ensuring high data quality standards and cost-effective data computations.

Portfolio

DoorDash
SQL, Snowflake, Apache Airflow, Data Quality, ETL, Data Engineering
iFood
PySpark, Databricks, SQL, Apache Airflow, Data Quality, Snowflake...
Arquivei
SQL, BigQuery, Apache Airflow, Data Visualization, Looker Studio, Python...

Experience

  • SQL - 6 years
  • Python - 6 years
  • Data Science - 5 years
  • Snowflake - 4 years
  • Data Quality - 4 years
  • ETL - 4 years
  • Data Warehousing - 4 years
  • PySpark - 3 years

Availability

Part-time

Preferred Environment

PyCharm, Visual Studio Code (VS Code), DataGrip

The most amazing...

...project I've led was the creation of a data warehouse for a people analytics team, integrating sources, creating pipelines, and ensuring data quality.

Work Experience

Senior Data Engineer

2024 - PRESENT
DoorDash
  • Implemented rigorous data quality rules and developed comprehensive standards, ensuring the highest data integrity and accuracy across all processes.
  • Maintained and optimized ETL processes, expertly managing and fine-tuning ETL workflows to ensure seamless data integration and transformation.
  • Leveraged SQL, Apache Airflow, and Snowflake for peak performance.
  • Tracked and resolved data quality issues and diligently monitored data quality metrics.
  • Identified and addressed issues to maintain the reliability and trustworthiness of the data ecosystem.
Technologies: SQL, Snowflake, Apache Airflow, Data Quality, ETL, Data Engineering

Data Engineer and Analyst

2020 - 2024
iFood
  • Led the implementation of a comprehensive data warehouse for the people analytics team, integrating HR data sources and establishing robust data pipelines with PySpark and Snowflake, enhancing data accessibility and analysis.
  • Developed rigorous data quality rules and performed statistical analyses using Python, ensuring reliable HR data. I provided strategic insights that informed talent acquisition, employee engagement, and retention strategies.
  • Defined user profiles using advanced SQL queries and managed data usage and integrity.
  • Ensured high-quality data for strategic insights, enabling personalized user experiences and supporting business growth.
Technologies: PySpark, Databricks, SQL, Apache Airflow, Data Quality, Snowflake, Data Engineering, Spark, Amazon Web Services (AWS), Python

Business Intelligence Analyst

2018 - 2020
Arquivei
  • Developed Python scripts for automated data processing, enhancing efficiency. Applied statistical methods to large datasets, extracting insights to inform business strategies and decision-making.
  • Crafted complex SQL queries in Google BigQuery for large-scale data analysis. Designed interactive dashboards in Google Data Studio, providing real-time insights into business metrics and analyzing churn rates.
  • Led initiatives to ensure data accuracy and consistency. Collaborated with departments to understand data needs, documented processes, and shared knowledge to foster a data-driven culture.
Technologies: SQL, BigQuery, Apache Airflow, Data Visualization, Looker Studio, Python, Data Engineering, Data Analysis, Business Intelligence (BI), ETL, Dashboards, Google Cloud Platform (GCP), Key Performance Indicators (KPIs)

Experience

Bookstore Database

https://github.com/anakafe/bookstore-db
A PostgreSQL-based solution designed to manage a bookstore efficiently. It features a robust database schema that supports multiple languages and allows users to access book titles and descriptions. The project includes advanced functions for generating sample data, personalized book recommendations, and insightful sales reports. Additionally, it offers easy setup and deployment using Docker, providing a solid foundation for developing and testing a bookstore application.

Education

2014 - 2021

Dual Bachelor's Degree in Computer Science and Statistics

University of São Paulo - São Carlos, SP, Brazil

2017 - 2020

Master's Degree in Mathematics and Computer Science

University of São Paulo - São Carlos, SP, Brazil

Skills

Libraries/APIs

PySpark

Tools

PyCharm, DataGrip, Apache Airflow, BigQuery

Languages

SQL, Snowflake, Python

Paradigms

ETL, Business Intelligence (BI)

Frameworks

Spark

Platforms

Visual Studio Code (VS Code), Databricks, Docker, Amazon Web Services (AWS), Google Cloud Platform (GCP)

Storage

PostgreSQL

Other

Data Warehousing, Data Science, Data Quality, Programming, Software Engineering, Quality Assurance (QA), Complex Networks, Machine Learning, Statistics, Data Cleaning, A/B Testing, Mathematics, Computer Science, Data Engineering, Data Visualization, Looker Studio, Data Analysis, Dashboards, Key Performance Indicators (KPIs)

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring