CELK Sistemas

Data Analyst, Systems Migration

CELK Sistemas

full-time

Posted on:

Location Type: Remote

Location: Brazil

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

PostgresSQL

About the role

  • 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.
Benefits
  • Health insurance
  • Dental insurance
  • Life insurance
  • Meal/Food allowance
  • Day off on your birthday
  • Wellhub (formerly Gympass)
Applicant Tracking System Keywords

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

Hard Skills & Tools
SQLdata migrationdata extractiondata transformationdata validationrelational modelingPostgreSQLperformance tuningincident analysisdata mapping
Soft Skills
problem-solvinganalytical thinkingattention to detailcommunicationteam collaborationrisk identification