Arco Educação

Data Migration Analyst

Arco Educação

full-time

Posted on:

Location Type: Remote

Location: Brazil

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

MySQLPostgresSQL

About the role

  • 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, refine and execute complex SQL scripts, including advanced SELECTs, JOINs, aggregations, bulk updates and data cleaning processes.
  • Transform diverse datasets to the format 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, recurrent patterns and recommended improvements to the migration process.
  • Collaborate with implementers and the onboarding team to align business rules and validate final data.

Requirements

  • 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 skill in formulating hypotheses and uncovering patterns.
  • Sharp logical reasoning and a high level of attention to detail.
  • Experience working with structured data and a basic understanding of data modeling.
  • Organization and clarity in documenting discoveries when required.
Benefits
  • Meal allowance and/or meal voucher
  • Health and dental insurance
  • Transportation allowance
  • Extended maternity and paternity leave
  • Childcare assistance
  • Health and wellness support: partnerships with Wellhub and Zenklub
  • Education incentives
  • Discounts on airline tickets
  • Partnership offering pet health insurance
  • Access to Arco educational materials for employees' children
  • Partnerships for MBA and postgraduate programs
Applicant Tracking System Keywords

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

Hard Skills & Tools
SQLadvanced queriesdata cleaningdata mappingdata transformationdata integritydata qualitydata modelingJOINsaggregations
Soft Skills
logical reasoningattention to detailorganizationdocumentationcollaboration