




Job Summary: The Data and Systems Migration Analyst will be responsible for leading data migration processes, ensuring data integrity, consistency, and compliance. Key Highlights: 1. Lead data migration from legacy systems to the CELK system 2. Develop SQL scripts for data extraction, transformation, and validation 3. Support incident analysis and risk identification in databases CELK is a public health management specialist company with 16 years of market presence. We are committed to transforming Brazil's public health system! We operate nationwide and provide solutions that connect the entire citizen health care network through a flexible, portable, and secure software platform, enabling more integrated and intelligent management. **Responsibilities and Duties** The Data and Systems Migration Analyst will lead data migration processes from legacy systems to the CELK system, ensuring integrity, consistency, and compliance of transferred information. The role also involves supporting implementation and technical support teams by developing data extraction and analysis scripts, as well as assisting in the investigation and resolution of database-related incidents. * Analyze databases of legacy systems (e.g., e\-SUS, municipal proprietary 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 * Collaborate with the implementation team during production go-live projects * Develop SQL queries to meet specific client requirements * Support analysis of data-related incidents * Proactively identify potential risks in databases. **Requirements and Qualifications** **Mandatory Requirements:** * Completed or ongoing Technical or Higher Education degree in Information Technology (Computer Science, Information Systems, Computer Engineering, or related fields). * Advanced SQL proficiency. * 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. * PostgreSQL knowledge. **Desirable Requirements:** * Basic performance tuning. * Experience with error logs. * Incident analysis experience. * Familiarity with LGPD (in the context of sensitive health data). **Additional Information** **Benefits:** Medical assistance Dental assistance Life insurance Meal/Voucher allowance Birthday day off Wellhub (formerly Gympass) **Work Schedule:** Remote work Monday to Friday, 8:00 AM to 5:00 PM (40 hours per week) With 16 years of industry experience, CELK Sistemas delivers specialized services—including technology, consulting, training, and technical support—to the public health sector. We offer solutions that connect the entire citizen health care network via a flexible, portable, and secure **software**, enabling significantly more integrated and intelligent management, as well as exclusive public health **consulting** services—ready to assist health secretaries and managers in improving municipal health indicators, optimizing available resources and services for the population. Currently, we serve over **3,000** health facilities across various regions of the country, submit over **65 million** records to the Ministry of Health, support over **10 million** people through our system, and have trained over **70,000** professionals to use it.


