Administrador de Dados / Modelador de Dados (PowerDesigner)
Core
Designing, governing, and optimizing data environments across complex enterprise ecosystems using SAP PowerDesigner.
Role type
Senior Data Administrator / Data Modeler
Builds
Relational, analytical, and NoSQL data architectures supporting BI and Big Data applications
Domain
Enterprise Data Management, Data Modeling, Big Data
Deliverable
production ML models | product features | dashboards & analysis
Required skills
SAP PowerDesigner, SQL (DDL/DML/DCL), Data Modeling (Conceptual/Logical/Physical), ETL specifications, Metadata Governance, Database Performance Optimization, NoSQL administration, Data Quality, VLDB management
Preferred skills
Informatica suite (PowerCenter, PowerExchange), Agile methodologies (Scrum/Kanban), Statistical analysis
Technologies
SAP PowerDesigner, Oracle, DB2, Sybase, PostgreSQL, SQL Server, MongoDB, InfluxDB, Apache Hawq/Impala, Informatica PowerCenter, Informatica PowerExchange, Informatica Data Quality
Responsibilities
Create and maintain conceptual, logical, and physical data models; Design data-service architectures across relational, analytical, and NoSQL ecosystems; Collaborate with DBAs on physical database implementation and performance optimization; Specify data integration mechanisms including ETL processes; Develop SQL scripts for validation and reporting; Provide technical guidance and mentoring to business and technology teams
Seniority
Senior, hands-on IC