Sandra Malaquias

Data Engineer | Analytics Engineer - Python · SQL · AWS · Iceberg · Terraform · dbt

Cotia, São Paulo, Brazil

About

Data Engineer and Analytics Engineer with a career spanning IBM mainframe systems to modern AWS data lake architectures. That experience shaped how I think about architecture — not just how to build, but how to build it right. I work across the full stack: from ingestion and pipeline design to dimensional modeling and dashboard consumption, adapting to what each problem needs. ▪ AWS (Athena, Glue, Lambda, Kinesis Firehose, S3, RDS, Redshift, EventBridge) ▪ Apache Iceberg ▪ Python ▪ SQL ▪ Terraform ▪ Docker ▪ Airflow ▪ PySpark Fluent in English and Portuguese · Open to remote opportunities.

Experience

  • Data Engineer | Analytics Engineer at BR Sytems | Owner
    Apr 2022 - Present · 4 yrs 4 mos

    Independent projects and technical experimentation in data engineering and analytics. - Migrated 11 NHANES fixed-width datasets to data lake — extracting schema metadata directly from legacy SAS import files via regex, eliminating manual documentation - Developed analytical dataset from Ministry of Education open data — ingested CSV, modeled normalized schema, and loaded into PostgreSQL RDS - Developed analytical dataset from Gov.br open data — timeline comparison across fuel price, inflation, dollar exchange rate, minimum wage, and Brent oil - Scraped official auction data via web scraping (Selenium/BeautifulSoup), ingested into S3 and processed with Lambda - Set up local streaming environment with Kafka, Flume, and Zookeeper using Docker Compose for hands-on experimentation with event-driven architectures - Managed infrastructure as code with Terraform and Docker

  • Data Engineer | Analytics Engineer at Positivo Educacional
    Apr 2025 - Apr 2026 · 1 yr 1 mo

    Working as Data Engineer and Analytics Engineer on data platform and analytics initiatives. - Modeled batch data from Kinesis Firehose into multi-layer analytical architecture serving front-end and back-end dashboards - Replaced Redshift analytical layer with an Athena-based solution, reducing cost and infrastructure complexity - Modeled dimensional schema (star schema) with facts and dimensions for KPI metrics - Designed reprocessing strategy for GA4 late-arriving data using Apache Iceberg + S3 Express staging, ensuring data integrity for product analytics in QA - Identified architectural weaknesses and proposed event-driven solution with API Gateway + SQS + Lambda for CRM pipeline - Automated infrastructure with Serverless Framework for Lambda; used official AWS Glue Docker image for local development and testing, avoiding version conflicts and unnecessary cloud execution costs

  • Data Engineer | Analytics Engineer at Sua Música
    Nov 2022 - Jul 2024 · 1 yr 9 mos

    Analytics and Data Engineer focused on user behavior and music audience data for a Brazilian music streaming platform. - Condensed streaming data into summarized analytical layers using AWS Lambda, Athena, and Glue - Integrated summarized data into Looker via community connector, developing dashboards for music streaming analysis - Modified the Looker community connector to run queries directly on Athena, eliminating an auxiliary Lambda and reducing latency - Fixed a recurring date extraction issue in the connector, ensuring data consistency across visualizations - Developed optimized SQL queries handling millions of streaming records

  • Data Engineer at BlueShift Brasil
    Jun 2021 - Mar 2022 · 10 mos

    Data Engineer focused on analytical datasets for machine learning models. - Proposed and implemented the join of complaints, production, and sales data from BRF — sourced from SAP and CRM on Azure — to enrich features for a product complaint prediction model - Resolved temporal alignment issues across multiple sources — SAP, CRM, and production data — identifying the semantically correct date to correlate complaints with production and sales cycle - Modeled data schema for exploratory analysis of São Paulo Fire Department incidents, mapping variables to predict vehicle dispatch by type and proximity

  • Business Analyst at Sovos Taxweb
    Nov 2020 - Apr 2021 · 6 mos

    Business Analyst focused on tax classification products for enterprise clients. - Led requirements gathering and validation meetings with enterprise clients including Ambev - Supported requirements analysis for product return processes with invoice tracking - Wrote user stories and requirements documentation for the TAXWeb tax classification product