Qualifications
To join our team, you should possess:- Strong knowledge of SQL, with experience in advanced queries and handling large volumes of data.- Experience with SQL Server, PostgreSQL, or MySQL.- Ability to investigate undocumented databases, with skills to formulate hypotheses and discover patterns.- Sharp logical reasoning and a high level of attention to detail.- Experience with structured data and basic understanding of data modeling.- Organization and clarity in documenting findings when necessary. Preferred Qualifications:- Previous experience in data migration or ETL processes.- Knowledge of Python and Git for simple automations.- Familiarity with school ERPs or administrative systems.- Self-directed profile, comfortable exploring new systems and databases.
About the job
Composed of individuals who transform education
All positions at Arco are open to People with Disabilities.
In your daily activities, you will:
- Analyze legacy databases from various school ERPs, understanding their tables, relationships, and implicit rules.
- Investigate, map, and interpret raw data, identifying inconsistencies, patterns, and exceptions.
- Create, modify, and execute complex SQL scripts, including advanced SELECTs, JOINs, mass updates, and data cleaning processes.
- Transform diverse datasets to meet the standards required by Activesoft, ensuring data integrity, completeness, and quality.
- Identify issues such as missing data, corrupted structures, improperly used fields, and divergent rules, proposing practical solutions.
- Document findings, identified patterns, and improvements for the migration process.
- Collaborate with implementers and the onboarding team to align business rules and validate final data.
