How about impacting lives by joining a company that drives innovative solutions and technological advancement in Brazil? If you share this purpose, check out our opportunity and join us: \#ComeWithUs \#BeAttus! **Before anything else, an important point:** Recognized by GPTW as one of the best companies to work for, Attus delivers intelligent solutions for judicial and advisory process management to State and Municipal Attorney Offices. **What are we looking for?** People who embody honesty, excellence, respect, and recognition of results—and who are ready to deliver their very best every day, with ethics, innovation, and teamwork. **About the role** At Attus, well-structured data fuels strategic decision-making. As a Migration Analyst, you will be a key player in our clients’ technological transition: you’ll dive into legacy systems, decipher complex business rules from the legal domain, and orchestrate secure migration of critical information. More than just running scripts, you’ll investigate, map, validate, and ensure no data is lost along the way. If you’re driven by analytical challenges, automation, and delivery quality, this is your place. Let’s build the future of public advocacy together! **Does this role fit you?** **Responsibilities and duties** YOUR CHALLENGE WILL BE: Reverse Engineering and Mapping (Source/Target): Conduct detailed assessments of clients’ legacy database structures, understand the source model, and build equivalence mapping (Data Mapping) for the Attus system—including transformation rules and data dependencies. On-Site Immersion and Reverse Engineering: Carry out strategic visits to client facilities to experience real-world operations, understand workflows, implicit rules, and legacy system specifics—ensuring reverse engineering faithfully reflects actual business reality. Execution of Migration Projects: Actively participate in defining and executing migration strategies, performing extractions, transformations, and loads (ETL and ELT) from databases, APIs, and files—ensuring deadlines are met without impacting client operations. Data Integrity and Quality Assurance (Data Quality): Ensure consistency of migrated data (cases, notifications, registries), validating referential integrity, semantic coherence, and performing data cleansing to prevent inconsistencies in the new environment. Automation of Data Flows: Identify recurring patterns and develop robust automations (scripts, pipelines, ETL/ELT routines) to reduce manual effort, increase load reliability, and accelerate future deliveries—including recurring Data Warehouse routines. Legal Knowledge and Rigorous Interpretation: Demonstrate understanding of legal processes, applying technical rigor and absolute attention to deadlines, procedural hierarchies, and legal impacts—ensuring migration preserves not only data but also legal security. Documentation and Knowledge Management: Document data dictionaries, source/target mappings, conversion scripts, ETL/ELT pipelines, and lessons learned from each legacy system—contributing to a reusable intelligence base for future projects. Technical Communication with Clients and Vendors: Participate in meetings with clients’ IT teams or external vendors, aligning on data access scopes (databases, APIs, files), technical dependencies, and legacy system limitations. Clear Communication and Translation: Translate technical complexity into accessible theoretical concepts, explaining scenarios and rules to clients simply, objectively, transparently, and aligned with their understanding. **Does this make sense to you? Let’s see what you absolutely need to join this team!** **Requirements and qualifications** **The technical and behavioral requirements for this position are:** **Technical** SQL Language Proficiency: Strong ability to write queries for data querying, manipulation (DML), and definition (DDL), including basic performance analysis and result validation under guidance. Experience with ETL / ELT Processes: Practical experience executing data extraction, transformation, and loading processes—handling diverse sources (CSV, JSON, APIs, relational databases), including support for recurring Data Warehouse loading routines. Knowledge of Business Rules (Law): Familiarity with core legal and public advocacy workflows and terminology (cases, courts, proceedings), with ability to apply predefined rules within migration processes. Learning Ability and Reverse Engineering: Aptitude for understanding legacy system architectures—often poorly or undocumented—conducting technical assessments with support from more experienced professionals. **Behavioral** Clear and Objective Communication: Ability to communicate data-related technical issues (e.g., inconsistencies, simple discrepancies, encoding) clearly to both the team and project management. Responsibility and Organization: Commitment to deadlines, quality, and organized delivery—executing and validating migrations and ETL/ELT routines per team-defined guidelines and standards. **What we value** Leadership by Example: Professionals who inspire through technical knowledge, proactive attitudes, and capacity to solve complex problems by diving into details when needed (Hands\-on during crises). Focus on the Collective: Low need for individual recognition, prioritizing team success and product stability over personal credit. Long-Term Vision: Sense of urgency in resolving incidents—but always with a mindset geared toward building scalable, sustainable, and replicable solutions. Curiosity and Continuous Learning: Passion for technology, ability to learn new automation tools quickly, and apply them effectively. Ownership: Full responsibility for platform availability—from architecture through maintenance and security. Resilience and Adaptability: Exceptional ability to face challenges in a dynamic environment and remain calm under pressure. Ethics: Non-negotiable for us. **What could set you apart in our process** Advanced ETL Knowledge with Apache NiFi: Experience using Apache NiFi to design and maintain data flows—including use of process groups, templates, and flowfile manipulation. Solid RDBMS Knowledge: Hands-on experience with relational databases—especially Oracle and PostgreSQL—performing queries, analyses, and supporting data administration activities. Prior Experience in Migration Projects: Experience migrating data from legacy systems, preferably within legal, governmental, or ERP contexts. Python Knowledge for Data: Basic understanding or practical experience using Python for data manipulation, processing, and validation in migration and ETL support routines. Basic Grafana Monitoring Skills: Ability to read and interpret dashboards and basic metrics in Grafana for tracking executions, performance, and identifying failures. Messaging Knowledge: Conceptual understanding of messaging architecture and operation—particularly Apache Kafka—for data consumption and integration. **Do you identify with this? Apply now and unlock your potential too!** **Additional information** **Last but not least! Check out our (and possibly yours) benefits...** 100% remote position. Eco-friendly welcome kit. Sustainable corporate culture. Ongoing campaigns. Composting incentive. Health insurance plan. Life insurance. Friendly and collaborative environment. Workplace gymnastics. FreeDay. Reading allowance. Meal voucher. Caju card + birthday chats. Virtual social live sessions. Off time. Continuous development. Innovation program. Education assistance. Dual screen. Discount partnerships (pharmacies/nutritionists and psychologists). Clude wellness app. Totalpass. Home office allowance. Graduation day off. Gift for new children of employees. Return-to-work gift after paternal leave. **Attus**, part of Eloware Group, offers a digital attorney office solution powered by **artificial intelligence**, designed for managing fiscal enforcement, extrajudicial collection, judicial litigation, and advisory services. Combining expertise, **innovation, and technology**, Attus **simplifies** attorneys’ tasks securely, **boosts** their productivity, and **enhances** attorney office outcomes. Embedded in a strong culture of **innovation and humanization**, the company has been certified as a **great place to work** by Great Place to Work (GPTW). In 2024, it achieved an outstanding trust score of **95%**, reinforcing our care and dedication to our team members. **Join the Attus team!**