Data Administrator – Engineering and Modeling

Role Overview

• Keep data models and the logical and physical data structures up to date, ensuring they remain consistent with business rules.
• Ensure metadata quality, considering its usefulness to the company’s various departments.
• Participate in the evaluation of automation solutions whenever they affect information production and use, monitoring model implementation and verifying the quality of database contents to ensure alignment with business objectives.
• Define conceptual, logical and physical modeling of the information required to meet business needs;
• Design, propose, maintain and update data models, ensuring data normalization, eliminating or minimizing redundant data, and promoting data consistency at the model level for implementation in the database;
• Define data access security procedures;
• Redefine data models based on specifics of physical implementation to improve database performance;
• Identify data distribution requirements and work with DBAs on physical implementation;
• Work on architecture modeling and deployment of BI & Big Data systems and of KPIs and dashboards to support executive decision-making;
• Design and develop the architecture for data services across the technology and platform ecosystem (Relational, Analytical, NoSQL) to support data consumption by BI applications;
• Promote and develop BI best practices focused on results and deliverables, providing consultancy, support and mentorship to business areas, with recommendations and guidance for continuous improvement and to sustain the established organizational model;
• Participate in the development and updating of data management and governance methodology;
• Support the specification of integration mechanisms such as services, ETL specifications, database links and other DBMS-based integration mechanisms;
• Write SQL scripts for data validations, report specifications, etc.

Requirements

• Bachelor's degree in Information Technology, or completion of any higher education degree accompanied by a postgraduate certificate (specialization, master’s or doctorate) in Information Technology of at least 360 hours.
• DESIRABLE CERTIFICATION: Hold at least one certification in one of the following databases: Microsoft SQL Server, PostgreSQL, Oracle, DB2, SAP ASE, SAP IQ, MySQL
• Preferred experience: 3 years of experience in data modeling and large-volume data integration in analytical and transactional environments.
• Knowledge of relational and dimensional modeling;
• Advanced SQL, DDL, DML, DCL;
• Platforms: Oracle, SQL Server, PostgreSQL, DB2, MongoDB;
• Modeling tools: PowerDesigner, Erwin, CA-Gen;
• Knowledge of integrations via DBMS, Database Links and ETL (e.g., Informatica PowerCenter).

Tech Stack

• ETL
• Informatica
• MongoDB
• MS SQL Server
• MySQL
• NoSQL
• Oracle
• Postgres
• SQL

Benefits

• Health plan
• Dental plan
• Life insurance
• Meal or food allowance
• Transportation allowance
• WellHub
• Gympass