CIEE - Centro de Integração Empresa-Escola

Data Engineer – Mid-Level

CIEE - Centro de Integração Empresa-Escola

full-time

Posted on:

Location Type: Hybrid

Location: São Paulo • Brazil

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

AirflowBigQueryCloudDockerETLPandasPythonSQL

About the role

  • Design, develop and maintain data pipelines (ETL/ELT) for data ingestion and transformation
  • Implement and maintain data models (star schema) optimized for analytical consumption
  • Write and optimize SQL queries for processing large volumes of data
  • Develop Python scripts to automate data processes
  • Monitor data quality through validations and automated tests
  • Collaborate with BI Analysts and Data Scientists to ensure data availability and reliability

Requirements

  • Education: Bachelor's degree in Computer Science, Information Systems, Computer Engineering or related fields.
  • Experience in data engineering or related areas
  • Advanced SQL: CTEs, window functions, query optimization, DDL/DML
  • Intermediate to advanced Python for data manipulation (pandas, etc.)
  • Experience building ETL/ELT pipelines
  • Knowledge of dimensional data modeling (star schema, snowflake schema)
  • Understanding of data quality and pipeline testing
  • Ability to work autonomously on medium-complexity tasks
  • Desired:
  • Experience with cloud data platforms (Databricks, Snowflake, BigQuery or similar)
  • Knowledge of orchestration tools (Airflow, Prefect, Dagster or similar)
  • Familiarity with version control (Git) and CI/CD practices for data
  • Experience with relational and non-relational databases
  • Basic containerization knowledge (Docker)
Benefits
  • Medical and dental insurance – because health always comes first;
  • Transportation allowance – guaranteed mobility for your daily commute;
  • iFood Benefits – meal allowance for quality food throughout your day;
  • Home office allowance – support for a more functional work environment;
  • Physical health care (Wellhub) and mental health (Wellz) – balance and well-being in all areas of life;
  • Birthday day off – a special day for you to enjoy as you wish;
  • Corporate University – continuous learning and development opportunities;
  • Access to the library – to expand your knowledge and explore new ideas;
  • SESC membership – access to culture, leisure and quality of life.
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
data pipelinesETLELTdata modelsSQLPythondata qualitydimensional data modelingquery optimizationcontainerization
Soft Skills
collaborationautonomyproblem-solving