Allocation City: Campinas-SP, Home Office, Recife-PE. Brazil
Activities
- Ensure that data is received, verified, transformed, stored and that it is accessible to the team.
- Build and promote data pipeline management and database maintenance.
- Gather and prepare data to be analyzed and worked on, correcting possible processing failures;
- Consume and transform data obtained from different sources (CSV, APIs, …);
- Add value by building, structuring and optimizing data to be used by analysts and users.
Essential Skills
- Python programming for data manipulation and analysis;
- ETL concepts and tools;
- SQL;
- Familiarity with data exploration tools;
Highly Desirable Skills
- Experience with extracting, processing and modeling data;
- Experience in creating scripts for querying and manipulating data in SQL database;
- Experience in developing ETL routines (Data Extraction, Transformation and Loading);
- Experience in AWS Tools (AWS Glue, AWS Lambda, AWS Athena, AWS S3, AWS EC2);
- Experience in Sequelize ORM;
- Experience in PostgreSQL;
- Experience in Apache Arrow and Apache Parquet.
Additional Skills
- Experience with Business Intelligence/Analytics projects;
- Experience in creating dashboards with BI tools;
- Experience in building executive, tactical and operational reports.