Equiplano

Data Engineer

• Responsible for developing, maintaining, and optimizing Equiplano's proprietary data migration tool ecosystem.
• Ensure automated routines can read data in various formats from source databases and write it to Equiplano's database with integrity, applying the business rules defined by Data Analysts.
• Development of Extractors and Converters: develop and maintain applications (desktop or console) that connect to databases of third-party systems, performing bulk extraction of Payroll and Procurement (Tenders) information.
• Maintain and evolve routines that process intermediate files and import data into the Equiplano ERP, ensuring high performance (migration time) and referential integrity of the information.
• Convert mapping spreadsheets created by Data Analysts into transformation algorithms, applying the defined conversion rules.
• Work on fixing and maintaining legacy tools (possibly developed in C++, Delphi, or older C#) and develop new agile scripts, primarily in Python.
• Develop routines capable of identifying inconsistent or “dirty” data that prevent import, generating clear and traceable logs to support Data Analysts in the correction process.

Data Migration Developer

Data Analyst

• Data Engineering & ETL: Extract data from different sources and formats (relational databases, .txt files, .csv files, competitors' backups) for import into Equiplano's ERP;
• Analysis and Cleansing: Identify inconsistencies, duplicates, and errors in source data before migration;
• Source-to-Target Mapping: Create mapping scripts and correlation routines between the tables of the source system and the Equiplano system;
• Business Validation: Support verification of migrated data (e.g., reconcile accounting balances, check functional histories) to ensure the integrity of public information;
• Automation: Develop scripts and routines (SQL/Python) to automate repetitive data cleaning and conversion processes.

Data Migration Developer

Senior Data & Migration Analyst