Administrador de Dados / Modelador de Dados (PowerDesigner)

This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for an Administrador de Dados / Modelador de Dados (PowerDesigner) based in Brazil. This role focuses on designing, governing, and optimizing data environments across complex enterprise ecosystems. You will work extensively with SAP PowerDesigner to create and maintain conceptual, logical, physical, and multidimensional data models. The position spans relational, analytical, and NoSQL architectures, supporting BI, Big Data, and critical business applications. You will collaborate closely with database administrators and technical teams on implementation, partitioning, integration, and performance optimization. The role also involves metadata governance, data quality, ETL specifications, and integration across diverse data sources. You will provide technical guidance and mentoring to business and technology teams, promoting consistent data practices. This is an opportunity to contribute to large-scale technology environments where reliable, well-structured, and governed data is essential to business performance. This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for an Administrador de Dados / Modelador de Dados (PowerDesigner) based in Brazil. This role focuses on designing, governing, and optimizing data environments across complex enterprise ecosystems. You will work extensively with SAP PowerDesigner to create and maintain conceptual, logical, physical, and multidimensional data models. The position spans relational, analytical, and NoSQL architectures, supporting BI, Big Data, and critical business applications. You will collaborate closely with database administrators and technical teams on implementation, partitioning, integration, and performance optimization. The role also involves metadata governance, data quality, ETL specifications, and integration across diverse data sources. You will provide technical guidance and mentoring to business and technology teams, promoting consistent data practices. This is an opportunity to contribute to large-scale technology environments where reliable, well-structured, and governed data is essential to business performance. Accountabilities: Create, propose, maintain, and update conceptual, logical, and physical data models using SAP PowerDesigner. Develop relational and multidimensional data models aligned with business and technical requirements. Ensure data structures are properly normalized, reducing redundancy and maintaining logical consistency. Manage and maintain metadata quality in accordance with established data management and governance methodologies. Design data-service architectures across relational, analytical, and NoSQL ecosystems to support BI and Big Data applications. Collaborate with DBAs on physical database implementation, including table partitioning and performance optimization. Support database performance monitoring and optimization across multiple database management systems, including Very Large Databases (VLDBs). Specify data integration mechanisms, including ETL processes, database links, and database services. Develop SQL scripts using DDL, DML, DCL, Transaction SQL, and SQL Plus for validation, analysis, and reporting purposes. Work with diverse data sources and formats, including VSAM, CSV, TXT, JSON, XML, relational databases, and NoSQL systems. Support and contribute to data administration, modeling, governance, and sustainability activities in critical enterprise environments. Provide consulting, technical support, and mentoring to business and technology teams. Promote best practices in BI, data management, modeling, and continuous process improvement. Requirements: Proven professional experience in conceptual, logical, and physical data modeling, including relational and multidimensional modeling. Strong practical expertise with SAP PowerDesigner. Advanced knowledge of SQL and related data languages and technologies, including DDL, DML, DCL, Transaction SQL, and SQL Plus. Experience administering and/or modeling data in relational and NoSQL database management systems. Familiarity with database technologies such as Oracle, DB2, Sybase, PostgreSQL, SQL Server, MongoDB, InfluxDB, and Apache Hawq/Impala. Experience with the Informatica suite, particularly PowerCenter, PowerExchange, Data Quality, and Metadata Management. Knowledge of data integration architectures, including ETL specifications, database links, and database-based services. Experience working with Very Large Databases (VLDBs), including database performance analysis and table-partitioning techniques. Understanding of data governance, metadata management, data quality, and enterprise data architecture principles. Knowledge of Agile methodologies such as Scrum, Kanban, XP, and the Agile Manifesto. Basic knowledge of statistics, predictive models, and probabilistic analysis. Strong analytical and problem-solving skills, with the ability to work across complex and diverse data environments. Effective communication and collaboration skills, with the ability to provide technical guidance and mentoring to different audiences. Ability to work independently, prioritize activities, and contribute effectively within multidisciplinary technical teams. Benefits: Full-time employment with a remote work model in Brazil. Opportunity to work on large-scale technology projects and complex enterprise environments. Exposure to critical data ecosystems spanning relational, analytical, and NoSQL technologies. Bradesco Saúde Nacional medical and dental coverage. Swile meal/food benefits. Transportation allowance. Exclusive banking credit package. Life insurance with 100% employer-funded coverage. Discounts on courses and educational institutions. Access to Wellhub (formerly Gympass) for fitness and wellbeing. Opportunities to contribute to digital transformation and data modernization initiatives. Environment focused on innovation, technical development, collaboration, and continuous improvement. How Jobgether works: We use an AI-powered matching process to ensure your application is reviewed quickly, objectively, and fairly against the role's core requirements. Our system identifies the top-fitting candidates, and this shortlist is then shared directly with the hiring company. The final decision and next steps (interviews, assessments) are managed by their internal team. We appreciate your interest and wish you the best! Why Apply Through Jobgether? Data Privacy Notice: By submitting your application, you acknowledge that Jobgether will process your personal data to evaluate your candidacy and share relevant information with the hiring employer. This processing is based on legitimate interest and pre-contractual measures under applicable data protection laws (including GDPR). You may exercise your rights (access, rectification, erasure, objection) at any time. #LI-CL1