Conduct data migration processes from legacy systems to the CELK system, ensuring integrity, consistency and compliance of transferred information.
Provide support to deployment and technical support teams.
Develop data extraction and analysis scripts.
Assist in the investigation and resolution of database-related incidents.
Analyze legacy system databases (e.g., e-SUS, municipality-specific systems, etc.).
Map data structures and align them with the CELK system model.
Develop SQL scripts for: data extraction; data transformation; consistency validation.
Execute and validate migration processes.
Document completed migration processes.
Work with the implementation team during production rollout projects.
Develop SQL queries to address specific client requests.
Support analysis of data-related incidents.
Proactively identify potential risks in databases.
Requirements
Technical or higher education completed or in progress in Information Technology (Computer Science, Information Systems, Computer Engineering, or related fields).
Advanced SQL.
Knowledge of relational modeling.
Ability to read and interpret legacy database structures.
Ability to write extraction, transformation, and validation scripts.
Knowledge of referential integrity.
Ability to trace data inconsistencies.
Experience with PostgreSQL.
Basic performance tuning.
Experience with error logs.
Incident analysis.
Familiarity with LGPD (Brazilian General Data Protection Law) in the context of sensitive health data.
Tech Stack
Postgres
SQL
Benefits
Health insurance
Dental insurance
Life insurance
Meal/Food allowance
Day off on your birthday
Wellhub (formerly Gympass)
Data Analyst, Systems Migration at CELK Sistemas | JobVerse