Administrador de Dados - Engenharia e modelagem

Tasks

• Contribute to data governance methodology
• Create propose maintain and update data models
• Define conceptual logical and physical modeling
• Define data access security procedures
• Define data distribution requirements with DBAs
• Develop data services architecture for BI consumption
• Ensure data consistency with business rules
• Implement physical data model changes
• Maintain data models
• Maintain data quality metadata
• Maintain logical and physical data structures
• Model BI and Big Data architecture
• Normalize data remove redundant data
• Promote BI best practices
• Redesign data models for performance
• Specify data integration mechanisms
• Write SQL scripts for validations and reports

Perks/Benefits

• Dental plan
• Gympass
• Health insurance
• Life insurance
• Meal or food voucher
• Transportation voucher

Skills/Tech-stack

CA Gen | DB2 | DCL | DDL | DML | Data Modeling | Data Normalization | Database links | Dimensional Modeling | ETL | Erwin | Informatica PowerCenter | Microsoft SQL | Microsoft SQL Server | MongoDB | Oracle | PostgreSQL | PowerDesigner | Relational modeling | SQL | SQL Server