Job Summary: We are seeking a professional to serve as the primary technical liaison for extracting, processing, and validating large volumes of data from legacy systems, ensuring the integrity of public information. Key Highlights: 1. Data Engineering & ETL: Extracting data from different sources and formats 2. Analysis and Cleansing: Identifying inconsistencies and errors in the data 3. Automation: Developing scripts for cleaning and conversion processes **A COMPANY THAT TRANSFORMS PUBLIC MANAGEMENT** We connect specialists across all areas to contribute intelligent and innovative solutions for efficient management! EQUIPLANO works to support the development of public administration. Our **PURPOSE** is to share knowledge, experiences, and solutions that enable us to **SIMPLIFY** the way we conduct more agile, efficient, and transparent **MANAGEMENT**. A PIONEERING, STRONG, and COMPETENT company with a recognized and valued history among employees, partners, and clients. **Want to contribute?** Then we want you on our team! \#JoinEquiplano and contribute to this development! **Responsibilities and Duties** We seek a professional to serve as the primary technical liaison for extracting, processing, and validating large volumes of data from legacy systems. The professional will be responsible for "translating" third-party databases into Equiplano's structure, ensuring accurate preservation of the client’s accounting, payroll, and tax history. Main Responsibilities: * Data Engineering \& ETL: Extract data from various sources and formats (relational databases, .txt and .csv files, competitor backups) for import into Equiplano’s ERP; * Analysis and Cleansing: Identify inconsistencies, duplicates, and errors in source data prior to migration; * Mapping From/To: Create correlation guidelines between source system tables and the Equiplano system; * Business Validation: Support verification of migrated data (e.g., reconciling accounting balances, checking employment histories) to ensure integrity of public information; * Automation: Develop scripts and routines (SQL/Python) to automate repetitive data cleaning and conversion processes. **Requirements and Qualifications** * Bachelor’s degree in Computer Science, Information Systems, Database Management, or related fields; * Advanced proficiency in SQL (writing complex queries, joins, views, procedures); * Proven ability to work with databases (PostgreSQL, Oracle, SQL Server, or Firebird). Desirable: * Knowledge of programming logic or scripting (Python or C\#); * Advanced Excel skills; * Familiarity with public management business rules (CASP \- Accounting Applied to the Public Sector, PCASP, Payroll Events Table, Law No. 8\.666/14\.133\). **Additional Information** **Benefits of \#BeingEquiplano** **Childcare Assistance**, a benefit designed to support your family journey with greater peace of mind; **iFood Card** \- valid for meals and food, making all your meals more convenient; **Birthday Bonus**, to celebrate your special day; **Colmeia Shop**, an exclusive platform offering special discounts on products. **Partnership with Educational Institutions** \- to boost your personal development; **“Tough Day” Leave**, your annual day off to enjoy however you prefer; **Fleury**, simplifying your medical appointments through online access; **OnHappy**, a benefits and discount platform for your travels; **Career Opportunities**, because we want you to grow with us; **Dental Insurance with Dental Uni** \- to ensure a healthy smile and ongoing care; **Private Pension Plan**; for a calm and secure future**;** **Health Insurance with Unimed** \- to guarantee your well-being; **Life Insurance**, for your security and that of your family; **Wellhub**, for taking care of your health with access to gyms. **A COMPANY THAT TRANSFORMS PUBLIC MANAGEMENT** We connect specialists across all areas to contribute intelligent and innovative solutions for efficient management! EQUIPLANO works to support the development of public administration. Our **PURPOSE** is to share knowledge, experiences, and solutions that enable us to **SIMPLIFY** the way we conduct more agile, efficient, and transparent **MANAGEMENT**. A PIONEERING, STRONG, and COMPETENT company with a recognized and valued history among employees, partners, and clients. **Want to contribute?** Then we want you on our team! \#BeEquiplano and contribute to this development!